DBA Data[Home] [Help]

APPS.OPI_DBI_WMS_UTILITY_PKG dependencies on FND_GLOBAL

Line 1569: l_user_id := nvl(fnd_global.user_id, -1);

1565: FETCH wdth_cu1_date_csr INTO l_wdth_cu1_date;
1566: CLOSE wdth_cu1_date_csr;
1567:
1568: -- Audit column information
1569: l_user_id := nvl(fnd_global.user_id, -1);
1570: l_login_id := nvl(fnd_global.login_id, -1);
1571: l_program_id := nvl (fnd_global.conc_program_id, -1);
1572: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
1573: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);

Line 1570: l_login_id := nvl(fnd_global.login_id, -1);

1566: CLOSE wdth_cu1_date_csr;
1567:
1568: -- Audit column information
1569: l_user_id := nvl(fnd_global.user_id, -1);
1570: l_login_id := nvl(fnd_global.login_id, -1);
1571: l_program_id := nvl (fnd_global.conc_program_id, -1);
1572: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
1573: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1574: l_request_id := nvl (fnd_global.conc_request_id, -1);

Line 1571: l_program_id := nvl (fnd_global.conc_program_id, -1);

1567:
1568: -- Audit column information
1569: l_user_id := nvl(fnd_global.user_id, -1);
1570: l_login_id := nvl(fnd_global.login_id, -1);
1571: l_program_id := nvl (fnd_global.conc_program_id, -1);
1572: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
1573: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1574: l_request_id := nvl (fnd_global.conc_request_id, -1);
1575:

Line 1572: l_program_login_id := nvl (fnd_global.conc_login_id, -1);

1568: -- Audit column information
1569: l_user_id := nvl(fnd_global.user_id, -1);
1570: l_login_id := nvl(fnd_global.login_id, -1);
1571: l_program_id := nvl (fnd_global.conc_program_id, -1);
1572: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
1573: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1574: l_request_id := nvl (fnd_global.conc_request_id, -1);
1575:
1576:

Line 1573: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);

1569: l_user_id := nvl(fnd_global.user_id, -1);
1570: l_login_id := nvl(fnd_global.login_id, -1);
1571: l_program_id := nvl (fnd_global.conc_program_id, -1);
1572: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
1573: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1574: l_request_id := nvl (fnd_global.conc_request_id, -1);
1575:
1576:
1577: -- Merge the date into the log

Line 1574: l_request_id := nvl (fnd_global.conc_request_id, -1);

1570: l_login_id := nvl(fnd_global.login_id, -1);
1571: l_program_id := nvl (fnd_global.conc_program_id, -1);
1572: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
1573: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1574: l_request_id := nvl (fnd_global.conc_request_id, -1);
1575:
1576:
1577: -- Merge the date into the log
1578: MERGE INTO opi_dbi_conc_prog_run_log base

Line 1726: l_user_id := nvl(fnd_global.user_id, -1);

1722: IF (nvl (l_old_pts_start_date, to_date ('01-01-1951', 'DD-MM-YYYY')) <>
1723: nvl (l_pts_start_date, to_date ('01-01-1951', 'DD-MM-YYYY')) ) THEN
1724:
1725: -- Audit column information
1726: l_user_id := nvl(fnd_global.user_id, -1);
1727: l_login_id := nvl(fnd_global.login_id, -1);
1728: l_program_id := nvl (fnd_global.conc_program_id, -1);
1729: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
1730: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);

Line 1727: l_login_id := nvl(fnd_global.login_id, -1);

1723: nvl (l_pts_start_date, to_date ('01-01-1951', 'DD-MM-YYYY')) ) THEN
1724:
1725: -- Audit column information
1726: l_user_id := nvl(fnd_global.user_id, -1);
1727: l_login_id := nvl(fnd_global.login_id, -1);
1728: l_program_id := nvl (fnd_global.conc_program_id, -1);
1729: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
1730: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1731: l_request_id := nvl (fnd_global.conc_request_id, -1);

Line 1728: l_program_id := nvl (fnd_global.conc_program_id, -1);

1724:
1725: -- Audit column information
1726: l_user_id := nvl(fnd_global.user_id, -1);
1727: l_login_id := nvl(fnd_global.login_id, -1);
1728: l_program_id := nvl (fnd_global.conc_program_id, -1);
1729: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
1730: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1731: l_request_id := nvl (fnd_global.conc_request_id, -1);
1732:

Line 1729: l_program_login_id := nvl (fnd_global.conc_login_id, -1);

1725: -- Audit column information
1726: l_user_id := nvl(fnd_global.user_id, -1);
1727: l_login_id := nvl(fnd_global.login_id, -1);
1728: l_program_id := nvl (fnd_global.conc_program_id, -1);
1729: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
1730: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1731: l_request_id := nvl (fnd_global.conc_request_id, -1);
1732:
1733: -- Merge the date into the log

Line 1730: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);

1726: l_user_id := nvl(fnd_global.user_id, -1);
1727: l_login_id := nvl(fnd_global.login_id, -1);
1728: l_program_id := nvl (fnd_global.conc_program_id, -1);
1729: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
1730: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1731: l_request_id := nvl (fnd_global.conc_request_id, -1);
1732:
1733: -- Merge the date into the log
1734: MERGE INTO opi_dbi_conc_prog_run_log base

Line 1731: l_request_id := nvl (fnd_global.conc_request_id, -1);

1727: l_login_id := nvl(fnd_global.login_id, -1);
1728: l_program_id := nvl (fnd_global.conc_program_id, -1);
1729: l_program_login_id := nvl (fnd_global.conc_login_id, -1);
1730: l_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1731: l_request_id := nvl (fnd_global.conc_request_id, -1);
1732:
1733: -- Merge the date into the log
1734: MERGE INTO opi_dbi_conc_prog_run_log base
1735: USING