DBA Data[Home] [Help]

APPS.OKI_REFRESH_PVT dependencies on FND_GLOBAL

Line 420: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

416: PROGRAM_APPLICATION_ID = g_program_application_id,
417: PROGRAM_ID = g_program_id,
418: PROGRAM_UPDATE_DATE = g_program_update_date,
419: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
420: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
421: LAST_UPDATE_DATE = SYSDATE,
422: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
423: JOB_RUN_ID = p_job_run_id
424: WHERE OBJECT_NAME = p_object_name;

Line 422: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

418: PROGRAM_UPDATE_DATE = g_program_update_date,
419: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
420: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
421: LAST_UPDATE_DATE = SYSDATE,
422: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
423: JOB_RUN_ID = p_job_run_id
424: WHERE OBJECT_NAME = p_object_name;
425:
426: IF SQL%ROWCOUNT <> 1 THEN

Line 474: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

470: PROGRAM_APPLICATION_ID = g_program_application_id,
471: PROGRAM_ID = g_program_id,
472: -- PROGRAM_UPDATE_DATE = g_program_update_date,
473: JOB_RUN_ID = p_job_run_id,
474: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
475: LAST_UPDATE_DATE = SYSDATE,
476: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
477: WHERE OBJECT_NAME = p_object_name;
478:

Line 476: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

472: -- PROGRAM_UPDATE_DATE = g_program_update_date,
473: JOB_RUN_ID = p_job_run_id,
474: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
475: LAST_UPDATE_DATE = SYSDATE,
476: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
477: WHERE OBJECT_NAME = p_object_name;
478:
479: EXCEPTION
480: WHEN OTHERS THEN

Line 574: , FND_GLOBAL.USER_ID

570: , p_job_end_date
571: , least(p_job_curr_start_date,l_sysdate)
572: , least(p_job_curr_end_date,l_sysdate)
573: , l_sysdate
574: , FND_GLOBAL.USER_ID
575: , l_sysdate
576: , FND_GLOBAL.USER_ID
577: , NULL
578: , g_request_id );

Line 576: , FND_GLOBAL.USER_ID

572: , least(p_job_curr_end_date,l_sysdate)
573: , l_sysdate
574: , FND_GLOBAL.USER_ID
575: , l_sysdate
576: , FND_GLOBAL.USER_ID
577: , NULL
578: , g_request_id );
579:
580: p_job_run_id := l_sequence ;

Line 1075: , FND_GLOBAL.USER_ID

1071: , NULL --trx_func_rate
1072: , NULL --trx_base_rate
1073: , NULL --conversion_date
1074: , l_sysdate
1075: , FND_GLOBAL.USER_ID
1076: , l_sysdate
1077: , FND_GLOBAL.USER_ID
1078: , NULL
1079: , g_request_id

Line 1077: , FND_GLOBAL.USER_ID

1073: , NULL --conversion_date
1074: , l_sysdate
1075: , FND_GLOBAL.USER_ID
1076: , l_sysdate
1077: , FND_GLOBAL.USER_ID
1078: , NULL
1079: , g_request_id
1080: , NULL --Major Version
1081: , NULL --Minor Version

Line 1096: , FND_GLOBAL.USER_ID

1092: , NULL --trx_func_rate
1093: , NULL --trx_base_rate
1094: , NULL --conversion_date
1095: , l_sysdate
1096: , FND_GLOBAL.USER_ID
1097: , l_sysdate
1098: , FND_GLOBAL.USER_ID
1099: , NULL
1100: , g_request_id

Line 1098: , FND_GLOBAL.USER_ID

1094: , NULL --conversion_date
1095: , l_sysdate
1096: , FND_GLOBAL.USER_ID
1097: , l_sysdate
1098: , FND_GLOBAL.USER_ID
1099: , NULL
1100: , g_request_id
1101: , NULL --Major Version
1102: , NULL --Minor Version

Line 1144: , FND_GLOBAL.USER_ID

1140: trunc(khr.start_date)
1141: , trunc(sysdate)
1142: ) conversion_date
1143: , l_sysdate
1144: , FND_GLOBAL.USER_ID
1145: , l_sysdate
1146: , FND_GLOBAL.USER_ID
1147: , NULL
1148: , g_request_id

