eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AM_TERMNT_INTERFACE_PVT dependencies on OKL_TERMNT_INTERFACE

Line 18: transaction_number OKL_TERMNT_INTERFACE.transaction_number%TYPE,

14: TYPE msg_tbl_type IS TABLE OF msg_rec_type
15: INDEX BY BINARY_INTEGER;
16: -- this record is used to store the messages for a particular line in the log
17: TYPE log_msg_rec_type IS RECORD (
18: transaction_number OKL_TERMNT_INTERFACE.transaction_number%TYPE,
19: msg_text VARCHAR2(2000));
20:
21: TYPE log_msg_tbl_type IS TABLE OF log_msg_rec_type
22: INDEX BY BINARY_INTEGER;

Line 25: transaction_number OKL_TERMNT_INTERFACE.transaction_number%TYPE,

21: TYPE log_msg_tbl_type IS TABLE OF log_msg_rec_type
22: INDEX BY BINARY_INTEGER;
23: -- this record is used to store the header inforamtion for particular line in the log
24: TYPE log_rec_type IS RECORD (
25: transaction_number OKL_TERMNT_INTERFACE.transaction_number%TYPE,
26: contract_number OKL_TERMNT_INTERFACE.contract_number%TYPE,
27: asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE,
28: date_effective_from OKL_TERMNT_INTERFACE.date_effective_from%TYPE,
29: quote_type OKL_TERMNT_INTERFACE.quote_type_code%TYPE,

Line 26: contract_number OKL_TERMNT_INTERFACE.contract_number%TYPE,

22: INDEX BY BINARY_INTEGER;
23: -- this record is used to store the header inforamtion for particular line in the log
24: TYPE log_rec_type IS RECORD (
25: transaction_number OKL_TERMNT_INTERFACE.transaction_number%TYPE,
26: contract_number OKL_TERMNT_INTERFACE.contract_number%TYPE,
27: asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE,
28: date_effective_from OKL_TERMNT_INTERFACE.date_effective_from%TYPE,
29: quote_type OKL_TERMNT_INTERFACE.quote_type_code%TYPE,
30: quote_reason OKL_TERMNT_INTERFACE.quote_reason_code%TYPE,

Line 27: asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE,

23: -- this record is used to store the header inforamtion for particular line in the log
24: TYPE log_rec_type IS RECORD (
25: transaction_number OKL_TERMNT_INTERFACE.transaction_number%TYPE,
26: contract_number OKL_TERMNT_INTERFACE.contract_number%TYPE,
27: asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE,
28: date_effective_from OKL_TERMNT_INTERFACE.date_effective_from%TYPE,
29: quote_type OKL_TERMNT_INTERFACE.quote_type_code%TYPE,
30: quote_reason OKL_TERMNT_INTERFACE.quote_reason_code%TYPE,
31: quote_number NUMBER);

Line 28: date_effective_from OKL_TERMNT_INTERFACE.date_effective_from%TYPE,

24: TYPE log_rec_type IS RECORD (
25: transaction_number OKL_TERMNT_INTERFACE.transaction_number%TYPE,
26: contract_number OKL_TERMNT_INTERFACE.contract_number%TYPE,
27: asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE,
28: date_effective_from OKL_TERMNT_INTERFACE.date_effective_from%TYPE,
29: quote_type OKL_TERMNT_INTERFACE.quote_type_code%TYPE,
30: quote_reason OKL_TERMNT_INTERFACE.quote_reason_code%TYPE,
31: quote_number NUMBER);
32:

Line 29: quote_type OKL_TERMNT_INTERFACE.quote_type_code%TYPE,

25: transaction_number OKL_TERMNT_INTERFACE.transaction_number%TYPE,
26: contract_number OKL_TERMNT_INTERFACE.contract_number%TYPE,
27: asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE,
28: date_effective_from OKL_TERMNT_INTERFACE.date_effective_from%TYPE,
29: quote_type OKL_TERMNT_INTERFACE.quote_type_code%TYPE,
30: quote_reason OKL_TERMNT_INTERFACE.quote_reason_code%TYPE,
31: quote_number NUMBER);
32:
33: TYPE log_tbl_type IS TABLE OF log_rec_type

Line 30: quote_reason OKL_TERMNT_INTERFACE.quote_reason_code%TYPE,

26: contract_number OKL_TERMNT_INTERFACE.contract_number%TYPE,
27: asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE,
28: date_effective_from OKL_TERMNT_INTERFACE.date_effective_from%TYPE,
29: quote_type OKL_TERMNT_INTERFACE.quote_type_code%TYPE,
30: quote_reason OKL_TERMNT_INTERFACE.quote_reason_code%TYPE,
31: quote_number NUMBER);
32:
33: TYPE log_tbl_type IS TABLE OF log_rec_type
34: INDEX BY BINARY_INTEGER;

