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 297: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_atp_rec.instance_id,

293: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'Insert into summary table');
294: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || ' update msc_atp_summary_so');
295: END IF;
296: -- use hint to do index search
297: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_atp_rec.instance_id,
298: -1,
299: p_atp_rec.organization_id,
300: p_atp_rec.inventory_item_id,
301: p_atp_rec.requested_ship_date,

Line 353: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_atp_rec.instance_id,

349: sysdate,
350: FND_GLOBAL.USER_ID);
351: EXCEPTION
352: WHEN DUP_VAL_ON_INDEX THEN
353: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_atp_rec.instance_id,
354: -1,
355: p_atp_rec.organization_id,
356: p_atp_rec.inventory_item_id,
357: p_atp_rec.requested_ship_date,

Line 746: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_atp_rec.instance_id,

742: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'add demands to summary tables');
743: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'First try to update');
744: END IF;
745:
746: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_atp_rec.instance_id,
747: p_plan_id,
748: p_atp_rec.organization_id,
749: p_atp_rec.inventory_item_id,
750: p_atp_rec.requested_ship_date,

Line 1294: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

1290: IF PG_DEBUG in ('Y', 'C') THEN
1291: msc_sch_wb.atp_debug('Add_Resource_Demand: ' || ' In summary mode update resource req');
1292: msc_sch_wb.atp_debug('Add_Resource_Demand: ' || 'First update');
1293: END IF;
1294: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
1295: p_plan_id,
1296: p_organization_id,
1297: null,
1298: p_start_date,

Line 1353: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

1349: FND_GLOBAL.USER_ID);
1350: EXCEPTION
1351: WHEN DUP_VAL_ON_INDEX THEN
1352:
1353: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
1354: p_plan_id,
1355: p_organization_id,
1356: null,
1357: p_start_date,

Line 2396: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

2392: --- update the MSC_ATP_SUMMARY_SD table
2393: IF PG_DEBUG in ('Y', 'C') THEN
2394: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'update summary table');
2395: END IF;
2396: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2397: p_plan_id,
2398: l_organization_id,
2399: l_inventory_item_id,
2400: c1.supply_demand_date,

Line 2512: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

2508: -- Check for Plan_id=-1 added for summary enhancement
2509: IF PG_DEBUG in ('Y', 'C') THEN
2510: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'summary mode, delete demand');
2511: END IF;
2512: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2513: p_plan_id,
2514: l_organization_id,
2515: l_inventory_item_id,
2516: l_sd_date,

Line 2547: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(c1.identifier1,

2543: IF (c1.summary_flag = 'Y') AND (NVL(c1.supplier_id, -1) <> -1) THEN
2544: IF PG_DEBUG in ('Y', 'C') THEN
2545: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'update suppliers info ');
2546: END IF;
2547: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(c1.identifier1,
2548: p_plan_id,
2549: null,
2550: c1.dest_inv_item_id,
2551: c1.supplier_atp_date,

Line 2573: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(c1.identifier1,

2569: IF PG_DEBUG in ('Y', 'C') THEN
2570: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'Number of rows updated in SUMMARY_SUP := ' || SQL%ROWCOUNT);
2571: END IF;
2572:
2573: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(c1.identifier1,
2574: p_plan_id,
2575: null,
2576: c1.dest_inv_item_id,
2577: c1.supplier_atp_date,

Line 2634: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

2630: IF PG_DEBUG in ('Y', 'C') THEN
2631: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'inventory_item id after conversion := ' || l_inventory_item_id);
2632: END IF;
2633:
2634: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2635: -1,
2636: c1.organization_id,
2637: l_inventory_item_id,
2638: l_sd_date,

Line 2664: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

2660: -- and sd_date = c1.supply_demand_date
2661: and sd_date = trunc(l_sd_date)
2662: and demand_class =Decode(p_dc_flag, 1, NVL(l_demand_class, '@@@'),'@@@') ;
2663:
2664: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2665: -1,
2666: c1.organization_id,
2667: l_inventory_item_id,
2668: l_sd_date,

Line 2711: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

2707: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'l_start_date = ' || l_start_date);
2708: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'l_instance_id = ' || l_instance_id);
2709: END IF;
2710:
2711: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2712: p_plan_id,
2713: l_organization_id,
2714: null,
2715: l_start_date,

Line 2737: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

2733: IF PG_DEBUG in ('Y', 'C') THEN
2734: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'Number of row updated in MSC_ATP_SUMMARY_RES := ' || SQL%ROWCOUNT);
2735: END IF;
2736:
2737: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
2738: p_plan_id,
2739: l_organization_id,
2740: null,
2741: l_start_date,

Line 3032: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

3028: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'in Summary mode, update planned orders');
3029: END IF;
3030: IF (p_date is NULL) THEN
3031:
3032: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
3033: p_plan_id,
3034: l_organization_id,
3035: l_inventory_item_id,
3036: l_sd_date,

Line 3057: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

