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 FND_PROFILE

Line 157: G_USE_SHIP_REC_CAL VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_USE_SHIP_REC_CAL'),'N'); --Bug 3593394

153: );
154:
155: G_SHIP_CAPACITY CONSTANT INTEGER := 1;
156: G_DOCK_CAPACITY CONSTANT INTEGER := 2;
157: G_USE_SHIP_REC_CAL VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_USE_SHIP_REC_CAL'),'N'); --Bug 3593394
158: /* changes for ship_rec_cal end */
159:
160: -- global variables
161: G_ITEM_INFO_REC item_attribute_rec;

Line 176: G_INV_CTP NUMBER := FND_PROFILE.value('INV_CTP') ;

172: G_PEGGING_FOR_SET MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
173: G_DEMAND_CLASS_ATP_FLAG MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
174: G_REQ_ATP_DATE MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
175: G_REQ_DATE_QTY MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
176: G_INV_CTP NUMBER := FND_PROFILE.value('INV_CTP') ;
177: G_SUB_COMP VARCHAR2(1) := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');
178: G_ALLOCATED_ATP VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
179: -- ATP4drp use original profile to restore value after DRP to non-DRP plan switch.
180: G_ORIG_ALLOC_ATP VARCHAR2(1) := G_ALLOCATED_ATP;

Line 177: G_SUB_COMP VARCHAR2(1) := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');

173: G_DEMAND_CLASS_ATP_FLAG MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
174: G_REQ_ATP_DATE MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
175: G_REQ_DATE_QTY MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
176: G_INV_CTP NUMBER := FND_PROFILE.value('INV_CTP') ;
177: G_SUB_COMP VARCHAR2(1) := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');
178: G_ALLOCATED_ATP VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
179: -- ATP4drp use original profile to restore value after DRP to non-DRP plan switch.
180: G_ORIG_ALLOC_ATP VARCHAR2(1) := G_ALLOCATED_ATP;
181: -- End ATP4drp

Line 178: G_ALLOCATED_ATP VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');

174: G_REQ_ATP_DATE MRP_ATP_PUB.date_arr:=MRP_ATP_PUB.date_arr();
175: G_REQ_DATE_QTY MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
176: G_INV_CTP NUMBER := FND_PROFILE.value('INV_CTP') ;
177: G_SUB_COMP VARCHAR2(1) := NVL(FND_PROFILE.value('MRP_ATP_SUB_COMP'), 'N');
178: G_ALLOCATED_ATP VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
179: -- ATP4drp use original profile to restore value after DRP to non-DRP plan switch.
180: G_ORIG_ALLOC_ATP VARCHAR2(1) := G_ALLOCATED_ATP;
181: -- End ATP4drp
182: G_RES_CONSUME VARCHAR2(1) := 'Y';

Line 184: G_HIERARCHY_PROFILE NUMBER := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);

180: G_ORIG_ALLOC_ATP VARCHAR2(1) := G_ALLOCATED_ATP;
181: -- End ATP4drp
182: G_RES_CONSUME VARCHAR2(1) := 'Y';
183: G_ASSEMBLY_LINE_ID NUMBER;
184: G_HIERARCHY_PROFILE NUMBER := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
185: G_PARTNER_ID NUMBER;
186: G_PARTNER_SITE_ID NUMBER;
187: G_SR_PARTY_SITE_ID NUMBER; --2814895
188: G_SR_CUSTOMER_COUNTRY VARCHAR2(60); --2814895

Line 194: G_MOV_PAST_DUE_SYSDATE_PROF VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_MOVE_PAST_DUE_TO_SYSDATE'), 'Y'); --6316476

190: G_SESSION_ID NUMBER;
191: G_ORDER_LINE_ID NUMBER;
192: G_DEMAND_PEGGING_ID NUMBER;
193: G_COMP_LINE_ID NUMBER;
194: G_MOV_PAST_DUE_SYSDATE_PROF VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_MOVE_PAST_DUE_TO_SYSDATE'), 'Y'); --6316476
195:
196: -- dsting default to 3 (11i source) since we don't read msc_apps_instances for non-distributed case
197: G_APPS_VER NUMBER := SOURCE11i; -- 2300767
198: G_SUMMARY_FLAG VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_ENABLE_ATP_SUMMARY'), 'N');