Line 505: FROM OKL_TERMNT_INTERFACE

501: x_tif_tbl OUT NOCOPY tif_tbl_type) IS
502: /* cursor retrives the distinct quote_types from INTERFACE TABLE*/
503: CURSOR get_quote_type_csr IS
504: SELECT DISTINCT(quote_type_code) quote_type
505: FROM OKL_TERMNT_INTERFACE
506: WHERE status = 'ENTERED' AND quote_type_code IS NOT NULL;
507:
508: /* validates each quote_type in INTERFACE table against FND_LOOKUPS*/
509: CURSOR validate_quote_type_csr(p_quote_type IN VARCHAR2) IS

Line 517: FROM OKL_TERMNT_INTERFACE

513:
514: /* cursor retrives the distinct quote_reason from INTERFACE TABLE*/
515: CURSOR get_quote_reason_csr IS
516: SELECT DISTINCT(quote_reason_code) quote_reason
517: FROM OKL_TERMNT_INTERFACE
518: WHERE status = 'ENTERED' AND quote_reason_code IS NOT NULL;
519:
520: /* validates each quote_reason in INTERFACE table against FND_LOOKUPS*/
521: CURSOR validate_quote_reason_csr(p_quote_reason IN VARCHAR2) IS

Line 795: p_trx_source_table => 'OKL_TERMNT_INTERFACE',

791: p_quote_reason => x_tif_rec.quote_reason_code,
792: msg_tbl => l_msg_tbl );
793: END IF;
794: OKL_AM_UTIL_PVT.process_messages(
795: p_trx_source_table => 'OKL_TERMNT_INTERFACE',
796: p_trx_id => p_tif_rec.transaction_number,
797: x_return_status => x_return_status);
798:
799:

Line 838: l_serial_number OKL_TERMNT_INTERFACE.serial_number%TYPE;

834: p_tif_rec IN tif_rec_type,
835: x_tif_rec OUT NOCOPY tif_rec_type
836: ) IS
837:
838: l_serial_number OKL_TERMNT_INTERFACE.serial_number%TYPE;
839: l_contract_id OKL_TERMNT_INTERFACE.contract_id%TYPE;
840: l_contract_status OKC_K_HEADERS_B.sts_code%TYPE;
841: l_asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE;
842: l_asset_id OKL_TERMNT_INTERFACE.asset_id%TYPE;

Line 839: l_contract_id OKL_TERMNT_INTERFACE.contract_id%TYPE;

835: x_tif_rec OUT NOCOPY tif_rec_type
836: ) IS
837:
838: l_serial_number OKL_TERMNT_INTERFACE.serial_number%TYPE;
839: l_contract_id OKL_TERMNT_INTERFACE.contract_id%TYPE;
840: l_contract_status OKC_K_HEADERS_B.sts_code%TYPE;
841: l_asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE;
842: l_asset_id OKL_TERMNT_INTERFACE.asset_id%TYPE;
843: l_asset_description OKL_TERMNT_INTERFACE.asset_description%TYPE;

Line 841: l_asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE;

837:
838: l_serial_number OKL_TERMNT_INTERFACE.serial_number%TYPE;
839: l_contract_id OKL_TERMNT_INTERFACE.contract_id%TYPE;
840: l_contract_status OKC_K_HEADERS_B.sts_code%TYPE;
841: l_asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE;
842: l_asset_id OKL_TERMNT_INTERFACE.asset_id%TYPE;
843: l_asset_description OKL_TERMNT_INTERFACE.asset_description%TYPE;
844: l_asset_status OKL_K_LINES_FULL_V.sts_code%TYPE;
845: l_tif_rec tif_rec_type;

Line 842: l_asset_id OKL_TERMNT_INTERFACE.asset_id%TYPE;

838: l_serial_number OKL_TERMNT_INTERFACE.serial_number%TYPE;
839: l_contract_id OKL_TERMNT_INTERFACE.contract_id%TYPE;
840: l_contract_status OKC_K_HEADERS_B.sts_code%TYPE;
841: l_asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE;
842: l_asset_id OKL_TERMNT_INTERFACE.asset_id%TYPE;
843: l_asset_description OKL_TERMNT_INTERFACE.asset_description%TYPE;
844: l_asset_status OKL_K_LINES_FULL_V.sts_code%TYPE;
845: l_tif_rec tif_rec_type;
846: l_quantity NUMBER;

Line 843: l_asset_description OKL_TERMNT_INTERFACE.asset_description%TYPE;

839: l_contract_id OKL_TERMNT_INTERFACE.contract_id%TYPE;
840: l_contract_status OKC_K_HEADERS_B.sts_code%TYPE;
841: l_asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE;
842: l_asset_id OKL_TERMNT_INTERFACE.asset_id%TYPE;
843: l_asset_description OKL_TERMNT_INTERFACE.asset_description%TYPE;
844: l_asset_status OKL_K_LINES_FULL_V.sts_code%TYPE;
845: l_tif_rec tif_rec_type;
846: l_quantity NUMBER;
847: l_instance_id NUMBER;

Line 1233: OKL_AM_UTIL_PVT.process_messages(p_trx_source_table => 'OKL_TERMNT_INTERFACE',

1229: p_quote_type => x_tif_rec.quote_type_code,
1230: p_quote_reason => x_tif_rec.quote_reason_code,
1231: msg_tbl => l_msg_tbl );
1232: END IF;
1233: OKL_AM_UTIL_PVT.process_messages(p_trx_source_table => 'OKL_TERMNT_INTERFACE',
1234: p_trx_id => p_tif_rec.transaction_number,
1235: x_return_status => x_return_status);
1236: EXCEPTION
1237: WHEN OTHERS THEN

Line 1464: UPDATE OKL_TERMNT_INTERFACE

1460: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1461: RAISE OKC_API.G_EXCEPTION_ERROR;
1462: END IF;
1463:
1464: UPDATE OKL_TERMNT_INTERFACE
1465: SET
1466: OKL_TERMNT_INTERFACE.TRANSACTION_NUMBER = p_tif_rec.transaction_number
1467: ,OKL_TERMNT_INTERFACE.BATCH_NUMBER = p_tif_rec.batch_number
1468: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id

Line 1466: OKL_TERMNT_INTERFACE.TRANSACTION_NUMBER = p_tif_rec.transaction_number

1462: END IF;
1463:
1464: UPDATE OKL_TERMNT_INTERFACE
1465: SET
1466: OKL_TERMNT_INTERFACE.TRANSACTION_NUMBER = p_tif_rec.transaction_number
1467: ,OKL_TERMNT_INTERFACE.BATCH_NUMBER = p_tif_rec.batch_number
1468: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id
1469: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number
1470: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id

Line 1467: ,OKL_TERMNT_INTERFACE.BATCH_NUMBER = p_tif_rec.batch_number

1463:
1464: UPDATE OKL_TERMNT_INTERFACE
1465: SET
1466: OKL_TERMNT_INTERFACE.TRANSACTION_NUMBER = p_tif_rec.transaction_number
1467: ,OKL_TERMNT_INTERFACE.BATCH_NUMBER = p_tif_rec.batch_number
1468: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id
1469: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number
1470: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id
1471: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number

Line 1468: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id

1464: UPDATE OKL_TERMNT_INTERFACE
1465: SET
1466: OKL_TERMNT_INTERFACE.TRANSACTION_NUMBER = p_tif_rec.transaction_number
1467: ,OKL_TERMNT_INTERFACE.BATCH_NUMBER = p_tif_rec.batch_number
1468: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id
1469: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number
1470: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id
1471: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number
1472: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description

Line 1469: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number

