APPS.MRP_KANBAN_PLAN_PK dependencies on FND_PROFILE

Line 638: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then

634: IF l_demand_quantity > 0 THEN
635:
636: IF INSERT_OR_CASCADE = TRUE THEN
637: -- added for eKanban project.
638: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then
639: INSERT INTO MRP_KANBAN_DEMAND (
640: DEMAND_ID,
641: KANBAN_PLAN_ID,
642: ORGANIZATION_ID,

Line 2556: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then

2552: RETURN FALSE;
2553: END IF;
2554: END IF;
2555: -- added for eKanban project.
2556: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then
2557:
2558: INSERT INTO MRP_KANBAN_DEMAND (
2559: DEMAND_ID,
2560: KANBAN_PLAN_ID,

Line 2901: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then

2897: End;
2898: END IF;
2899: */
2900: -- added for eKanban project.
2901: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then
2902:
2903: INSERT INTO MRP_KANBAN_DEMAND (
2904: DEMAND_ID,
2905: KANBAN_PLAN_ID,

Line 3211: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then

3207: Null;
3208: End;
3209: END IF;
3210: -- added for eKanban project.
3211: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then
3212:
3213: INSERT INTO MRP_KANBAN_DEMAND (
3214: DEMAND_ID,
3215: KANBAN_PLAN_ID,

Line 4134: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then

4130:
4131: IF l_pull_sequence_rec.kanban_size IS NULL OR
4132: l_pull_sequence_rec.number_of_cards IS NULL THEN
4133: -- added for eKanban project.
4134: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then
4135:
4136: IF NOT Kanban_Calculation_Pvt (
4137: l_average_demand,
4138: l_pull_sequence_rec.allocation_percent,

Line 4299: g_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';

4295: exc_error_condition exception;
4296:
4297: BEGIN
4298:
4299: g_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
4300:
4301: var_trace := fnd_profile.value('MRP_TRACE') = 'Y';
4302: if var_trace then
4303: c := dbms_sql.open_cursor;

Line 4301: var_trace := fnd_profile.value('MRP_TRACE') = 'Y';

4297: BEGIN
4298:
4299: g_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
4300:
4301: var_trace := fnd_profile.value('MRP_TRACE') = 'Y';
4302: if var_trace then
4303: c := dbms_sql.open_cursor;
4304: statement := 'alter session set sql_trace=true';
4305: dbms_sql.parse(c, statement, dbms_sql.native);