DBA Data[Home] [Help]

APPS.MRP_KANBAN_PLAN_PK dependencies on FND_GLOBAL

Line 673: fnd_global.conc_request_id,

669: (NVL(ps.allocation_percent, 100) *
670: l_demand_quantity/ 100),
671: p_demand_type,
672: 'Y',
673: fnd_global.conc_request_id,
674: fnd_global.prog_appl_id,
675: fnd_global.conc_program_id,
676: sysdate,
677: sysdate,

Line 674: fnd_global.prog_appl_id,

670: l_demand_quantity/ 100),
671: p_demand_type,
672: 'Y',
673: fnd_global.conc_request_id,
674: fnd_global.prog_appl_id,
675: fnd_global.conc_program_id,
676: sysdate,
677: sysdate,
678: fnd_global.user_id,

Line 675: fnd_global.conc_program_id,

671: p_demand_type,
672: 'Y',
673: fnd_global.conc_request_id,
674: fnd_global.prog_appl_id,
675: fnd_global.conc_program_id,
676: sysdate,
677: sysdate,
678: fnd_global.user_id,
679: sysdate,

Line 678: fnd_global.user_id,

674: fnd_global.prog_appl_id,
675: fnd_global.conc_program_id,
676: sysdate,
677: sysdate,
678: fnd_global.user_id,
679: sysdate,
680: fnd_global.user_id
681: FROM
682: mtl_kanban_pull_sequences ps

Line 680: fnd_global.user_id

676: sysdate,
677: sysdate,
678: fnd_global.user_id,
679: sysdate,
680: fnd_global.user_id
681: FROM
682: mtl_kanban_pull_sequences ps
683: WHERE ps.wip_line_id = l_line_id
684: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE

Line 730: fnd_global.conc_request_id,

726: l_demand_date,
727: l_demand_quantity,
728: p_demand_type,
729: p_kanban_item_flag,
730: fnd_global.conc_request_id,
731: fnd_global.prog_appl_id,
732: fnd_global.conc_program_id,
733: sysdate,
734: sysdate,

Line 731: fnd_global.prog_appl_id,

727: l_demand_quantity,
728: p_demand_type,
729: p_kanban_item_flag,
730: fnd_global.conc_request_id,
731: fnd_global.prog_appl_id,
732: fnd_global.conc_program_id,
733: sysdate,
734: sysdate,
735: fnd_global.user_id,

Line 732: fnd_global.conc_program_id,

728: p_demand_type,
729: p_kanban_item_flag,
730: fnd_global.conc_request_id,
731: fnd_global.prog_appl_id,
732: fnd_global.conc_program_id,
733: sysdate,
734: sysdate,
735: fnd_global.user_id,
736: sysdate,

Line 735: fnd_global.user_id,

731: fnd_global.prog_appl_id,
732: fnd_global.conc_program_id,
733: sysdate,
734: sysdate,
735: fnd_global.user_id,
736: sysdate,
737: fnd_global.user_id
738: FROM
739: DUAL;

Line 737: fnd_global.user_id

733: sysdate,
734: sysdate,
735: fnd_global.user_id,
736: sysdate,
737: fnd_global.user_id
738: FROM
739: DUAL;
740:
741: END IF;

Line 1192: fnd_global.conc_request_id,

1188: l_forecast_date,
1189: l_demand_quantity,
1190: 8,
1191: l_kanban_item_flag,
1192: fnd_global.conc_request_id,
1193: fnd_global.prog_appl_id,
1194: fnd_global.conc_program_id,
1195: sysdate,
1196: sysdate,

Line 1193: fnd_global.prog_appl_id,

1189: l_demand_quantity,
1190: 8,
1191: l_kanban_item_flag,
1192: fnd_global.conc_request_id,
1193: fnd_global.prog_appl_id,
1194: fnd_global.conc_program_id,
1195: sysdate,
1196: sysdate,
1197: fnd_global.user_id,

Line 1194: fnd_global.conc_program_id,

1190: 8,
1191: l_kanban_item_flag,
1192: fnd_global.conc_request_id,
1193: fnd_global.prog_appl_id,
1194: fnd_global.conc_program_id,
1195: sysdate,
1196: sysdate,
1197: fnd_global.user_id,
1198: sysdate,

Line 1197: fnd_global.user_id,

1193: fnd_global.prog_appl_id,
1194: fnd_global.conc_program_id,
1195: sysdate,
1196: sysdate,
1197: fnd_global.user_id,
1198: sysdate,
1199: fnd_global.user_id
1200: FROM
1201: DUAL;

Line 1199: fnd_global.user_id

1195: sysdate,
1196: sysdate,
1197: fnd_global.user_id,
1198: sysdate,
1199: fnd_global.user_id
1200: FROM
1201: DUAL;
1202:
1203: END IF;

Line 1729: fnd_global.conc_request_id,

1725: l_schedule_date,
1726: l_demand_quantity,
1727: 8,
1728: l_kanban_item_flag,
1729: fnd_global.conc_request_id,
1730: fnd_global.prog_appl_id,
1731: fnd_global.conc_program_id,
1732: sysdate,
1733: sysdate,

Line 1730: fnd_global.prog_appl_id,

1726: l_demand_quantity,
1727: 8,
1728: l_kanban_item_flag,
1729: fnd_global.conc_request_id,
1730: fnd_global.prog_appl_id,
1731: fnd_global.conc_program_id,
1732: sysdate,
1733: sysdate,
1734: fnd_global.user_id,

Line 1731: fnd_global.conc_program_id,

1727: 8,
1728: l_kanban_item_flag,
1729: fnd_global.conc_request_id,
1730: fnd_global.prog_appl_id,
1731: fnd_global.conc_program_id,
1732: sysdate,
1733: sysdate,
1734: fnd_global.user_id,
1735: sysdate,

Line 1734: fnd_global.user_id,

1730: fnd_global.prog_appl_id,
1731: fnd_global.conc_program_id,
1732: sysdate,
1733: sysdate,
1734: fnd_global.user_id,
1735: sysdate,
1736: fnd_global.user_id
1737: FROM
1738: DUAL;

Line 1736: fnd_global.user_id

1732: sysdate,
1733: sysdate,
1734: fnd_global.user_id,
1735: sysdate,
1736: fnd_global.user_id
1737: FROM
1738: DUAL;
1739:
1740: END IF;

Line 2217: fnd_global.conc_request_id,

2213: l_schedule_date,
2214: l_demand_quantity,
2215: 8,
2216: l_kanban_item_flag,
2217: fnd_global.conc_request_id,
2218: fnd_global.prog_appl_id,
2219: fnd_global.conc_program_id,
2220: sysdate,
2221: sysdate,

Line 2218: fnd_global.prog_appl_id,

2214: l_demand_quantity,
2215: 8,
2216: l_kanban_item_flag,
2217: fnd_global.conc_request_id,
2218: fnd_global.prog_appl_id,
2219: fnd_global.conc_program_id,
2220: sysdate,
2221: sysdate,
2222: fnd_global.user_id,

Line 2219: fnd_global.conc_program_id,

2215: 8,
2216: l_kanban_item_flag,
2217: fnd_global.conc_request_id,
2218: fnd_global.prog_appl_id,
2219: fnd_global.conc_program_id,
2220: sysdate,
2221: sysdate,
2222: fnd_global.user_id,
2223: sysdate,

Line 2222: fnd_global.user_id,

2218: fnd_global.prog_appl_id,
2219: fnd_global.conc_program_id,
2220: sysdate,
2221: sysdate,
2222: fnd_global.user_id,
2223: sysdate,
2224: fnd_global.user_id
2225: FROM
2226: DUAL;

Line 2224: fnd_global.user_id

2220: sysdate,
2221: sysdate,
2222: fnd_global.user_id,
2223: sysdate,
2224: fnd_global.user_id
2225: FROM
2226: DUAL;
2227:
2228: END IF;

Line 2485: fnd_global.conc_request_id,

2481: (NVL(ps.allocation_percent, 100) *
2482: l_forecast_quantity/ 100),
2483: l_origination_type,
2484: 'Y',
2485: fnd_global.conc_request_id,
2486: fnd_global.prog_appl_id,
2487: fnd_global.conc_program_id,
2488: sysdate,
2489: sysdate,

Line 2486: fnd_global.prog_appl_id,

2482: l_forecast_quantity/ 100),
2483: l_origination_type,
2484: 'Y',
2485: fnd_global.conc_request_id,
2486: fnd_global.prog_appl_id,
2487: fnd_global.conc_program_id,
2488: sysdate,
2489: sysdate,
2490: fnd_global.user_id,

Line 2487: fnd_global.conc_program_id,

2483: l_origination_type,
2484: 'Y',
2485: fnd_global.conc_request_id,
2486: fnd_global.prog_appl_id,
2487: fnd_global.conc_program_id,
2488: sysdate,
2489: sysdate,
2490: fnd_global.user_id,
2491: sysdate,

Line 2490: fnd_global.user_id,

2486: fnd_global.prog_appl_id,
2487: fnd_global.conc_program_id,
2488: sysdate,
2489: sysdate,
2490: fnd_global.user_id,
2491: sysdate,
2492: fnd_global.user_id
2493: FROM
2494: mtl_kanban_pull_sequences ps

Line 2492: fnd_global.user_id

2488: sysdate,
2489: sysdate,
2490: fnd_global.user_id,
2491: sysdate,
2492: fnd_global.user_id
2493: FROM
2494: mtl_kanban_pull_sequences ps
2495: WHERE ps.wip_line_id = l_line_id
2496: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE

Line 2758: fnd_global.conc_request_id,

2754: (NVL(ps.allocation_percent, 100) *
2755: l_schedule_quantity/ 100),
2756: l_schedule_type,
2757: 'Y',
2758: fnd_global.conc_request_id,
2759: fnd_global.prog_appl_id,
2760: fnd_global.conc_program_id,
2761: sysdate,
2762: sysdate,

Line 2759: fnd_global.prog_appl_id,

2755: l_schedule_quantity/ 100),
2756: l_schedule_type,
2757: 'Y',
2758: fnd_global.conc_request_id,
2759: fnd_global.prog_appl_id,
2760: fnd_global.conc_program_id,
2761: sysdate,
2762: sysdate,
2763: fnd_global.user_id,

Line 2760: fnd_global.conc_program_id,

2756: l_schedule_type,
2757: 'Y',
2758: fnd_global.conc_request_id,
2759: fnd_global.prog_appl_id,
2760: fnd_global.conc_program_id,
2761: sysdate,
2762: sysdate,
2763: fnd_global.user_id,
2764: sysdate,

Line 2763: fnd_global.user_id,

2759: fnd_global.prog_appl_id,
2760: fnd_global.conc_program_id,
2761: sysdate,
2762: sysdate,
2763: fnd_global.user_id,
2764: sysdate,
2765: fnd_global.user_id
2766: FROM
2767: mtl_kanban_pull_sequences ps

Line 2765: fnd_global.user_id

2761: sysdate,
2762: sysdate,
2763: fnd_global.user_id,
2764: sysdate,
2765: fnd_global.user_id
2766: FROM
2767: mtl_kanban_pull_sequences ps
2768: WHERE ps.wip_line_id = l_line_id
2769: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE

Line 2996: fnd_global.conc_request_id,

2992: (NVL(ps.allocation_percent, 100) *
2993: l_schedule_quantity/ 100),
2994: l_schedule_origination_type,
2995: 'Y',
2996: fnd_global.conc_request_id,
2997: fnd_global.prog_appl_id,
2998: fnd_global.conc_program_id,
2999: sysdate,
3000: sysdate,

Line 2997: fnd_global.prog_appl_id,

2993: l_schedule_quantity/ 100),
2994: l_schedule_origination_type,
2995: 'Y',
2996: fnd_global.conc_request_id,
2997: fnd_global.prog_appl_id,
2998: fnd_global.conc_program_id,
2999: sysdate,
3000: sysdate,
3001: fnd_global.user_id,

Line 2998: fnd_global.conc_program_id,

2994: l_schedule_origination_type,
2995: 'Y',
2996: fnd_global.conc_request_id,
2997: fnd_global.prog_appl_id,
2998: fnd_global.conc_program_id,
2999: sysdate,
3000: sysdate,
3001: fnd_global.user_id,
3002: sysdate,

Line 3001: fnd_global.user_id,

2997: fnd_global.prog_appl_id,
2998: fnd_global.conc_program_id,
2999: sysdate,
3000: sysdate,
3001: fnd_global.user_id,
3002: sysdate,
3003: fnd_global.user_id
3004: FROM
3005: mtl_kanban_pull_sequences ps

Line 3003: fnd_global.user_id

2999: sysdate,
3000: sysdate,
3001: fnd_global.user_id,
3002: sysdate,
3003: fnd_global.user_id
3004: FROM
3005: mtl_kanban_pull_sequences ps
3006: WHERE ps.wip_line_id = l_line_id
3007: AND ps.source_type = G_PRODUCTION_SOURCE_TYPE

Line 3689: fnd_global.conc_request_id,

3685: -- Now go ahead and insert/update into mtl_kanban_pull_sequences table
3686: -- information about this kanban item/location for this kanban plan
3687:
3688: SELECT
3689: fnd_global.conc_request_id,
3690: fnd_global.prog_appl_id,
3691: fnd_global.conc_program_id,
3692: sysdate,
3693: sysdate,

Line 3690: fnd_global.prog_appl_id,

3686: -- information about this kanban item/location for this kanban plan
3687:
3688: SELECT
3689: fnd_global.conc_request_id,
3690: fnd_global.prog_appl_id,
3691: fnd_global.conc_program_id,
3692: sysdate,
3693: sysdate,
3694: fnd_global.user_id,

Line 3691: fnd_global.conc_program_id,

3687:
3688: SELECT
3689: fnd_global.conc_request_id,
3690: fnd_global.prog_appl_id,
3691: fnd_global.conc_program_id,
3692: sysdate,
3693: sysdate,
3694: fnd_global.user_id,
3695: sysdate,

Line 3694: fnd_global.user_id,

3690: fnd_global.prog_appl_id,
3691: fnd_global.conc_program_id,
3692: sysdate,
3693: sysdate,
3694: fnd_global.user_id,
3695: sysdate,
3696: fnd_global.user_id
3697: INTO
3698: l_pull_sequence_rec.request_id,

Line 3696: fnd_global.user_id

3692: sysdate,
3693: sysdate,
3694: fnd_global.user_id,
3695: sysdate,
3696: fnd_global.user_id
3697: INTO
3698: l_pull_sequence_rec.request_id,
3699: l_pull_sequence_rec.program_application_id,
3700: l_pull_sequence_rec.program_id,