478: into l_argument4, l_argument5
479: from xla_upgrade_dates xud;
480:
481: if (l_argument4 is not null) then
482: AD_CONC_UTILS_PKG.submit_subrequests(
483: X_errbuf=>X_errbuf,
484: X_retcode=>X_retcode,
485: X_WorkerConc_app_shortname=>'BOM',
486: X_WorkerConc_progname=>'CSTUINVW',
701: into l_argument4, l_argument5
702: from xla_upgrade_dates xud;
703:
704: if (l_argument4 is not null) then
705: AD_CONC_UTILS_PKG.submit_subrequests(
706: X_errbuf=>X_errbuf,
707: X_retcode=>X_retcode,
708: X_WorkerConc_app_shortname=>'BOM',
709: X_WorkerConc_progname=>'CSTUWIPW',
923: into l_argument4, l_argument5
924: from xla_upgrade_dates xud;
925:
926: if (l_argument4 is not null) then
927: AD_CONC_UTILS_PKG.submit_subrequests(
928: X_errbuf=>X_errbuf,
929: X_retcode=>X_retcode,
930: X_WorkerConc_app_shortname=>'BOM',
931: X_WorkerConc_progname=>'CSTURCVW',
1050: -- Version : Initial version 1.0
1051: -- Notes : The API is used for defining the "Upgrade Inventory Subledger to SLA"
1052: -- worker Concurrent Executable and Concurrent Program. It is called
1053: -- from Update_Proc_INV_MGR by submitting multiple requests
1054: -- via AD_CONC_UTILS_PKG.submit_subrequests. It is also used by the
1055: -- downtime upgrade script cstmtaupg.sql.
1056: --
1057: -- End of comments
1058: -------------------------------------------------------------------------------------
1189: FALSE);
1190:
1191: end loop;
1192:
1193: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
1194:
1195: EXCEPTION
1196: WHEN OTHERS THEN
1197: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1193: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
1194:
1195: EXCEPTION
1196: WHEN OTHERS THEN
1197: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1198: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1199: raise;
1200: END;
1201:
1302: -- Version : Initial version 1.0
1303: -- Notes : The API is used for defining the "Upgrade WIP Subledger to SLA"
1304: -- worker Concurrent Executable and Concurrent Program. It is called
1305: -- from Update_Proc_WIP_MGR by submitting multiple requests
1306: -- via AD_CONC_UTILS_PKG.submit_subrequests. It is also used by the
1307: -- downtime upgrade script cstwtaupg.sql.
1308: --
1309: -- End of comments
1310: -------------------------------------------------------------------------------------
1439: X_batch_size,
1440: FALSE);
1441:
1442: end loop;
1443: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
1444:
1445: EXCEPTION
1446: WHEN OTHERS THEN
1447: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1443: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
1444:
1445: EXCEPTION
1446: WHEN OTHERS THEN
1447: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1448: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1449: raise;
1450: END;
1451:
1552: -- Version : Initial version 1.0
1553: -- Notes : The API is used for defining the "Upgrade Receiving Subledger to SLA"
1554: -- worker Concurrent Executable and Concurrent Program. It is called
1555: -- from Update_Proc_RCV_MGR by submitting multiple requests
1556: -- via AD_CONC_UTILS_PKG.submit_subrequests. It is also used by the
1557: -- downtime upgrade script cstrrsupg.sql.
1558: --
1559: -- End of comments
1560: -------------------------------------------------------------------------------------
1712: X_batch_size,
1713: FALSE);
1714:
1715: end loop;
1716: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
1717:
1718: EXCEPTION
1719: WHEN OTHERS THEN
1720: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1716: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
1717:
1718: EXCEPTION
1719: WHEN OTHERS THEN
1720: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1721: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1722: raise;
1723: END;
1724: