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 493: FROM OKL_TERMNT_INTERFACE

489: x_tif_tbl OUT NOCOPY tif_tbl_type) IS
490: /* cursor retrives the distinct quote_types from INTERFACE TABLE*/
491: CURSOR get_quote_type_csr IS
492: SELECT DISTINCT(quote_type_code) quote_type
493: FROM OKL_TERMNT_INTERFACE
494: WHERE status = 'ENTERED' AND quote_type_code IS NOT NULL;
495:
496: /* validates each quote_type in INTERFACE table against FND_LOOKUPS*/
497: CURSOR validate_quote_type_csr(p_quote_type IN VARCHAR2) IS

Line 505: FROM OKL_TERMNT_INTERFACE

501:
502: /* cursor retrives the distinct quote_reason from INTERFACE TABLE*/
503: CURSOR get_quote_reason_csr IS
504: SELECT DISTINCT(quote_reason_code) quote_reason
505: FROM OKL_TERMNT_INTERFACE
506: WHERE status = 'ENTERED' AND quote_reason_code IS NOT NULL;
507:
508: /* validates each quote_reason in INTERFACE table against FND_LOOKUPS*/
509: CURSOR validate_quote_reason_csr(p_quote_reason IN VARCHAR2) IS

Line 762: p_trx_source_table => 'OKL_TERMNT_INTERFACE',

758: p_quote_reason => x_tif_rec.quote_reason_code,
759: msg_tbl => l_msg_tbl );
760: END IF;
761: OKL_AM_UTIL_PVT.process_messages(
762: p_trx_source_table => 'OKL_TERMNT_INTERFACE',
763: p_trx_id => p_tif_rec.transaction_number,
764: x_return_status => x_return_status);
765:
766:

Line 805: l_serial_number OKL_TERMNT_INTERFACE.serial_number%TYPE;

801: p_tif_rec IN tif_rec_type,
802: x_tif_rec OUT NOCOPY tif_rec_type
803: ) IS
804:
805: l_serial_number OKL_TERMNT_INTERFACE.serial_number%TYPE;
806: l_contract_id OKL_TERMNT_INTERFACE.contract_id%TYPE;
807: l_contract_status OKC_K_HEADERS_B.sts_code%TYPE;
808: l_asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE;
809: l_asset_id OKL_TERMNT_INTERFACE.asset_id%TYPE;

Line 806: l_contract_id OKL_TERMNT_INTERFACE.contract_id%TYPE;

802: x_tif_rec OUT NOCOPY tif_rec_type
803: ) IS
804:
805: l_serial_number OKL_TERMNT_INTERFACE.serial_number%TYPE;
806: l_contract_id OKL_TERMNT_INTERFACE.contract_id%TYPE;
807: l_contract_status OKC_K_HEADERS_B.sts_code%TYPE;
808: l_asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE;
809: l_asset_id OKL_TERMNT_INTERFACE.asset_id%TYPE;
810: l_asset_description OKL_TERMNT_INTERFACE.asset_description%TYPE;

Line 808: l_asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE;

804:
805: l_serial_number OKL_TERMNT_INTERFACE.serial_number%TYPE;
806: l_contract_id OKL_TERMNT_INTERFACE.contract_id%TYPE;
807: l_contract_status OKC_K_HEADERS_B.sts_code%TYPE;
808: l_asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE;
809: l_asset_id OKL_TERMNT_INTERFACE.asset_id%TYPE;
810: l_asset_description OKL_TERMNT_INTERFACE.asset_description%TYPE;
811: l_asset_status OKL_K_LINES_FULL_V.sts_code%TYPE;
812: l_tif_rec tif_rec_type;

Line 809: l_asset_id OKL_TERMNT_INTERFACE.asset_id%TYPE;

805: l_serial_number OKL_TERMNT_INTERFACE.serial_number%TYPE;
806: l_contract_id OKL_TERMNT_INTERFACE.contract_id%TYPE;
807: l_contract_status OKC_K_HEADERS_B.sts_code%TYPE;
808: l_asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE;
809: l_asset_id OKL_TERMNT_INTERFACE.asset_id%TYPE;
810: l_asset_description OKL_TERMNT_INTERFACE.asset_description%TYPE;
811: l_asset_status OKL_K_LINES_FULL_V.sts_code%TYPE;
812: l_tif_rec tif_rec_type;
813: l_quantity NUMBER;

Line 810: l_asset_description OKL_TERMNT_INTERFACE.asset_description%TYPE;

806: l_contract_id OKL_TERMNT_INTERFACE.contract_id%TYPE;
807: l_contract_status OKC_K_HEADERS_B.sts_code%TYPE;
808: l_asset_number OKL_TERMNT_INTERFACE.asset_number%TYPE;
809: l_asset_id OKL_TERMNT_INTERFACE.asset_id%TYPE;
810: l_asset_description OKL_TERMNT_INTERFACE.asset_description%TYPE;
811: l_asset_status OKL_K_LINES_FULL_V.sts_code%TYPE;
812: l_tif_rec tif_rec_type;
813: l_quantity NUMBER;
814: l_instance_id NUMBER;

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

1121: p_quote_type => x_tif_rec.quote_type_code,
1122: p_quote_reason => x_tif_rec.quote_reason_code,
1123: msg_tbl => l_msg_tbl );
1124: END IF;
1125: OKL_AM_UTIL_PVT.process_messages(p_trx_source_table => 'OKL_TERMNT_INTERFACE',
1126: p_trx_id => p_tif_rec.transaction_number,
1127: x_return_status => x_return_status);
1128: EXCEPTION
1129: WHEN OTHERS THEN

Line 1312: UPDATE OKL_TERMNT_INTERFACE

1308: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1309: RAISE OKC_API.G_EXCEPTION_ERROR;
1310: END IF;
1311:
1312: UPDATE OKL_TERMNT_INTERFACE
1313: SET
1314: OKL_TERMNT_INTERFACE.TRANSACTION_NUMBER = p_tif_rec.transaction_number
1315: ,OKL_TERMNT_INTERFACE.BATCH_NUMBER = p_tif_rec.batch_number
1316: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id

Line 1314: OKL_TERMNT_INTERFACE.TRANSACTION_NUMBER = p_tif_rec.transaction_number

1310: END IF;
1311:
1312: UPDATE OKL_TERMNT_INTERFACE
1313: SET
1314: OKL_TERMNT_INTERFACE.TRANSACTION_NUMBER = p_tif_rec.transaction_number
1315: ,OKL_TERMNT_INTERFACE.BATCH_NUMBER = p_tif_rec.batch_number
1316: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id
1317: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number
1318: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id

Line 1315: ,OKL_TERMNT_INTERFACE.BATCH_NUMBER = p_tif_rec.batch_number

1311:
1312: UPDATE OKL_TERMNT_INTERFACE
1313: SET
1314: OKL_TERMNT_INTERFACE.TRANSACTION_NUMBER = p_tif_rec.transaction_number
1315: ,OKL_TERMNT_INTERFACE.BATCH_NUMBER = p_tif_rec.batch_number
1316: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id
1317: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number
1318: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id
1319: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number

Line 1316: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id

1312: UPDATE OKL_TERMNT_INTERFACE
1313: SET
1314: OKL_TERMNT_INTERFACE.TRANSACTION_NUMBER = p_tif_rec.transaction_number
1315: ,OKL_TERMNT_INTERFACE.BATCH_NUMBER = p_tif_rec.batch_number
1316: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id
1317: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number
1318: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id
1319: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number
1320: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description

Line 1317: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number

1313: SET
1314: OKL_TERMNT_INTERFACE.TRANSACTION_NUMBER = p_tif_rec.transaction_number
1315: ,OKL_TERMNT_INTERFACE.BATCH_NUMBER = p_tif_rec.batch_number
1316: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id
1317: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number
1318: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id
1319: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number
1320: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description
1321: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number

Line 1318: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id

1314: OKL_TERMNT_INTERFACE.TRANSACTION_NUMBER = p_tif_rec.transaction_number
1315: ,OKL_TERMNT_INTERFACE.BATCH_NUMBER = p_tif_rec.batch_number
1316: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id
1317: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number
1318: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id
1319: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number
1320: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description
1321: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number
1322: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system

Line 1319: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number

1315: ,OKL_TERMNT_INTERFACE.BATCH_NUMBER = p_tif_rec.batch_number
1316: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id
1317: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number
1318: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id
1319: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number
1320: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description
1321: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number
1322: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system
1323: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference

Line 1320: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description

1316: ,OKL_TERMNT_INTERFACE.CONTRACT_ID = p_tif_rec.contract_id
1317: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number
1318: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id
1319: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number
1320: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description
1321: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number
1322: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system
1323: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference
1324: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate

Line 1321: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number

1317: ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER = p_tif_rec.contract_number
1318: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id
1319: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number
1320: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description
1321: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number
1322: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system
1323: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference
1324: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate
1325: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments

Line 1322: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system

1318: ,OKL_TERMNT_INTERFACE.ASSET_ID = p_tif_rec.asset_id
1319: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number
1320: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description
1321: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number
1322: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system
1323: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference
1324: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate
1325: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments
1326: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed

Line 1323: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference

1319: ,OKL_TERMNT_INTERFACE.ASSET_NUMBER = p_tif_rec.asset_number
1320: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description
1321: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number
1322: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system
1323: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference
1324: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate
1325: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments
1326: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed
1327: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from

Line 1324: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate

1320: ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION = p_tif_rec.asset_description
1321: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number
1322: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system
1323: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference
1324: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate
1325: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments
1326: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed
1327: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from
1328: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email

Line 1325: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments

1321: ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER = p_tif_rec.serial_number
1322: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system
1323: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference
1324: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate
1325: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments
1326: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed
1327: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from
1328: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
1329: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn

Line 1326: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed

1322: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM = p_tif_rec.orig_system
1323: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference
1324: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate
1325: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments
1326: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed
1327: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from
1328: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
1329: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn
1330: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn

Line 1327: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from

1323: ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE = p_tif_rec.orig_system_reference
1324: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate
1325: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments
1326: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed
1327: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from
1328: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
1329: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn
1330: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn
1331: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code

Line 1328: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email

1324: ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE = p_tif_rec.units_to_terminate
1325: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments
1326: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed
1327: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from
1328: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
1329: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn
1330: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn
1331: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code
1332: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code

Line 1329: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn

1325: ,OKL_TERMNT_INTERFACE.COMMENTS = p_tif_rec.comments
1326: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed
1327: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from
1328: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
1329: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn
1330: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn
1331: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code
1332: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code
1333: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id

Line 1330: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn

1326: ,OKL_TERMNT_INTERFACE.DATE_PROCESSED = p_tif_rec.date_processed
1327: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from
1328: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
1329: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn
1330: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn
1331: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code
1332: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code
1333: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id
1334: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status

Line 1331: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code

1327: ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM = p_tif_rec.date_effective_from
1328: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
1329: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn
1330: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn
1331: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code
1332: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code
1333: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id
1334: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status
1335: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id

Line 1332: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code

1328: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
1329: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn
1330: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn
1331: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code
1332: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code
1333: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id
1334: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status
1335: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id
1336: ,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 1333: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id

1329: ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN = p_tif_rec.termination_notification_yn
1330: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn
1331: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code
1332: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code
1333: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id
1334: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status
1335: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id
1336: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
1337: ,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 1334: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status

1330: ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN = p_tif_rec.auto_accept_yn
1331: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code
1332: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code
1333: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id
1334: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status
1335: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id
1336: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
1337: ,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)
1338: ,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 1335: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id

1331: ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE = p_tif_rec.quote_type_code
1332: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code
1333: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id
1334: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status
1335: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id
1336: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
1337: ,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)
1338: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
1339: ,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 1336: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)

1332: ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE = p_tif_rec.quote_reason_code
1333: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id
1334: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status
1335: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id
1336: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
1337: ,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)
1338: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
1339: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
1340: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category

Line 1337: ,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)

1333: ,OKL_TERMNT_INTERFACE.QTE_ID = p_tif_rec.qte_id
1334: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status
1335: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id
1336: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
1337: ,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)
1338: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
1339: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
1340: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category
1341: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1

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

1334: ,OKL_TERMNT_INTERFACE.STATUS = p_tif_rec.status
1335: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id
1336: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
1337: ,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)
1338: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
1339: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
1340: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category
1341: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1
1342: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2

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

1335: ,OKL_TERMNT_INTERFACE.ORG_ID = p_tif_rec.org_id
1336: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
1337: ,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)
1338: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
1339: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
1340: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category
1341: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1
1342: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2
1343: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3

Line 1340: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category

1336: ,OKL_TERMNT_INTERFACE.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
1337: ,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)
1338: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
1339: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
1340: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category
1341: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1
1342: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2
1343: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3
1344: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4

Line 1341: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1

1337: ,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)
1338: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
1339: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
1340: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category
1341: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1
1342: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2
1343: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3
1344: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4
1345: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5

Line 1342: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2

1338: ,OKL_TERMNT_INTERFACE.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
1339: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
1340: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category
1341: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1
1342: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2
1343: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3
1344: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4
1345: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5
1346: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6

Line 1343: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3

1339: ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
1340: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category
1341: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1
1342: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2
1343: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3
1344: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4
1345: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5
1346: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6
1347: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7

Line 1344: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4

1340: ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY = p_tif_rec.attribute_category
1341: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1
1342: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2
1343: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3
1344: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4
1345: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5
1346: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6
1347: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7
1348: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8

Line 1345: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5

1341: ,OKL_TERMNT_INTERFACE.ATTRIBUTE1 = p_tif_rec.attribute1
1342: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2
1343: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3
1344: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4
1345: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5
1346: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6
1347: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7
1348: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8
1349: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9

Line 1346: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6

1342: ,OKL_TERMNT_INTERFACE.ATTRIBUTE2 = p_tif_rec.attribute2
1343: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3
1344: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4
1345: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5
1346: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6
1347: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7
1348: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8
1349: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9
1350: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10

Line 1347: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7

1343: ,OKL_TERMNT_INTERFACE.ATTRIBUTE3 = p_tif_rec.attribute3
1344: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4
1345: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5
1346: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6
1347: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7
1348: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8
1349: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9
1350: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10
1351: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11

Line 1348: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8

1344: ,OKL_TERMNT_INTERFACE.ATTRIBUTE4 = p_tif_rec.attribute4
1345: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5
1346: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6
1347: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7
1348: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8
1349: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9
1350: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10
1351: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11
1352: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12

Line 1349: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9

1345: ,OKL_TERMNT_INTERFACE.ATTRIBUTE5 = p_tif_rec.attribute5
1346: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6
1347: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7
1348: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8
1349: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9
1350: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10
1351: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11
1352: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12
1353: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13

Line 1350: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10

1346: ,OKL_TERMNT_INTERFACE.ATTRIBUTE6 = p_tif_rec.attribute6
1347: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7
1348: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8
1349: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9
1350: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10
1351: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11
1352: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12
1353: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13
1354: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14

Line 1351: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11

1347: ,OKL_TERMNT_INTERFACE.ATTRIBUTE7 = p_tif_rec.attribute7
1348: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8
1349: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9
1350: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10
1351: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11
1352: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12
1353: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13
1354: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14
1355: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15

Line 1352: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12

1348: ,OKL_TERMNT_INTERFACE.ATTRIBUTE8 = p_tif_rec.attribute8
1349: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9
1350: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10
1351: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11
1352: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12
1353: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13
1354: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14
1355: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15
1356: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by

Line 1353: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13

1349: ,OKL_TERMNT_INTERFACE.ATTRIBUTE9 = p_tif_rec.attribute9
1350: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10
1351: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11
1352: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12
1353: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13
1354: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14
1355: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15
1356: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by
1357: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date

Line 1354: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14

1350: ,OKL_TERMNT_INTERFACE.ATTRIBUTE10 = p_tif_rec.attribute10
1351: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11
1352: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12
1353: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13
1354: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14
1355: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15
1356: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by
1357: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date
1358: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID

Line 1355: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15

1351: ,OKL_TERMNT_INTERFACE.ATTRIBUTE11 = p_tif_rec.attribute11
1352: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12
1353: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13
1354: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14
1355: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15
1356: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by
1357: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date
1358: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1359: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE

Line 1356: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by

1352: ,OKL_TERMNT_INTERFACE.ATTRIBUTE12 = p_tif_rec.attribute12
1353: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13
1354: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14
1355: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15
1356: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by
1357: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date
1358: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1359: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE
1360: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 1357: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date

1353: ,OKL_TERMNT_INTERFACE.ATTRIBUTE13 = p_tif_rec.attribute13
1354: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14
1355: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15
1356: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by
1357: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date
1358: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1359: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE
1360: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1361: ,OKL_TERMNT_INTERFACE.GROUP_NUMBER = p_tif_rec.group_number

Line 1358: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID

1354: ,OKL_TERMNT_INTERFACE.ATTRIBUTE14 = p_tif_rec.attribute14
1355: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15
1356: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by
1357: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date
1358: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1359: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE
1360: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1361: ,OKL_TERMNT_INTERFACE.GROUP_NUMBER = p_tif_rec.group_number
1362: WHERE

Line 1359: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE

1355: ,OKL_TERMNT_INTERFACE.ATTRIBUTE15 = p_tif_rec.attribute15
1356: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by
1357: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date
1358: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1359: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE
1360: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1361: ,OKL_TERMNT_INTERFACE.GROUP_NUMBER = p_tif_rec.group_number
1362: WHERE
1363: OKL_TERMNT_INTERFACE.ROWID =p_tif_rec.row_id;

Line 1360: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1356: ,OKL_TERMNT_INTERFACE.CREATED_BY = p_tif_rec.created_by
1357: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date
1358: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1359: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE
1360: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1361: ,OKL_TERMNT_INTERFACE.GROUP_NUMBER = p_tif_rec.group_number
1362: WHERE
1363: OKL_TERMNT_INTERFACE.ROWID =p_tif_rec.row_id;
1364: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1361: ,OKL_TERMNT_INTERFACE.GROUP_NUMBER = p_tif_rec.group_number

1357: ,OKL_TERMNT_INTERFACE.CREATION_DATE = p_tif_rec.creation_date
1358: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1359: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE
1360: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1361: ,OKL_TERMNT_INTERFACE.GROUP_NUMBER = p_tif_rec.group_number
1362: WHERE
1363: OKL_TERMNT_INTERFACE.ROWID =p_tif_rec.row_id;
1364: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1365:

Line 1363: OKL_TERMNT_INTERFACE.ROWID =p_tif_rec.row_id;

1359: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE = SYSDATE
1360: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1361: ,OKL_TERMNT_INTERFACE.GROUP_NUMBER = p_tif_rec.group_number
1362: WHERE
1363: OKL_TERMNT_INTERFACE.ROWID =p_tif_rec.row_id;
1364: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1365:
1366: OKL_AM_UTIL_PVT.process_messages(p_trx_source_table => 'OKL_TERMNT_INTERFACE',
1367: p_trx_id => p_tif_rec.transaction_number,

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

1362: WHERE
1363: OKL_TERMNT_INTERFACE.ROWID =p_tif_rec.row_id;
1364: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1365:
1366: OKL_AM_UTIL_PVT.process_messages(p_trx_source_table => 'OKL_TERMNT_INTERFACE',
1367: p_trx_id => p_tif_rec.transaction_number,
1368: x_return_status => l_return_status);
1369: x_return_status := l_return_status;
1370: EXCEPTION

Line 1475: FROM OKL_TERMNT_INTERFACE

1471: ,LAST_UPDATED_BY
1472: ,LAST_UPDATE_DATE
1473: ,LAST_UPDATE_LOGIN
1474: ,GROUP_NUMBER
1475: FROM OKL_TERMNT_INTERFACE
1476: WHERE status = p_status
1477: ORDER BY CONTRACT_NUMBER,QUOTE_TYPE_CODE,DATE_EFFECTIVE_FROM,QUOTE_REASON_CODE,ASSET_ID;
1478: BEGIN
1479: record_number:=0;

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

2193: ,x_msg_count => x_msg_count
2194: ,x_return_status => x_return_status
2195: ,p_tif_rec => x_tif_tbl(record_number));
2196: -- Save message from stack into transaction message table
2197: OKL_AM_UTIL_PVT.process_messages(p_trx_source_table => 'OKL_TERMNT_INTERFACE',
2198: p_trx_id => lx_tif_tbl(record_number).transaction_number,
2199: x_return_status => x_return_status);
2200: END LOOP;
2201: END IF;

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

2239: x_tif_tbl OUT NOCOPY tif_tbl_type,
2240: p_tip_tbl IN tip_tbl_type,
2241: x_tip_tbl OUT NOCOPY tip_tbl_type) IS
2242:
2243: -- cursor to retrive contract_id from OKL_TERMNT_INTERFACE joined by transaction_number
2244: CURSOR get_contract_id_csr(p_transaction_number IN NUMBER) IS
2245: SELECT contract_id,status
2246: FROM OKL_TERMNT_INTERFACE
2247: WHERE transaction_number = p_transaction_number;

Line 2246: FROM OKL_TERMNT_INTERFACE

2242:
2243: -- cursor to retrive contract_id from OKL_TERMNT_INTERFACE joined by transaction_number
2244: CURSOR get_contract_id_csr(p_transaction_number IN NUMBER) IS
2245: SELECT contract_id,status
2246: FROM OKL_TERMNT_INTERFACE
2247: WHERE transaction_number = p_transaction_number;
2248:
2249: -- cursor to select the party details using contract_id and quote_role_code
2250: --Fixed Bug # 5484903

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

2328: OKC_API.set_message(p_app_name => g_app_name,
2329: p_msg_name => 'OKL_AM_ERR_INTERFACE',
2330: p_token1 => 'TRANSACTION_NUMBER',
2331: p_token1_value => lx_tip_tbl(record_number).transaction_number);
2332: message :='transaction_number in OKL_TERMNT_INTERFACE is ERROR for transaction number '||lx_tip_tbl(record_number).transaction_number;
2333: ELSE
2334: l_chr_id := interface_dtls.contract_id;
2335: END IF;
2336: END LOOP;

Line 3031: FROM OKL_TERMNT_INTERFACE

3027: ,LAST_UPDATED_BY
3028: ,LAST_UPDATE_DATE
3029: ,LAST_UPDATE_LOGIN
3030: ,GROUP_NUMBER
3031: FROM OKL_TERMNT_INTERFACE
3032: WHERE status = p_status
3033: ORDER BY CONTRACT_NUMBER;
3034:
3035: l_api_version CONSTANT NUMBER := 1;