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 2671: l_transaction_number OKL_TERMNT_INTF_PTY.transaction_number%TYPE;

2667: where transaction_number = p_transaction_number;
2668:
2669: l_count NUMBER;
2670: l_dup_flag VARCHAR2(1);
2671: l_transaction_number OKL_TERMNT_INTF_PTY.transaction_number%TYPE;
2672: l_chr_id NUMBER;
2673: lp_tip_tbl tip_tbl_type;
2674: lx_tip_tbl tip_tbl_type;
2675: l_qpy_id OKL_TERMNT_INTF_PTY.qpy_id%TYPE;

Line 2675: l_qpy_id OKL_TERMNT_INTF_PTY.qpy_id%TYPE;

2671: l_transaction_number OKL_TERMNT_INTF_PTY.transaction_number%TYPE;
2672: l_chr_id NUMBER;
2673: lp_tip_tbl tip_tbl_type;
2674: lx_tip_tbl tip_tbl_type;
2675: l_qpy_id OKL_TERMNT_INTF_PTY.qpy_id%TYPE;
2676: l_party_object_id1 OKL_TERMNT_INTF_PTY.party_object_id1%TYPE;
2677: l_party_object_id2 OKL_TERMNT_INTF_PTY.party_object_id2%TYPE;
2678: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;
2679: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;

Line 2676: l_party_object_id1 OKL_TERMNT_INTF_PTY.party_object_id1%TYPE;

2672: l_chr_id NUMBER;
2673: lp_tip_tbl tip_tbl_type;
2674: lx_tip_tbl tip_tbl_type;
2675: l_qpy_id OKL_TERMNT_INTF_PTY.qpy_id%TYPE;
2676: l_party_object_id1 OKL_TERMNT_INTF_PTY.party_object_id1%TYPE;
2677: l_party_object_id2 OKL_TERMNT_INTF_PTY.party_object_id2%TYPE;
2678: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;
2679: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;
2680: l_contract_party_id OKL_TERMNT_INTF_PTY.contract_party_id%TYPE;

Line 2677: l_party_object_id2 OKL_TERMNT_INTF_PTY.party_object_id2%TYPE;

2673: lp_tip_tbl tip_tbl_type;
2674: lx_tip_tbl tip_tbl_type;
2675: l_qpy_id OKL_TERMNT_INTF_PTY.qpy_id%TYPE;
2676: l_party_object_id1 OKL_TERMNT_INTF_PTY.party_object_id1%TYPE;
2677: l_party_object_id2 OKL_TERMNT_INTF_PTY.party_object_id2%TYPE;
2678: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;
2679: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;
2680: l_contract_party_id OKL_TERMNT_INTF_PTY.contract_party_id%TYPE;
2681: l_contract_party_name OKL_TERMNT_INTF_PTY.contract_party_name%TYPE;

Line 2678: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;

2674: lx_tip_tbl tip_tbl_type;
2675: l_qpy_id OKL_TERMNT_INTF_PTY.qpy_id%TYPE;
2676: l_party_object_id1 OKL_TERMNT_INTF_PTY.party_object_id1%TYPE;
2677: l_party_object_id2 OKL_TERMNT_INTF_PTY.party_object_id2%TYPE;
2678: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;
2679: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;
2680: l_contract_party_id OKL_TERMNT_INTF_PTY.contract_party_id%TYPE;
2681: l_contract_party_name OKL_TERMNT_INTF_PTY.contract_party_name%TYPE;
2682: l_email_address OKL_TERMNT_INTF_PTY.email_address%TYPE;

Line 2679: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;

2675: l_qpy_id OKL_TERMNT_INTF_PTY.qpy_id%TYPE;
2676: l_party_object_id1 OKL_TERMNT_INTF_PTY.party_object_id1%TYPE;
2677: l_party_object_id2 OKL_TERMNT_INTF_PTY.party_object_id2%TYPE;
2678: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;
2679: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;
2680: l_contract_party_id OKL_TERMNT_INTF_PTY.contract_party_id%TYPE;
2681: l_contract_party_name OKL_TERMNT_INTF_PTY.contract_party_name%TYPE;
2682: l_email_address OKL_TERMNT_INTF_PTY.email_address%TYPE;
2683: message VARCHAR2(200);

Line 2680: l_contract_party_id OKL_TERMNT_INTF_PTY.contract_party_id%TYPE;