3053: and organization_id = l_organization_id
3054: and sd_date = trunc(l_sd_date)
3055: and sr_instance_id = l_instance_id;
3056:
3057: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
3058: p_plan_id,
3059: l_organization_id,
3060: l_inventory_item_id,
3061: l_sd_date,

Line 3076: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

3072: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'old and new dates are not same');
3073: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'Update summary for old date');
3074: END IF;
3075:
3076: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
3077: p_plan_id,
3078: l_organization_id,
3079: l_inventory_item_id,
3080: l_sd_date,

Line 3097: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

3093: organization_id = l_organization_id and
3094: sd_date = trunc(l_sd_date) and
3095: plan_id = p_plan_id;
3096:
3097: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
3098: p_plan_id,
3099: l_organization_id,
3100: l_inventory_item_id,
3101: l_sd_date,

Line 3117: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

3113: IF PG_DEBUG in ('Y', 'C') THEN
3114: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'update the qty on new date ');
3115: END IF;
3116:
3117: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
3118: p_plan_id,
3119: l_organization_id,
3120: l_inventory_item_id,
3121: p_date,

Line 3271: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,

3267:
3268: IF PG_DEBUG in ('Y', 'C') THEN
3269: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'Summary Mode- update planned order demand');
3270: END IF;
3271: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(l_instance_id,
3272: l_plan_id,
3273: l_organization_id,
3274: l_inventory_item_id,
3275: l_sd_date,

Line 3454: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

3450: msc_sch_wb.atp_debug('Update_SD_Date: ' || 'l_org_id := ' || l_org_id);
3451: msc_sch_wb.atp_debug('Update_SD_Date: ' || 'Update summary for old date');
3452: END IF;
3453:
3454: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
3455: -1,
3456: l_org_id,
3457: l_inventory_item_id,
3458: l_sd_date,

Line 3483: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

3479: IF PG_DEBUG in ('Y', 'C') THEN
3480: msc_sch_wb.atp_debug('Update_SD_Date: ' || 'update the qty on new date ');
3481: END IF;
3482:
3483: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
3484: -1,
3485: l_org_id,
3486: l_inventory_item_id,
3487: p_supply_demand_date,

Line 3537: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

3533: sysdate,
3534: FND_GLOBAL.USER_ID);
3535: EXCEPTION
3536: WHEN DUP_VAL_ON_INDEX THEN
3537: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
3538: -1,
3539: l_org_id,
3540: l_inventory_item_id,
3541: p_supply_demand_date,

Line 3559: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

3555: and organization_id = l_org_id
3556: and sd_date = trunc(p_supply_demand_date)
3557: and demand_class = Decode(p_dc_flag, 1, NVL(l_demand_class, '@@@'),'@@@') ;
3558:
3559: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
3560: -1,
3561: l_org_id,
3562: l_inventory_item_id,
3563: p_supply_demand_date,

Line 3715: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

3711: msc_sch_wb.atp_debug('Update_SD_Date: ' || 'l_org_id := ' || l_org_id);
3712: msc_sch_wb.atp_debug('Update_SD_Date: ' || 'Update summary for old date');
3713: END IF;
3714:
3715: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
3716: p_plan_id,
3717: l_org_id,
3718: l_inventory_item_id,
3719: p_old_demand_date,

Line 3740: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

3736: IF PG_DEBUG in ('Y', 'C') THEN
3737: msc_sch_wb.atp_debug('Update_SD_Date: ' || 'No of rows update := ' || SQL%ROWCOUNT);
3738: END IF;
3739: commit;
3740: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
3741: p_plan_id,
3742: l_org_id,
3743: l_inventory_item_id,
3744: p_old_demand_date,

Line 3757: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

3753: --- if record exists then update
3754: IF PG_DEBUG in ('Y', 'C') THEN
3755: msc_sch_wb.atp_debug('Update_SD_Date: ' || 'update the qty on new date ');
3756: END IF;
3757: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
3758: p_plan_id,
3759: l_org_id,
3760: l_inventory_item_id,
3761: p_supply_demand_date,

Line 4500: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,

4496: sysdate,
4497: FND_GLOBAL.USER_ID);
4498: EXCEPTION
4499: WHEN DUP_VAL_ON_INDEX THEN
4500: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_instance_id,
4501: p_plan_id,
4502: p_organization_id,
4503: p_inventory_item_id,
4504: p_date,

Line 5206: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_supply_rec_type.instance_id,

5202: msc_sch_wb.atp_debug('Add_Planned_Order: ' || 'Create planned orders for summary mode');
5203: msc_sch_wb.atp_debug('Add_Planned_Order: ' || 'First try to update ');
5204: END IF;
5205:
5206: MSC_ATP_PROC.SHOW_SUMMARY_QUANTITY(p_supply_rec_type.instance_id,
5207: p_supply_rec_type.plan_id,
5208: p_supply_rec_type.organization_id,
5209: p_supply_rec_type.inventory_item_id,
5210: p_supply_rec_type.schedule_date,