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_INTF_PTY

Line 2271: l_transaction_number OKL_TERMNT_INTF_PTY.transaction_number%TYPE;

2267: WHERE ((party_id = p_object1_id1) AND party_type IN ( 'PERSON','ORGANIZATION'));
2268:
2269: l_count NUMBER;
2270: l_dup_flag VARCHAR2(1);
2271: l_transaction_number OKL_TERMNT_INTF_PTY.transaction_number%TYPE;
2272: l_chr_id NUMBER;
2273: lp_tip_tbl tip_tbl_type;
2274: lx_tip_tbl tip_tbl_type;
2275: l_qpy_id OKL_TERMNT_INTF_PTY.qpy_id%TYPE;

Line 2275: l_qpy_id OKL_TERMNT_INTF_PTY.qpy_id%TYPE;

2271: l_transaction_number OKL_TERMNT_INTF_PTY.transaction_number%TYPE;
2272: l_chr_id NUMBER;
2273: lp_tip_tbl tip_tbl_type;
2274: lx_tip_tbl tip_tbl_type;
2275: l_qpy_id OKL_TERMNT_INTF_PTY.qpy_id%TYPE;
2276: l_party_object_id1 OKL_TERMNT_INTF_PTY.party_object_id1%TYPE;
2277: l_party_object_id2 OKL_TERMNT_INTF_PTY.party_object_id2%TYPE;
2278: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;
2279: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;

Line 2276: l_party_object_id1 OKL_TERMNT_INTF_PTY.party_object_id1%TYPE;

2272: l_chr_id NUMBER;
2273: lp_tip_tbl tip_tbl_type;
2274: lx_tip_tbl tip_tbl_type;
2275: l_qpy_id OKL_TERMNT_INTF_PTY.qpy_id%TYPE;
2276: l_party_object_id1 OKL_TERMNT_INTF_PTY.party_object_id1%TYPE;
2277: l_party_object_id2 OKL_TERMNT_INTF_PTY.party_object_id2%TYPE;
2278: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;
2279: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;
2280: l_contract_party_id OKL_TERMNT_INTF_PTY.contract_party_id%TYPE;

Line 2277: l_party_object_id2 OKL_TERMNT_INTF_PTY.party_object_id2%TYPE;

2273: lp_tip_tbl tip_tbl_type;
2274: lx_tip_tbl tip_tbl_type;
2275: l_qpy_id OKL_TERMNT_INTF_PTY.qpy_id%TYPE;
2276: l_party_object_id1 OKL_TERMNT_INTF_PTY.party_object_id1%TYPE;
2277: l_party_object_id2 OKL_TERMNT_INTF_PTY.party_object_id2%TYPE;
2278: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;
2279: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;
2280: l_contract_party_id OKL_TERMNT_INTF_PTY.contract_party_id%TYPE;
2281: l_contract_party_name OKL_TERMNT_INTF_PTY.contract_party_name%TYPE;

Line 2278: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;

2274: lx_tip_tbl tip_tbl_type;
2275: l_qpy_id OKL_TERMNT_INTF_PTY.qpy_id%TYPE;
2276: l_party_object_id1 OKL_TERMNT_INTF_PTY.party_object_id1%TYPE;
2277: l_party_object_id2 OKL_TERMNT_INTF_PTY.party_object_id2%TYPE;
2278: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;
2279: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;
2280: l_contract_party_id OKL_TERMNT_INTF_PTY.contract_party_id%TYPE;
2281: l_contract_party_name OKL_TERMNT_INTF_PTY.contract_party_name%TYPE;
2282: l_email_address OKL_TERMNT_INTF_PTY.email_address%TYPE;

Line 2279: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;

2275: l_qpy_id OKL_TERMNT_INTF_PTY.qpy_id%TYPE;
2276: l_party_object_id1 OKL_TERMNT_INTF_PTY.party_object_id1%TYPE;
2277: l_party_object_id2 OKL_TERMNT_INTF_PTY.party_object_id2%TYPE;
2278: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;
2279: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;
2280: l_contract_party_id OKL_TERMNT_INTF_PTY.contract_party_id%TYPE;
2281: l_contract_party_name OKL_TERMNT_INTF_PTY.contract_party_name%TYPE;
2282: l_email_address OKL_TERMNT_INTF_PTY.email_address%TYPE;
2283: message VARCHAR2(200);

