APPS.MSC_X_CVMI_REPLENISH dependencies on DUAL

Line 86: INTO l_rep_transaction_id FROM DUAL;

82:
83: BEGIN
84: -- get the next replenishment transaction id
85: SELECT msc_sup_dem_entries_s.nextval
86: INTO l_rep_transaction_id FROM DUAL;
87:
88:
89: vmi_replenish(l_last_max_refresh_number,
90: p_replenish_time_fence);

Line 296: INTO l_rep_transaction_id FROM DUAL;

292: | Get the new replenishment tranaction id |
293: +-----------------------------------------*/
294:
295: SELECT msc_sup_dem_entries_s.nextval
296: INTO l_rep_transaction_id FROM DUAL;
297:
298:
299: if(l_repl_row_found = SYS_NO) then
300:

Line 1016: select sysdate into l_curr_date from dual;

1012: BEGIN
1013: print_user_info(' Start of calculating/creating replenishment');
1014:
1015:
1016: select sysdate into l_curr_date from dual;
1017:
1018:
1019: /*-------------------------------------------+
1020: | Call procedure to set the vmi_refresh_flag |

Line 1142: from dual;

1138:
1139: BEGIN
1140: select mrp_atp_schedule_temp_s.nextval
1141: into l_session_id
1142: from dual;
1143:
1144: MSC_ATP_PROC.ATP_Intransit_LT(
1145: 2, --- Destination
1146: l_session_id, -- session_id

Line 1684: INTO l_rep_transaction_id FROM DUAL;

1680: || '/' || p_vmi_release_type
1681: );
1682:
1683: SELECT msc_sup_dem_entries_s.nextval
1684: INTO l_rep_transaction_id FROM DUAL;
1685: -- use item id, supplier id, customer id, customer site id, replenishment
1686: -- transaction id to compose a Workflow key, this Workflow key will be used
1687: -- by UI code to release the replenishment
1688: l_wf_key := TO_CHAR(p_inventory_item_id)