APPS.INV_LABEL dependencies on WMS_LABEL_REQUESTS_HIST

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

1310:
1311:
1312: -- This procedure is to write label xml data into LABEL_XML.log
1313: -- This is not used anymore from Patchset I (11.5.9) because
1314: -- the label data will be inserted into WMS_LABEL_REQUESTS_HIST table
1315: PROCEDURE writeIntoFile(xml LONG) IS
1316: l_dir VARCHAR2(128);
1317: l_debug_trace NUMBER;
1318: l_file_name VARCHAR2(100) := 'LABEL_XML.log';

Line 1440: * Insert into WMS_LABEL_REQUESTS_HIST

1436:
1437: END writeIntoFile;
1438:
1439: /*************************************
1440: * Insert into WMS_LABEL_REQUESTS_HIST
1441: ************************************/
1442: PROCEDURE insert_history_record(p_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE) IS
1443: PRAGMA AUTONOMOUS_TRANSACTION;
1444: BEGIN

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

1438:
1439: /*************************************
1440: * Insert into WMS_LABEL_REQUESTS_HIST
1441: ************************************/
1442: PROCEDURE insert_history_record(p_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE) IS
1443: PRAGMA AUTONOMOUS_TRANSACTION;
1444: BEGIN
1445: INSERT INTO wms_label_requests_hist
1446: ( label_request_id,

Line 1445: INSERT INTO wms_label_requests_hist

1441: ************************************/
1442: PROCEDURE insert_history_record(p_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE) IS
1443: PRAGMA AUTONOMOUS_TRANSACTION;
1444: BEGIN
1445: INSERT INTO wms_label_requests_hist
1446: ( label_request_id,
1447: LABEL_TYPE_ID ,
1448: LABEL_FORMAT_ID,
1449: ORGANIZATION_ID,

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

1587: COMMIT;
1588: EXCEPTION
1589: WHEN others THEN
1590: IF (l_debug = 1) THEN
1591: trace('Error in inserting into WMS_LABEL_REQUESTS_HIST record, Req ID:'|| p_history_rec.label_request_id,TRACE_PROMPT, TRACE_LEVEL);
1592: END IF;
1593: END insert_history_record;
1594:
1595: /************************************

Line 1611: l_hist_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;

1607: CURSOR label_req_rec IS
1608: SELECT * FROM WMS_LABEL_REQUESTS
1609: WHERE label_request_id = p_label_request_id;
1610:
1611: l_hist_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;
1612:
1613: l_job_name VARCHAR2(150) := NULL;
1614:
1615: BEGIN

Line 1732: UPDATE wms_label_requests_hist

1728: , p_error_message IN VARCHAR2
1729: ) IS PRAGMA AUTONOMOUS_TRANSACTION;
1730:
1731: BEGIN
1732: UPDATE wms_label_requests_hist
1733: SET status_flag = nvl(p_status_flag, status_flag)
1734: , job_status = nvl(p_job_status,job_status)
1735: , printer_status = nvl(p_printer_status, printer_status)
1736: , status_type = nvl(p_status_type, status_type)

Line 3446: l_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;

3442: l_job_status VARCHAR2(2000); -- Bug 3328061 increased the size
3443: l_printer_status VARCHAR2(2000); -- Bug 3328061 increased the size
3444: l_status_type NUMBER;
3445:
3446: l_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;
3447: CURSOR c_hist IS
3448: SELECT * FROM wms_label_requests_hist
3449: WHERE label_request_id = p_hist_label_request_id;
3450:

Line 3448: SELECT * FROM wms_label_requests_hist

3444: l_status_type NUMBER;
3445:
3446: l_history_rec WMS_LABEL_REQUESTS_HIST%ROWTYPE;
3447: CURSOR c_hist IS
3448: SELECT * FROM wms_label_requests_hist
3449: WHERE label_request_id = p_hist_label_request_id;
3450:
3451: l_label_content LONG;
3452: l_printer_name VARCHAR2(50);

Line 3714: from wms_label_requests_hist wlrh,

3710: msik.concatenated_segments item,
3711: mfglkup1.meaning bus_flow,
3712: mfglkup2.meaning label_type,
3713: wlrh.label_request_id label_request_id
3714: from wms_label_requests_hist wlrh,
3715: wms_label_formats wlf,
3716: wms_license_plate_numbers wlpn,
3717: mtl_system_items_kfv msik,
3718: mfg_lookups mfglkup1,