APPS.MSC_REL_PLAN_PUB dependencies on MSC_REL_PLAN_PUB

Line 1: PACKAGE BODY MSC_REL_PLAN_PUB AS

1: PACKAGE BODY MSC_REL_PLAN_PUB AS
2: /* $Header: MSCPRELB.pls 120.41.12010000.13 2008/12/23 11:21:01 vsiyer ship $ */
3:
4: -- Start of Comments
5: -- API name MSC_Release_Plan_SC

Line 608: into MSC_Rel_Plan_PUB.g_batch_id;

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

Line 980: into MSC_Rel_Plan_PUB.g_batch_id;

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

Line 1360: IF(MSC_Rel_Plan_PUB.G_SPP_SPLIT_YN = 'Y') THEN

1356:
1357:
1358: IF l_plan_type = 8 THEN
1359:
1360: IF(MSC_Rel_Plan_PUB.G_SPP_SPLIT_YN = 'Y') THEN
1361: Release_IRO_2(
1362: p_dblink => arg_dblink,
1363: p_arg_iro_batch_number => l_batch_number3,
1364: p_arg_owning_instance => arg_owning_instance,

Line 1450: IF(MSC_Rel_Plan_PUB.G_SPP_SPLIT_YN = 'Y') THEN

1446: --WHERE PLAN_ID = arg_plan_id ;
1447:
1448: IF l_plan_type = 8 THEN
1449:
1450: IF(MSC_Rel_Plan_PUB.G_SPP_SPLIT_YN = 'Y') THEN
1451:
1452: Release_ERO_2(
1453: p_dblink => arg_dblink,
1454: p_arg_ero_batch_number => l_batch_number4,

Line 2417: ' to_number(substr(d.order_number,1,instr(d.order_number,ltrim(d.order_number,''0123456789''))-1)) ,' || --' msc_rel_plan_pub.Decode_Sales_Order_Number' || l_dblink || '(d.order_number),' || -- xxx dsting

2413: ' mp.operating_unit, ' || -- src_operating unit
2414: ' mp2.operating_unit, ' || -- to_operating_unit
2415: ' :p_load_type, ' || -- load type
2416: ' d.sales_order_line_id,' || -- sales order line_id
2417: ' to_number(substr(d.order_number,1,instr(d.order_number,ltrim(d.order_number,''0123456789''))-1)) ,' || --' msc_rel_plan_pub.Decode_Sales_Order_Number' || l_dblink || '(d.order_number),' || -- xxx dsting
2418: ' s.implement_unit_number, ' || -- end item number
2419: ' DECODE(s.implement_firm, 1, ''Y'', ''N''), '||
2420: ' s.transaction_id, ' || -- transaction_id of msc_supplies
2421: l_plan_type ||','||

Line 9474: END MSC_REL_PLAN_PUB;

9470: RETURN lv_return_code;
9471:
9472: END reschedule_po_wf;
9473:
9474: END MSC_REL_PLAN_PUB;