Line 1146: , FND_GLOBAL.USER_ID

1142: ) conversion_date
1143: , l_sysdate
1144: , FND_GLOBAL.USER_ID
1145: , l_sysdate
1146: , FND_GLOBAL.USER_ID
1147: , NULL
1148: , g_request_id
1149: , vnm.major_version
1150: , vnm.minor_version

Line 1433: , FND_GLOBAL.USER_ID

1429: ,l_trx_func_rate_tab(j)
1430: ,l_trx_base_rate_tab(j)
1431: , conversion_date_tab(j)
1432: , l_sysdate
1433: , FND_GLOBAL.USER_ID
1434: , l_sysdate
1435: , FND_GLOBAL.USER_ID
1436: , NULL
1437: , g_request_id

Line 1435: , FND_GLOBAL.USER_ID

1431: , conversion_date_tab(j)
1432: , l_sysdate
1433: , FND_GLOBAL.USER_ID
1434: , l_sysdate
1435: , FND_GLOBAL.USER_ID
1436: , NULL
1437: , g_request_id
1438: ,major_version_tab(j)
1439: ,minor_version_tab(j));

Line 1613: , FND_GLOBAL.USER_ID

1609: -- does not overlap with the previous job run
1610: , l_job_start_date
1611: , l_job_end_date
1612: , l_sysdate
1613: , FND_GLOBAL.USER_ID
1614: , l_sysdate
1615: , FND_GLOBAL.USER_ID
1616: , NULL
1617: , g_request_id

Line 1615: , FND_GLOBAL.USER_ID

1611: , l_job_end_date
1612: , l_sysdate
1613: , FND_GLOBAL.USER_ID
1614: , l_sysdate
1615: , FND_GLOBAL.USER_ID
1616: , NULL
1617: , g_request_id
1618: FROM oki_job_runs jrn1
1619: WHERE jrn1.job_run_id = (

Line 1803: , FND_GLOBAL.USER_ID

1799: , NULL
1800: , l_job_start_date
1801: , l_sysdate
1802: , l_sysdate
1803: , FND_GLOBAL.USER_ID
1804: , l_sysdate
1805: , FND_GLOBAL.USER_ID
1806: , NULL
1807: , g_request_id);

Line 1805: , FND_GLOBAL.USER_ID

1801: , l_sysdate
1802: , l_sysdate
1803: , FND_GLOBAL.USER_ID
1804: , l_sysdate
1805: , FND_GLOBAL.USER_ID
1806: , NULL
1807: , g_request_id);
1808:
1809: COMMIT ;

Line 5395: g_request_id := fnd_global.CONC_REQUEST_ID;

5391: --
5392: ---------------------------------------------------------------------
5393:
5394: BEGIN
5395: g_request_id := fnd_global.CONC_REQUEST_ID;
5396: g_program_application_id := fnd_global.PROG_APPL_ID;
5397: g_program_id := fnd_global.CONC_PROGRAM_ID;
5398: g_program_update_date := SYSDATE;
5399: END OKI_REFRESH_PVT ;

Line 5396: g_program_application_id := fnd_global.PROG_APPL_ID;

5392: ---------------------------------------------------------------------
5393:
5394: BEGIN
5395: g_request_id := fnd_global.CONC_REQUEST_ID;
5396: g_program_application_id := fnd_global.PROG_APPL_ID;
5397: g_program_id := fnd_global.CONC_PROGRAM_ID;
5398: g_program_update_date := SYSDATE;
5399: END OKI_REFRESH_PVT ;

Line 5397: g_program_id := fnd_global.CONC_PROGRAM_ID;

5393:
5394: BEGIN
5395: g_request_id := fnd_global.CONC_REQUEST_ID;
5396: g_program_application_id := fnd_global.PROG_APPL_ID;
5397: g_program_id := fnd_global.CONC_PROGRAM_ID;
5398: g_program_update_date := SYSDATE;
5399: END OKI_REFRESH_PVT ;