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 8400: MSC_ATP_DB_UTILS.Add_Resource_Demand(p_instance_id,

8396: l_res_start_date);
8397: END IF;
8398: -- End Bug 3450725
8399:
8400: MSC_ATP_DB_UTILS.Add_Resource_Demand(p_instance_id,
8401: p_plan_id,
8402: l_supply_id,
8403: p_organization_id,
8404: l_resource_id,

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

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

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

8651: -- Bug 3826234
8652: l_pegging_rec.manufacturing_cal_code := l_calendar_code;
8653: l_pegging_rec.organization_type := NVL ( MSC_ATP_PVT.G_ORG_INFO_REC.org_type, MSC_ATP_PVT.DISCRETE_ORG); --4775920
8654:
8655: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);
8656:
8657: END IF;
8658:
8659: ELSE

Line 8735: MSC_ATP_DB_UTILS.Add_Resource_Demand(p_instance_id,

8731: END IF;
8732: -- End Bug 3450725
8733: -- End Bug 3348095
8734:
8735: MSC_ATP_DB_UTILS.Add_Resource_Demand(p_instance_id,
8736: p_plan_id,
8737: l_supply_id,
8738: p_organization_id,
8739: l_resource_id,

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

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

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

8982: -- Bug 3826234
8983: l_pegging_rec.manufacturing_cal_code := l_calendar_code;
8984: l_pegging_rec.organization_type := NVL ( MSC_ATP_PVT.G_ORG_INFO_REC.org_type, MSC_ATP_PVT.DISCRETE_ORG); --4775920
8985:
8986: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);
8987:
8988: END IF;
8989: END IF;
8990:

Line 9013: MSC_ATP_DB_UTILS.move_SD_temp_into_mrp_details(l_pegging_id,

9009: END LOOP;
9010: */
9011:
9012: IF p_insert_flag <> 0 THEN
9013: MSC_ATP_DB_UTILS.move_SD_temp_into_mrp_details(l_pegging_id,
9014: MSC_ATP_PVT.G_DEMAND_PEGGING_ID);
9015: END IF;
9016:
9017: IF PG_DEBUG in ('Y', 'C') THEN

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

10863: l_pegging_rec.error_code := l_model_error_code;
10864: --e_cto_rearch
10865:
10866: l_pegging_rec.summary_flag := MSC_ATP_PVT.G_SUMMARY_FLAG; -- for summary enhancement
10867: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);
10868: END IF;
10869: ELSE
10870:
10871: -- ATP4drp Assign parent_item_id for DRP Kitting in DRP plans.

Line 11378: MSC_ATP_DB_UTILS.Clear_SD_Details_Temp();

11374:
11375: IF (NVL(p_sup_atp_info_rec.insert_flag, 0) <> 0) THEN
11376:
11377: -- dsting clear sd details temp table
11378: MSC_ATP_DB_UTILS.Clear_SD_Details_Temp();
11379:
11380: -- add one more entry to indicate infinite time fence date
11381: -- and quantity.
11382: MSC_SATP_FUNC.Extend_Atp_Period(x_atp_period, x_return_status);

Line 11822: MSC_ATP_DB_UTILS.Clear_SD_Details_temp();

11818: END IF; -- IF l_summary_sql = 'Y' THEN
11819:
11820: ELSE -- now p_sup_atp_info_rec.insert_flag <> 0
11821:
11822: MSC_ATP_DB_UTILS.Clear_SD_Details_temp();
11823:
11824: IF l_check_cap_model_flag = 1 THEN
11825: msc_sch_wb.atp_debug('Check Sources for model, details are on');
11826: INSERT INTO msc_atp_sd_details_temp (

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

12817: l_pegging_rec.supplier_site_id := NULL;
12818: l_pegging_rec.supplier_site_name := NULL;
12819:
12820:
12821: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);
12822:
12823: l_wt_demand_pegging_id := l_pegging_id;
12824:
12825: -- add pegging info for volume demand

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

12851: l_pegging_rec.supplier_name := NULL;
12852: l_pegging_rec.supplier_site_id := NULL;
12853: l_pegging_rec.supplier_site_name := NULL;
12854:
12855: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);
12856:
12857: l_vol_demand_pegging_id := l_pegging_id;
12858:
12859: -- add pegging info for weight supply

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

12886: l_pegging_rec.supplier_site_id := NULL;
12887: l_pegging_rec.supplier_site_name := NULL;
12888: l_pegging_rec.source_type := 0;
12889:
12890: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);
12891:
12892: -- add pegging info for volume supply
12893:
12894: l_pegging_rec.session_id := MSC_ATP_PVT.G_SESSION_ID;

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

12920: l_pegging_rec.supplier_site_name := NULL;
12921:
12922: l_pegging_rec.source_type := 0;
12923:
12924: MSC_ATP_DB_UTILS.Add_Pegging(l_pegging_rec, l_pegging_id);
12925:
12926: FOR i in 1..l_atp_period.Level.COUNT LOOP
12927: l_atp_period.Pegging_Id(i) := l_pegging_id;
12928: l_atp_period.End_Pegging_Id(i) := MSC_ATP_PVT.G_DEMAND_PEGGING_ID;