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_DB_UTILS dependencies on MSC_ATP_PROC

Line 153: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_atp_rec.instance_id,

149: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'Insert into summary table');
150: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || ' update msc_atp_summary_so');
151: END IF;
152: -- use hint to do index search
153: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_atp_rec.instance_id,
154: -1,
155: p_atp_rec.organization_id,
156: p_atp_rec.inventory_item_id,
157: p_atp_rec.requested_ship_date,

Line 209: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_atp_rec.instance_id,

205: sysdate,
206: FND_GLOBAL.USER_ID);
207: EXCEPTION
208: WHEN DUP_VAL_ON_INDEX THEN
209: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_atp_rec.instance_id,
210: -1,
211: p_atp_rec.organization_id,
212: p_atp_rec.inventory_item_id,
213: p_atp_rec.requested_ship_date,

Line 593: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_atp_rec.instance_id,

589: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'add demands to summary tables');
590: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'First try to update');
591: END IF;
592:
593: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_atp_rec.instance_id,
594: p_plan_id,
595: p_atp_rec.organization_id,
596: p_atp_rec.inventory_item_id,
597: p_atp_rec.requested_ship_date,

Line 1141: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

1137: IF PG_DEBUG in ('Y', 'C') THEN
1138: msc_sch_wb.atp_debug('Add_Resource_Demand: ' || ' In summary mode update resource req');
1139: msc_sch_wb.atp_debug('Add_Resource_Demand: ' || 'First update');
1140: END IF;
1141: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
1142: p_plan_id,
1143: p_organization_id,
1144: null,
1145: p_start_date,

Line 1200: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

1196: FND_GLOBAL.USER_ID);
1197: EXCEPTION
1198: WHEN DUP_VAL_ON_INDEX THEN
1199:
1200: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
1201: p_plan_id,
1202: p_organization_id,
1203: null,
1204: p_start_date,

Line 2239: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

2235: --- update the MSC_ATP_SUMMARY_SD table
2236: IF PG_DEBUG in ('Y', 'C') THEN
2237: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'update summary table');
2238: END IF;
2239: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2240: p_plan_id,
2241: l_organization_id,
2242: l_inventory_item_id,
2243: c1.supply_demand_date,

Line 2355: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

2351: -- Check for Plan_id=-1 added for summary enhancement
2352: IF PG_DEBUG in ('Y', 'C') THEN
2353: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'summary mode, delete demand');
2354: END IF;
2355: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2356: p_plan_id,
2357: l_organization_id,
2358: l_inventory_item_id,
2359: l_sd_date,

Line 2390: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(c1.identifier1,

2386: IF (c1.summary_flag = 'Y') AND (NVL(c1.supplier_id, -1) <> -1) THEN
2387: IF PG_DEBUG in ('Y', 'C') THEN
2388: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'update suppliers info ');
2389: END IF;
2390: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(c1.identifier1,
2391: p_plan_id,
2392: null,
2393: c1.dest_inv_item_id,
2394: c1.supplier_atp_date,

Line 2416: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(c1.identifier1,

2412: IF PG_DEBUG in ('Y', 'C') THEN
2413: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'Number of rows updated in SUMMARY_SUP := ' || SQL%ROWCOUNT);
2414: END IF;
2415:
2416: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(c1.identifier1,
2417: p_plan_id,
2418: null,
2419: c1.dest_inv_item_id,
2420: c1.supplier_atp_date,

Line 2477: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

2473: IF PG_DEBUG in ('Y', 'C') THEN
2474: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'inventory_item id after conversion := ' || l_inventory_item_id);
2475: END IF;
2476:
2477: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2478: -1,
2479: c1.organization_id,
2480: l_inventory_item_id,
2481: l_sd_date,

Line 2507: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

2503: -- and sd_date = c1.supply_demand_date
2504: and sd_date = trunc(l_sd_date)
2505: and demand_class =Decode(p_dc_flag, 1, NVL(l_demand_class, '@@@'),'@@@') ;
2506:
2507: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2508: -1,
2509: c1.organization_id,
2510: l_inventory_item_id,
2511: l_sd_date,

Line 2554: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

2550: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'l_start_date = ' || l_start_date);
2551: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'l_instance_id = ' || l_instance_id);
2552: END IF;
2553:
2554: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2555: p_plan_id,
2556: l_organization_id,
2557: null,
2558: l_start_date,

Line 2580: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

2576: IF PG_DEBUG in ('Y', 'C') THEN
2577: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'Number of row updated in MSC_ATP_SUMMARY_RES := ' || SQL%ROWCOUNT);
2578: END IF;
2579:
2580: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2581: p_plan_id,
2582: l_organization_id,
2583: null,
2584: l_start_date,

Line 2870: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

2866: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'in Summary mode, update planned orders');
2867: END IF;
2868: IF (p_date is NULL) THEN
2869:
2870: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2871: p_plan_id,
2872: l_organization_id,
2873: l_inventory_item_id,
2874: l_sd_date,

