APPS.INV_KANBAN_PVT dependencies on DUAL

Line 491: CURSOR C2 IS SELECT mtl_kanban_pull_sequences_s.nextval FROM sys.dual;

487: l_report_generate_id NUMBER := 0; --Report id for generating cards
488: l_report_print_id NUMBER := 0; --Report id for printing cards
489: l_count_generate NUMBER := 0; --Count of number of cards to be generated
490: l_count_print NUMBER := 0; -- Count of number of cards to be printed
491: CURSOR C2 IS SELECT mtl_kanban_pull_sequences_s.nextval FROM sys.dual;
492: --Get new pull_sequence_id during insert.
493:
494: Begin
495: FND_MSG_PUB.initialize;

Line 500: INTO l_report_generate_id from DUAL;

496: l_PullSeqTable := p_Pull_Sequence_tbl;
497: l_operation_tbl:= p_operation_tbl;
498:
499: SELECT MTL_KANBAN_CARD_PRINT_TEMP_S.nextval
500: INTO l_report_generate_id from DUAL;
501:
502: SELECT MTL_KANBAN_CARD_PRINT_TEMP_S.nextval
503: INTO l_report_print_id from DUAL;
504:

Line 503: INTO l_report_print_id from DUAL;

499: SELECT MTL_KANBAN_CARD_PRINT_TEMP_S.nextval
500: INTO l_report_generate_id from DUAL;
501:
502: SELECT MTL_KANBAN_CARD_PRINT_TEMP_S.nextval
503: INTO l_report_print_id from DUAL;
504:
505: FOR l_record_count in 1 ..l_PullSeqtable.Count LOOP
506: l_pull_sequence_rec := INV_PullSequence_PKG.Query_Row
507: ( p_pull_sequence_id =>

Line 1671: From Dual;

1667: Begin
1668:
1669: Select MTL_KANBAN_REPLENISH_CYCLE_S.NextVal
1670: Into l_next_replenish_cycle_Id
1671: From Dual;
1672: Return(l_next_replenish_cycle_Id);
1673:
1674: End Get_Next_Replenish_Cycle_Id;
1675:

Line 2631: from dual;

2627: LOOP
2628:
2629: select wsm_lot_sm_ifc_header_s.nextval
2630: into l_header_id
2631: from dual;
2632:
2633:
2634:
2635: select wsm_lot_job_interface_s.NEXTVAL

Line 2637: from dual;

2633:
2634:
2635: select wsm_lot_job_interface_s.NEXTVAL
2636: into l_group_id
2637: from dual;
2638:
2639: IF p_kanban_card_rec_tbl(l_order_count).lot_number IS NULL THEN
2640: l_mode_flag := 1;
2641: ELSE

Line 2647: from dual;

2643: END IF;
2644:
2645: select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval
2646: INTO l_job_name
2647: from dual;
2648: --3100874 Outbound Flow Sequencing
2649: --if the need_by_date is passed completion date should be set to the
2650: --value passed, otherwise just set the start date to sysdate
2651: IF p_kanban_card_rec_tbl(l_order_count).need_by_date IS NOT NULL THEN

Line 2849: FROM dual WHERE exists

2845: THEN
2846:
2847: BEGIN
2848: SELECT 'Y' INTO l_is_lot_control
2849: FROM dual WHERE exists
2850: (SELECT 1 FROM mtl_system_items
2851: WHERE
2852: organization_id = p_kanban_card_rec_tbl(1).organization_id
2853: AND inventory_item_id = p_kanban_card_rec_tbl(1).inventory_item_id

Line 2943: FROM dual WHERE exists

2939: elsif (v_cfm_flag = 3) AND (wsmpvers.get_osfm_release_version > '110508') THEN
2940:
2941: BEGIN
2942: SELECT 'Y' INTO l_is_lot_control
2943: FROM dual WHERE exists
2944: (SELECT 1 FROM mtl_system_items
2945: WHERE
2946: organization_id = p_kanban_card_rec_tbl(1).organization_id
2947: AND inventory_item_id = p_kanban_card_rec_tbl(1).inventory_item_id

Line 3964: FROM DUAL;

3960:
3961: /*Get the next header id*/
3962: SELECT mtl_material_transactions_s.NEXTVAL
3963: INTO l_txn_header_id
3964: FROM DUAL;
3965:
3966: /* Check whether item is serial controlled or not */
3967: SELECT DECODE(serial_number_control_code,1,'F','T')
3968: INTO l_serial_control_code