DBA Data[Home] [Help]

APPS.MSC_REL_PLAN_PUB dependencies on DUAL

Line 197: select nvl(lv_total,0) into lv_total from dual;

193: and NOT (mbc.usage_quantity < 0 and mbc.component_type <> 10)
194: and coprod.order_type = 17
195: and coprod.disposition_id = disp_id;
196:
197: select nvl(lv_total,0) into lv_total from dual;
198:
199: return lv_total;
200:
201: EXCEPTION

Line 601: FROM DUAL;

597:
598: SELECT
599: DECODE(NVL(fnd_profile.value('MSC_RELEASED_BY_USER_ONLY') ,'N'), 'Y',1 ,2)
600: INTO v_msc_released_only_by_user
601: FROM DUAL;
602: v_batch_id_populated := 1;
603: IF (g_batch_id = g_prev_batch_id) OR g_batch_id = -1 THEN
604: begin
605: -- populating batch_id from destination side seq.

Line 607: FROM DUAL '

603: IF (g_batch_id = g_prev_batch_id) OR g_batch_id = -1 THEN
604: begin
605: -- populating batch_id from destination side seq.
606: Execute immediate 'select mrp_workbench_query_s.nextval
607: FROM DUAL '
608: into MSC_Rel_Plan_PUB.g_batch_id;
609: v_batch_id_populated := 2;
610: exception when others then
611: fnd_file.put_line(FND_FILE.LOG, sqlerrm);

Line 624: FROM dual;

620: INTO v_user_id,
621: l_user_name,
622: l_resp_name,
623: l_application_name
624: FROM dual;
625:
626:
627: SELECT APPLICATION_ID
628: INTO l_application_id

Line 973: FROM DUAL;

969:
970: SELECT
971: DECODE(NVL(fnd_profile.value('MSC_RELEASED_BY_USER_ONLY') ,'N'), 'Y',1 ,2)
972: INTO v_msc_released_only_by_user
973: FROM DUAL;
974: v_batch_id_populated := 1;
975: IF (g_batch_id = g_prev_batch_id) OR g_batch_id = -1 THEN
976: begin
977: -- populating batch_id from destination side seq.

Line 979: FROM DUAL '

975: IF (g_batch_id = g_prev_batch_id) OR g_batch_id = -1 THEN
976: begin
977: -- populating batch_id from destination side seq.
978: Execute immediate 'select mrp_workbench_query_s.nextval
979: FROM DUAL '
980: into MSC_Rel_Plan_PUB.g_batch_id;
981: v_batch_id_populated := 2;
982: exception when others then
983: fnd_file.put_line(FND_FILE.LOG, sqlerrm);

Line 996: FROM dual;

992: INTO v_user_id,
993: l_user_name,
994: l_resp_name,
995: l_application_name
996: FROM dual;
997:
998: -------- Release the planned order one instance by one instance.
999:
1000: OPEN c_Instance;

Line 1346: lv_sql_stmt := ' SELECT mrp_workbench_query_s.nextval from dual'|| arg_dblink;

1342: IF ( lv_wf_load_type = IRO_LOAD OR
1343: lv_wf= SYS_NO OR
1344: lv_wf =3) AND l_apps_ver > MSC_UTIL.G_APPS115 THEN
1345:
1346: lv_sql_stmt := ' SELECT mrp_workbench_query_s.nextval from dual'|| arg_dblink;
1347: OPEN c_batch_number for lv_sql_stmt;
1348: FETCH c_batch_number INTO l_batch_number3;
1349: CLOSE c_batch_number;
1350:

Line 1432: lv_sql_stmt := ' SELECT mrp_workbench_query_s.nextval from dual'|| arg_dblink;

1428: IF (lv_wf_load_type = ERO_LOAD OR
1429: lv_wf= SYS_NO OR
1430: lv_wf =3) AND l_apps_ver > MSC_UTIL.G_APPS115 THEN
1431:
1432: lv_sql_stmt := ' SELECT mrp_workbench_query_s.nextval from dual'|| arg_dblink;
1433: OPEN c_batch_number for lv_sql_stmt;
1434: FETCH c_batch_number INTO l_batch_number4;
1435: CLOSE c_batch_number;
1436:

Line 1443: --execute immediate ' SELECT mrp_workbench_query_s@arg_dblink.nextval INTO l_batch_number4 from dual'|| arg_dblink;

1439: OPEN c_plan_type(arg_plan_id);
1440: FETCH c_plan_type INTO l_plan_type;
1441: CLOSE c_plan_type;
1442:
1443: --execute immediate ' SELECT mrp_workbench_query_s@arg_dblink.nextval INTO l_batch_number4 from dual'|| arg_dblink;
1444:
1445: --SELECT msc_plans.mrp_plan_type INTO l_plan_type from MSC_PLANS
1446: --WHERE PLAN_ID = arg_plan_id ;
1447:

Line 1536: lv_sql_stmt := ' SELECT mrp_workbench_query_s.nextval from dual'|| arg_dblink;

1532: no transaction id nor lv_wf_load_type. Therefore, we need to call
1533: the populate_iso_in_source twice. One for new iso, another for re-sche
1534: of ISO with hardcoded load_type. */
1535:
1536: lv_sql_stmt := ' SELECT mrp_workbench_query_s.nextval from dual'|| arg_dblink;
1537:
1538: OPEN c_batch_number for lv_sql_stmt;
1539: FETCH c_batch_number INTO l_batch_number1;
1540: CLOSE c_batch_number;

Line 3769: FROM dual;

3765:
3766: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
3767: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
3768: INTO lv_release_details,lv_inflate_wip
3769: FROM dual;
3770:
3771:
3772: /* we release the lot based job details, only if it doesn't use aggregate resources */
3773:

Line 5751: FROM dual;

5747:
5748: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
5749: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
5750: INTO lv_release_details,lv_inflate_wip
5751: FROM dual;
5752:
5753: /* we release the discrete job, only if it doesn't use aggregate resources */
5754: /* bug 1252659 fix, replace rowid by
5755: (transaction_id,sr_instance_id,plan_id) */