DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_ATP_CTO

Line 234: l_item_sourcing_info_rec MSC_ATP_CTO.item_sourcing_info_rec;

230: l_req_date_qty mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
231: l_demand_class_atp_flag mrp_atp_pub.number_arr := mrp_atp_pub.number_arr();
232:
233: --s_cto_rearch
234: l_item_sourcing_info_rec MSC_ATP_CTO.item_sourcing_info_rec;
235:
236: l_null_item_sourcing_info_rec MSC_ATP_CTO.item_sourcing_info_rec;
237: l_plan_found_for_match number;
238: --e_cto_rearch

Line 236: l_null_item_sourcing_info_rec MSC_ATP_CTO.item_sourcing_info_rec;

232:
233: --s_cto_rearch
234: l_item_sourcing_info_rec MSC_ATP_CTO.item_sourcing_info_rec;
235:
236: l_null_item_sourcing_info_rec MSC_ATP_CTO.item_sourcing_info_rec;
237: l_plan_found_for_match number;
238: --e_cto_rearch
239:
240: -- time_phased_atp

Line 1111: msc_sch_wb.atp_debug('G_MODEL_IS_PRESENT_IN_SET := ' || MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET);

1107:
1108: l_stmt := 130;
1109: IF PG_DEBUG in ('Y', 'C') THEN
1110: msc_sch_wb.atp_debug('Schedule: Stmt = '||l_stmt);
1111: msc_sch_wb.atp_debug('G_MODEL_IS_PRESENT_IN_SET := ' || MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET);
1112: END IF;
1113:
1114: --s_cto_rearch
1115: IF NVL(MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET, 2) = 1 THEN

Line 1115: IF NVL(MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET, 2) = 1 THEN

1111: msc_sch_wb.atp_debug('G_MODEL_IS_PRESENT_IN_SET := ' || MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET);
1112: END IF;
1113:
1114: --s_cto_rearch
1115: IF NVL(MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET, 2) = 1 THEN
1116:
1117: MSC_ATP_CTO.Extend_Sources_Rec(l_sources);
1118:
1119: --L_atp_table contains either then whole ship set or

Line 1117: MSC_ATP_CTO.Extend_Sources_Rec(l_sources);

1113:
1114: --s_cto_rearch
1115: IF NVL(MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET, 2) = 1 THEN
1116:
1117: MSC_ATP_CTO.Extend_Sources_Rec(l_sources);
1118:
1119: --L_atp_table contains either then whole ship set or
1120: --it contains a particular line for arrival set with index K.
1121:

Line 1141: MSC_ATP_CTO.Validate_CTO_Sources(l_sources,

1137: END IF;
1138:
1139:
1140:
1141: MSC_ATP_CTO.Validate_CTO_Sources(l_sources,
1142: l_atp_table.identifier,
1143: p_instance_id,
1144: MSC_ATP_PVT.G_SESSION_ID,
1145: l_return_status);

Line 5043: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET = 1 THEN

5039:
5040: --Changes for Bug 3629191: Population of Offset data in Global record ends.
5041:
5042: -- CTO ODR and Simplified Pegging
5043: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET = 1 THEN
5044:
5045: -- ATP request successfull, create atp pegging
5046: IF PG_DEBUG in ('Y', 'C') THEN
5047: msc_sch_wb.atp_debug('Schedule: ' || 'Model present in Set Creating ATP Pegging');

Line 5091: END IF; -- MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET = 1

5087: END IF;
5088:
5089: END LOOP;
5090:
5091: END IF; -- MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET = 1
5092: -- End CTO ODR and Simplified Pegging
5093:
5094: END IF;
5095: --e_cto_rearch

Line 5099: IF l_inv_ctp = 4 and MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1

5095: --e_cto_rearch
5096: END IF; -- Bug 1661545
5097:
5098: /*-- we now insert new picture for each session. Hence we do not need to update old picture
5099: IF l_inv_ctp = 4 and MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1
5100: AND NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
5101: IF (x_atp_table.action(1) = ATPQUERY or
5102: ((x_atp_table.Action(1) = DEMANDMODIFY OR
5103: x_atp_table.Action(1) = DEMANDADD OR

Line 5108: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,

5104: x_atp_table.Action(1) = DMDRSVADD)
5105: AND NVL(x_atp_table.error_code(1), -1) not in (0, 61))) THEN
5106:
5107: --failure case
5108: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5109: x_atp_table,
5110: MSC_ATP_CTO.FAIL);
5111: ELSE
5112: --scheduling and success

Line 5110: MSC_ATP_CTO.FAIL);

5106:
5107: --failure case
5108: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5109: x_atp_table,
5110: MSC_ATP_CTO.FAIL);
5111: ELSE
5112: --scheduling and success
5113: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5114: x_atp_table,

Line 5113: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,

5109: x_atp_table,
5110: MSC_ATP_CTO.FAIL);
5111: ELSE
5112: --scheduling and success
5113: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5114: x_atp_table,
5115: MSC_ATP_CTO.Success);
5116: END IF;
5117:

Line 5115: MSC_ATP_CTO.Success);

5111: ELSE
5112: --scheduling and success
5113: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5114: x_atp_table,
5115: MSC_ATP_CTO.Success);
5116: END IF;
5117:
5118: END IF;
5119: */

Line 5227: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET);

5223: x_atp_table.Action(1) = DEMANDADD OR
5224: x_atp_table.Action(1) = DMDRSVADD) THEN
5225: IF PG_DEBUG in ('Y', 'C') THEN
5226: msc_sch_wb.atp_debug('Schedule: Model in set : ' ||
5227: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET);
5228: END IF;
5229:
5230: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET = 1 THEN
5231: -- Dealing with Unschedule ATP Process.

Line 5230: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET = 1 THEN

5226: msc_sch_wb.atp_debug('Schedule: Model in set : ' ||
5227: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET);
5228: END IF;
5229:
5230: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET = 1 THEN
5231: -- Dealing with Unschedule ATP Process.
5232: -- So Just Delete the old data.
5233: FOR i in 1..x_atp_table.inventory_item_id.COUNT LOOP
5234: IF (x_atp_table.ATO_Model_Line_Id(i) IS NOT NULL AND

Line 5400: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN

5396: msc_sch_wb.atp_debug('Schedule: ' || 'after resetting the demands when scheduling failed');
5397: END IF;
5398:
5399: /* --s_cto_rearch
5400: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
5401: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5402: x_atp_table,
5403: MSC_ATP_CTO.FAIL);
5404: END IF;

Line 5401: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,

5397: END IF;
5398:
5399: /* --s_cto_rearch
5400: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
5401: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5402: x_atp_table,
5403: MSC_ATP_CTO.FAIL);
5404: END IF;
5405: --e_cto_rearch

Line 5403: MSC_ATP_CTO.FAIL);

5399: /* --s_cto_rearch
5400: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
5401: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5402: x_atp_table,
5403: MSC_ATP_CTO.FAIL);
5404: END IF;
5405: --e_cto_rearch
5406: */
5407:

Line 5540: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN

5536: msc_sch_wb.atp_debug('Schedule: ' || 'after resetting the demands when scheduling failed');
5537: END IF;
5538:
5539: /* --s_cto_rearch
5540: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
5541: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5542: x_atp_table,
5543: MSC_ATP_CTO.FAIL);
5544: END IF;

Line 5541: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,

5537: END IF;
5538:
5539: /* --s_cto_rearch
5540: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
5541: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5542: x_atp_table,
5543: MSC_ATP_CTO.FAIL);
5544: END IF;
5545: --e_cto_rearch

Line 5543: MSC_ATP_CTO.FAIL);

5539: /* --s_cto_rearch
5540: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
5541: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5542: x_atp_table,
5543: MSC_ATP_CTO.FAIL);
5544: END IF;
5545: --e_cto_rearch
5546: */
5547:

Line 5689: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN

5685: msc_sch_wb.atp_debug('Schedule: ' || 'after resetting the demands when scheduling failed');
5686: END IF;
5687:
5688: /*--s_cto_rearch
5689: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
5690: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5691: x_atp_table,
5692: MSC_ATP_CTO.FAIL);
5693: END IF;

Line 5690: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,

5686: END IF;
5687:
5688: /*--s_cto_rearch
5689: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
5690: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5691: x_atp_table,
5692: MSC_ATP_CTO.FAIL);
5693: END IF;
5694: --e_cto_rearch

Line 5692: MSC_ATP_CTO.FAIL);

5688: /*--s_cto_rearch
5689: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
5690: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5691: x_atp_table,
5692: MSC_ATP_CTO.FAIL);
5693: END IF;
5694: --e_cto_rearch
5695: */
5696: END IF;

Line 5841: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN

5837: msc_sch_wb.atp_debug('Schedule: ' || 'after resetting the demands when scheduling failed');
5838: END IF;
5839:
5840: /* --s_cto_rearch
5841: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
5842: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5843: x_atp_table,
5844: MSC_ATP_CTO.FAIL);
5845: END IF;

Line 5842: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,

5838: END IF;
5839:
5840: /* --s_cto_rearch
5841: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
5842: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5843: x_atp_table,
5844: MSC_ATP_CTO.FAIL);
5845: END IF;
5846: --e_cto_rearch

Line 5844: MSC_ATP_CTO.FAIL);

5840: /* --s_cto_rearch
5841: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
5842: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5843: x_atp_table,
5844: MSC_ATP_CTO.FAIL);
5845: END IF;
5846: --e_cto_rearch
5847: */
5848:

Line 6013: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN

6009: msc_sch_wb.atp_debug('Schedule: ' || 'after resetting the demands when scheduling failed');
6010: END IF;
6011:
6012: /* --s_cto_rearch
6013: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
6014: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6015: x_atp_table,
6016: MSC_ATP_CTO.FAIL);
6017: END IF;

Line 6014: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,

6010: END IF;
6011:
6012: /* --s_cto_rearch
6013: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
6014: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6015: x_atp_table,
6016: MSC_ATP_CTO.FAIL);
6017: END IF;
6018: --e_cto_rearch

Line 6016: MSC_ATP_CTO.FAIL);

6012: /* --s_cto_rearch
6013: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
6014: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6015: x_atp_table,
6016: MSC_ATP_CTO.FAIL);
6017: END IF;
6018: --e_cto_rearch
6019: */
6020:

Line 6211: l_item_sourcing_info_rec MSC_ATP_CTO.Item_Sourcing_Info_Rec;

6207: --4570421
6208: l_op_seq_id NUMBER;
6209:
6210: --s_cto_rearch
6211: l_item_sourcing_info_rec MSC_ATP_CTO.Item_Sourcing_Info_Rec;
6212: l_null_item_sourcing_info_rec MSC_ATP_CTO.Item_Sourcing_Info_Rec;
6213: l_get_comp_info_rec MSC_ATP_REQ.get_comp_info_rec;
6214: --l_get_sup_info_rec MSC_ATP_PVT.Supplier_Info_rec;
6215: l_item_info_rec MSC_ATP_PVT.item_attribute_rec;

Line 6212: l_null_item_sourcing_info_rec MSC_ATP_CTO.Item_Sourcing_Info_Rec;

6208: l_op_seq_id NUMBER;
6209:
6210: --s_cto_rearch
6211: l_item_sourcing_info_rec MSC_ATP_CTO.Item_Sourcing_Info_Rec;
6212: l_null_item_sourcing_info_rec MSC_ATP_CTO.Item_Sourcing_Info_Rec;
6213: l_get_comp_info_rec MSC_ATP_REQ.get_comp_info_rec;
6214: --l_get_sup_info_rec MSC_ATP_PVT.Supplier_Info_rec;
6215: l_item_info_rec MSC_ATP_PVT.item_attribute_rec;
6216: l_atp_rule_name varchar2(80);

Line 8894: MSC_ATP_CTO.Check_Base_Model_For_Cap_Check(C_ITEM_INFO_REC.dest_inv_item_id,

8890: C_ITEM_INFO_REC.atp_flag = 'Y' and
8891: C_ITEM_INFO_REC.atp_comp_flag = 'N' and
8892: MSC_ATP_PVT.G_INV_CTP = 4 THEN
8893:
8894: MSC_ATP_CTO.Check_Base_Model_For_Cap_Check(C_ITEM_INFO_REC.dest_inv_item_id,
8895: C_ITEM_INFO_REC.base_item_id,
8896: l_requested_ship_date,
8897: p_atp_record.instance_id,
8898: p_plan_id,

Line 12855: msc_sch_wb.atp_debug('G_MODEL_BOM_IS_COLLECTED := ' || MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED);

12851:
12852: --s_cto_rearch
12853: IF PG_DEBUG in ('Y', 'C') THEN
12854: msc_sch_wb.atp_debug('It is a make case ');
12855: msc_sch_wb.atp_debug('G_MODEL_BOM_IS_COLLECTED := ' || MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED);
12856: msc_sch_wb.atp_debug('Bom Item Flag := ' || PF_ITEM_INFO_REC.bom_item_type);
12857: END IF;
12858: l_get_comp_info_rec.line_id := p_atp_record.demand_source_line;
12859: l_get_comp_info_rec.bom_item_type := PF_ITEM_INFO_REC.Bom_item_type;

Line 12903: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 THEN

12899: l_get_comp_info_rec.parent_line_id := p_atp_record.parent_line_id;
12900: l_get_comp_info_rec.parent_so_quantity := p_atp_record.parent_so_quantity;
12901:
12902: /* -- we also need to get model bom if it has not been collected
12903: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 THEN
12904:
12905: MSC_ATP_CTO.Populate_CTO_Bom(MSC_ATP_PVT.G_SESSION_ID, null);
12906: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 1;
12907:

Line 12905: MSC_ATP_CTO.Populate_CTO_Bom(MSC_ATP_PVT.G_SESSION_ID, null);

12901:
12902: /* -- we also need to get model bom if it has not been collected
12903: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 THEN
12904:
12905: MSC_ATP_CTO.Populate_CTO_Bom(MSC_ATP_PVT.G_SESSION_ID, null);
12906: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 1;
12907:
12908: END IF;
12909: */

Line 12906: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 1;

12902: /* -- we also need to get model bom if it has not been collected
12903: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 THEN
12904:
12905: MSC_ATP_CTO.Populate_CTO_Bom(MSC_ATP_PVT.G_SESSION_ID, null);
12906: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 1;
12907:
12908: END IF;
12909: */
12910: ELSIF PF_ITEM_INFO_REC.bom_item_type = 4 and PF_ITEM_INFO_REC.replenish_to_ord_flag = 'Y' THEN

Line 16298: l_mand_comp_info_rec MSC_ATP_CTO.mand_comp_info_rec;

16294:
16295: --s_cto_rearch
16296: l_included_item_table MRP_ATP_PUB.ATP_Rec_Typ;
16297: l_included_item_cntr number;
16298: l_mand_comp_info_rec MSC_ATP_CTO.mand_comp_info_rec;
16299: l_null_mand_comp_info_rec MSC_ATP_CTO.mand_comp_info_rec;
16300: l_pto_cntr number;
16301: l_count number;
16302: l_parent_idx number;

Line 16299: l_null_mand_comp_info_rec MSC_ATP_CTO.mand_comp_info_rec;

16295: --s_cto_rearch
16296: l_included_item_table MRP_ATP_PUB.ATP_Rec_Typ;
16297: l_included_item_cntr number;
16298: l_mand_comp_info_rec MSC_ATP_CTO.mand_comp_info_rec;
16299: l_null_mand_comp_info_rec MSC_ATP_CTO.mand_comp_info_rec;
16300: l_pto_cntr number;
16301: l_count number;
16302: l_parent_idx number;
16303: l_process_included_item_flag number := 0;

Line 16345: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 2;

16341: G_HIERARCHY_PROFILE:= NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
16342: G_INF_SUP_TF_PAD := GREATEST(CEIL(NVL(FND_PROFILE.VALUE('MSC_ATP_INFINITE_TF_PAD'),0)),0);
16343:
16344: --bug 3625348: reset global variable
16345: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 2;
16346: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 2;
16347: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 2;
16348: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 2;
16349:

Line 16346: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 2;

16342: G_INF_SUP_TF_PAD := GREATEST(CEIL(NVL(FND_PROFILE.VALUE('MSC_ATP_INFINITE_TF_PAD'),0)),0);
16343:
16344: --bug 3625348: reset global variable
16345: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 2;
16346: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 2;
16347: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 2;
16348: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 2;
16349:
16350: -- ngoel 9/27: Reset G_SR_PARTNER_SITE_ID GLOBAL Variable

Line 16347: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 2;

16343:
16344: --bug 3625348: reset global variable
16345: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 2;
16346: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 2;
16347: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 2;
16348: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 2;
16349:
16350: -- ngoel 9/27: Reset G_SR_PARTNER_SITE_ID GLOBAL Variable
16351: G_SR_PARTNER_SITE_ID := NULL;

Line 16348: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 2;

16344: --bug 3625348: reset global variable
16345: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 2;
16346: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 2;
16347: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 2;
16348: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 2;
16349:
16350: -- ngoel 9/27: Reset G_SR_PARTNER_SITE_ID GLOBAL Variable
16351: G_SR_PARTNER_SITE_ID := NULL;
16352:

Line 16494: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 2;

16490: l_atp_details := l_null_atp_details;
16491: --s_cto_rearch
16492: --l_mand_comp_info_rec := l_null_mand_comp_info_rec;
16493: l_set_fail_flag := 'N';
16494: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 2;
16495: --e_cto_rearch
16496:
16497:
16498: IF PG_DEBUG in ('Y', 'C') THEN

Line 16524: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 1;

16520: msc_sch_wb.atp_debug('l_included_item_cntr := ' || l_included_item_cntr);
16521: END IF;
16522:
16523: l_included_item_cntr := nvl(l_included_item_cntr, 0) + 1;
16524: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 1;
16525:
16526: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table,
16527: j,
16528: l_atp_input_table,

Line 16575: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 1;

16571: -- selectively update the data for child lines.
16572: IF PG_DEBUG in ('Y', 'C') THEN
16573: msc_sch_wb.atp_debug('ato model -line is := ' || p_atp_table.ato_model_line_id(j));
16574: END IF;
16575: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 1;
16576: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 1;
16577:
16578:
16579: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 and

Line 16576: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 1;

16572: IF PG_DEBUG in ('Y', 'C') THEN
16573: msc_sch_wb.atp_debug('ato model -line is := ' || p_atp_table.ato_model_line_id(j));
16574: END IF;
16575: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 1;
16576: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 1;
16577:
16578:
16579: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 and
16580: (NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' ) THEN

Line 16579: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 and

16575: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 1;
16576: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 1;
16577:
16578:
16579: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 and
16580: (NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' ) THEN
16581:
16582: MSC_ATP_CTO.Populate_CTO_Bom(MSC_ATP_PVT.G_SESSION_ID, p_refresh_number, null);
16583: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 1;

Line 16582: MSC_ATP_CTO.Populate_CTO_Bom(MSC_ATP_PVT.G_SESSION_ID, p_refresh_number, null);

16578:
16579: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 and
16580: (NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' ) THEN
16581:
16582: MSC_ATP_CTO.Populate_CTO_Bom(MSC_ATP_PVT.G_SESSION_ID, p_refresh_number, null);
16583: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 1;
16584:
16585: END IF;
16586: END IF;

Line 16583: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 1;

16579: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 and
16580: (NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' ) THEN
16581:
16582: MSC_ATP_CTO.Populate_CTO_Bom(MSC_ATP_PVT.G_SESSION_ID, p_refresh_number, null);
16583: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 1;
16584:
16585: END IF;
16586: END IF;
16587:

Line 16666: MSC_ATP_CTO.Get_Mandatory_Components( -1,

16662: END IF;
16663:
16664: --- included items are not passed. Explode them
16665: MSC_ATP_PVT.G_PTF_DATE := sysdate;
16666: MSC_ATP_CTO.Get_Mandatory_Components( -1,
16667: p_instance_id,
16668: p_atp_table.validation_org(j),
16669: p_atp_table.inventory_item_id(j),
16670: p_atp_table.quantity_ordered(j),

Line 16691: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 1;

16687: msc_sch_wb.atp_debug('Comp Count := ' || l_mand_comp_info_rec.sr_inventory_item_id.count);
16688: msc_sch_wb.atp_debug('SMC or PTO Kit');
16689: END IF;
16690: FOR l_pto_cntr in 1..l_mand_comp_info_rec.sr_inventory_item_id.count LOOP
16691: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 1;
16692: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table,
16693: j,
16694: l_atp_input_table,
16695: l_return_status );