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.89.12020000.7 2012/11/29 05:21:25 qiangwan ship $ */
3:
4: -- Start of Comments
5: -- API name MSC_Release_Plan_SC

Line 762: into MSC_Rel_Plan_PUB.g_batch_id;

758: begin
759: -- populating batch_id from destination side seq.
760: Execute immediate 'select mrp_workbench_query_s.nextval
761: FROM DUAL '
762: into MSC_Rel_Plan_PUB.g_batch_id;
763: v_batch_id_populated := 2;
764: exception when others then
765: fnd_file.put_line(FND_FILE.LOG, sqlerrm);
766: end;

Line 1177: into MSC_Rel_Plan_PUB.g_batch_id;

1173: begin
1174: -- populating batch_id from destination side seq.
1175: Execute immediate 'select mrp_workbench_query_s.nextval
1176: FROM DUAL '
1177: into MSC_Rel_Plan_PUB.g_batch_id;
1178: v_batch_id_populated := 2;
1179: exception when others then
1180: fnd_file.put_line(FND_FILE.LOG, sqlerrm);
1181: end;

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

1641: CLOSE c_plan_type;
1642:
1643: IF l_plan_type = 8 THEN
1644:
1645: IF(MSC_Rel_Plan_PUB.G_SPP_SPLIT_YN = 'Y') THEN
1646: Release_IRO_2(
1647: p_dblink => arg_dblink,
1648: p_arg_iro_batch_number => l_batch_number3,
1649: p_arg_owning_instance => arg_owning_instance,

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

1731: --WHERE PLAN_ID = arg_plan_id ;
1732:
1733: IF l_plan_type = 8 THEN
1734:
1735: IF(MSC_Rel_Plan_PUB.G_SPP_SPLIT_YN = 'Y') THEN
1736:
1737: Release_ERO_2(
1738: p_dblink => arg_dblink,
1739: p_arg_ero_batch_number => l_batch_number4,

Line 2952: /* ' 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 */

2948: ' mp2.operating_unit, ' || -- to_operating unit
2949: ' mp.operating_unit, ' || -- src_operating_unit
2950: ' :p_load_type, ' || -- load type
2951: ' d.sales_order_line_id,' || -- sales order line_id
2952: /* ' 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 */
2953: ' decode(instr(d.order_number,ltrim(d.order_number,''0123456789'')), null,to_number(d.order_number), to_number(substr(d.order_number,1,instr(d.order_number,ltrim(d.order_number,''0123456789''))-1))), '|| -- 9849059
2954: ' s.implement_unit_number, ' || -- end item number
2955: ' DECODE(s.implement_firm, 1, ''Y'', ''N''), '||
2956: ' s.transaction_id, ' || -- transaction_id of msc_supplies

Line 13560: END MSC_REL_PLAN_PUB;

13556: NULL;
13557: end;
13558: END SET_RP_TIMESTAMP_PO;
13559:
13560: END MSC_REL_PLAN_PUB;