eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ATP_PVT dependencies on MSC_SATP_FUNC

Line 825: MSC_SATP_FUNC.Get_Regions (

821: IF (p_atp_table.Source_Organization_id(1) IS NULL or p_atp_table.ship_method(1) IS NULL or
822: p_atp_table.delivery_lead_time(1) IS NULL) and (p_atp_table.Calling_Module(1) = 724)
823: and (NVL(p_atp_table.Customer_Site_Id(1), -1) <> NVL(G_SR_PARTNER_SITE_ID, -1)) THEN
824:
825: MSC_SATP_FUNC.Get_Regions (
826: p_customer_site_id => p_atp_table.Customer_Site_Id(1),
827: p_calling_module => p_atp_table.Calling_Module(1),
828: -- i.e. Source (ERP) or Destination (724)
829: p_instance_id => p_instance_id,

Line 951: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table, k,

947:
948: -- arrival set exists
949: l_atp_table := x_atp_table; -- this is to null out l_atp_table;
950: -- get the info for this process item and put into l_atp_table
951: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table, k,
952: l_atp_table, l_return_status );
953: ELSE
954: l_stmt := 160;
955: IF PG_DEBUG in ('Y', 'C') THEN

Line 1227: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table, k,

1223:
1224: -- arrival set exists
1225: l_atp_table := x_atp_table; -- this is to null out l_atp_table;
1226: -- get the info for this process item and put into l_atp_table
1227: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table, k,
1228: l_atp_table, l_return_status );
1229: ELSE
1230: l_stmt := 160;
1231: IF PG_DEBUG in ('Y', 'C') THEN

Line 4927: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table,

4923: END IF;
4924:
4925: IF i = l_ship_count THEN
4926:
4927: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table,
4928: l_temp_atp_table,
4929: l_return_status );
4930:
4931: END IF;

Line 5171: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_atp_table,

5167:
5168: -- if this is an arrival set, since we need to organize the
5169: -- scenario before we actually store the info into x table,
5170: -- let's store the info in temp arr table.
5171: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_atp_table,
5172: l_temp_arr_atp_table,
5173: x_return_status );
5174:
5175: MSC_ATP_PROC.Details_Output(l_temp_atp_period,

Line 5181: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_atp_table,

5177: l_temp_arr_atp_period,
5178: l_temp_arr_atp_supply_demand,
5179: x_return_status);
5180: ELSE
5181: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_atp_table,
5182: x_atp_table,
5183: x_return_status );
5184:
5185: MSC_ATP_PROC.Details_Output(l_temp_atp_period,

Line 5223: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, x_return_status );

5219: ELSE
5220:
5221: -- for oe bug fix : no record for undemand
5222:
5223: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, x_return_status );
5224:
5225: END IF; -- end if action = ATPQUERY or DEMANDADD or DEMANDMODIFY
5226: */
5227:

Line 5275: MSC_SATP_FUNC.Assign_Atp_Input_Rec(l_temp_arr_atp_table,

5271: l_temp_arr_atp_table.Ship_Date(i)+
5272: NVL(l_temp_arr_atp_table.delivery_lead_time(i),0));
5273: --4460369+ MSC_ATP_PVT.G_END_OF_DAY;
5274:
5275: MSC_SATP_FUNC.Assign_Atp_Input_Rec(l_temp_arr_atp_table,
5276: i,
5277: x_atp_table,
5278: l_return_status);
5279:

Line 5322: MSC_SATP_FUNC.Assign_Atp_Input_Rec(l_temp_arr_atp_table,

5318: -- requested_date_quantity
5319:
5320: l_total_qty:=l_total_qty +greatest(0,
5321: l_temp_arr_atp_table.Requested_Date_Quantity(i));
5322: MSC_SATP_FUNC.Assign_Atp_Input_Rec(l_temp_arr_atp_table,
5323: i,
5324: x_atp_table,
5325: l_return_status );
5326:

Line 5375: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_arr_atp_table,

5371: IF PG_DEBUG in ('Y', 'C') THEN
5372: msc_sch_wb.atp_debug('Schedule: ' || 'in arrival set, oe case');
5373: END IF;
5374:
5375: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_arr_atp_table,
5376: x_atp_table,
5377: x_return_status );
5378:
5379: MSC_ATP_PROC.Details_Output(l_temp_arr_atp_period,

Line 5825: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, x_return_status );

