APPS.MSC_X_REPLENISH dependencies on DUAL

Line 680: INTO l_rep_transaction_id FROM DUAL;

676: end if;
677: elsif (l_enable_vmi_auto_repl_flag = 'Y') then
678: -- get the next replenishment transaction id
679: SELECT msc_sup_dem_entries_s.nextval
680: INTO l_rep_transaction_id FROM DUAL;
681:
682: print_debug_info(' new replenishment transaction id = ' || l_rep_transaction_id);
683:
684: -- use org id, supplier id, supplier site id and replenishment id

Line 792: SELECT msc_x_seller_role_s.NEXTVAL INTO l_seller_role_seq FROM dual;

788:
789: print_debug_info(' buyer contact name = ' || l_buyer_name);
790: print_debug_info(' release approval flag = ' || l_vmi_replenishment_approval);
791:
792: SELECT msc_x_seller_role_s.NEXTVAL INTO l_seller_role_seq FROM dual;
793:
794: -- start of set up the Workflow role for seller
795: l_seller_role_name := 'MSCX_SELLER_ROLE' || l_seller_role_seq;
796: l_seller_role_display_name := 'VMI Replenishment Approver';

Line 853: SELECT msc_x_vmi_role_s.NEXTVAL INTO l_vmi_role_seq FROM dual;

849: -- end of set up the Workflow role for seller
850:
851: -- check if need to send notification to both buyer and seller
852: IF (l_vmi_replenishment_approval = 'SUPPLIER_OR_BUYER') THEN
853: SELECT msc_x_vmi_role_s.NEXTVAL INTO l_vmi_role_seq FROM dual;
854:
855: l_vmi_role_name := 'MSCX_VMI_ROLE' || l_vmi_role_seq;
856: l_vmi_role_display_name := 'VMI Replenishment Approver';
857:

Line 2286: FROM dual;

2282: INTO l_user_id,
2283: l_user_name,
2284: l_resp_name,
2285: l_application_name
2286: FROM dual;
2287:
2288: print_debug_info(' user ID/user name/responsibility/application = '
2289: || l_user_id
2290: || '/' || l_user_name

Line 3270: FROM dual;

3266: INTO l_user_id,
3267: l_user_name,
3268: l_resp_name,
3269: l_application_name
3270: FROM dual;
3271:
3272:
3273: print_debug_info(' user ID/user/responsibility/application = '
3274: || l_user_id