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_REQ dependencies on MSC_ATP_DB_UTILS

Line 1656: MSC_ATP_DB_UTILS.Clear_SD_Details_temp();

1652: x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ
1653: ) IS
1654: BEGIN
1655:
1656: MSC_ATP_DB_UTILS.Clear_SD_Details_temp();
1657:
1658: IF nvl(p_batching_flag, 0) = 1 THEN
1659: IF nvl(p_optimized_flag, 0) = 1 THEN
1660: get_res_avail_opt_bat_dtls(

Line 4481: MSC_ATP_DB_UTILS.Add_Mat_Demand(l_atp_insert_rec,

4477: l_atp_insert_rec.origination_type := 1;
4478: END IF;
4479: -- End ATP4drp
4480:
4481: MSC_ATP_DB_UTILS.Add_Mat_Demand(l_atp_insert_rec,
4482: l_plan_id,
4483: 0,
4484: l_demand_id);
4485: END IF;

Line 4566: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);

4562: l_pegging_rec.constraint_type := NULL;
4563: --s_cto_rearch
4564: l_pegging_rec.dest_inv_item_id := l_pf_item_id;
4565:
4566: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);
4567:
4568: l_pegging_rec.session_id:= MSC_ATP_PVT.G_SESSION_ID;
4569: l_pegging_rec.order_line_id:= MSC_ATP_PVT.G_ORDER_LINE_ID;
4570: l_pegging_rec.parent_pegging_id:= l_pegging_id;

Line 4624: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_atp_pegging_id);

4620: l_pegging_rec.summary_flag := MSC_ATP_PVT.G_SUMMARY_FLAG;
4621: -- Bug 3826234
4622: l_pegging_rec.manufacturing_cal_code := p_atp_record.manufacturing_cal_code;
4623:
4624: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_atp_pegging_id);
4625:
4626: -- Add pegging_id to the l_atp_period and l_atp_supply_demand
4627:
4628: FOR i in 1..g_atp_period.Level.COUNT LOOP

Line 4634: MSC_ATP_DB_UTILS.move_SD_temp_into_mrp_details(l_atp_pegging_id,

4630: g_atp_period.End_Pegging_Id(i) := MSC_ATP_PVT.G_DEMAND_PEGGING_ID;
4631: END LOOP;
4632:
4633: IF p_atp_record.insert_flag <> 0 THEN
4634: MSC_ATP_DB_UTILS.move_SD_temp_into_mrp_details(l_atp_pegging_id,
4635: MSC_ATP_PVT.G_DEMAND_PEGGING_ID);
4636: END IF;
4637:
4638:

Line 4918: MSC_ATP_DB_UTILS.Clear_SD_Details_temp(); --bug 4618369

4914: IF (l_requested_date >=
4915: NVL(l_infinite_time_fence_date, l_requested_date +1)) THEN
4916: -- requested date outside the infinite time fence. no need to do
4917: -- the actual atp check.
4918: MSC_ATP_DB_UTILS.Clear_SD_Details_temp(); --bug 4618369
4919: p_mat_atp_info_rec.requested_date_quantity := MSC_ATP_PVT.INFINITE_NUMBER;
4920: p_mat_atp_info_rec.atp_date_quantity_this_level := MSC_ATP_PVT.INFINITE_NUMBER;
4921: p_mat_atp_info_rec.atp_date_this_level := l_requested_date;
4922:

Line 5447: MSC_ATP_DB_UTILS.Clear_SD_Details_temp();

5443: msc_sch_wb.atp_debug('Insert_Details: ' || 'Sequence Number Is :'|| l_sysdate_seq_num);
5444: msc_sch_wb.atp_debug('Insert_Details: ' || 'before select');
5445: END IF;
5446:
5447: MSC_ATP_DB_UTILS.Clear_SD_Details_temp();
5448:
5449: --- bug 2152184: compare p_inventory_item_id and l_request_item_id
5450: -- previous condition : p_inventory_item_id = p_request_item_id
5451: -- 2859130

Line 8396: MSC_ATP_DB_UTILS.Add_Resource_Demand(p_instance_id,

8392: l_res_start_date);
8393: END IF;
8394: -- End Bug 3450725
8395:
8396: MSC_ATP_DB_UTILS.Add_Resource_Demand(p_instance_id,
8397: p_plan_id,
8398: l_supply_id,
8399: p_organization_id,
8400: l_resource_id,

Line 8546: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);

8542: -- Bug 3826234
8543: l_pegging_rec.manufacturing_cal_code := NULL;
8544: l_pegging_rec.organization_type := NVL ( MSC_ATP_PVT.G_ORG_INFO_REC.org_type, MSC_ATP_PVT.DISCRETE_ORG); --4775920
8545:
8546: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);
8547:
8548: -- 1487344: instead of getting resource code and department code
8549: -- separately, we get them together to ensure we won't accidently
8550: -- get the line info. Because we display either owing dept or

Line 8651: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);