5821: --Changes for Bug 3629191: Population of Offset data in Global record ends.
5822:
5823: -- for oe bug fix : no record for undemand
5824:
5825: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, x_return_status );
5826: -- CTO ODR and Simplified Pegging
5827: -- Dealing with the Unschedule process
5828: IF (x_atp_table.Action(1) = DEMANDMODIFY OR
5829: x_atp_table.Action(1) = DEMANDADD OR

Line 5908: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_arr_atp_table, x_atp_table, l_return_status);

5904: END IF;
5905: --for arrivalset l_atp_table contains only the record that we are processing
5906: --- so we need to make sure that we add all the records in arrival set to x_atp_tbale
5907: ---first we add the record we have processed so far
5908: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_arr_atp_table, x_atp_table, l_return_status);
5909: ---now we add the current reocrd
5910: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status);
5911: --now we assign rest of the record.
5912: l_count := l_temp_arr_atp_table.inventory_item_id.count + 2;

Line 5910: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status);

5906: --- so we need to make sure that we add all the records in arrival set to x_atp_tbale
5907: ---first we add the record we have processed so far
5908: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_arr_atp_table, x_atp_table, l_return_status);
5909: ---now we add the current reocrd
5910: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status);
5911: --now we assign rest of the record.
5912: l_count := l_temp_arr_atp_table.inventory_item_id.count + 2;
5913: IF PG_DEBUG in ('Y', 'C') THEN
5914: msc_sch_wb.atp_debug('Schedule: ' || 'l_count := ' || l_count);

Line 5917: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table, i, x_atp_table, l_return_status);

5913: IF PG_DEBUG in ('Y', 'C') THEN
5914: msc_sch_wb.atp_debug('Schedule: ' || 'l_count := ' || l_count);
5915: END IF;
5916: FOR i in l_count..p_atp_table.inventory_item_id.count LOOP
5917: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table, i, x_atp_table, l_return_status);
5918: END LOOP;
5919: ELSE
5920: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status );
5921: END IF;

Line 5920: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status );

5916: FOR i in l_count..p_atp_table.inventory_item_id.count LOOP
5917: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table, i, x_atp_table, l_return_status);
5918: END LOOP;
5919: ELSE
5920: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status );
5921: END IF;
5922:
5923: IF PG_DEBUG in ('Y', 'C') THEN
5924: msc_sch_wb.atp_debug('Schedule: NO_DATA_FOUND: Stmt = '||l_stmt);

Line 6044: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_arr_atp_table, x_atp_table, l_return_status);

6040: END IF;
6041: --for arrivalset l_atp_table contains only the record that we are processing
6042: --- so we need to make sure that we add all the records in arrival set to x_atp_tbale
6043: ---first we add the record we have processed so far
6044: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_arr_atp_table, x_atp_table, l_return_status);
6045: ---now we add the current reocrd
6046: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status);
6047: --now we assign rest of the record.
6048: l_count := l_temp_arr_atp_table.inventory_item_id.count + 2;

Line 6046: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status);

6042: --- so we need to make sure that we add all the records in arrival set to x_atp_tbale
6043: ---first we add the record we have processed so far
6044: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_arr_atp_table, x_atp_table, l_return_status);
6045: ---now we add the current reocrd
6046: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status);
6047: --now we assign rest of the record.
6048: l_count := l_temp_arr_atp_table.inventory_item_id.count + 2;
6049: IF PG_DEBUG in ('Y', 'C') THEN
6050: msc_sch_wb.atp_debug('Schedule: ' || 'l_count := ' || l_count);

Line 6053: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table, i, x_atp_table, l_return_status);

