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 1028: select sysdate into l_curr_date from dual;

1024: BEGIN
1025: print_user_info(' Start of calculating/creating replenishment');
1026:
1027:
1028: select sysdate into l_curr_date from dual;
1029:
1030:
1031: /*-------------------------------------------+
1032: | Call procedure to set the vmi_refresh_flag |

Line 1154: from dual;

1150:
1151: BEGIN
1152: select mrp_atp_schedule_temp_s.nextval
1153: into l_session_id
1154: from dual;
1155:
1156: MSC_ATP_PROC.ATP_Intransit_LT(
1157: 2, --- Destination
1158: l_session_id, -- session_id

Line 1696: INTO l_rep_transaction_id FROM DUAL;

1692: || '/' || p_vmi_release_type
1693: );
1694:
1695: SELECT msc_sup_dem_entries_s.nextval
1696: INTO l_rep_transaction_id FROM DUAL;
1697: -- use item id, supplier id, customer id, customer site id, replenishment
1698: -- transaction id to compose a Workflow key, this Workflow key will be used
1699: -- by UI code to release the replenishment
1700: l_wf_key := TO_CHAR(p_inventory_item_id)