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,
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,
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,
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
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
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,
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,
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,
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;
733: sysdate,
734: sysdate,
735: fnd_global.user_id,
736: sysdate,
737: fnd_global.user_id
738: FROM
739: DUAL;
740:
741: END IF;
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,
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,
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,
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;
1195: sysdate,
1196: sysdate,
1197: fnd_global.user_id,
1198: sysdate,
1199: fnd_global.user_id
1200: FROM
1201: DUAL;
1202:
1203: END IF;
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,
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,
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,
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;
1732: sysdate,
1733: sysdate,
1734: fnd_global.user_id,
1735: sysdate,
1736: fnd_global.user_id
1737: FROM
1738: DUAL;
1739:
1740: END IF;
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,
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,
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,
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;
2220: sysdate,
2221: sysdate,
2222: fnd_global.user_id,
2223: sysdate,
2224: fnd_global.user_id
2225: FROM
2226: DUAL;
2227:
2228: END IF;
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,
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,
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,
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
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
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,
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,
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,
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
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
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,
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,
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,
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
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
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,
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,
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,
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,
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,