6049: IF PG_DEBUG in ('Y', 'C') THEN
6050: msc_sch_wb.atp_debug('Schedule: ' || 'l_count := ' || l_count);
6051: END IF;
6052: FOR i in l_count..p_atp_table.inventory_item_id.count LOOP
6053: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table, i, x_atp_table, l_return_status);
6054: END LOOP;
6055: END IF;
6056:
6057: -- Error Handling Changes

Line 6193: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_arr_atp_table, x_atp_table, l_return_status);

6189: END IF;
6190: --for arrivalset l_atp_table contains only the record that we are processing
6191: --- so we need to make sure that we add all the records in arrival set to x_atp_tbale
6192: ---first we add the record we have processed so far
6193: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_arr_atp_table, x_atp_table, l_return_status);
6194: ---now we add the current reocrd
6195: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status);
6196: --now we assign rest of the record.
6197: l_count := l_temp_arr_atp_table.inventory_item_id.count + 2;

Line 6195: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status);

6191: --- so we need to make sure that we add all the records in arrival set to x_atp_tbale
6192: ---first we add the record we have processed so far
6193: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_arr_atp_table, x_atp_table, l_return_status);
6194: ---now we add the current reocrd
6195: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status);
6196: --now we assign rest of the record.
6197: l_count := l_temp_arr_atp_table.inventory_item_id.count + 2;
6198: IF PG_DEBUG in ('Y', 'C') THEN
6199: msc_sch_wb.atp_debug('Schedule: ' || 'l_count := ' || l_count);

Line 6202: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table, i, x_atp_table, l_return_status);

6198: IF PG_DEBUG in ('Y', 'C') THEN
6199: msc_sch_wb.atp_debug('Schedule: ' || 'l_count := ' || l_count);
6200: END IF;
6201: FOR i in l_count..p_atp_table.inventory_item_id.count LOOP
6202: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table, i, x_atp_table, l_return_status);
6203: END LOOP;
6204: END IF;
6205:
6206: IF (x_atp_table.Inventory_item_id.COUNT = 0) THEN

Line 6347: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_arr_atp_table, x_atp_table, l_return_status);

6343: END IF;
6344: --for arrivalset l_atp_table contains only the record that we are processing
6345: --- so we need to make sure that we add all the records in arrival set to x_atp_tbale
6346: ---first we add the record we have processed so far
6347: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_arr_atp_table, x_atp_table, l_return_status);
6348: ---now we add the current reocrd
6349: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status);
6350: --now we assign rest of the record.
6351: l_count := l_temp_arr_atp_table.inventory_item_id.count + 2;

Line 6349: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status);

6345: --- so we need to make sure that we add all the records in arrival set to x_atp_tbale
6346: ---first we add the record we have processed so far
6347: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_arr_atp_table, x_atp_table, l_return_status);
6348: ---now we add the current reocrd
6349: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status);
6350: --now we assign rest of the record.
6351: l_count := l_temp_arr_atp_table.inventory_item_id.count + 2;
6352: IF PG_DEBUG in ('Y', 'C') THEN
6353: msc_sch_wb.atp_debug('Schedule: ' || 'l_count := ' || l_count);

Line 6356: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table, i, x_atp_table, l_return_status);

6352: IF PG_DEBUG in ('Y', 'C') THEN
6353: msc_sch_wb.atp_debug('Schedule: ' || 'l_count := ' || l_count);
6354: END IF;
6355: FOR i in l_count..p_atp_table.inventory_item_id.count LOOP
6356: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table, i, x_atp_table, l_return_status);
6357: END LOOP;
6358: END IF;
6359:
6360: -- Error Handling krajan

Line 6520: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_arr_atp_table, x_atp_table, l_return_status);

6516: END IF;
6517: --for arrivalset l_atp_table contains only the record that we are processing
6518: --- so we need to make sure that we add all the records in arrival set to x_atp_tbale
6519: ---first we add the record we have processed so far
6520: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_arr_atp_table, x_atp_table, l_return_status);
6521: ---now we add the current reocrd
6522: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status);
6523: --now we assign rest of the record.
6524: l_count := l_temp_arr_atp_table.inventory_item_id.count + 2;