1465: SET
1466: OKL_TERMNT_INTERFACE.TRANSACTION_NUMBER = p_tif_rec.transaction_number
1467: ,OKL_TERMNT_INTERFACE.BATCH_NUMBER = p_tif_rec.batch_number
1468: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id
1469: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number
1470: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id
1471: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number
1472: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description
1473: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number

Line 1470: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id

1466: OKL_TERMNT_INTERFACE.TRANSACTION_NUMBER = p_tif_rec.transaction_number
1467: ,OKL_TERMNT_INTERFACE.BATCH_NUMBER = p_tif_rec.batch_number
1468: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id
1469: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number
1470: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id
1471: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number
1472: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description
1473: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number
1474: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system

Line 1471: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number

1467: ,OKL_TERMNT_INTERFACE.BATCH_NUMBER = p_tif_rec.batch_number
1468: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id
1469: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number
1470: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id
1471: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number
1472: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description
1473: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number
1474: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system
1475: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference

Line 1472: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description

1468: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id
1469: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number
1470: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id
1471: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number
1472: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description
1473: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number
1474: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system
1475: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference
1476: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate

Line 1473: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number

1469: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number
1470: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id
1471: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number
1472: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description
1473: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number
1474: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system
1475: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference
1476: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate
1477: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments

Line 1474: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system

1470: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id
1471: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number
1472: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description
1473: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number
1474: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system
1475: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference
1476: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate
1477: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments
1478: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed

Line 1475: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference

1471: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number
1472: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description
1473: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number
1474: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system
1475: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference
1476: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate
1477: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments
1478: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed
1479: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from

Line 1476: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate

1472: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description
1473: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number
1474: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system
1475: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference
1476: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate
1477: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments
1478: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed
1479: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from
1480: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email

Line 1477: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments

1473: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number
1474: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system
1475: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference
1476: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate
1477: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments
1478: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed
1479: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from
1480: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
1481: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn

Line 1478: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed

1474: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system
1475: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference
1476: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate
1477: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments
1478: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed
1479: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from
1480: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
1481: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn
1482: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn

Line 1479: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from

1475: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference
1476: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate
1477: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments
1478: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed
1479: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from
1480: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
1481: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn
1482: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn
1483: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code

Line 1480: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email

1476: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate
1477: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments
1478: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed
1479: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from
1480: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
1481: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn
1482: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn
1483: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code
1484: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code

Line 1481: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn

1477: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments
1478: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed
1479: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from
1480: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
1481: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn
1482: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn
1483: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code
1484: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code
1485: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id

Line 1482: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn

1478: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed
1479: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from
1480: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
1481: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn
1482: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn
1483: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code
1484: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code
1485: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id
1486: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status

Line 1483: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code

1479: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from
1480: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
1481: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn
1482: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn
1483: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code
1484: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code
1485: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id
1486: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status
1487: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id

Line 1484: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code

1480: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
1481: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn
1482: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn
1483: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code
1484: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code
1485: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id
1486: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status
1487: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id
1488: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)

Line 1485: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id

1481: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn
1482: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn
1483: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code
1484: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code
1485: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id
1486: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status
1487: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id
1488: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
1489: ,OKL_TERMNT_INTERFACE.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tif_rec.program_application_id)

Line 1486: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status

1482: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn
1483: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code
1484: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code
1485: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id
1486: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status
1487: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id
1488: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
1489: ,OKL_TERMNT_INTERFACE.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tif_rec.program_application_id)
1490: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)

Line 1487: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id

1483: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code
1484: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code
1485: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id
1486: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status
1487: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id
1488: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
1489: ,OKL_TERMNT_INTERFACE.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tif_rec.program_application_id)
1490: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
1491: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)

Line 1488: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)

1484: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code
1485: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id
1486: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status
1487: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id
1488: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
1489: ,OKL_TERMNT_INTERFACE.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tif_rec.program_application_id)
1490: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
1491: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
1492: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category

Line 1489: ,OKL_TERMNT_INTERFACE.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tif_rec.program_application_id)

1485: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id
1486: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status
1487: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id
1488: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
1489: ,OKL_TERMNT_INTERFACE.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tif_rec.program_application_id)
1490: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
1491: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
1492: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category
1493: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1