Line 2280: l_contract_party_id OKL_TERMNT_INTF_PTY.contract_party_id%TYPE;

2276: l_party_object_id1 OKL_TERMNT_INTF_PTY.party_object_id1%TYPE;
2277: l_party_object_id2 OKL_TERMNT_INTF_PTY.party_object_id2%TYPE;
2278: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;
2279: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;
2280: l_contract_party_id OKL_TERMNT_INTF_PTY.contract_party_id%TYPE;
2281: l_contract_party_name OKL_TERMNT_INTF_PTY.contract_party_name%TYPE;
2282: l_email_address OKL_TERMNT_INTF_PTY.email_address%TYPE;
2283: message VARCHAR2(200);
2284: l_msg_tbl msg_tbl_type;

Line 2281: l_contract_party_name OKL_TERMNT_INTF_PTY.contract_party_name%TYPE;

2277: l_party_object_id2 OKL_TERMNT_INTF_PTY.party_object_id2%TYPE;
2278: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;
2279: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;
2280: l_contract_party_id OKL_TERMNT_INTF_PTY.contract_party_id%TYPE;
2281: l_contract_party_name OKL_TERMNT_INTF_PTY.contract_party_name%TYPE;
2282: l_email_address OKL_TERMNT_INTF_PTY.email_address%TYPE;
2283: message VARCHAR2(200);
2284: l_msg_tbl msg_tbl_type;
2285: BEGIN

Line 2282: l_email_address OKL_TERMNT_INTF_PTY.email_address%TYPE;

2278: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;
2279: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;
2280: l_contract_party_id OKL_TERMNT_INTF_PTY.contract_party_id%TYPE;
2281: l_contract_party_name OKL_TERMNT_INTF_PTY.contract_party_name%TYPE;
2282: l_email_address OKL_TERMNT_INTF_PTY.email_address%TYPE;
2283: message VARCHAR2(200);
2284: l_msg_tbl msg_tbl_type;
2285: BEGIN
2286: x_tif_tbl := p_tif_tbl;

Line 2587: UPDATE OKL_TERMNT_INTF_PTY

2583: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2584: RAISE OKC_API.G_EXCEPTION_ERROR;
2585: END IF;
2586: -- updates the party table
2587: UPDATE OKL_TERMNT_INTF_PTY
2588: SET
2589: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID = p_tip_rec.contract_party_id,
2590: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE = p_tip_rec.contract_party_role,
2591: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,

Line 2589: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID = p_tip_rec.contract_party_id,

2585: END IF;
2586: -- updates the party table
2587: UPDATE OKL_TERMNT_INTF_PTY
2588: SET
2589: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID = p_tip_rec.contract_party_id,
2590: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE = p_tip_rec.contract_party_role,
2591: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,
2592: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,
2593: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,

Line 2590: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE = p_tip_rec.contract_party_role,

2586: -- updates the party table
2587: UPDATE OKL_TERMNT_INTF_PTY
2588: SET
2589: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID = p_tip_rec.contract_party_id,
2590: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE = p_tip_rec.contract_party_role,
2591: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,
2592: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,
2593: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,
2594: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,

Line 2591: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,

2587: UPDATE OKL_TERMNT_INTF_PTY
2588: SET
2589: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID = p_tip_rec.contract_party_id,
2590: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE = p_tip_rec.contract_party_role,
2591: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,
2592: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,
2593: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,
2594: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,
2595: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,

Line 2592: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,

2588: SET
2589: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID = p_tip_rec.contract_party_id,
2590: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE = p_tip_rec.contract_party_role,
2591: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,
2592: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,
2593: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,
2594: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,
2595: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,
2596: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,

Line 2593: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,

2589: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID = p_tip_rec.contract_party_id,
2590: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE = p_tip_rec.contract_party_role,
2591: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,
2592: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,
2593: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,
2594: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,
2595: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,
2596: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,
2597: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,

Line 2594: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,

2590: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE = p_tip_rec.contract_party_role,
2591: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,
2592: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,
2593: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,
2594: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,
2595: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,
2596: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,
2597: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,
2598: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,

Line 2595: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,

2591: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,
2592: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,
2593: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,
2594: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,
2595: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,
2596: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,
2597: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,
2598: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,
2599: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,