2676: l_party_object_id1 OKL_TERMNT_INTF_PTY.party_object_id1%TYPE;
2677: l_party_object_id2 OKL_TERMNT_INTF_PTY.party_object_id2%TYPE;
2678: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;
2679: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;
2680: l_contract_party_id OKL_TERMNT_INTF_PTY.contract_party_id%TYPE;
2681: l_contract_party_name OKL_TERMNT_INTF_PTY.contract_party_name%TYPE;
2682: l_email_address OKL_TERMNT_INTF_PTY.email_address%TYPE;
2683: message VARCHAR2(200);
2684: l_msg_tbl msg_tbl_type;

Line 2681: l_contract_party_name OKL_TERMNT_INTF_PTY.contract_party_name%TYPE;

2677: l_party_object_id2 OKL_TERMNT_INTF_PTY.party_object_id2%TYPE;
2678: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;
2679: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;
2680: l_contract_party_id OKL_TERMNT_INTF_PTY.contract_party_id%TYPE;
2681: l_contract_party_name OKL_TERMNT_INTF_PTY.contract_party_name%TYPE;
2682: l_email_address OKL_TERMNT_INTF_PTY.email_address%TYPE;
2683: message VARCHAR2(200);
2684: l_msg_tbl msg_tbl_type;
2685:

Line 2682: l_email_address OKL_TERMNT_INTF_PTY.email_address%TYPE;

2678: l_party_object_code OKL_TERMNT_INTF_PTY.party_object_code%TYPE;
2679: l_contract_party_number OKL_TERMNT_INTF_PTY.contract_party_number%TYPE;
2680: l_contract_party_id OKL_TERMNT_INTF_PTY.contract_party_id%TYPE;
2681: l_contract_party_name OKL_TERMNT_INTF_PTY.contract_party_name%TYPE;
2682: l_email_address OKL_TERMNT_INTF_PTY.email_address%TYPE;
2683: message VARCHAR2(200);
2684: l_msg_tbl msg_tbl_type;
2685:
2686: l_trxn_exists BOOLEAN := FALSE;

Line 3163: UPDATE OKL_TERMNT_INTF_PTY

3159: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3160: RAISE OKC_API.G_EXCEPTION_ERROR;
3161: END IF;
3162: -- updates the party table
3163: UPDATE OKL_TERMNT_INTF_PTY
3164: SET
3165: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID = p_tip_rec.contract_party_id,
3166: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE = p_tip_rec.contract_party_role,
3167: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,

Line 3165: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID = p_tip_rec.contract_party_id,

3161: END IF;
3162: -- updates the party table
3163: UPDATE OKL_TERMNT_INTF_PTY
3164: SET
3165: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID = p_tip_rec.contract_party_id,
3166: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE = p_tip_rec.contract_party_role,
3167: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,
3168: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,
3169: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,

Line 3166: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE = p_tip_rec.contract_party_role,

3162: -- updates the party table
3163: UPDATE OKL_TERMNT_INTF_PTY
3164: SET
3165: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID = p_tip_rec.contract_party_id,
3166: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE = p_tip_rec.contract_party_role,
3167: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,
3168: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,
3169: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,
3170: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,

Line 3167: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,

3163: UPDATE OKL_TERMNT_INTF_PTY
3164: SET
3165: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID = p_tip_rec.contract_party_id,
3166: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE = p_tip_rec.contract_party_role,
3167: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,
3168: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,
3169: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,
3170: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,
3171: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,

Line 3168: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,

3164: SET
3165: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID = p_tip_rec.contract_party_id,
3166: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE = p_tip_rec.contract_party_role,
3167: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,
3168: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,
3169: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,
3170: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,
3171: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,
3172: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,

Line 3169: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,

3165: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID = p_tip_rec.contract_party_id,
3166: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE = p_tip_rec.contract_party_role,
3167: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,
3168: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,
3169: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,
3170: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,
3171: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,
3172: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,
3173: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,

Line 3170: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,

3166: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE = p_tip_rec.contract_party_role,
3167: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,
3168: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,
3169: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,
3170: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,
3171: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,
3172: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,
3173: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,
3174: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,

Line 3171: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,

3167: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME = p_tip_rec.contract_party_name,
3168: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,
3169: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,
3170: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,
3171: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,
3172: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,
3173: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,
3174: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,
3175: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,

Line 3172: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,

3168: OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER = p_tip_rec.contract_party_number,
3169: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,
3170: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,
3171: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,
3172: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,
3173: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,
3174: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,
3175: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,
3176: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,

Line 3173: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,

