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_PVT dependencies on MSC_ATP_CTO

Line 236: l_item_sourcing_info_rec MSC_ATP_CTO.item_sourcing_info_rec;

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

Line 238: l_null_item_sourcing_info_rec MSC_ATP_CTO.item_sourcing_info_rec;

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

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

1149:
1150: l_stmt := 130;
1151: IF PG_DEBUG in ('Y', 'C') THEN
1152: msc_sch_wb.atp_debug('Schedule: Stmt = '||l_stmt);
1153: msc_sch_wb.atp_debug('G_MODEL_IS_PRESENT_IN_SET := ' || MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET);
1154: END IF;
1155:
1156: --s_cto_rearch
1157: IF NVL(MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET, 2) = 1 THEN

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

1153: msc_sch_wb.atp_debug('G_MODEL_IS_PRESENT_IN_SET := ' || MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET);
1154: END IF;
1155:
1156: --s_cto_rearch
1157: IF NVL(MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET, 2) = 1 THEN
1158:
1159: IF (l_sources.organization_id.count = 0) THEN --bug#12617952
1160: MSC_ATP_CTO.Extend_Sources_Rec(l_sources);
1161: END IF;

Line 1160: MSC_ATP_CTO.Extend_Sources_Rec(l_sources);

1156: --s_cto_rearch
1157: IF NVL(MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET, 2) = 1 THEN
1158:
1159: IF (l_sources.organization_id.count = 0) THEN --bug#12617952
1160: MSC_ATP_CTO.Extend_Sources_Rec(l_sources);
1161: END IF;
1162:
1163: --L_atp_table contains either then whole ship set or
1164: --it contains a particular line for arrival set with index K.

Line 1185: MSC_ATP_CTO.Validate_CTO_Sources(l_sources,

1181: END IF;
1182:
1183:
1184:
1185: MSC_ATP_CTO.Validate_CTO_Sources(l_sources,
1186: l_atp_table.identifier,
1187: p_instance_id,
1188: MSC_ATP_PVT.G_SESSION_ID,
1189: l_return_status);

Line 5649: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET = 1 THEN

5645:
5646: --Changes for Bug 3629191: Population of Offset data in Global record ends.
5647:
5648: -- CTO ODR and Simplified Pegging
5649: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET = 1 THEN
5650:
5651: -- ATP request successfull, create atp pegging
5652: IF PG_DEBUG in ('Y', 'C') THEN
5653: msc_sch_wb.atp_debug('Schedule: ' || 'Model present in Set Creating ATP Pegging');

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

5693: END IF;
5694:
5695: END LOOP;
5696:
5697: END IF; -- MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET = 1
5698: -- End CTO ODR and Simplified Pegging
5699:
5700: END IF;
5701: --e_cto_rearch

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

5701: --e_cto_rearch
5702: END IF; -- Bug 1661545
5703:
5704: /*-- we now insert new picture for each session. Hence we do not need to update old picture
5705: IF l_inv_ctp = 4 and MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1
5706: AND NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
5707: IF (x_atp_table.action(1) = ATPQUERY or
5708: ((x_atp_table.Action(1) = DEMANDMODIFY OR
5709: x_atp_table.Action(1) = DEMANDADD OR

Line 5714: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,

5710: x_atp_table.Action(1) = DMDRSVADD)
5711: AND NVL(x_atp_table.error_code(1), -1) not in (0, 61))) THEN
5712:
5713: --failure case
5714: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5715: x_atp_table,
5716: MSC_ATP_CTO.FAIL);
5717: ELSE
5718: --scheduling and success

Line 5716: MSC_ATP_CTO.FAIL);

5712:
5713: --failure case
5714: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5715: x_atp_table,
5716: MSC_ATP_CTO.FAIL);
5717: ELSE
5718: --scheduling and success
5719: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5720: x_atp_table,

Line 5719: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,

5715: x_atp_table,
5716: MSC_ATP_CTO.FAIL);
5717: ELSE
5718: --scheduling and success
5719: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5720: x_atp_table,
5721: MSC_ATP_CTO.Success);
5722: END IF;
5723:

Line 5721: MSC_ATP_CTO.Success);

5717: ELSE
5718: --scheduling and success
5719: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
5720: x_atp_table,
5721: MSC_ATP_CTO.Success);
5722: END IF;
5723:
5724: END IF;
5725: */

Line 5833: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET);

5829: x_atp_table.Action(1) = DEMANDADD OR
5830: x_atp_table.Action(1) = DMDRSVADD) THEN
5831: IF PG_DEBUG in ('Y', 'C') THEN
5832: msc_sch_wb.atp_debug('Schedule: Model in set : ' ||
5833: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET);
5834: END IF;
5835:
5836: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET = 1 THEN
5837: -- Dealing with Unschedule ATP Process.

Line 5836: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET = 1 THEN

5832: msc_sch_wb.atp_debug('Schedule: Model in set : ' ||
5833: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET);
5834: END IF;
5835:
5836: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET = 1 THEN
5837: -- Dealing with Unschedule ATP Process.
5838: -- So Just Delete the old data.
5839: FOR i in 1..x_atp_table.inventory_item_id.COUNT LOOP
5840: IF (x_atp_table.ATO_Model_Line_Id(i) IS NOT NULL AND

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

6004: msc_sch_wb.atp_debug('Schedule: ' || 'after resetting the demands when scheduling failed');
6005: END IF;
6006:
6007: /* --s_cto_rearch
6008: 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_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6010: x_atp_table,
6011: MSC_ATP_CTO.FAIL);
6012: END IF;

Line 6009: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,

6005: END IF;
6006:
6007: /* --s_cto_rearch
6008: 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_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6010: x_atp_table,
6011: MSC_ATP_CTO.FAIL);
6012: END IF;
6013: --e_cto_rearch

Line 6011: MSC_ATP_CTO.FAIL);

6007: /* --s_cto_rearch
6008: 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_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6010: x_atp_table,
6011: MSC_ATP_CTO.FAIL);
6012: END IF;
6013: --e_cto_rearch
6014: */
6015:

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

6146: msc_sch_wb.atp_debug('Schedule: ' || 'after resetting the demands when scheduling failed');
6147: END IF;
6148:
6149: /* --s_cto_rearch
6150: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
6151: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6152: x_atp_table,
6153: MSC_ATP_CTO.FAIL);
6154: END IF;

Line 6151: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,

6147: END IF;
6148:
6149: /* --s_cto_rearch
6150: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
6151: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6152: x_atp_table,
6153: MSC_ATP_CTO.FAIL);
6154: END IF;
6155: --e_cto_rearch

Line 6153: MSC_ATP_CTO.FAIL);

6149: /* --s_cto_rearch
6150: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
6151: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6152: x_atp_table,
6153: MSC_ATP_CTO.FAIL);
6154: END IF;
6155: --e_cto_rearch
6156: */
6157:

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

6297: msc_sch_wb.atp_debug('Schedule: ' || 'after resetting the demands when scheduling failed');
6298: END IF;
6299:
6300: /*--s_cto_rearch
6301: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
6302: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6303: x_atp_table,
6304: MSC_ATP_CTO.FAIL);
6305: END IF;

Line 6302: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,

6298: END IF;
6299:
6300: /*--s_cto_rearch
6301: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
6302: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6303: x_atp_table,
6304: MSC_ATP_CTO.FAIL);
6305: END IF;
6306: --e_cto_rearch

Line 6304: MSC_ATP_CTO.FAIL);

6300: /*--s_cto_rearch
6301: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
6302: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6303: x_atp_table,
6304: MSC_ATP_CTO.FAIL);
6305: END IF;
6306: --e_cto_rearch
6307: */
6308: END IF;

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

6451: msc_sch_wb.atp_debug('Schedule: ' || 'after resetting the demands when scheduling failed');
6452: END IF;
6453:
6454: /* --s_cto_rearch
6455: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
6456: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6457: x_atp_table,
6458: MSC_ATP_CTO.FAIL);
6459: END IF;

Line 6456: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,

6452: END IF;
6453:
6454: /* --s_cto_rearch
6455: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
6456: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6457: x_atp_table,
6458: MSC_ATP_CTO.FAIL);
6459: END IF;
6460: --e_cto_rearch

Line 6458: MSC_ATP_CTO.FAIL);

6454: /* --s_cto_rearch
6455: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
6456: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6457: x_atp_table,
6458: MSC_ATP_CTO.FAIL);
6459: END IF;
6460: --e_cto_rearch
6461: */
6462:

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

6625: msc_sch_wb.atp_debug('Schedule: ' || 'after resetting the demands when scheduling failed');
6626: END IF;
6627:
6628: /* --s_cto_rearch
6629: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
6630: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6631: x_atp_table,
6632: MSC_ATP_CTO.FAIL);
6633: END IF;

Line 6630: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,

6626: END IF;
6627:
6628: /* --s_cto_rearch
6629: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
6630: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6631: x_atp_table,
6632: MSC_ATP_CTO.FAIL);
6633: END IF;
6634: --e_cto_rearch

Line 6632: MSC_ATP_CTO.FAIL);

6628: /* --s_cto_rearch
6629: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET =1 and NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' THEN
6630: MSC_ATP_CTO.Maintain_OS_Sourcing(p_instance_id,
6631: x_atp_table,
6632: MSC_ATP_CTO.FAIL);
6633: END IF;
6634: --e_cto_rearch
6635: */
6636:

Line 6827: l_item_sourcing_info_rec MSC_ATP_CTO.Item_Sourcing_Info_Rec;

6823: --4570421
6824: l_op_seq_id NUMBER;
6825:
6826: --s_cto_rearch
6827: l_item_sourcing_info_rec MSC_ATP_CTO.Item_Sourcing_Info_Rec;
6828: l_null_item_sourcing_info_rec MSC_ATP_CTO.Item_Sourcing_Info_Rec;
6829: l_get_comp_info_rec MSC_ATP_REQ.get_comp_info_rec;
6830: --l_get_sup_info_rec MSC_ATP_PVT.Supplier_Info_rec;
6831: l_item_info_rec MSC_ATP_PVT.item_attribute_rec;

Line 6828: l_null_item_sourcing_info_rec MSC_ATP_CTO.Item_Sourcing_Info_Rec;

6824: l_op_seq_id NUMBER;
6825:
6826: --s_cto_rearch
6827: l_item_sourcing_info_rec MSC_ATP_CTO.Item_Sourcing_Info_Rec;
6828: l_null_item_sourcing_info_rec MSC_ATP_CTO.Item_Sourcing_Info_Rec;
6829: l_get_comp_info_rec MSC_ATP_REQ.get_comp_info_rec;
6830: --l_get_sup_info_rec MSC_ATP_PVT.Supplier_Info_rec;
6831: l_item_info_rec MSC_ATP_PVT.item_attribute_rec;
6832: l_atp_rule_name varchar2(80);

Line 9587: MSC_ATP_CTO.Check_Base_Model_For_Cap_Check(C_ITEM_INFO_REC.dest_inv_item_id,

9583: C_ITEM_INFO_REC.atp_flag = 'Y' and
9584: C_ITEM_INFO_REC.atp_comp_flag = 'N' and
9585: MSC_ATP_PVT.G_INV_CTP = 4 THEN
9586:
9587: MSC_ATP_CTO.Check_Base_Model_For_Cap_Check(C_ITEM_INFO_REC.dest_inv_item_id,
9588: C_ITEM_INFO_REC.base_item_id,
9589: l_requested_ship_date,
9590: p_atp_record.instance_id,
9591: p_plan_id,

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

13643:
13644: --s_cto_rearch
13645: IF PG_DEBUG in ('Y', 'C') THEN
13646: msc_sch_wb.atp_debug('It is a make case ');
13647: msc_sch_wb.atp_debug('G_MODEL_BOM_IS_COLLECTED := ' || MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED);
13648: msc_sch_wb.atp_debug('Bom Item Flag := ' || PF_ITEM_INFO_REC.bom_item_type);
13649: END IF;
13650: l_get_comp_info_rec.line_id := p_atp_record.demand_source_line;
13651: l_get_comp_info_rec.bom_item_type := PF_ITEM_INFO_REC.Bom_item_type;

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

13693: l_get_comp_info_rec.parent_line_id := p_atp_record.parent_line_id;
13694: l_get_comp_info_rec.parent_so_quantity := p_atp_record.parent_so_quantity;
13695:
13696: /* -- we also need to get model bom if it has not been collected
13697: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 THEN
13698:
13699: MSC_ATP_CTO.Populate_CTO_Bom(MSC_ATP_PVT.G_SESSION_ID, null);
13700: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 1;
13701:

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

13695:
13696: /* -- we also need to get model bom if it has not been collected
13697: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 THEN
13698:
13699: MSC_ATP_CTO.Populate_CTO_Bom(MSC_ATP_PVT.G_SESSION_ID, null);
13700: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 1;
13701:
13702: END IF;
13703: */

Line 13700: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 1;

13696: /* -- we also need to get model bom if it has not been collected
13697: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 THEN
13698:
13699: MSC_ATP_CTO.Populate_CTO_Bom(MSC_ATP_PVT.G_SESSION_ID, null);
13700: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 1;
13701:
13702: END IF;
13703: */
13704: ELSIF PF_ITEM_INFO_REC.bom_item_type = 4 and PF_ITEM_INFO_REC.replenish_to_ord_flag = 'Y' THEN

Line 17151: l_mand_comp_info_rec MSC_ATP_CTO.mand_comp_info_rec;

17147:
17148: --s_cto_rearch
17149: l_included_item_table MRP_ATP_PUB.ATP_Rec_Typ;
17150: l_included_item_cntr number;
17151: l_mand_comp_info_rec MSC_ATP_CTO.mand_comp_info_rec;
17152: l_null_mand_comp_info_rec MSC_ATP_CTO.mand_comp_info_rec;
17153: l_pto_cntr number;
17154: l_count number;
17155: l_parent_idx number;

Line 17152: l_null_mand_comp_info_rec MSC_ATP_CTO.mand_comp_info_rec;

17148: --s_cto_rearch
17149: l_included_item_table MRP_ATP_PUB.ATP_Rec_Typ;
17150: l_included_item_cntr number;
17151: l_mand_comp_info_rec MSC_ATP_CTO.mand_comp_info_rec;
17152: l_null_mand_comp_info_rec MSC_ATP_CTO.mand_comp_info_rec;
17153: l_pto_cntr number;
17154: l_count number;
17155: l_parent_idx number;
17156: l_process_included_item_flag number := 0;

Line 17200: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 2;

17196: G_HIERARCHY_PROFILE:= NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
17197: G_INF_SUP_TF_PAD := GREATEST(CEIL(NVL(FND_PROFILE.VALUE('MSC_ATP_INFINITE_TF_PAD'),0)),0);
17198:
17199: --bug 3625348: reset global variable
17200: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 2;
17201: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 2;
17202: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 2;
17203: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 2;
17204:

Line 17201: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 2;

17197: G_INF_SUP_TF_PAD := GREATEST(CEIL(NVL(FND_PROFILE.VALUE('MSC_ATP_INFINITE_TF_PAD'),0)),0);
17198:
17199: --bug 3625348: reset global variable
17200: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 2;
17201: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 2;
17202: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 2;
17203: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 2;
17204:
17205: -- ngoel 9/27: Reset G_SR_PARTNER_SITE_ID GLOBAL Variable

Line 17202: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 2;

17198:
17199: --bug 3625348: reset global variable
17200: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 2;
17201: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 2;
17202: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 2;
17203: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 2;
17204:
17205: -- ngoel 9/27: Reset G_SR_PARTNER_SITE_ID GLOBAL Variable
17206: G_SR_PARTNER_SITE_ID := NULL;

Line 17203: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 2;

17199: --bug 3625348: reset global variable
17200: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 2;
17201: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 2;
17202: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 2;
17203: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 2;
17204:
17205: -- ngoel 9/27: Reset G_SR_PARTNER_SITE_ID GLOBAL Variable
17206: G_SR_PARTNER_SITE_ID := NULL;
17207:

Line 17357: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 2;

17353: l_atp_details := l_null_atp_details;
17354: --s_cto_rearch
17355: --l_mand_comp_info_rec := l_null_mand_comp_info_rec;
17356: l_set_fail_flag := 'N';
17357: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 2;
17358: --e_cto_rearch
17359:
17360:
17361: IF PG_DEBUG in ('Y', 'C') THEN

Line 17387: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 1;

17383: msc_sch_wb.atp_debug('l_included_item_cntr := ' || l_included_item_cntr);
17384: END IF;
17385:
17386: l_included_item_cntr := nvl(l_included_item_cntr, 0) + 1;
17387: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 1;
17388:
17389: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table,
17390: j,
17391: l_atp_input_table,

Line 17438: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 1;

17434: -- selectively update the data for child lines.
17435: IF PG_DEBUG in ('Y', 'C') THEN
17436: msc_sch_wb.atp_debug('ato model -line is := ' || p_atp_table.ato_model_line_id(j));
17437: END IF;
17438: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 1;
17439: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 1;
17440:
17441:
17442: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 and

Line 17439: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 1;

17435: IF PG_DEBUG in ('Y', 'C') THEN
17436: msc_sch_wb.atp_debug('ato model -line is := ' || p_atp_table.ato_model_line_id(j));
17437: END IF;
17438: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 1;
17439: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 1;
17440:
17441:
17442: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 and
17443: (NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' ) THEN

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

17438: MSC_ATP_CTO.G_MODEL_IS_PRESENT := 1;
17439: MSC_ATP_CTO.G_MODEL_IS_PRESENT_IN_SET := 1;
17440:
17441:
17442: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 and
17443: (NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' ) THEN
17444:
17445: MSC_ATP_CTO.Populate_CTO_Bom(MSC_ATP_PVT.G_SESSION_ID, p_refresh_number, null);
17446: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 1;

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

17441:
17442: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 and
17443: (NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' ) THEN
17444:
17445: MSC_ATP_CTO.Populate_CTO_Bom(MSC_ATP_PVT.G_SESSION_ID, p_refresh_number, null);
17446: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 1;
17447:
17448: END IF;
17449: END IF;

Line 17446: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 1;

17442: IF NVL(MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED, 2) = 2 and
17443: (NVL(MSC_ATP_PVT.G_SYNC_ATP_CHECK, 'N') = 'N' ) THEN
17444:
17445: MSC_ATP_CTO.Populate_CTO_Bom(MSC_ATP_PVT.G_SESSION_ID, p_refresh_number, null);
17446: MSC_ATP_CTO.G_MODEL_BOM_IS_COLLECTED := 1;
17447:
17448: END IF;
17449: END IF;
17450:

Line 17529: MSC_ATP_CTO.Get_Mandatory_Components( -1,

17525: END IF;
17526:
17527: --- included items are not passed. Explode them
17528: MSC_ATP_PVT.G_PTF_DATE := sysdate;
17529: MSC_ATP_CTO.Get_Mandatory_Components( -1,
17530: p_instance_id,
17531: p_atp_table.validation_org(j),
17532: p_atp_table.inventory_item_id(j),
17533: p_atp_table.quantity_ordered(j),

Line 17554: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 1;

17550: msc_sch_wb.atp_debug('Comp Count := ' || l_mand_comp_info_rec.sr_inventory_item_id.count);
17551: msc_sch_wb.atp_debug('SMC or PTO Kit');
17552: END IF;
17553: FOR l_pto_cntr in 1..l_mand_comp_info_rec.sr_inventory_item_id.count LOOP
17554: MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT := 1;
17555: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_table,
17556: j,
17557: l_atp_input_table,
17558: l_return_status );