8647: -- Bug 3826234
8648: l_pegging_rec.manufacturing_cal_code := l_calendar_code;
8649: l_pegging_rec.organization_type := NVL ( MSC_ATP_PVT.G_ORG_INFO_REC.org_type, MSC_ATP_PVT.DISCRETE_ORG); --4775920
8650:
8651: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);
8652:
8653: END IF;
8654:
8655: ELSE

Line 8731: MSC_ATP_DB_UTILS.Add_Resource_Demand(p_instance_id,

8727: END IF;
8728: -- End Bug 3450725
8729: -- End Bug 3348095
8730:
8731: MSC_ATP_DB_UTILS.Add_Resource_Demand(p_instance_id,
8732: p_plan_id,
8733: l_supply_id,
8734: p_organization_id,
8735: l_resource_id,

Line 8871: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);

8867: -- Bug 3826234
8868: l_pegging_rec.manufacturing_cal_code := NULL;
8869: l_pegging_rec.organization_type := NVL ( MSC_ATP_PVT.G_ORG_INFO_REC.org_type, MSC_ATP_PVT.DISCRETE_ORG); --4775920
8870:
8871: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);
8872:
8873: -- 1487344: instead of getting resource code and department code
8874: -- separately, we get them together to ensure we won't accidently
8875: -- get the line info. Because we display either owing dept or

Line 8982: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);

8978: -- Bug 3826234
8979: l_pegging_rec.manufacturing_cal_code := l_calendar_code;
8980: l_pegging_rec.organization_type := NVL ( MSC_ATP_PVT.G_ORG_INFO_REC.org_type, MSC_ATP_PVT.DISCRETE_ORG); --4775920
8981:
8982: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);
8983:
8984: END IF;
8985: END IF;
8986:

Line 9009: MSC_ATP_DB_UTILS.move_SD_temp_into_mrp_details(l_pegging_id,

9005: END LOOP;
9006: */
9007:
9008: IF p_insert_flag <> 0 THEN
9009: MSC_ATP_DB_UTILS.move_SD_temp_into_mrp_details(l_pegging_id,
9010: MSC_ATP_PVT.G_DEMAND_PEGGING_ID);
9011: END IF;
9012:
9013: IF PG_DEBUG in ('Y', 'C') THEN

Line 10846: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);

10842: l_pegging_rec.error_code := l_model_error_code;
10843: --e_cto_rearch
10844:
10845: l_pegging_rec.summary_flag := MSC_ATP_PVT.G_SUMMARY_FLAG; -- for summary enhancement
10846: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);
10847: END IF;
10848: ELSE
10849:
10850: -- ATP4drp Assign parent_item_id for DRP Kitting in DRP plans.

Line 11345: MSC_ATP_DB_UTILS.Clear_SD_Details_Temp();

11341:
11342: IF (NVL(p_sup_atp_info_rec.insert_flag, 0) <> 0) THEN
11343:
11344: -- dsting clear sd details temp table
11345: MSC_ATP_DB_UTILS.Clear_SD_Details_Temp();
11346:
11347: -- add one more entry to indicate infinite time fence date
11348: -- and quantity.
11349: MSC_SATP_FUNC.Extend_Atp_Period(x_atp_period, x_return_status);

Line 11789: MSC_ATP_DB_UTILS.Clear_SD_Details_temp();

11785: END IF; -- IF l_summary_sql = 'Y' THEN
11786:
11787: ELSE -- now p_sup_atp_info_rec.insert_flag <> 0
11788:
11789: MSC_ATP_DB_UTILS.Clear_SD_Details_temp();
11790:
11791: IF l_check_cap_model_flag = 1 THEN
11792: msc_sch_wb.atp_debug('Check Sources for model, details are on');
11793: INSERT INTO msc_atp_sd_details_temp (

Line 12788: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);

12784: l_pegging_rec.supplier_site_id := NULL;
12785: l_pegging_rec.supplier_site_name := NULL;
12786:
12787:
12788: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);
12789:
12790: l_wt_demand_pegging_id := l_pegging_id;
12791:
12792: -- add pegging info for volume demand

Line 12822: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);

12818: l_pegging_rec.supplier_name := NULL;
12819: l_pegging_rec.supplier_site_id := NULL;
12820: l_pegging_rec.supplier_site_name := NULL;
12821:
12822: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);
12823:
12824: l_vol_demand_pegging_id := l_pegging_id;
12825:
12826: -- add pegging info for weight supply

Line 12857: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);

12853: l_pegging_rec.supplier_site_id := NULL;
12854: l_pegging_rec.supplier_site_name := NULL;
12855: l_pegging_rec.source_type := 0;
12856:
12857: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);
12858:
12859: -- add pegging info for volume supply
12860:
12861: l_pegging_rec.session_id := MSC_ATP_PVT.G_SESSION_ID;

Line 12891: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);

12887: l_pegging_rec.supplier_site_name := NULL;
12888:
12889: l_pegging_rec.source_type := 0;
12890:
12891: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);
12892:
12893: FOR i in 1..l_atp_period.Level.COUNT LOOP
12894: l_atp_period.Pegging_Id(i) := l_pegging_id;
12895: l_atp_period.End_Pegging_Id(i) := MSC_ATP_PVT.G_DEMAND_PEGGING_ID;