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