Line 1490: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)

1486: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status
1487: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id
1488: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
1489: ,OKL_TERMNT_INTERFACE.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tif_rec.program_application_id)
1490: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
1491: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
1492: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category
1493: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1
1494: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2

Line 1491: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)

1487: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id
1488: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
1489: ,OKL_TERMNT_INTERFACE.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tif_rec.program_application_id)
1490: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
1491: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
1492: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category
1493: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1
1494: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2
1495: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3

Line 1492: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category

1488: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
1489: ,OKL_TERMNT_INTERFACE.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tif_rec.program_application_id)
1490: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
1491: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
1492: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category
1493: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1
1494: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2
1495: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3
1496: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4

Line 1493: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1

1489: ,OKL_TERMNT_INTERFACE.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tif_rec.program_application_id)
1490: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
1491: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
1492: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category
1493: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1
1494: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2
1495: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3
1496: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4
1497: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5

Line 1494: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2

1490: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
1491: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
1492: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category
1493: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1
1494: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2
1495: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3
1496: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4
1497: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5
1498: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6

Line 1495: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3

1491: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
1492: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category
1493: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1
1494: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2
1495: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3
1496: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4
1497: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5
1498: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6
1499: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7

Line 1496: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4

1492: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category
1493: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1
1494: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2
1495: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3
1496: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4
1497: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5
1498: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6
1499: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7
1500: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8

Line 1497: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5

1493: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1
1494: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2
1495: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3
1496: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4
1497: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5
1498: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6
1499: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7
1500: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8
1501: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9

Line 1498: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6

1494: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2
1495: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3
1496: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4
1497: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5
1498: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6
1499: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7
1500: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8
1501: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9
1502: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10

Line 1499: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7

1495: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3
1496: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4
1497: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5
1498: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6
1499: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7
1500: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8
1501: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9
1502: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10
1503: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11

Line 1500: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8

1496: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4
1497: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5
1498: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6
1499: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7
1500: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8
1501: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9
1502: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10
1503: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11
1504: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12

Line 1501: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9

1497: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5
1498: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6
1499: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7
1500: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8
1501: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9
1502: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10
1503: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11
1504: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12
1505: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13

Line 1502: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10

1498: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6
1499: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7
1500: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8
1501: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9
1502: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10
1503: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11
1504: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12
1505: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13
1506: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14

Line 1503: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11

1499: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7
1500: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8
1501: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9
1502: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10
1503: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11
1504: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12
1505: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13
1506: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14
1507: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15

Line 1504: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12

1500: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8
1501: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9
1502: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10
1503: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11
1504: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12
1505: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13
1506: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14
1507: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15
1508: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by

Line 1505: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13

1501: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9
1502: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10
1503: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11
1504: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12
1505: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13
1506: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14
1507: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15
1508: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by
1509: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date

Line 1506: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14

1502: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10
1503: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11
1504: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12
1505: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13
1506: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14
1507: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15
1508: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by
1509: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date
1510: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID

Line 1507: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15

1503: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11
1504: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12
1505: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13
1506: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14
1507: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15
1508: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by
1509: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date
1510: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1511: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE

Line 1508: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by

1504: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12
1505: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13
1506: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14
1507: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15
1508: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by
1509: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date
1510: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1511: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE
1512: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 1509: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date

1505: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13
1506: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14
1507: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15
1508: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by
1509: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date
1510: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1511: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE
1512: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1513: ,OKL_TERMNT_INTERFACE.GROUP_NUMBER = p_tif_rec.group_number

Line 1510: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID

1506: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14
1507: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15
1508: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by
1509: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date
1510: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1511: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE
1512: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1513: ,OKL_TERMNT_INTERFACE.GROUP_NUMBER = p_tif_rec.group_number
1514: WHERE

Line 1511: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE

1507: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15
1508: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by
1509: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date
1510: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1511: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE
1512: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1513: ,OKL_TERMNT_INTERFACE.GROUP_NUMBER = p_tif_rec.group_number
1514: WHERE
1515: OKL_TERMNT_INTERFACE.ROWID =p_tif_rec.row_id;

Line 1512: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1508: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by
1509: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date
1510: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1511: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE
1512: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1513: ,OKL_TERMNT_INTERFACE.GROUP_NUMBER = p_tif_rec.group_number
1514: WHERE
1515: OKL_TERMNT_INTERFACE.ROWID =p_tif_rec.row_id;
1516: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1513: ,OKL_TERMNT_INTERFACE.GROUP_NUMBER = p_tif_rec.group_number

1509: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date
1510: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1511: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE
1512: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1513: ,OKL_TERMNT_INTERFACE.GROUP_NUMBER = p_tif_rec.group_number
1514: WHERE
1515: OKL_TERMNT_INTERFACE.ROWID =p_tif_rec.row_id;
1516: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1517:

Line 1515: OKL_TERMNT_INTERFACE.ROWID =p_tif_rec.row_id;

1511: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE
1512: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1513: ,OKL_TERMNT_INTERFACE.GROUP_NUMBER = p_tif_rec.group_number
1514: WHERE
1515: OKL_TERMNT_INTERFACE.ROWID =p_tif_rec.row_id;
1516: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1517:
1518: OKL_AM_UTIL_PVT.process_messages(p_trx_source_table => 'OKL_TERMNT_INTERFACE',
1519: p_trx_id => p_tif_rec.transaction_number,

Line 1518: OKL_AM_UTIL_PVT.process_messages(p_trx_source_table => 'OKL_TERMNT_INTERFACE',

1514: WHERE
1515: OKL_TERMNT_INTERFACE.ROWID =p_tif_rec.row_id;
1516: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1517:
1518: OKL_AM_UTIL_PVT.process_messages(p_trx_source_table => 'OKL_TERMNT_INTERFACE',
1519: p_trx_id => p_tif_rec.transaction_number,
1520: x_return_status => l_return_status);
1521: x_return_status := l_return_status;
1522: EXCEPTION

Line 1628: FROM OKL_TERMNT_INTERFACE

1624: ,LAST_UPDATED_BY
1625: ,LAST_UPDATE_DATE
1626: ,LAST_UPDATE_LOGIN
1627: ,GROUP_NUMBER
1628: FROM OKL_TERMNT_INTERFACE
1629: WHERE status = p_status
1630: ORDER BY CONTRACT_NUMBER,QUOTE_TYPE_CODE,DATE_EFFECTIVE_FROM,QUOTE_REASON_CODE,ASSET_ID;
1631: BEGIN
1632:

Line 2587: OKL_AM_UTIL_PVT.process_messages(p_trx_source_table => 'OKL_TERMNT_INTERFACE',

2583: ,x_msg_count => x_msg_count
2584: ,x_return_status => x_return_status
2585: ,p_tif_rec => x_tif_tbl(record_number));
2586: -- Save message from stack into transaction message table
2587: OKL_AM_UTIL_PVT.process_messages(p_trx_source_table => 'OKL_TERMNT_INTERFACE',
2588: p_trx_id => lx_tif_tbl(record_number).transaction_number,
2589: x_return_status => x_return_status);
2590: END LOOP;
2591: END IF;

Line 2638: -- cursor to retrive contract_id from OKL_TERMNT_INTERFACE joined by transaction_number

2634: x_tif_tbl OUT NOCOPY tif_tbl_type,
2635: p_tip_tbl IN tip_tbl_type,
2636: x_tip_tbl OUT NOCOPY tip_tbl_type) IS
2637:
2638: -- cursor to retrive contract_id from OKL_TERMNT_INTERFACE joined by transaction_number
2639: CURSOR get_contract_id_csr(p_transaction_number IN VARCHAR2) IS
2640: SELECT contract_id,status
2641: FROM OKL_TERMNT_INTERFACE
2642: WHERE transaction_number = p_transaction_number;

Line 2641: FROM OKL_TERMNT_INTERFACE

2637:
2638: -- cursor to retrive contract_id from OKL_TERMNT_INTERFACE joined by transaction_number
2639: CURSOR get_contract_id_csr(p_transaction_number IN VARCHAR2) IS
2640: SELECT contract_id,status
2641: FROM OKL_TERMNT_INTERFACE
2642: WHERE transaction_number = p_transaction_number;
2643:
2644: -- cursor to select the party details using contract_id and quote_role_code
2645: --Fixed Bug # 5484903

Line 2666: select count(*) from OKL_TERMNT_INTERFACE

2662: WHERE ((party_id = p_object1_id1) AND party_type IN ( 'PERSON','ORGANIZATION'));
2663:
2664: --cursor to check the record in interface table for a transaction number
2665: Cursor l_rec_exists_csr (p_transaction_number VARCHAR2) IS
2666: select count(*) from OKL_TERMNT_INTERFACE
2667: where transaction_number = p_transaction_number;
2668:
2669: l_count NUMBER;
2670: l_dup_flag VARCHAR2(1);

Line 2788: message :='transaction_number in OKL_TERMNT_INTERFACE is ERROR for transaction number '||lx_tip_tbl(record_number).transaction_number;

2784: OKC_API.set_message(p_app_name => g_app_name,
2785: p_msg_name => 'OKL_AM_ERR_INTERFACE',
2786: p_token1 => 'TRANSACTION_NUMBER',
2787: p_token1_value => lx_tip_tbl(record_number).transaction_number);
2788: message :='transaction_number in OKL_TERMNT_INTERFACE is ERROR for transaction number '||lx_tip_tbl(record_number).transaction_number;
2789: IF (G_DEBUG_LEVEL_PROCEDURE >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
2790: FND_LOG.STRING(G_DEBUG_LEVEL_PROCEDURE,'OKL_AM_TERMNT_INTERFACE_PVT.validate_party','message 3 '||message);
2791: END IF;
2792:

Line 3708: p_trx_source_table => 'OKL_TERMNT_INTERFACE',

3704: -- ||'group_number = ' ||group_number );
3705: -- Save message from stack into transaction message table
3706:
3707: OKL_AM_UTIL_PVT.process_messages(
3708: p_trx_source_table => 'OKL_TERMNT_INTERFACE',
3709: p_trx_id => l_lessee_tif_tbl(i).transaction_number,
3710: x_return_status => x_return_status);
3711:
3712: END LOOP;

Line 3905: p_trx_source_table => 'OKL_TERMNT_INTERFACE',

3901: p_tif_rec => l_vendor_tif_tbl(i));
3902:
3903: -- Save message from stack into transaction message table
3904: OKL_AM_UTIL_PVT.process_messages(
3905: p_trx_source_table => 'OKL_TERMNT_INTERFACE',
3906: p_trx_id => l_vendor_tif_tbl(i).transaction_number,
3907: x_return_status => x_return_status);
3908:
3909: END LOOP;