Line 6522: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status);

6518: --- so we need to make sure that we add all the records in arrival set to x_atp_tbale
6519: ---first we add the record we have processed so far
6520: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_temp_arr_atp_table, x_atp_table, l_return_status);
6521: ---now we add the current reocrd
6522: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_table, x_atp_table, l_return_status);
6523: --now we assign rest of the record.
6524: l_count := l_temp_arr_atp_table.inventory_item_id.count + 2;
6525: IF PG_DEBUG in ('Y', 'C') THEN
6526: msc_sch_wb.atp_debug('Schedule: ' || 'l_count := ' || l_count);

Line 6529: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table, i, x_atp_table, l_return_status);

6525: IF PG_DEBUG in ('Y', 'C') THEN
6526: msc_sch_wb.atp_debug('Schedule: ' || 'l_count := ' || l_count);
6527: END IF;
6528: FOR i in l_count..p_atp_table.inventory_item_id.count LOOP
6529: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table, i, x_atp_table, l_return_status);
6530: END LOOP;
6531: END IF;
6532:
6533: -- Error Handling krajan

Line 17367: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table,

17363: END IF;
17364:
17365: EXIT WHEN i is NULL;
17366: /* ---s_cto_rearch
17367: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table,
17368: i,
17369: l_atp_input_table,
17370: l_return_status );
17371:

Line 17389: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table,

17385:
17386: l_included_item_cntr := nvl(l_included_item_cntr, 0) + 1;
17387: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 1;
17388:
17389: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table,
17390: j,
17391: l_atp_input_table,
17392: l_return_status );
17393:

Line 17426: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table,

17422:
17423: ---either this is first item or PTO included items have already been ATPed. Null out the table
17424: l_mand_comp_info_rec := l_null_mand_comp_info_rec;
17425:
17426: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table,
17427: j,
17428: l_atp_input_table,
17429: l_return_status );
17430:

Line 17555: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table,

17551: msc_sch_wb.atp_debug('SMC or PTO Kit');
17552: END IF;
17553: FOR l_pto_cntr in 1..l_mand_comp_info_rec.sr_inventory_item_id.count LOOP
17554: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 1;
17555: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table,
17556: j,
17557: l_atp_input_table,
17558: l_return_status );
17559: IF PG_DEBUG in ('Y', 'C') THEN

Line 17662: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table,

17658: END IF;
17659:
17660: -- make sure we are in the same ship set before we assign the value.
17661:
17662: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table,
17663: j,
17664: l_atp_input_table,
17665: l_return_status );
17666:

Line 18137: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_output_table,x_atp_table,l_return_status );

18133: --l_atp_output_table.requested_date_quantity(m) := l_atp_input_table.Quantity_Ordered(m);
18134: l_atp_output_table.Error_Code(m) := 0;
18135:
18136: -- bug 5898303
18137: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_output_table,x_atp_table,l_return_status );
18138:
18139: m := l_atp_input_table.Action.NEXT(m);
18140: -- End Bug 2232555, 2250456
18141: END LOOP;

Line 18334: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_output_table,x_atp_table,l_return_status );

18330: END LOOP;
18331: END IF;
18332: --4500382 ENDS
18333: -- now get the results/details and append it to the 'real' output
18334: MSC_SATP_FUNC.Assign_Atp_Output_Rec(l_atp_output_table,x_atp_table,l_return_status );
18335:
18336: MSC_ATP_PROC.Details_Output(l_atp_period,
18337: l_atp_supply_demand,
18338: x_atp_period,

Line 19075: MSC_SATP_FUNC.get_src_to_dstn_profiles(l_dblink,

19071: --bug3940999 start honor profile options passed from the source
19072: -- We have passed atp debug mode profile seperately so that debug mode
19073: -- can be set as we enter Call_Schedule_Remote
19074: IF l_dblink is not null then
19075: MSC_SATP_FUNC.get_src_to_dstn_profiles(l_dblink,
19076: p_session_id,
19077: x_return_status);
19078: END IF;
19079: