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: G_INTERNAL_SALES_ORDER VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ISO_ALLOC_ATP'),'N'); --10425563
180: -- ATP4drp use original profile to restore value after DRP to non-DRP plan switch.

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: G_INTERNAL_SALES_ORDER VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ISO_ALLOC_ATP'),'N'); --10425563
180: -- ATP4drp use original profile to restore value after DRP to non-DRP plan switch.
181: G_ORIG_ALLOC_ATP VARCHAR2(1) := G_ALLOCATED_ATP;

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: G_INTERNAL_SALES_ORDER VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ISO_ALLOC_ATP'),'N'); --10425563
180: -- ATP4drp use original profile to restore value after DRP to non-DRP plan switch.
181: G_ORIG_ALLOC_ATP VARCHAR2(1) := G_ALLOCATED_ATP;
182: -- End ATP4drp

Line 179: G_INTERNAL_SALES_ORDER VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ISO_ALLOC_ATP'),'N'); --10425563

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: G_INTERNAL_SALES_ORDER VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ISO_ALLOC_ATP'),'N'); --10425563
180: -- ATP4drp use original profile to restore value after DRP to non-DRP plan switch.
181: G_ORIG_ALLOC_ATP VARCHAR2(1) := G_ALLOCATED_ATP;
182: -- End ATP4drp
183: G_RES_CONSUME VARCHAR2(1) := 'Y';

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

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

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

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

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

195: G_MOV_PAST_DUE_SYSDATE_PROF VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_MOVE_PAST_DUE_TO_SYSDATE'), 'Y'); --6316476
196:
197: -- dsting default to 3 (11i source) since we don't read msc_apps_instances for non-distributed case
198: G_APPS_VER NUMBER := SOURCE11i; -- 2300767
199: G_SUMMARY_FLAG VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_ENABLE_ATP_SUMMARY'), 'N');
200: G_SUMMARY_SQL VARCHAR2(1); -- For summary enhancement
201:
202: --optional_fw
203: G_OPTIONAL_FW NUMBER := 1; --This global variable is Null for the first pass and not null for remain passes.

Line 212: G_FORWARD_ATP VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ENHANCED_FORWARD_ATP'), 'N');

208: G_FW_CTP_PEGGING_ID MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
209: --Points to the PO supply line pegging added during subsequent passes.
210: G_FW_STEAL_PEGGING_ID MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
211: --Points to the Stealing line in forward pass.
212: G_FORWARD_ATP VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ENHANCED_FORWARD_ATP'), 'N');
213: --Profile to control which f/w pass we choose.
214: G_DEMAND_ID NUMBER; --5158454
215: G_NUMBER_OF_ITERATIONS NUMBER; --5211558
216: G_LOOP_COUNT NUMBER; --5211558

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

219: -- Workaround to match ASCP and ATP output.
220: -- Round the days in case user erroneously
221: -- sets fraction Number as profile calue. If user sets profile
222: -- value to be -ve,Consider it to be 0.
223: G_INF_SUP_TF_PAD NUMBER := GREATEST(CEIL(NVL(FND_PROFILE.value('MSC_ATP_INFINITE_TF_PAD'),0)),0);
224: ---diag_atp
225: G_DIAGNOSTIC_ATP NUMBER;
226: G_SUBSTITUTION_FLAG VARCHAR2(1);
227: G_PLAN_SUBST_FLAG NUMBER;

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

250:
251: G_INSTANCE_ID NUMBER; -- this variable contains value of instance id
252: --with which call is made
253: --plan by request date
254: G_HP_DEMAND_BUCKETING_PREF NUMBER := NVL(FND_PROFILE.VALUE('MSC_HP_DMD_BKT_PRF'), 1);
255: -- Action code
256: G_ZERO_ALLOCATION_PERC VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ZERO_ALLOC_PERC'),'N');--6359986
257:
258: ATPQUERY CONSTANT INTEGER := 100;

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

252: --with which call is made
253: --plan by request date
254: G_HP_DEMAND_BUCKETING_PREF NUMBER := NVL(FND_PROFILE.VALUE('MSC_HP_DMD_BKT_PRF'), 1);
255: -- Action code
256: G_ZERO_ALLOCATION_PERC VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ZERO_ALLOC_PERC'),'N');--6359986
257:
258: ATPQUERY CONSTANT INTEGER := 100;
259: DEMANDADD CONSTANT INTEGER := 110;
260: DEMANDMODIFY CONSTANT INTEGER := 120;

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

376: --- bug 1905037. The following variable is added so
377: --- we can return the inventory_item_id which is not collected
378: --- to schedule procedure
379: G_SR_INVENTORY_ITEM_ID number;
380: G_PLAN_COPRODUCTS VARCHAR(1) := FND_Profile.value('MSC_PLAN_COPRODUCTS');
381: G_DATABASE_LINK VARCHAR2(128);
382: --bug 2178544
383: --G_PTF_FLAG NUMBER; -- This flag indicates that plan is constrained by PTF or not
384: G_MSO_LEAD_TIME_FACTOR NUMBER := NVL(FND_PROFILE.value('MSO_SCO_LEAD_TIME_FACTOR'),0);

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

380: G_PLAN_COPRODUCTS VARCHAR(1) := FND_Profile.value('MSC_PLAN_COPRODUCTS');
381: G_DATABASE_LINK VARCHAR2(128);
382: --bug 2178544
383: --G_PTF_FLAG NUMBER; -- This flag indicates that plan is constrained by PTF or not
384: G_MSO_LEAD_TIME_FACTOR NUMBER := NVL(FND_PROFILE.value('MSO_SCO_LEAD_TIME_FACTOR'),0);
385: G_FUTURE_ORDER_DATE DATE;
386: G_FUTURE_START_DATE DATE;
387: G_PTF_DATE DATE;
388: G_PTF_DATE_THIS_LEVEL DATE;

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

385: G_FUTURE_ORDER_DATE DATE;
386: G_FUTURE_START_DATE DATE;
387: G_PTF_DATE DATE;
388: G_PTF_DATE_THIS_LEVEL DATE;
389: G_ALLOCATION_METHOD NUMBER := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);
390: G_FUTURE_PEGGING_ID NUMBER;
391:
392: G_REFRESH_NUMBER NUMBER;
393: --G_CREATE_TIME_FENCE VARCHAR(1) := NVL(FND_Profile.value('MRP_FIRM_ORDER_TF'),'N');

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

389: G_ALLOCATION_METHOD NUMBER := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);
390: G_FUTURE_PEGGING_ID NUMBER;
391:
392: G_REFRESH_NUMBER NUMBER;
393: --G_CREATE_TIME_FENCE VARCHAR(1) := NVL(FND_Profile.value('MRP_FIRM_ORDER_TF'),'N');
394:
395: -- krajan: 2408902
396: -- Variable to store Demand Class passed in for ATO models.
397: G_ATP_DEMAND_CLASS VARCHAR2(34);

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

397: G_ATP_DEMAND_CLASS VARCHAR2(34);
398:
399: -- krajan: 2408696
400: -- Variable to store Phantom Profile option value
401: G_EXPLODE_PHANTOM VARCHAR(1) := NVL(FND_Profile.value('MSC_ENABLE_PHANT_COMP'), 'N');
402:
403: -- 24x7 Support : Synchronization in progress flag
404: G_SYNC_ATP_CHECK VARCHAR2(1);
405: --Set in case msc_item_id_lid has no records 4091487

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

467: YES CONSTANT NUMBER := 1;
468: NO CONSTANT NUMBER := 2;
469: CHECK_ORG_IN_PLAN CONSTANT NUMBER := 3;
470: --4279623 4333596
471: G_ATP_CHECK_ISO NUMBER := NVL(FND_PROFILE.VALUE('MSC_ATP_CHECK_INT_SALES_ORDERS'),NO); --6485306
472:
473: --bug 4358596
474: G_RETAIN_TIME_NON_ATP VARCHAR(1) := NVL(FND_Profile.value('MSC_RETAIN_TIME_NON_ATP_ITEM'), 'Y');
475: G_ATP_ITEM_PRESENT_IN_SET VARCHAR(1) :='N'; --4460369

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

470: --4279623 4333596
471: G_ATP_CHECK_ISO NUMBER := NVL(FND_PROFILE.VALUE('MSC_ATP_CHECK_INT_SALES_ORDERS'),NO); --6485306
472:
473: --bug 4358596
474: G_RETAIN_TIME_NON_ATP VARCHAR(1) := NVL(FND_Profile.value('MSC_RETAIN_TIME_NON_ATP_ITEM'), 'Y');
475: G_ATP_ITEM_PRESENT_IN_SET VARCHAR(1) :='N'; --4460369
476:
477: G_WS_CALL VARCHAR2(1) := 'N'; -- GOP Web Service Call
478:

Line 480: G_HYBRID_ALLOC_ATP VARCHAR(1) := LEAST(G_ORIG_ALLOC_ATP, Nvl(FND_Profile.value('MSC_HYBRID_ALLOC_ATP'),'N'));

476:
477: G_WS_CALL VARCHAR2(1) := 'N'; -- GOP Web Service Call
478:
479: --ALLOC ATP CHANGES -12973673
480: G_HYBRID_ALLOC_ATP VARCHAR(1) := LEAST(G_ORIG_ALLOC_ATP, Nvl(FND_Profile.value('MSC_HYBRID_ALLOC_ATP'),'N'));
481:
482: PROCEDURE Schedule (
483: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
484: p_instance_id IN NUMBER,