Line 4200: p_trx_source_table => 'OKL_TERMNT_INTERFACE',

4196: p_tif_rec => l_lessee_tif_tbl(i));
4197:
4198: -- Save message from stack into transaction message table
4199: OKL_AM_UTIL_PVT.process_messages(
4200: p_trx_source_table => 'OKL_TERMNT_INTERFACE',
4201: p_trx_id => l_lessee_tif_tbl(i).transaction_number,
4202: x_return_status => x_return_status);
4203:
4204: END LOOP;

Line 4393: p_trx_source_table => 'OKL_TERMNT_INTERFACE',

4389: p_tif_rec => l_vendor_tif_tbl(i));
4390:
4391: -- Save message from stack into transaction message table
4392: OKL_AM_UTIL_PVT.process_messages(
4393: p_trx_source_table => 'OKL_TERMNT_INTERFACE',
4394: p_trx_id => l_vendor_tif_tbl(i).transaction_number,
4395: x_return_status => x_return_status);
4396:
4397: END LOOP;

Line 4585: FROM OKL_TERMNT_INTERFACE

4581: ,LAST_UPDATED_BY
4582: ,LAST_UPDATE_DATE
4583: ,LAST_UPDATE_LOGIN
4584: ,GROUP_NUMBER
4585: FROM OKL_TERMNT_INTERFACE
4586: WHERE status = p_status
4587: ORDER BY CONTRACT_NUMBER,TRANSACTION_NUMBER; --sechawla 02-Aug-2011 12745559 : added transaction_number
4588:
4589: l_api_version CONSTANT NUMBER := 1;