APPS.INV_LABEL dependencies on WMS_LABEL_REQUESTS_HIST

Line 1375: -- the label data will be inserted into WMS_LABEL_REQUESTS_HIST table

1371:
1372:
1373: -- This procedure is to write label xml data into LABEL_XML.log
1374: -- This is not used anymore from Patchset I (11.5.9) because
1375: -- the label data will be inserted into WMS_LABEL_REQUESTS_HIST table
1376: PROCEDURE writeIntoFile(xml LONG) IS
1377: l_dir VARCHAR2(128);
1378: l_debug_trace NUMBER;
1379: l_file_name VARCHAR2(100) := 'LABEL_XML.log';

Line 1501: * Insert into WMS_LABEL_REQUESTS_HIST

1497:
1498: END writeIntoFile;
1499:
1500: /*************************************
1501: * Insert into WMS_LABEL_REQUESTS_HIST
1502: ************************************/
1503: PROCEDURE insert_history_record(p_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE) IS
1504: PRAGMA AUTONOMOUS_TRANSACTION;
1505: BEGIN

Line 1503: PROCEDURE insert_history_record(p_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE) IS

1499:
1500: /*************************************
1501: * Insert into WMS_LABEL_REQUESTS_HIST
1502: ************************************/
1503: PROCEDURE insert_history_record(p_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE) IS
1504: PRAGMA AUTONOMOUS_TRANSACTION;
1505: BEGIN
1506: INSERT INTO wms_label_requests_hist
1507: ( label_request_id,

Line 1506: INSERT INTO wms_label_requests_hist

1502: ************************************/
1503: PROCEDURE insert_history_record(p_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE) IS
1504: PRAGMA AUTONOMOUS_TRANSACTION;
1505: BEGIN
1506: INSERT INTO wms_label_requests_hist
1507: ( label_request_id,
1508: LABEL_TYPE_ID ,
1509: LABEL_FORMAT_ID,
1510: ORGANIZATION_ID,

Line 1652: trace('Error in inserting into WMS_LABEL_REQUESTS_HIST record, Req ID:'|| p_history_rec.label_request_id,TRACE_PROMPT, TRACE_LEVEL);

1648: COMMIT;
1649: EXCEPTION
1650: WHEN others THEN
1651: IF (l_debug = 1) THEN
1652: trace('Error in inserting into WMS_LABEL_REQUESTS_HIST record, Req ID:'|| p_history_rec.label_request_id,TRACE_PROMPT, TRACE_LEVEL);
1653: END IF;
1654: END insert_history_record;
1655:
1656: /************************************

Line 1672: l_hist_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;

1668: CURSOR label_req_rec IS
1669: SELECT * FROM WMS_LABEL_REQUESTS
1670: WHERE label_request_id = p_label_request_id;
1671:
1672: l_hist_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;
1673:
1674: l_job_name VARCHAR2(150) := NULL;
1675:
1676: BEGIN

Line 1793: UPDATE wms_label_requests_hist

1789: , p_error_message IN VARCHAR2
1790: ) IS PRAGMA AUTONOMOUS_TRANSACTION;
1791:
1792: BEGIN
1793: UPDATE wms_label_requests_hist
1794: SET status_flag = nvl(p_status_flag, status_flag)
1795: , job_status = nvl(p_job_status,job_status)
1796: , printer_status = nvl(p_printer_status, printer_status)
1797: , status_type = nvl(p_status_type, status_type)

Line 3518: l_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;

3514: l_job_status VARCHAR2(2000); -- Bug 3328061 increased the size
3515: l_printer_status VARCHAR2(2000); -- Bug 3328061 increased the size
3516: l_status_type NUMBER;
3517:
3518: l_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;
3519: CURSOR c_hist IS
3520: SELECT * FROM wms_label_requests_hist
3521: WHERE label_request_id = p_hist_label_request_id;
3522:

Line 3520: SELECT * FROM wms_label_requests_hist

3516: l_status_type NUMBER;
3517:
3518: l_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;
3519: CURSOR c_hist IS
3520: SELECT * FROM wms_label_requests_hist
3521: WHERE label_request_id = p_hist_label_request_id;
3522:
3523: l_label_content LONG;
3524: l_printer_name VARCHAR2(50);

Line 3787: from wms_label_requests_hist wlrh,

3783: msik.concatenated_segments item,
3784: mfglkup1.meaning bus_flow,
3785: mfglkup2.meaning label_type,
3786: wlrh.label_request_id label_request_id
3787: from wms_label_requests_hist wlrh,
3788: wms_label_formats wlf,
3789: wms_license_plate_numbers wlpn,
3790: mtl_system_items_kfv msik,
3791: mfg_lookups mfglkup1,