3169: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE = p_tip_rec.party_object_code,
3170: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,
3171: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,
3172: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,
3173: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,
3174: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,
3175: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,
3176: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,
3177: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,

Line 3174: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,

3170: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1 = p_tip_rec.party_object_id1,
3171: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,
3172: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,
3173: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,
3174: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,
3175: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,
3176: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,
3177: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,
3178: 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 3175: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,

3171: OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2 = p_tip_rec.party_object_id2,
3172: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,
3173: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,
3174: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,
3175: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,
3176: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,
3177: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,
3178: 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),
3179: 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 3176: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,

3172: OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS = p_tip_rec.email_address,
3173: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,
3174: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,
3175: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,
3176: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,
3177: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,
3178: 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),
3179: 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),
3180: 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 3177: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,

3173: OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE = p_tip_rec.allocation_percentage,
3174: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,
3175: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,
3176: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,
3177: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,
3178: 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),
3179: 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),
3180: 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),
3181: 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 3178: 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),

3174: OKL_TERMNT_INTF_PTY.DELAY_DAYS = p_tip_rec.delay_days,
3175: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,
3176: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,
3177: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,
3178: 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),
3179: 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),
3180: 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),
3181: 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),
3182: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,

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

3175: OKL_TERMNT_INTF_PTY.QPY_ID = p_tip_rec.qpy_id,
3176: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,
3177: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,
3178: 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),
3179: 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),
3180: 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),
3181: 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),
3182: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,
3183: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,

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

3176: OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER = p_tip_rec.transaction_number,
3177: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,
3178: 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),
3179: 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),
3180: 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),
3181: 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),
3182: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,
3183: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,
3184: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,

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

3177: OKL_TERMNT_INTF_PTY.STATUS = p_tip_rec.status,
3178: 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),
3179: 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),
3180: 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),
3181: 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),
3182: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,
3183: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,
3184: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,
3185: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,

Line 3182: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,

3178: 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),
3179: 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),
3180: 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),
3181: 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),
3182: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,
3183: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,
3184: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,
3185: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,
3186: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,

Line 3183: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,

3179: 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),
3180: 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),
3181: 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),
3182: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,
3183: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,
3184: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,
3185: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,
3186: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,
3187: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,

Line 3184: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,

3180: 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),
3181: 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),
3182: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,
3183: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,
3184: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,
3185: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,
3186: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,
3187: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,
3188: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,

Line 3185: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,

3181: 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),
3182: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,
3183: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,
3184: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,
3185: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,
3186: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,
3187: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,
3188: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,
3189: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,

Line 3186: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,

3182: OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY = p_tip_rec.attribute_category,
3183: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,
3184: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,
3185: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,
3186: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,
3187: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,
3188: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,
3189: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,
3190: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,

Line 3187: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,

3183: OKL_TERMNT_INTF_PTY.ATTRIBUTE1 = p_tip_rec.attribute1,
3184: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,
3185: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,
3186: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,
3187: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,
3188: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,
3189: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,
3190: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,
3191: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,

Line 3188: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,

3184: OKL_TERMNT_INTF_PTY.ATTRIBUTE2 = p_tip_rec.attribute2,
3185: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,
3186: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,
3187: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,
3188: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,
3189: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,
3190: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,
3191: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,
3192: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,

Line 3189: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,

3185: OKL_TERMNT_INTF_PTY.ATTRIBUTE3 = p_tip_rec.attribute3,
3186: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,
3187: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,
3188: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,
3189: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,
3190: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,
3191: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,
3192: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,
3193: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,

Line 3190: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,

3186: OKL_TERMNT_INTF_PTY.ATTRIBUTE4 = p_tip_rec.attribute4,
3187: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,
3188: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,
3189: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,
3190: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,
3191: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,
3192: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,
3193: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,
3194: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,

Line 3191: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,

3187: OKL_TERMNT_INTF_PTY.ATTRIBUTE5 = p_tip_rec.attribute5,
3188: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,
3189: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,
3190: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,
3191: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,
3192: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,
3193: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,
3194: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,
3195: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,

Line 3192: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,

3188: OKL_TERMNT_INTF_PTY.ATTRIBUTE6 = p_tip_rec.attribute6,
3189: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,
3190: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,
3191: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,
3192: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,
3193: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,
3194: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,
3195: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,
3196: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,

Line 3193: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,

3189: OKL_TERMNT_INTF_PTY.ATTRIBUTE7 = p_tip_rec.attribute7,
3190: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,
3191: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,
3192: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,
3193: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,
3194: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,
3195: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,
3196: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,
3197: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,