Line 2895: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

2891: and organization_id = l_organization_id
2892: and sd_date = trunc(l_sd_date)
2893: and sr_instance_id = l_instance_id;
2894:
2895: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2896: p_plan_id,
2897: l_organization_id,
2898: l_inventory_item_id,
2899: l_sd_date,

Line 2914: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

2910: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'old and new dates are not same');
2911: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'Update summary for old date');
2912: END IF;
2913:
2914: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2915: p_plan_id,
2916: l_organization_id,
2917: l_inventory_item_id,
2918: l_sd_date,

Line 2935: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

2931: organization_id = l_organization_id and
2932: sd_date = trunc(l_sd_date) and
2933: plan_id = p_plan_id;
2934:
2935: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2936: p_plan_id,
2937: l_organization_id,
2938: l_inventory_item_id,
2939: l_sd_date,

Line 2955: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

2951: IF PG_DEBUG in ('Y', 'C') THEN
2952: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'update the qty on new date ');
2953: END IF;
2954:
2955: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2956: p_plan_id,
2957: l_organization_id,
2958: l_inventory_item_id,
2959: p_date,

Line 3109: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

3105:
3106: IF PG_DEBUG in ('Y', 'C') THEN
3107: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'Summary Mode- update planned order demand');
3108: END IF;
3109: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
3110: l_plan_id,
3111: l_organization_id,
3112: l_inventory_item_id,
3113: l_sd_date,

Line 3287: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

3283: msc_sch_wb.atp_debug('Update_SD_Date: ' || 'l_org_id := ' || l_org_id);
3284: msc_sch_wb.atp_debug('Update_SD_Date: ' || 'Update summary for old date');
3285: END IF;
3286:
3287: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
3288: -1,
3289: l_org_id,
3290: l_inventory_item_id,
3291: l_sd_date,

Line 3316: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

3312: IF PG_DEBUG in ('Y', 'C') THEN
3313: msc_sch_wb.atp_debug('Update_SD_Date: ' || 'update the qty on new date ');
3314: END IF;
3315:
3316: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
3317: -1,
3318: l_org_id,
3319: l_inventory_item_id,
3320: p_supply_demand_date,

Line 3370: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

3366: sysdate,
3367: FND_GLOBAL.USER_ID);
3368: EXCEPTION
3369: WHEN DUP_VAL_ON_INDEX THEN
3370: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
3371: -1,
3372: l_org_id,
3373: l_inventory_item_id,
3374: p_supply_demand_date,

Line 3392: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

3388: and organization_id = l_org_id
3389: and sd_date = trunc(p_supply_demand_date)
3390: and demand_class = Decode(p_dc_flag, 1, NVL(l_demand_class, '@@@'),'@@@') ;
3391:
3392: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
3393: -1,
3394: l_org_id,
3395: l_inventory_item_id,
3396: p_supply_demand_date,

Line 3548: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

3544: msc_sch_wb.atp_debug('Update_SD_Date: ' || 'l_org_id := ' || l_org_id);
3545: msc_sch_wb.atp_debug('Update_SD_Date: ' || 'Update summary for old date');
3546: END IF;
3547:
3548: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
3549: p_plan_id,
3550: l_org_id,
3551: l_inventory_item_id,
3552: p_old_demand_date,

Line 3573: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

3569: IF PG_DEBUG in ('Y', 'C') THEN
3570: msc_sch_wb.atp_debug('Update_SD_Date: ' || 'No of rows update := ' || SQL%ROWCOUNT);
3571: END IF;
3572: commit;
3573: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
3574: p_plan_id,
3575: l_org_id,
3576: l_inventory_item_id,
3577: p_old_demand_date,

Line 3590: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

3586: --- if record exists then update
3587: IF PG_DEBUG in ('Y', 'C') THEN
3588: msc_sch_wb.atp_debug('Update_SD_Date: ' || 'update the qty on new date ');
3589: END IF;
3590: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
3591: p_plan_id,
3592: l_org_id,
3593: l_inventory_item_id,
3594: p_supply_demand_date,

Line 4318: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

4314: sysdate,
4315: FND_GLOBAL.USER_ID);
4316: EXCEPTION
4317: WHEN DUP_VAL_ON_INDEX THEN
4318: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
4319: p_plan_id,
4320: p_organization_id,
4321: p_inventory_item_id,
4322: p_date,

Line 5024: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_supply_rec_type.instance_id,

5020: msc_sch_wb.atp_debug('Add_Planned_Order: ' || 'Create planned orders for summary mode');
5021: msc_sch_wb.atp_debug('Add_Planned_Order: ' || 'First try to update ');
5022: END IF;
5023:
5024: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_supply_rec_type.instance_id,
5025: p_supply_rec_type.plan_id,
5026: p_supply_rec_type.organization_id,
5027: p_supply_rec_type.inventory_item_id,
5028: p_supply_rec_type.schedule_date,