Line 2596: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,

2592: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,
2593: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,
2594: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,
2595: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,
2596: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,
2597: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,
2598: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,
2599: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,
2600: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,

Line 2597: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,

2593: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,
2594: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,
2595: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,
2596: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,
2597: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,
2598: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,
2599: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,
2600: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,
2601: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,

Line 2598: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,

2594: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,
2595: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,
2596: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,
2597: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,
2598: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,
2599: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,
2600: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,
2601: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,
2602: OKL_TERMNT_INTF_PTY.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tip_rec.request_id),

Line 2599: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,

2595: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,
2596: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,
2597: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,
2598: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,
2599: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,
2600: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,
2601: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,
2602: OKL_TERMNT_INTF_PTY.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tip_rec.request_id),
2603: OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tip_rec.program_application_id),

Line 2600: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,

2596: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,
2597: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,
2598: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,
2599: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,
2600: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,
2601: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,
2602: OKL_TERMNT_INTF_PTY.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tip_rec.request_id),
2603: OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tip_rec.program_application_id),
2604: OKL_TERMNT_INTF_PTY.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tip_rec.program_id),

Line 2601: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,

2597: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,
2598: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,
2599: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,
2600: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,
2601: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,
2602: OKL_TERMNT_INTF_PTY.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tip_rec.request_id),
2603: OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tip_rec.program_application_id),
2604: OKL_TERMNT_INTF_PTY.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tip_rec.program_id),
2605: OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tip_rec.program_update_date,SYSDATE),

Line 2602: OKL_TERMNT_INTF_PTY.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tip_rec.request_id),

2598: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,
2599: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,
2600: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,
2601: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,
2602: OKL_TERMNT_INTF_PTY.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tip_rec.request_id),
2603: OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tip_rec.program_application_id),
2604: OKL_TERMNT_INTF_PTY.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tip_rec.program_id),
2605: OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tip_rec.program_update_date,SYSDATE),
2606: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,

Line 2603: OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tip_rec.program_application_id),

2599: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,
2600: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,
2601: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,
2602: OKL_TERMNT_INTF_PTY.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tip_rec.request_id),
2603: OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tip_rec.program_application_id),
2604: OKL_TERMNT_INTF_PTY.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tip_rec.program_id),
2605: OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tip_rec.program_update_date,SYSDATE),
2606: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,
2607: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,

Line 2604: OKL_TERMNT_INTF_PTY.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tip_rec.program_id),

2600: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,
2601: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,
2602: OKL_TERMNT_INTF_PTY.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tip_rec.request_id),
2603: OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tip_rec.program_application_id),
2604: OKL_TERMNT_INTF_PTY.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tip_rec.program_id),
2605: OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tip_rec.program_update_date,SYSDATE),
2606: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,
2607: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,
2608: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,

Line 2605: OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tip_rec.program_update_date,SYSDATE),

2601: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,
2602: OKL_TERMNT_INTF_PTY.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tip_rec.request_id),
2603: OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tip_rec.program_application_id),
2604: OKL_TERMNT_INTF_PTY.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tip_rec.program_id),
2605: OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tip_rec.program_update_date,SYSDATE),
2606: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,
2607: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,
2608: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,
2609: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,

Line 2606: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,

2602: OKL_TERMNT_INTF_PTY.REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tip_rec.request_id),
2603: OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tip_rec.program_application_id),
2604: OKL_TERMNT_INTF_PTY.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tip_rec.program_id),
2605: OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tip_rec.program_update_date,SYSDATE),
2606: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,
2607: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,
2608: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,
2609: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,
2610: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,

Line 2607: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,

2603: OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tip_rec.program_application_id),
2604: OKL_TERMNT_INTF_PTY.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tip_rec.program_id),
2605: OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tip_rec.program_update_date,SYSDATE),
2606: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,
2607: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,
2608: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,
2609: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,
2610: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,
2611: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,

Line 2608: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,

2604: OKL_TERMNT_INTF_PTY.PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tip_rec.program_id),
2605: OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tip_rec.program_update_date,SYSDATE),
2606: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,
2607: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,
2608: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,
2609: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,
2610: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,
2611: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,
2612: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,

Line 2609: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,

2605: OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tip_rec.program_update_date,SYSDATE),
2606: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,
2607: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,
2608: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,
2609: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,
2610: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,
2611: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,
2612: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,
2613: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,

Line 2610: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,

2606: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,
2607: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,
2608: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,
2609: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,
2610: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,
2611: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,
2612: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,
2613: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,
2614: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,

Line 2611: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,

2607: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,
2608: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,
2609: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,
2610: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,
2611: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,
2612: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,
2613: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,
2614: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,
2615: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,

Line 2612: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,

2608: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,
2609: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,
2610: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,
2611: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,
2612: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,
2613: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,
2614: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,
2615: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,
2616: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,

Line 2613: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,

2609: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,
2610: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,
2611: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,
2612: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,
2613: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,
2614: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,
2615: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,
2616: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,
2617: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,

Line 2614: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,

2610: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,
2611: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,
2612: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,
2613: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,
2614: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,
2615: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,
2616: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,
2617: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,
2618: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,

Line 2615: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,

2611: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,
2612: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,
2613: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,
2614: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,
2615: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,
2616: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,
2617: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,
2618: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,
2619: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,

Line 2616: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,

2612: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,
2613: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,
2614: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,
2615: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,
2616: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,
2617: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,
2618: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,
2619: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,
2620: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,

Line 2617: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,

2613: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,
2614: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,
2615: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,
2616: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,
2617: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,
2618: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,
2619: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,
2620: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,
2621: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,

Line 2618: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,

2614: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,
2615: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,
2616: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,
2617: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,
2618: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,
2619: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,
2620: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,
2621: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,
2622: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,

Line 2619: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,

2615: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,
2616: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,
2617: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,
2618: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,
2619: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,
2620: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,
2621: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,
2622: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,
2623: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,

Line 2620: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,

2616: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,
2617: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,
2618: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,
2619: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,
2620: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,
2621: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,
2622: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,
2623: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,
2624: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 2621: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,

2617: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,
2618: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,
2619: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,
2620: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,
2621: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,
2622: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,
2623: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,
2624: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2625: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,

Line 2622: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,

2618: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,
2619: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,
2620: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,
2621: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,
2622: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,
2623: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,
2624: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2625: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,
2626: OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 2623: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,

2619: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,
2620: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,
2621: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,
2622: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,
2623: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,
2624: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2625: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,
2626: OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2627: OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE = p_tip_rec.quote_role_code

Line 2624: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2620: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,
2621: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,
2622: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,
2623: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,
2624: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2625: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,
2626: OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2627: OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE = p_tip_rec.quote_role_code
2628: WHERE

Line 2625: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,

2621: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,
2622: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,
2623: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,
2624: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2625: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,
2626: OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2627: OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE = p_tip_rec.quote_role_code
2628: WHERE
2629: OKL_TERMNT_INTF_PTY.ROWID =p_tip_rec.row_id;

Line 2626: OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

2622: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,
2623: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,
2624: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2625: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,
2626: OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2627: OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE = p_tip_rec.quote_role_code
2628: WHERE
2629: OKL_TERMNT_INTF_PTY.ROWID =p_tip_rec.row_id;
2630:

Line 2627: OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE = p_tip_rec.quote_role_code

2623: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,
2624: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2625: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,
2626: OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2627: OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE = p_tip_rec.quote_role_code
2628: WHERE
2629: OKL_TERMNT_INTF_PTY.ROWID =p_tip_rec.row_id;
2630:
2631: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2629: OKL_TERMNT_INTF_PTY.ROWID =p_tip_rec.row_id;

2625: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,
2626: OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
2627: OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE = p_tip_rec.quote_role_code
2628: WHERE
2629: OKL_TERMNT_INTF_PTY.ROWID =p_tip_rec.row_id;
2630:
2631: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2632: x_return_status := l_return_status;
2633: EXCEPTION

Line 2730: FROM OKL_TERMNT_INTF_PTY

2726: ,LAST_UPDATED_BY
2727: ,LAST_UPDATE_DATE
2728: ,LAST_UPDATE_LOGIN
2729: ,QUOTE_ROLE_CODE
2730: FROM OKL_TERMNT_INTF_PTY
2731: WHERE STATUS = P_STATUS
2732: ORDER BY TRANSACTION_NUMBER;
2733:
2734: BEGIN