Line 3194: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,

3190: OKL_TERMNT_INTF_PTY.ATTRIBUTE8 = p_tip_rec.attribute8,
3191: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,
3192: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,
3193: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,
3194: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,
3195: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,
3196: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,
3197: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,
3198: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,

Line 3195: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,

3191: OKL_TERMNT_INTF_PTY.ATTRIBUTE9 = p_tip_rec.attribute9,
3192: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,
3193: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,
3194: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,
3195: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,
3196: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,
3197: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,
3198: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,
3199: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,

Line 3196: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,

3192: OKL_TERMNT_INTF_PTY.ATTRIBUTE10 = p_tip_rec.attribute10,
3193: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,
3194: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,
3195: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,
3196: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,
3197: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,
3198: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,
3199: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,
3200: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 3197: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,

3193: OKL_TERMNT_INTF_PTY.ATTRIBUTE11 = p_tip_rec.attribute11,
3194: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,
3195: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,
3196: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,
3197: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,
3198: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,
3199: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,
3200: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3201: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,

Line 3198: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,

3194: OKL_TERMNT_INTF_PTY.ATTRIBUTE12 = p_tip_rec.attribute12,
3195: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,
3196: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,
3197: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,
3198: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,
3199: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,
3200: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3201: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,
3202: OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 3199: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,

3195: OKL_TERMNT_INTF_PTY.ATTRIBUTE13 = p_tip_rec.attribute13,
3196: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,
3197: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,
3198: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,
3199: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,
3200: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3201: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,
3202: OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
3203: OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE = p_tip_rec.quote_role_code

Line 3200: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

3196: OKL_TERMNT_INTF_PTY.ATTRIBUTE14 = p_tip_rec.attribute14,
3197: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,
3198: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,
3199: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,
3200: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3201: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,
3202: OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
3203: OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE = p_tip_rec.quote_role_code
3204: WHERE

Line 3201: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,

3197: OKL_TERMNT_INTF_PTY.ATTRIBUTE15 = p_tip_rec.attribute15,
3198: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,
3199: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,
3200: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3201: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,
3202: OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
3203: OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE = p_tip_rec.quote_role_code
3204: WHERE
3205: OKL_TERMNT_INTF_PTY.ROWID =p_tip_rec.row_id;

Line 3202: OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

3198: OKL_TERMNT_INTF_PTY.CREATED_BY = p_tip_rec.created_by,
3199: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,
3200: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3201: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,
3202: OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
3203: OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE = p_tip_rec.quote_role_code
3204: WHERE
3205: OKL_TERMNT_INTF_PTY.ROWID =p_tip_rec.row_id;
3206:

Line 3203: OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE = p_tip_rec.quote_role_code

3199: OKL_TERMNT_INTF_PTY.CREATION_DATE = p_tip_rec.creation_date,
3200: OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3201: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,
3202: OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
3203: OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE = p_tip_rec.quote_role_code
3204: WHERE
3205: OKL_TERMNT_INTF_PTY.ROWID =p_tip_rec.row_id;
3206:
3207: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3205: OKL_TERMNT_INTF_PTY.ROWID =p_tip_rec.row_id;

3201: OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE = SYSDATE,
3202: OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
3203: OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE = p_tip_rec.quote_role_code
3204: WHERE
3205: OKL_TERMNT_INTF_PTY.ROWID =p_tip_rec.row_id;
3206:
3207: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3208: x_return_status := l_return_status;
3209: EXCEPTION

Line 3307: FROM OKL_TERMNT_INTF_PTY

3303: ,LAST_UPDATED_BY
3304: ,LAST_UPDATE_DATE
3305: ,LAST_UPDATE_LOGIN
3306: ,QUOTE_ROLE_CODE
3307: FROM OKL_TERMNT_INTF_PTY
3308: WHERE STATUS = P_STATUS
3309: ORDER BY TRANSACTION_NUMBER;
3310:
3311: BEGIN

Line 3491: l_quote_role_code OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE%TYPE;

3487: l_contract_number l_tif_rec.contract_number%TYPE;
3488: l_quote_type l_tif_rec.quote_type_code%TYPE;
3489: l_quote_reason l_tif_rec.quote_reason_code%TYPE;
3490: l_date_effective_from l_tif_rec.date_effective_from%TYPE;
3491: l_quote_role_code OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE%TYPE;
3492:
3493: l_error_msg_rec ERROR_MESSAGE_TYPE;
3494: BEGIN
3495: IF (G_DEBUG_LEVEL_PROCEDURE >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN