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 1947: From Dual;

1943: Begin
1944:
1945: Select MTL_KANBAN_REPLENISH_CYCLE_S.NextVal
1946: Into l_next_replenish_cycle_Id
1947: From Dual;
1948: Return(l_next_replenish_cycle_Id);
1949:
1950: End Get_Next_Replenish_Cycle_Id;
1951:

Line 3020: from dual;

3016: LOOP
3017:
3018: select wsm_lot_sm_ifc_header_s.nextval
3019: into l_header_id
3020: from dual;
3021:
3022:
3023:
3024: select wsm_lot_job_interface_s.NEXTVAL

Line 3026: from dual;

3022:
3023:
3024: select wsm_lot_job_interface_s.NEXTVAL
3025: into l_group_id
3026: from dual;
3027:
3028: IF p_kanban_card_rec_tbl(l_order_count).lot_number IS NULL THEN
3029: l_mode_flag := 1;
3030: ELSE

Line 3036: from dual;

3032: END IF;
3033:
3034: select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval
3035: INTO l_job_name
3036: from dual;
3037: --3100874 Outbound Flow Sequencing
3038: --if the need_by_date is passed completion date should be set to the
3039: --value passed, otherwise just set the start date to sysdate
3040: IF p_kanban_card_rec_tbl(l_order_count).need_by_date IS NOT NULL THEN

Line 3245: FROM dual WHERE exists

3241: THEN
3242:
3243: BEGIN
3244: SELECT 'Y' INTO l_is_lot_control
3245: FROM dual WHERE exists
3246: (SELECT 1 FROM mtl_system_items
3247: WHERE
3248: organization_id = p_kanban_card_rec_tbl(1).organization_id
3249: AND inventory_item_id = p_kanban_card_rec_tbl(1).inventory_item_id

Line 3339: FROM dual WHERE exists

3335: elsif (v_cfm_flag = 3) AND (wsmpvers.get_osfm_release_version > '110508') THEN
3336:
3337: BEGIN
3338: SELECT 'Y' INTO l_is_lot_control
3339: FROM dual WHERE exists
3340: (SELECT 1 FROM mtl_system_items
3341: WHERE
3342: organization_id = p_kanban_card_rec_tbl(1).organization_id
3343: AND inventory_item_id = p_kanban_card_rec_tbl(1).inventory_item_id

Line 4381: FROM DUAL;

4377:
4378: /*Get the next header id*/
4379: SELECT mtl_material_transactions_s.NEXTVAL
4380: INTO l_txn_header_id
4381: FROM DUAL;
4382:
4383: /* Check whether item is serial controlled or not */
4384: SELECT DECODE(serial_number_control_code,1,'F','T')
4385: INTO l_serial_control_code