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

550: 'who cols populated : ');
551: end if;
552:
553: lp_tif_tbl(record_number).CREATION_DATE := SYSDATE;
554: lp_tif_tbl(record_number).CREATED_BY := FND_GLOBAL.USER_ID;
555: END LOOP;
556: END IF;
557: /* cursor retrives the distinct quote_types from INTERFACE TABLE*/
558: FOR term_rec IN get_quote_type_csr

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

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

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

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

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

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

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

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

Line 1510: ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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

Line 1512: ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

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

Line 2734: lx_tip_tbl(record_number).CREATED_BY := FND_GLOBAL.USER_ID;

2730:
2731: IF l_trxn_exists THEN
2732: -- populate WHO columns in party table
2733: lx_tip_tbl(record_number).CREATION_DATE := SYSDATE;
2734: lx_tip_tbl(record_number).CREATED_BY := FND_GLOBAL.USER_ID;
2735: l_dup_flag := 'N';
2736: IF(l_transaction_number = lp_tip_tbl(record_number).transaction_number) THEN
2737: lx_tip_tbl(record_number).status := 'ERROR';
2738: l_dup_flag := 'Y';

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