Line 198: G_SUMMARY_FLAG VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_ENABLE_ATP_SUMMARY'), 'N');

194: G_MOV_PAST_DUE_SYSDATE_PROF VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_MOVE_PAST_DUE_TO_SYSDATE'), 'Y'); --6316476
195:
196: -- dsting default to 3 (11i source) since we don't read msc_apps_instances for non-distributed case
197: G_APPS_VER NUMBER := SOURCE11i; -- 2300767
198: G_SUMMARY_FLAG VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_ENABLE_ATP_SUMMARY'), 'N');
199: G_SUMMARY_SQL VARCHAR2(1); -- For summary enhancement
200:
201: -- Bug 2877340, 2746213
202: -- Create new global variable for Infinite Time Fence Pad

Line 207: G_INF_SUP_TF_PAD NUMBER := GREATEST(CEIL(NVL(FND_PROFILE.value('MSC_ATP_INFINITE_TF_PAD'),0)),0);

203: -- Workaround to match ASCP and ATP output.
204: -- Round the days in case user erroneously
205: -- sets fraction Number as profile calue. If user sets profile
206: -- value to be -ve,Consider it to be 0.
207: G_INF_SUP_TF_PAD NUMBER := GREATEST(CEIL(NVL(FND_PROFILE.value('MSC_ATP_INFINITE_TF_PAD'),0)),0);
208: ---diag_atp
209: G_DIAGNOSTIC_ATP NUMBER;
210: G_SUBSTITUTION_FLAG VARCHAR2(1);
211: G_PLAN_SUBST_FLAG NUMBER;

Line 238: G_HP_DEMAND_BUCKETING_PREF NUMBER := NVL(FND_PROFILE.VALUE('MSC_HP_DMD_BKT_PRF'), 1);

234:
235: G_INSTANCE_ID NUMBER; -- this variable contains value of instance id
236: --with which call is made
237: --plan by request date
238: G_HP_DEMAND_BUCKETING_PREF NUMBER := NVL(FND_PROFILE.VALUE('MSC_HP_DMD_BKT_PRF'), 1);
239: -- Action code
240: G_ZERO_ALLOCATION_PERC VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ZERO_ALLOC_PERC'),'N');--6359986
241:
242: ATPQUERY CONSTANT INTEGER := 100;

Line 240: G_ZERO_ALLOCATION_PERC VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ZERO_ALLOC_PERC'),'N');--6359986

236: --with which call is made
237: --plan by request date
238: G_HP_DEMAND_BUCKETING_PREF NUMBER := NVL(FND_PROFILE.VALUE('MSC_HP_DMD_BKT_PRF'), 1);
239: -- Action code
240: G_ZERO_ALLOCATION_PERC VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ZERO_ALLOC_PERC'),'N');--6359986
241:
242: ATPQUERY CONSTANT INTEGER := 100;
243: DEMANDADD CONSTANT INTEGER := 110;
244: DEMANDMODIFY CONSTANT INTEGER := 120;

Line 364: G_PLAN_COPRODUCTS VARCHAR(1) := FND_Profile.value('MSC_PLAN_COPRODUCTS');

360: --- bug 1905037. The following variable is added so
361: --- we can return the inventory_item_id which is not collected
362: --- to schedule procedure
363: G_SR_INVENTORY_ITEM_ID number;
364: G_PLAN_COPRODUCTS VARCHAR(1) := FND_Profile.value('MSC_PLAN_COPRODUCTS');
365: G_DATABASE_LINK VARCHAR2(128);
366: --bug 2178544
367: --G_PTF_FLAG NUMBER; -- This flag indicates that plan is constrained by PTF or not
368: G_MSO_LEAD_TIME_FACTOR NUMBER := NVL(FND_PROFILE.value('MSO_SCO_LEAD_TIME_FACTOR'),0);

Line 368: G_MSO_LEAD_TIME_FACTOR NUMBER := NVL(FND_PROFILE.value('MSO_SCO_LEAD_TIME_FACTOR'),0);

