APPS.MRP_KANBAN_PLAN_PK dependencies on FND_GLOBAL

Line 128: request_id = fnd_global.conc_request_id

124: SET plan_start_date = g_kanban_info_rec.start_date,
125: plan_completion_date = NULL,
126: bom_effectivity_date = g_kanban_info_rec.bom_effectivity,
127: plan_cutoff_date = g_kanban_info_rec.cutoff_date,
128: request_id = fnd_global.conc_request_id
129: WHERE kanban_plan_id = g_kanban_info_rec.kanban_plan_id;
130:
131: RETURN TRUE;
132:

Line 677: fnd_global.conc_request_id,

673: l_demand_date,
674: l_demand_quantity,
675: p_demand_type,
676: 'Y',
677: fnd_global.conc_request_id,
678: fnd_global.prog_appl_id,
679: fnd_global.conc_program_id,
680: sysdate,
681: sysdate,

Line 678: fnd_global.prog_appl_id,

674: l_demand_quantity,
675: p_demand_type,
676: 'Y',
677: fnd_global.conc_request_id,
678: fnd_global.prog_appl_id,
679: fnd_global.conc_program_id,
680: sysdate,
681: sysdate,
682: fnd_global.user_id,

Line 679: fnd_global.conc_program_id,

675: p_demand_type,
676: 'Y',
677: fnd_global.conc_request_id,
678: fnd_global.prog_appl_id,
679: fnd_global.conc_program_id,
680: sysdate,
681: sysdate,
682: fnd_global.user_id,
683: sysdate,

Line 682: fnd_global.user_id,

678: fnd_global.prog_appl_id,
679: fnd_global.conc_program_id,
680: sysdate,
681: sysdate,
682: fnd_global.user_id,
683: sysdate,
684: fnd_global.user_id
685: FROM
686: mtl_kanban_pull_sequences ps

Line 684: fnd_global.user_id

680: sysdate,
681: sysdate,
682: fnd_global.user_id,
683: sysdate,
684: fnd_global.user_id
685: FROM
686: mtl_kanban_pull_sequences ps
687: WHERE /* ps.wip_line_id = l_line_id
688: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE

Line 735: fnd_global.conc_request_id,

731: (NVL(ps.allocation_percent, 100) *
732: l_demand_quantity/ 100),
733: p_demand_type,
734: 'Y',
735: fnd_global.conc_request_id,
736: fnd_global.prog_appl_id,
737: fnd_global.conc_program_id,
738: sysdate,
739: sysdate,

Line 736: fnd_global.prog_appl_id,

732: l_demand_quantity/ 100),
733: p_demand_type,
734: 'Y',
735: fnd_global.conc_request_id,
736: fnd_global.prog_appl_id,
737: fnd_global.conc_program_id,
738: sysdate,
739: sysdate,
740: fnd_global.user_id,

Line 737: fnd_global.conc_program_id,

733: p_demand_type,
734: 'Y',
735: fnd_global.conc_request_id,
736: fnd_global.prog_appl_id,
737: fnd_global.conc_program_id,
738: sysdate,
739: sysdate,
740: fnd_global.user_id,
741: sysdate,

Line 740: fnd_global.user_id,

736: fnd_global.prog_appl_id,
737: fnd_global.conc_program_id,
738: sysdate,
739: sysdate,
740: fnd_global.user_id,
741: sysdate,
742: fnd_global.user_id
743: FROM
744: mtl_kanban_pull_sequences ps

Line 742: fnd_global.user_id

738: sysdate,
739: sysdate,
740: fnd_global.user_id,
741: sysdate,
742: fnd_global.user_id
743: FROM
744: mtl_kanban_pull_sequences ps
745: WHERE ps.wip_line_id = l_line_id
746: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE

Line 793: fnd_global.conc_request_id,

789: l_demand_date,
790: l_demand_quantity,
791: p_demand_type,
792: p_kanban_item_flag,
793: fnd_global.conc_request_id,
794: fnd_global.prog_appl_id,
795: fnd_global.conc_program_id,
796: sysdate,
797: sysdate,

Line 794: fnd_global.prog_appl_id,

790: l_demand_quantity,
791: p_demand_type,
792: p_kanban_item_flag,
793: fnd_global.conc_request_id,
794: fnd_global.prog_appl_id,
795: fnd_global.conc_program_id,
796: sysdate,
797: sysdate,
798: fnd_global.user_id,

Line 795: fnd_global.conc_program_id,

791: p_demand_type,
792: p_kanban_item_flag,
793: fnd_global.conc_request_id,
794: fnd_global.prog_appl_id,
795: fnd_global.conc_program_id,
796: sysdate,
797: sysdate,
798: fnd_global.user_id,
799: sysdate,

Line 798: fnd_global.user_id,

794: fnd_global.prog_appl_id,
795: fnd_global.conc_program_id,
796: sysdate,
797: sysdate,
798: fnd_global.user_id,
799: sysdate,
800: fnd_global.user_id
801: FROM
802: DUAL;

Line 800: fnd_global.user_id

796: sysdate,
797: sysdate,
798: fnd_global.user_id,
799: sysdate,
800: fnd_global.user_id
801: FROM
802: DUAL;
803:
804: END IF;

Line 1265: fnd_global.conc_request_id,

1261: l_forecast_date,
1262: l_demand_quantity,
1263: 8,
1264: l_kanban_item_flag,
1265: fnd_global.conc_request_id,
1266: fnd_global.prog_appl_id,
1267: fnd_global.conc_program_id,
1268: sysdate,
1269: sysdate,

Line 1266: fnd_global.prog_appl_id,

1262: l_demand_quantity,
1263: 8,
1264: l_kanban_item_flag,
1265: fnd_global.conc_request_id,
1266: fnd_global.prog_appl_id,
1267: fnd_global.conc_program_id,
1268: sysdate,
1269: sysdate,
1270: fnd_global.user_id,

Line 1267: fnd_global.conc_program_id,

1263: 8,
1264: l_kanban_item_flag,
1265: fnd_global.conc_request_id,
1266: fnd_global.prog_appl_id,
1267: fnd_global.conc_program_id,
1268: sysdate,
1269: sysdate,
1270: fnd_global.user_id,
1271: sysdate,

Line 1270: fnd_global.user_id,

1266: fnd_global.prog_appl_id,
1267: fnd_global.conc_program_id,
1268: sysdate,
1269: sysdate,
1270: fnd_global.user_id,
1271: sysdate,
1272: fnd_global.user_id
1273: FROM
1274: DUAL;

Line 1272: fnd_global.user_id

1268: sysdate,
1269: sysdate,
1270: fnd_global.user_id,
1271: sysdate,
1272: fnd_global.user_id
1273: FROM
1274: DUAL;
1275:
1276: END IF;

Line 1819: fnd_global.conc_request_id,

1815: l_schedule_date,
1816: l_demand_quantity,
1817: 8,
1818: l_kanban_item_flag,
1819: fnd_global.conc_request_id,
1820: fnd_global.prog_appl_id,
1821: fnd_global.conc_program_id,
1822: sysdate,
1823: sysdate,

Line 1820: fnd_global.prog_appl_id,

1816: l_demand_quantity,
1817: 8,
1818: l_kanban_item_flag,
1819: fnd_global.conc_request_id,
1820: fnd_global.prog_appl_id,
1821: fnd_global.conc_program_id,
1822: sysdate,
1823: sysdate,
1824: fnd_global.user_id,

Line 1821: fnd_global.conc_program_id,

1817: 8,
1818: l_kanban_item_flag,
1819: fnd_global.conc_request_id,
1820: fnd_global.prog_appl_id,
1821: fnd_global.conc_program_id,
1822: sysdate,
1823: sysdate,
1824: fnd_global.user_id,
1825: sysdate,

Line 1824: fnd_global.user_id,

1820: fnd_global.prog_appl_id,
1821: fnd_global.conc_program_id,
1822: sysdate,
1823: sysdate,
1824: fnd_global.user_id,
1825: sysdate,
1826: fnd_global.user_id
1827: FROM
1828: DUAL;

Line 1826: fnd_global.user_id

1822: sysdate,
1823: sysdate,
1824: fnd_global.user_id,
1825: sysdate,
1826: fnd_global.user_id
1827: FROM
1828: DUAL;
1829:
1830: END IF;

Line 2322: fnd_global.conc_request_id,

2318: l_schedule_date,
2319: l_demand_quantity,
2320: 8,
2321: l_kanban_item_flag,
2322: fnd_global.conc_request_id,
2323: fnd_global.prog_appl_id,
2324: fnd_global.conc_program_id,
2325: sysdate,
2326: sysdate,

Line 2323: fnd_global.prog_appl_id,

2319: l_demand_quantity,
2320: 8,
2321: l_kanban_item_flag,
2322: fnd_global.conc_request_id,
2323: fnd_global.prog_appl_id,
2324: fnd_global.conc_program_id,
2325: sysdate,
2326: sysdate,
2327: fnd_global.user_id,

Line 2324: fnd_global.conc_program_id,

2320: 8,
2321: l_kanban_item_flag,
2322: fnd_global.conc_request_id,
2323: fnd_global.prog_appl_id,
2324: fnd_global.conc_program_id,
2325: sysdate,
2326: sysdate,
2327: fnd_global.user_id,
2328: sysdate,

Line 2327: fnd_global.user_id,

2323: fnd_global.prog_appl_id,
2324: fnd_global.conc_program_id,
2325: sysdate,
2326: sysdate,
2327: fnd_global.user_id,
2328: sysdate,
2329: fnd_global.user_id
2330: FROM
2331: DUAL;

Line 2329: fnd_global.user_id

2325: sysdate,
2326: sysdate,
2327: fnd_global.user_id,
2328: sysdate,
2329: fnd_global.user_id
2330: FROM
2331: DUAL;
2332:
2333: END IF;

Line 2596: fnd_global.conc_request_id,

2592: l_forecast_date,
2593: l_forecast_quantity,
2594: l_origination_type,
2595: 'Y',
2596: fnd_global.conc_request_id,
2597: fnd_global.prog_appl_id,
2598: fnd_global.conc_program_id,
2599: sysdate,
2600: sysdate,

Line 2597: fnd_global.prog_appl_id,

2593: l_forecast_quantity,
2594: l_origination_type,
2595: 'Y',
2596: fnd_global.conc_request_id,
2597: fnd_global.prog_appl_id,
2598: fnd_global.conc_program_id,
2599: sysdate,
2600: sysdate,
2601: fnd_global.user_id,

Line 2598: fnd_global.conc_program_id,

2594: l_origination_type,
2595: 'Y',
2596: fnd_global.conc_request_id,
2597: fnd_global.prog_appl_id,
2598: fnd_global.conc_program_id,
2599: sysdate,
2600: sysdate,
2601: fnd_global.user_id,
2602: sysdate,

Line 2601: fnd_global.user_id,

2597: fnd_global.prog_appl_id,
2598: fnd_global.conc_program_id,
2599: sysdate,
2600: sysdate,
2601: fnd_global.user_id,
2602: sysdate,
2603: fnd_global.user_id
2604: FROM
2605: mtl_kanban_pull_sequences ps

Line 2603: fnd_global.user_id

2599: sysdate,
2600: sysdate,
2601: fnd_global.user_id,
2602: sysdate,
2603: fnd_global.user_id
2604: FROM
2605: mtl_kanban_pull_sequences ps
2606: WHERE
2607: -- eKanban Changes.

Line 2659: fnd_global.conc_request_id,

2655: (NVL(ps.allocation_percent, 100) *
2656: l_forecast_quantity/ 100),
2657: l_origination_type,
2658: 'Y',
2659: fnd_global.conc_request_id,
2660: fnd_global.prog_appl_id,
2661: fnd_global.conc_program_id,
2662: sysdate,
2663: sysdate,

Line 2660: fnd_global.prog_appl_id,

2656: l_forecast_quantity/ 100),
2657: l_origination_type,
2658: 'Y',
2659: fnd_global.conc_request_id,
2660: fnd_global.prog_appl_id,
2661: fnd_global.conc_program_id,
2662: sysdate,
2663: sysdate,
2664: fnd_global.user_id,

Line 2661: fnd_global.conc_program_id,

2657: l_origination_type,
2658: 'Y',
2659: fnd_global.conc_request_id,
2660: fnd_global.prog_appl_id,
2661: fnd_global.conc_program_id,
2662: sysdate,
2663: sysdate,
2664: fnd_global.user_id,
2665: sysdate,

Line 2664: fnd_global.user_id,

2660: fnd_global.prog_appl_id,
2661: fnd_global.conc_program_id,
2662: sysdate,
2663: sysdate,
2664: fnd_global.user_id,
2665: sysdate,
2666: fnd_global.user_id
2667: FROM
2668: mtl_kanban_pull_sequences ps

Line 2666: fnd_global.user_id

2662: sysdate,
2663: sysdate,
2664: fnd_global.user_id,
2665: sysdate,
2666: fnd_global.user_id
2667: FROM
2668: mtl_kanban_pull_sequences ps
2669: WHERE
2670: ps.wip_line_id = l_line_id

Line 2941: fnd_global.conc_request_id,

2937: l_schedule_date,
2938: l_schedule_quantity,
2939: l_schedule_type,
2940: 'Y',
2941: fnd_global.conc_request_id,
2942: fnd_global.prog_appl_id,
2943: fnd_global.conc_program_id,
2944: sysdate,
2945: sysdate,

Line 2942: fnd_global.prog_appl_id,

2938: l_schedule_quantity,
2939: l_schedule_type,
2940: 'Y',
2941: fnd_global.conc_request_id,
2942: fnd_global.prog_appl_id,
2943: fnd_global.conc_program_id,
2944: sysdate,
2945: sysdate,
2946: fnd_global.user_id,

Line 2943: fnd_global.conc_program_id,

2939: l_schedule_type,
2940: 'Y',
2941: fnd_global.conc_request_id,
2942: fnd_global.prog_appl_id,
2943: fnd_global.conc_program_id,
2944: sysdate,
2945: sysdate,
2946: fnd_global.user_id,
2947: sysdate,

Line 2946: fnd_global.user_id,

2942: fnd_global.prog_appl_id,
2943: fnd_global.conc_program_id,
2944: sysdate,
2945: sysdate,
2946: fnd_global.user_id,
2947: sysdate,
2948: fnd_global.user_id
2949: FROM
2950: mtl_kanban_pull_sequences ps

Line 2948: fnd_global.user_id

2944: sysdate,
2945: sysdate,
2946: fnd_global.user_id,
2947: sysdate,
2948: fnd_global.user_id
2949: FROM
2950: mtl_kanban_pull_sequences ps
2951: WHERE
2952: -- eKanban Changes.

Line 3004: fnd_global.conc_request_id,

3000: (NVL(ps.allocation_percent, 100) *
3001: l_schedule_quantity/ 100),
3002: l_schedule_type,
3003: 'Y',
3004: fnd_global.conc_request_id,
3005: fnd_global.prog_appl_id,
3006: fnd_global.conc_program_id,
3007: sysdate,
3008: sysdate,

Line 3005: fnd_global.prog_appl_id,

3001: l_schedule_quantity/ 100),
3002: l_schedule_type,
3003: 'Y',
3004: fnd_global.conc_request_id,
3005: fnd_global.prog_appl_id,
3006: fnd_global.conc_program_id,
3007: sysdate,
3008: sysdate,
3009: fnd_global.user_id,

Line 3006: fnd_global.conc_program_id,

3002: l_schedule_type,
3003: 'Y',
3004: fnd_global.conc_request_id,
3005: fnd_global.prog_appl_id,
3006: fnd_global.conc_program_id,
3007: sysdate,
3008: sysdate,
3009: fnd_global.user_id,
3010: sysdate,

Line 3009: fnd_global.user_id,

3005: fnd_global.prog_appl_id,
3006: fnd_global.conc_program_id,
3007: sysdate,
3008: sysdate,
3009: fnd_global.user_id,
3010: sysdate,
3011: fnd_global.user_id
3012: FROM
3013: mtl_kanban_pull_sequences ps

Line 3011: fnd_global.user_id

3007: sysdate,
3008: sysdate,
3009: fnd_global.user_id,
3010: sysdate,
3011: fnd_global.user_id
3012: FROM
3013: mtl_kanban_pull_sequences ps
3014: WHERE
3015: ps.wip_line_id = l_line_id

Line 3251: fnd_global.conc_request_id,

3247: l_schedule_date,
3248: l_schedule_quantity,
3249: l_schedule_origination_type,
3250: 'Y',
3251: fnd_global.conc_request_id,
3252: fnd_global.prog_appl_id,
3253: fnd_global.conc_program_id,
3254: sysdate,
3255: sysdate,

Line 3252: fnd_global.prog_appl_id,

3248: l_schedule_quantity,
3249: l_schedule_origination_type,
3250: 'Y',
3251: fnd_global.conc_request_id,
3252: fnd_global.prog_appl_id,
3253: fnd_global.conc_program_id,
3254: sysdate,
3255: sysdate,
3256: fnd_global.user_id,

Line 3253: fnd_global.conc_program_id,

3249: l_schedule_origination_type,
3250: 'Y',
3251: fnd_global.conc_request_id,
3252: fnd_global.prog_appl_id,
3253: fnd_global.conc_program_id,
3254: sysdate,
3255: sysdate,
3256: fnd_global.user_id,
3257: sysdate,

Line 3256: fnd_global.user_id,

3252: fnd_global.prog_appl_id,
3253: fnd_global.conc_program_id,
3254: sysdate,
3255: sysdate,
3256: fnd_global.user_id,
3257: sysdate,
3258: fnd_global.user_id
3259: FROM
3260: mtl_kanban_pull_sequences ps

Line 3258: fnd_global.user_id

3254: sysdate,
3255: sysdate,
3256: fnd_global.user_id,
3257: sysdate,
3258: fnd_global.user_id
3259: FROM
3260: mtl_kanban_pull_sequences ps
3261: WHERE
3262: -- eKanban Changes.

Line 3315: fnd_global.conc_request_id,

3311: (NVL(ps.allocation_percent, 100) *
3312: l_schedule_quantity/ 100),
3313: l_schedule_origination_type,
3314: 'Y',
3315: fnd_global.conc_request_id,
3316: fnd_global.prog_appl_id,
3317: fnd_global.conc_program_id,
3318: sysdate,
3319: sysdate,

Line 3316: fnd_global.prog_appl_id,

3312: l_schedule_quantity/ 100),
3313: l_schedule_origination_type,
3314: 'Y',
3315: fnd_global.conc_request_id,
3316: fnd_global.prog_appl_id,
3317: fnd_global.conc_program_id,
3318: sysdate,
3319: sysdate,
3320: fnd_global.user_id,

Line 3317: fnd_global.conc_program_id,

3313: l_schedule_origination_type,
3314: 'Y',
3315: fnd_global.conc_request_id,
3316: fnd_global.prog_appl_id,
3317: fnd_global.conc_program_id,
3318: sysdate,
3319: sysdate,
3320: fnd_global.user_id,
3321: sysdate,

Line 3320: fnd_global.user_id,

3316: fnd_global.prog_appl_id,
3317: fnd_global.conc_program_id,
3318: sysdate,
3319: sysdate,
3320: fnd_global.user_id,
3321: sysdate,
3322: fnd_global.user_id
3323: FROM
3324: mtl_kanban_pull_sequences ps

Line 3322: fnd_global.user_id

3318: sysdate,
3319: sysdate,
3320: fnd_global.user_id,
3321: sysdate,
3322: fnd_global.user_id
3323: FROM
3324: mtl_kanban_pull_sequences ps
3325: WHERE
3326: ps.wip_line_id = l_line_id

Line 4182: fnd_global.conc_request_id,

4178: -- Now go ahead and insert/update into mtl_kanban_pull_sequences table
4179: -- information about this kanban item/location for this kanban plan
4180:
4181: SELECT
4182: fnd_global.conc_request_id,
4183: fnd_global.prog_appl_id,
4184: fnd_global.conc_program_id,
4185: sysdate,
4186: sysdate,

Line 4183: fnd_global.prog_appl_id,

4179: -- information about this kanban item/location for this kanban plan
4180:
4181: SELECT
4182: fnd_global.conc_request_id,
4183: fnd_global.prog_appl_id,
4184: fnd_global.conc_program_id,
4185: sysdate,
4186: sysdate,
4187: fnd_global.user_id,

Line 4184: fnd_global.conc_program_id,

4180:
4181: SELECT
4182: fnd_global.conc_request_id,
4183: fnd_global.prog_appl_id,
4184: fnd_global.conc_program_id,
4185: sysdate,
4186: sysdate,
4187: fnd_global.user_id,
4188: sysdate,

Line 4187: fnd_global.user_id,

4183: fnd_global.prog_appl_id,
4184: fnd_global.conc_program_id,
4185: sysdate,
4186: sysdate,
4187: fnd_global.user_id,
4188: sysdate,
4189: fnd_global.user_id
4190: INTO
4191: l_pull_sequence_rec.request_id,

Line 4189: fnd_global.user_id

4185: sysdate,
4186: sysdate,
4187: fnd_global.user_id,
4188: sysdate,
4189: fnd_global.user_id
4190: INTO
4191: l_pull_sequence_rec.request_id,
4192: l_pull_sequence_rec.program_application_id,
4193: l_pull_sequence_rec.program_id,