APPS.INV_LABEL dependencies on WMS_LABEL_PRINT_HISTORY_S

Line 1850: SELECT wms_label_print_history_s.nextval into l_label_request_id from dual;

1846: trace(' **Supplier ID : ' || P_SUPPLIER_ID, TRACE_PROMPT, TRACE_LEVEL);
1847: trace(' **Supplier Site ID : ' || P_SUPPLIER_SITE_ID, TRACE_PROMPT, TRACE_LEVEL);
1848: END IF;
1849:
1850: SELECT wms_label_print_history_s.nextval into l_label_request_id from dual;
1851: x_label_request_id := l_label_request_id;
1852:
1853: trace(' **Label Request ID : ' || l_label_request_id, TRACE_PROMPT, TRACE_LEVEL);
1854:

Line 3489: select wms_label_print_history_s.nextval into l_history_rec.label_request_id

3485: trace('Found history record',TRACE_PROMPT, TRACE_LEVEL);
3486: END IF;
3487: -- populate original request id and get new label_request_id;
3488: l_history_rec.original_request_id := p_hist_label_request_id;
3489: select wms_label_print_history_s.nextval into l_history_rec.label_request_id
3490: from dual;
3491: select sysdate into l_sysdate from dual;
3492: l_history_rec.request_date := l_sysdate;
3493: l_history_rec.creation_date := l_sysdate;