eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LABEL dependencies on DUAL

Line 283: -- The format can also be derived in the individual label API's(INVLAP*B.pls) via

279:
280: -- Deleted the IF condition around the call to the
281: -- WSH_REPORT_PRINTERS_PVT.GET_PRINTER() as part of cleanup since irrespective of
282: -- the fact that a default format is defined or not the printer has to be derived.
283: -- The format can also be derived in the individual label API's(INVLAP*B.pls) via
284: -- the rules engine anyways. Moreover the default printer is defined based on the
285: -- document (label type in this case and not on the format)
286:
287: --Get default printer

Line 436: -- The format can also be derived in the individual label API's(INVLAP*B.pls) via

432:
433: -- Deleted the IF condition around the call to the
434: -- WSH_REPORT_PRINTERS_PVT.GET_PRINTER() as part of cleanup since irrespective of
435: -- the fact that a default format is defined or not the printer has to be derived.
436: -- The format can also be derived in the individual label API's(INVLAP*B.pls) via
437: -- the rules engine anyways. Moreover the default printer is defined based on the
438: -- document (label type in this case and not on the format)
439:
440: -- Get default printer

Line 888: INTO l_date, l_time FROM dual;

884: '...sysdate:' || to_char(l_sysdate, 'DD/MM/YYYY HH:MI:SS') || '...new sysdate:' || to_char(l_sysdate+(l_tz_offset_hrs-l_db_offset)/24, 'DD/MM/YYYY HH:MI:SS'), TRACE_PROMPT, TRACE_LEVEL);
885: END IF;
886:
887: SELECT to_char(l_sysdate+(l_tz_offset_hrs-l_db_offset)/24, G_DATE_FORMAT_MASK), to_char(l_sysdate+(l_tz_offset_hrs-l_db_offset)/24, 'HH24:MI:SS')
888: INTO l_date, l_time FROM dual;
889: -- Bug 14253300 ends
890: ELSE
891: SELECT to_char(l_sysdate, G_DATE_FORMAT_MASK), to_char(l_sysdate, 'HH24:MI:SS')
892: INTO l_date, l_time FROM dual;

Line 892: INTO l_date, l_time FROM dual;

888: INTO l_date, l_time FROM dual;
889: -- Bug 14253300 ends
890: ELSE
891: SELECT to_char(l_sysdate, G_DATE_FORMAT_MASK), to_char(l_sysdate, 'HH24:MI:SS')
892: INTO l_date, l_time FROM dual;
893: END IF;
894:
895: -- Set the global variables
896: G_DATE := l_date;

Line 1251: * format. This get called from the individual label

1247:
1248:
1249: /*****************************************************
1250: * API to get the label fields defined for a specific
1251: * format. This get called from the individual label
1252: * API's often.
1253: *****************************************************/
1254: PROCEDURE GET_VARIABLES_FOR_FORMAT(
1255: x_variables OUT NOCOPY label_field_variable_tbl_type

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

1907: trace(' **Supplier ID : ' || P_SUPPLIER_ID, TRACE_PROMPT, TRACE_LEVEL);
1908: trace(' **Supplier Site ID : ' || P_SUPPLIER_SITE_ID, TRACE_PROMPT, TRACE_LEVEL);
1909: END IF;
1910:
1911: SELECT wms_label_print_history_s.nextval into l_label_request_id from dual;
1912: x_label_request_id := l_label_request_id;
1913:
1914: trace(' **Label Request ID : ' || l_label_request_id, TRACE_PROMPT, TRACE_LEVEL);
1915:

Line 2071: -- This change only needs to be done in the main package while the individual label API's remain

2067:
2068: -- Added this as part of the fix for Bug 2810264. The Rules Engine is called only for WMS enabled Orgs.
2069: -- Earlier, in case of MSCA Orgs, the GET_FORMAT_WITH_RULE would return a null label_format_id.
2070: -- In this fix, for MSCA Orgs, the default format ID and default foamrat name is derived and passed back.
2071: -- This change only needs to be done in the main package while the individual label API's remain
2072: -- untouched.
2073: -- Get default format
2074: get_default_format
2075: ( p_label_type_id => P_DOCUMENT_ID,

Line 2819: SELECT WMS_EPC_S2.nextval INTO EPC_GROUP_ID FROM DUAL;

2815:
2816: -- Added for R12 RFID Compliance project
2817: -- Set value for global variable EPC_GROUP_ID
2818: -- The value will be set to null at the end of label printing code
2819: SELECT WMS_EPC_S2.nextval INTO EPC_GROUP_ID FROM DUAL;
2820: IF (l_debug = 1) THEN
2821: trace(' Set EPC_GROUP_ID = '||EPC_GROUP_ID, TRACE_PROMPT, TRACE_LEVEL);
2822: END IF;
2823:

Line 3562: from dual;

3558: END IF;
3559: -- populate original request id and get new label_request_id;
3560: l_history_rec.original_request_id := p_hist_label_request_id;
3561: select wms_label_print_history_s.nextval into l_history_rec.label_request_id
3562: from dual;
3563: select sysdate into l_sysdate from dual;
3564: l_history_rec.request_date := l_sysdate;
3565: l_history_rec.creation_date := l_sysdate;
3566: l_history_rec.last_update_date := l_sysdate;

Line 3563: select sysdate into l_sysdate from dual;

3559: -- populate original request id and get new label_request_id;
3560: l_history_rec.original_request_id := p_hist_label_request_id;
3561: select wms_label_print_history_s.nextval into l_history_rec.label_request_id
3562: from dual;
3563: select sysdate into l_sysdate from dual;
3564: l_history_rec.request_date := l_sysdate;
3565: l_history_rec.creation_date := l_sysdate;
3566: l_history_rec.last_update_date := l_sysdate;
3567: