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_FUNC dependencies on MSC_ATP_PVT

Line 49: AND b.component_identifier (+) = MSC_ATP_PVT.G_COMP_LINE_ID

45: AND i.organization_id = p_organization_id
46: AND i.plan_id = p_plan_id
47: AND i.sr_instance_id = p_instance_id
48: AND b.component_item_id (+) = i.sr_inventory_item_id
49: AND b.component_identifier (+) = MSC_ATP_PVT.G_COMP_LINE_ID
50: AND b.session_id (+) = MSC_ATP_PVT.G_SESSION_ID;
51:
52: IF l_bom_item_type = 4 AND NVL(l_atp_check, -1) = 2 THEN
53: l_atp_flag := 'N';

Line 50: AND b.session_id (+) = MSC_ATP_PVT.G_SESSION_ID;

46: AND i.plan_id = p_plan_id
47: AND i.sr_instance_id = p_instance_id
48: AND b.component_item_id (+) = i.sr_inventory_item_id
49: AND b.component_identifier (+) = MSC_ATP_PVT.G_COMP_LINE_ID
50: AND b.session_id (+) = MSC_ATP_PVT.G_SESSION_ID;
51:
52: IF l_bom_item_type = 4 AND NVL(l_atp_check, -1) = 2 THEN
53: l_atp_flag := 'N';
54: END IF;

Line 56: MSC_ATP_PVT.G_SR_INVENTORY_ITEM_ID := NULL;

52: IF l_bom_item_type = 4 AND NVL(l_atp_check, -1) = 2 THEN
53: l_atp_flag := 'N';
54: END IF;
55:
56: MSC_ATP_PVT.G_SR_INVENTORY_ITEM_ID := NULL;
57: return l_atp_flag;
58: EXCEPTION
59: WHEN NO_DATA_FOUND THEN
60: MSC_ATP_PVT.G_SR_INVENTORY_ITEM_ID := p_inventory_item_id;

Line 60: MSC_ATP_PVT.G_SR_INVENTORY_ITEM_ID := p_inventory_item_id;

56: MSC_ATP_PVT.G_SR_INVENTORY_ITEM_ID := NULL;
57: return l_atp_flag;
58: EXCEPTION
59: WHEN NO_DATA_FOUND THEN
60: MSC_ATP_PVT.G_SR_INVENTORY_ITEM_ID := p_inventory_item_id;
61: return 'N';
62: END get_atp_flag;
63:
64:

Line 85: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ORDER_LINE_ID = '||MSC_ATP_PVT.G_ORDER_LINE_ID);

81: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_inventory_item_id = '||p_inventory_item_id);
82: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'organization_id = '||p_organization_id);
83: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'plan_id = '||p_plan_id);
84: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_instance_id = '||p_instance_id);
85: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ORDER_LINE_ID = '||MSC_ATP_PVT.G_ORDER_LINE_ID);
86: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ASSEMBLY_LINE_ID = '||MSC_ATP_PVT.G_ASSEMBLY_LINE_ID);
87: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_COMP_LINE_ID = '||MSC_ATP_PVT.G_COMP_LINE_ID);
88: END IF;
89:

Line 86: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ASSEMBLY_LINE_ID = '||MSC_ATP_PVT.G_ASSEMBLY_LINE_ID);

82: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'organization_id = '||p_organization_id);
83: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'plan_id = '||p_plan_id);
84: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_instance_id = '||p_instance_id);
85: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ORDER_LINE_ID = '||MSC_ATP_PVT.G_ORDER_LINE_ID);
86: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ASSEMBLY_LINE_ID = '||MSC_ATP_PVT.G_ASSEMBLY_LINE_ID);
87: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_COMP_LINE_ID = '||MSC_ATP_PVT.G_COMP_LINE_ID);
88: END IF;
89:
90: -- Fix for Bug 1413039 9/22/00 - NGOEL

Line 87: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_COMP_LINE_ID = '||MSC_ATP_PVT.G_COMP_LINE_ID);

83: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'plan_id = '||p_plan_id);
84: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'sr_instance_id = '||p_instance_id);
85: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ORDER_LINE_ID = '||MSC_ATP_PVT.G_ORDER_LINE_ID);
86: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_ASSEMBLY_LINE_ID = '||MSC_ATP_PVT.G_ASSEMBLY_LINE_ID);
87: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_COMP_LINE_ID = '||MSC_ATP_PVT.G_COMP_LINE_ID);
88: END IF;
89:
90: -- Fix for Bug 1413039 9/22/00 - NGOEL
91: -- Since we don't support multi-level ATP for ODS, set

Line 95: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_INV_CTP = '||MSC_ATP_PVT.G_INV_CTP);

91: -- Since we don't support multi-level ATP for ODS, set
92: -- return ATP component flag as N in case of ODS.
93:
94: IF PG_DEBUG in ('Y', 'C') THEN
95: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_INV_CTP = '||MSC_ATP_PVT.G_INV_CTP);
96: END IF;
97: IF MSC_ATP_PVT.G_INV_CTP = 5 THEN
98: l_atp_comp_flag := 'N';
99:

Line 97: IF MSC_ATP_PVT.G_INV_CTP = 5 THEN

93:
94: IF PG_DEBUG in ('Y', 'C') THEN
95: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_INV_CTP = '||MSC_ATP_PVT.G_INV_CTP);
96: END IF;
97: IF MSC_ATP_PVT.G_INV_CTP = 5 THEN
98: l_atp_comp_flag := 'N';
99:
100: -- IF p_plan_id = -1 THEN
101:

Line 134: IF (NVL(MSC_ATP_PVT.G_CTO_LINE, 'N') = 'N') THEN

130: -- in case of CTO, we try to get the BOM correctly from msc_bom_temp_table.-NGOEL 02/01/2001
131:
132: -- ngoel 9/24/2001, added to identify if current line is a MATO line, no need to run this select again.
133:
134: IF (NVL(MSC_ATP_PVT.G_CTO_LINE, 'N') = 'N') THEN
135: SELECT count(assembly_identifier)
136: INTO l_cto_bom
137: FROM msc_bom_temp mbt
138: WHERE mbt.session_id = MSC_ATP_PVT.G_SESSION_ID

Line 138: WHERE mbt.session_id = MSC_ATP_PVT.G_SESSION_ID

134: IF (NVL(MSC_ATP_PVT.G_CTO_LINE, 'N') = 'N') THEN
135: SELECT count(assembly_identifier)
136: INTO l_cto_bom
137: FROM msc_bom_temp mbt
138: WHERE mbt.session_id = MSC_ATP_PVT.G_SESSION_ID
139: AND mbt.assembly_identifier = MSC_ATP_PVT.G_COMP_LINE_ID
140: AND mbt.assembly_item_id = p_inventory_item_id;
141:
142: IF l_cto_bom > 0 THEN

Line 139: AND mbt.assembly_identifier = MSC_ATP_PVT.G_COMP_LINE_ID

135: SELECT count(assembly_identifier)
136: INTO l_cto_bom
137: FROM msc_bom_temp mbt
138: WHERE mbt.session_id = MSC_ATP_PVT.G_SESSION_ID
139: AND mbt.assembly_identifier = MSC_ATP_PVT.G_COMP_LINE_ID
140: AND mbt.assembly_item_id = p_inventory_item_id;
141:
142: IF l_cto_bom > 0 THEN
143: MSC_ATP_PVT.G_CTO_LINE := 'Y';

Line 143: MSC_ATP_PVT.G_CTO_LINE := 'Y';

139: AND mbt.assembly_identifier = MSC_ATP_PVT.G_COMP_LINE_ID
140: AND mbt.assembly_item_id = p_inventory_item_id;
141:
142: IF l_cto_bom > 0 THEN
143: MSC_ATP_PVT.G_CTO_LINE := 'Y';
144: END IF;
145: END IF;
146:
147: -- FOR CTO Models, pick_components_flag shall be 'N' and replenish_to_order

Line 154: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_CTO_LINE = '||MSC_ATP_PVT.G_CTO_LINE);

150: -- material.
151:
152: IF PG_DEBUG in ('Y', 'C') THEN
153: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_cto_bom = '||l_cto_bom);
154: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_CTO_LINE = '||MSC_ATP_PVT.G_CTO_LINE);
155: END IF;
156:
157: IF ((NVL(l_pick_comp_flag, 'N') = 'N') AND (NVL(l_replenish_flag, 'N') = 'Y')) AND
158: (NVL(MSC_ATP_PVT.G_CTO_LINE, 'N') = 'Y') AND (l_bom_item_type = 1) THEN

Line 158: (NVL(MSC_ATP_PVT.G_CTO_LINE, 'N') = 'Y') AND (l_bom_item_type = 1) THEN

154: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'G_CTO_LINE = '||MSC_ATP_PVT.G_CTO_LINE);
155: END IF;
156:
157: IF ((NVL(l_pick_comp_flag, 'N') = 'N') AND (NVL(l_replenish_flag, 'N') = 'Y')) AND
158: (NVL(MSC_ATP_PVT.G_CTO_LINE, 'N') = 'Y') AND (l_bom_item_type = 1) THEN
159: IF l_atp_comp_flag = 'N' THEN
160: l_atp_comp_flag := 'Y';
161: ELSIF l_atp_comp_flag = 'R' THEN
162: l_atp_comp_flag := 'C';

Line 177: AND component_identifier = MSC_ATP_PVT.G_COMP_LINE_ID

173: SELECT atp_check
174: INTO l_atp_check
175: FROM msc_bom_temp
176: WHERE component_item_id = p_inventory_item_id
177: AND component_identifier = MSC_ATP_PVT.G_COMP_LINE_ID
178: AND session_id = MSC_ATP_PVT.G_SESSION_ID;
179:
180: IF PG_DEBUG in ('Y', 'C') THEN
181: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_atp_check : '||l_atp_check);

Line 178: AND session_id = MSC_ATP_PVT.G_SESSION_ID;

174: INTO l_atp_check
175: FROM msc_bom_temp
176: WHERE component_item_id = p_inventory_item_id
177: AND component_identifier = MSC_ATP_PVT.G_COMP_LINE_ID
178: AND session_id = MSC_ATP_PVT.G_SESSION_ID;
179:
180: IF PG_DEBUG in ('Y', 'C') THEN
181: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_atp_check : '||l_atp_check);
182: END IF;

Line 282: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'selecting infinite_time_fence_date, MSC_ATP_PVT.G_INV_CTP = 4');

278: BEGIN
279: /* for 1478110. please refer to the BUG
280: IF p_plan_id <> -1 THEN
281: IF PG_DEBUG in ('Y', 'C') THEN
282: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'selecting infinite_time_fence_date, MSC_ATP_PVT.G_INV_CTP = 4');
283: END IF;
284:
285: SELECT curr_cutoff_date
286: INTO l_infinite_time_fence_date

Line 295: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'selecting infinite_time_fence_date, MSC_ATP_PVT.G_INV_CTP = 5');

291: END IF;
292: ELSE
293:
294: IF PG_DEBUG in ('Y', 'C') THEN
295: msc_sch_wb.atp_debug('get_infinite_time_fence_date: ' || 'selecting infinite_time_fence_date, MSC_ATP_PVT.G_INV_CTP = 5');
296: END IF;
297: */
298:
299: -- Bug 1566260, in case of modle or option class for PDS ATP, return null.

Line 329: msc_sch_wb.atp_debug('get_infinite_time_fence_date: MSC_ATP_PVT.G_INF_SUP_TF_PAD ' || MSC_ATP_PVT.G_INF_SUP_TF_PAD);

325: -- Read the Profile option to pad the user defined days
326: -- to infinite Supply fence.
327: IF PG_DEBUG in ('Y', 'C') THEN
328: msc_sch_wb.atp_debug('get_infinite_time_fence_date: Profile value for Infinite Supply Pad');
329: msc_sch_wb.atp_debug('get_infinite_time_fence_date: MSC_ATP_PVT.G_INF_SUP_TF_PAD ' || MSC_ATP_PVT.G_INF_SUP_TF_PAD);
330: END IF;
331: -- End Bug 2877340, 2746213
332: SELECT c2.calendar_date
333: INTO l_infinite_time_fence_date

Line 360: 1, ceil(i.cumulative_total_lead_time) + MSC_ATP_PVT.G_INF_SUP_TF_PAD,

356: -- Add Infinite Supply Time Fence PAD
357: --bug3609031 adding ceil
358: AND c2.seq_num = c1.next_seq_num +
359: DECODE(r.infinite_supply_fence_code,
360: 1, ceil(i.cumulative_total_lead_time) + MSC_ATP_PVT.G_INF_SUP_TF_PAD,
361: 2, ceil(i.cum_manufacturing_lead_time) + MSC_ATP_PVT.G_INF_SUP_TF_PAD,
362: 3, DECODE(NVL(ceil(i.preprocessing_lead_time),-1)+
363: NVL(ceil(i.full_lead_time),-1)+
364: NVL(ceil(i.postprocessing_lead_time),-1),-3,

Line 361: 2, ceil(i.cum_manufacturing_lead_time) + MSC_ATP_PVT.G_INF_SUP_TF_PAD,

357: --bug3609031 adding ceil
358: AND c2.seq_num = c1.next_seq_num +
359: DECODE(r.infinite_supply_fence_code,
360: 1, ceil(i.cumulative_total_lead_time) + MSC_ATP_PVT.G_INF_SUP_TF_PAD,
361: 2, ceil(i.cum_manufacturing_lead_time) + MSC_ATP_PVT.G_INF_SUP_TF_PAD,
362: 3, DECODE(NVL(ceil(i.preprocessing_lead_time),-1)+
363: NVL(ceil(i.full_lead_time),-1)+
364: NVL(ceil(i.postprocessing_lead_time),-1),-3,
365: NULL, -- All are NULL so return NULL.

Line 369: + MSC_ATP_PVT.G_INF_SUP_TF_PAD),

365: NULL, -- All are NULL so return NULL.
366: NVL(ceil(i.preprocessing_lead_time),0)+ -- Otherwise
367: NVL(ceil(i.full_lead_time),0) + -- evaluate to
368: NVL(ceil(i.postprocessing_lead_time),0) -- NON NULL
369: + MSC_ATP_PVT.G_INF_SUP_TF_PAD),
370: -- Bugs 1986353, 2004479.
371: 4, r.infinite_supply_time_fence)
372: -- End Bug 2877340, 2746213
373: AND c2.calendar_code = c1.calendar_code