Routines for cntr_bdb.kb


GetContract

File Name

cntr_bdb.kb

Syntax

GetContract( VAL id: INTEGER, VAL wHdl: WINDOW ): ContractRec

Parameters

ID - contract ID

wHdl - parent window handle

Returns

Contract table record

Side Effects

None

Description

This routine returns the contract record that has the contract ID that is passed into the function.

Dialog Forms Called

None


GetContractAddressList

File Name

cntr_bdb.kb

Syntax

GetContractAddressList( REF KAddressList: LIST OF ContractAddress, VAL ID: INTEGER )

Parameters

KAddressList - list of contract address records

ID - contract ID

Returns

Integer for success or failure

Side Effects

None

Description

This routine returns a list of contract address records for the contract ID supplied to the function.

Dialog Forms Called

None


GetContractAddressList

File Name

cntr_bdb.kb

Syntax

GetSomeContractList( REF kList: LIST OF ContractRec, VAL where: STRING, VAL wHdl: WINDOW, VAL organizationID: STRING )

Parameters

kList - list of Contrac Address records

where - where clause of select statement

wHdl - parent window handle

organizationID - organization ID

Returns

Integer for success or failure

Side Effects

None

Description

This routine returns a list of contract records based on the where clause. Organization ID is also used to determine the list if TSD is in secure mode.

Dialog Forms Called

None


GetContractID

File Name

cntr_bdb.kb

Syntax

GetContractID( VAL contract_number: STRING, VAL wHdl: WINDOW )

Parameters

contract_number - contract number

wHdl - parent window handle

Returns

Integer for success or failure

Side Effects

None

Description

This routine returns the contract ID based on the contract number passed into the function.

Dialog Forms Called

None


GetContractInvList

File Name

cntr_bdb.kb

Syntax

GetContractInvList(REF kList: LIST OF InvContractRec, VAL contract_ID: INTEGER)

Parameters

kList - list of records from the INV_CONTRACT table

contract_id - contract ID

Returns

Integer for success or failure

Side Effects

None

Description

This routine returns a list of contract / inventory relation records for the contract ID supplied to the function.

Dialog Forms Called

None


GetContractMaintList

File Name

cntr_bdb.kb

Syntax

GetContractMaintList( REF KMaintenanceList: LIST OF ContractMaintenance, VAL ID: INTEGER )

Parameters

KMaintenanceList - list of contract maintenance records

ID - contract ID

Returns

Integer for success or failure

Side Effects

None

Description

This routine returns a list of contract maintenance records for the contract ID supplied to the function.

Dialog Forms Called

None


GetContractNumber

File Name

cntr_bdb.kb

Syntax

GetContractNumber( VAL contract_id: INTEGER, VAL wHdl: WINDOW )

Parameters

contract_id - contract ID

wHdl - parent window handle

Returns

contract number

Side Effects

None

Description

This routine returns the contract number based on the contract ID passed into the function.

Dialog Forms Called

None


GetSomeKListLite

File Name

cntr_bdb.kb

Syntax

GetSomeKListLite( VAL what: STRING, VAL where: STRING, REF contractList: LIST OF ContractRec, VAL wHdl: WINDOW )

Parameters

what - what clause of contract list select statement

where - where clause of contract list select statement

Returns

Success or failure of select statement.

Side Effects

None

Description

This routine returns a list of contract records based on the what and where clauses passed into the select statement.

Dialog Forms Called

None