364: G_PLAN_COPRODUCTS VARCHAR(1) := FND_Profile.value('MSC_PLAN_COPRODUCTS');
365: G_DATABASE_LINK VARCHAR2(128);
366: --bug 2178544
367: --G_PTF_FLAG NUMBER; -- This flag indicates that plan is constrained by PTF or not
368: G_MSO_LEAD_TIME_FACTOR NUMBER := NVL(FND_PROFILE.value('MSO_SCO_LEAD_TIME_FACTOR'),0);
369: G_FUTURE_ORDER_DATE DATE;
370: G_FUTURE_START_DATE DATE;
371: G_PTF_DATE DATE;
372: G_PTF_DATE_THIS_LEVEL DATE;

Line 373: G_ALLOCATION_METHOD NUMBER := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);

369: G_FUTURE_ORDER_DATE DATE;
370: G_FUTURE_START_DATE DATE;
371: G_PTF_DATE DATE;
372: G_PTF_DATE_THIS_LEVEL DATE;
373: G_ALLOCATION_METHOD NUMBER := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);
374: G_FUTURE_PEGGING_ID NUMBER;
375:
376: G_REFRESH_NUMBER NUMBER;
377: --G_CREATE_TIME_FENCE VARCHAR(1) := NVL(FND_Profile.value('MRP_FIRM_ORDER_TF'),'N');

Line 377: --G_CREATE_TIME_FENCE VARCHAR(1) := NVL(FND_Profile.value('MRP_FIRM_ORDER_TF'),'N');

373: G_ALLOCATION_METHOD NUMBER := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);
374: G_FUTURE_PEGGING_ID NUMBER;
375:
376: G_REFRESH_NUMBER NUMBER;
377: --G_CREATE_TIME_FENCE VARCHAR(1) := NVL(FND_Profile.value('MRP_FIRM_ORDER_TF'),'N');
378:
379: -- krajan: 2408902
380: -- Variable to store Demand Class passed in for ATO models.
381: G_ATP_DEMAND_CLASS VARCHAR2(34);

Line 385: G_EXPLODE_PHANTOM VARCHAR(1) := NVL(FND_Profile.value('MSC_ENABLE_PHANT_COMP'), 'N');

381: G_ATP_DEMAND_CLASS VARCHAR2(34);
382:
383: -- krajan: 2408696
384: -- Variable to store Phantom Profile option value
385: G_EXPLODE_PHANTOM VARCHAR(1) := NVL(FND_Profile.value('MSC_ENABLE_PHANT_COMP'), 'N');
386:
387: -- 24x7 Support : Synchronization in progress flag
388: G_SYNC_ATP_CHECK VARCHAR2(1);
389: --Set in case msc_item_id_lid has no records 4091487

Line 455: G_ATP_CHECK_ISO NUMBER := NVL(FND_PROFILE.VALUE('MSC_ATP_CHECK_INT_SALES_ORDERS'),NO); --6485306

451: YES CONSTANT NUMBER := 1;
452: NO CONSTANT NUMBER := 2;
453: CHECK_ORG_IN_PLAN CONSTANT NUMBER := 3;
454: --4279623 4333596
455: G_ATP_CHECK_ISO NUMBER := NVL(FND_PROFILE.VALUE('MSC_ATP_CHECK_INT_SALES_ORDERS'),NO); --6485306
456:
457: --bug 4358596
458: G_RETAIN_TIME_NON_ATP VARCHAR(1) := NVL(FND_Profile.value('MSC_RETAIN_TIME_NON_ATP_ITEM'), 'Y');
459: G_ATP_ITEM_PRESENT_IN_SET VARCHAR(1) :='N'; --4460369

Line 458: G_RETAIN_TIME_NON_ATP VARCHAR(1) := NVL(FND_Profile.value('MSC_RETAIN_TIME_NON_ATP_ITEM'), 'Y');

454: --4279623 4333596
455: G_ATP_CHECK_ISO NUMBER := NVL(FND_PROFILE.VALUE('MSC_ATP_CHECK_INT_SALES_ORDERS'),NO); --6485306
456:
457: --bug 4358596
458: G_RETAIN_TIME_NON_ATP VARCHAR(1) := NVL(FND_Profile.value('MSC_RETAIN_TIME_NON_ATP_ITEM'), 'Y');
459: G_ATP_ITEM_PRESENT_IN_SET VARCHAR(1) :='N'; --4460369
460:
461:
462: