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 FND_GLOBAL

Line 527: lp_tif_tbl(record_number).CREATED_BY := FND_GLOBAL.USER_ID;

523: --loops through the interface table records to populate WHO_columns
524: FOR record_number IN lp_tif_tbl.FIRST..lp_tif_tbl.LAST
525: LOOP
526: lp_tif_tbl(record_number).CREATION_DATE := SYSDATE;
527: lp_tif_tbl(record_number).CREATED_BY := FND_GLOBAL.USER_ID;
528: END LOOP;
529: END IF;
530: /* cursor retrives the distinct quote_types from INTERFACE TABLE*/
531: FOR term_rec IN get_quote_type_csr

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 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 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 2296: lx_tip_tbl(record_number).CREATED_BY := FND_GLOBAL.USER_ID;

2292: -- sets the session variables
2293: FOR record_number IN lp_tip_tbl.FIRST..lp_tip_tbl.LAST LOOP
2294: -- populate WHO columns in party table
2295: lx_tip_tbl(record_number).CREATION_DATE := SYSDATE;
2296: lx_tip_tbl(record_number).CREATED_BY := FND_GLOBAL.USER_ID;
2297: l_dup_flag := 'N';
2298: IF(l_transaction_number = lp_tip_tbl(record_number).transaction_number) THEN
2299: lx_tip_tbl(record_number).status := 'ERROR';
2300: l_dup_flag := 'Y';

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 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 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: