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.PO_DOCUMENT_CONTROL_PVT dependencies on PO_HEADERS_ALL

Line 230: l_approved_date PO_HEADERS_ALL.approved_date%TYPE;

226: l_rel_doc_num PO_RELEASES.release_num%TYPE;
227:
228: --< Bug 3554754 > Removed unnecessary CancelPO FPJ variables. Added variable for
229: -- approved_date.
230: l_approved_date PO_HEADERS_ALL.approved_date%TYPE;
231: l_authorization_status po_headers.authorization_status%TYPE; --Bug5142892
232:
233: --
234: l_printflag VARCHAR2(1) := 'N';

Line 247: l_xml_flag PO_HEADERS_all.xml_flag%TYPE; -- Bug 5407459

243: l_is_complex_work_po BOOLEAN;
244: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
245: --
246:
247: l_xml_flag PO_HEADERS_all.xml_flag%TYPE; -- Bug 5407459
248:
249: BEGIN
250: -- Start standard API initialization
251: SAVEPOINT control_document_PVT;

Line 429: FROM po_headers_all

425: WHERE po_release_id = p_doc_id;
426: ELSE
427: SELECT authorization_status
428: INTO l_authorization_status
429: FROM po_headers_all
430: WHERE po_header_id= p_doc_id;
431: END IF;
432: --Bug5142892 end
433:

Line 729: from po_headers_all

725: ELSE
726: --Get the segment1 for the given document
727: select segment1
728: into l_doc_num
729: from po_headers_all
730: where po_header_id = p_doc_id;
731:
732: IF(p_communication_method_option = 'EMAIL') then
733: l_emailflag := 'Y';

Line 754: -- xml_flag on PO_HEADERS_ALL/PO_RELEASES_ALL accordingly.

750: --
751:
752: -- Bug 5407459 START
753: -- Pass p_xml_flag to start_wf_process so it can update the
754: -- xml_flag on PO_HEADERS_ALL/PO_RELEASES_ALL accordingly.
755: IF (l_default_method = 'XML') THEN
756: l_xml_flag := 'Y';
757: ELSE
758: l_xml_flag := 'N';

Line 1756: po_headers_all poh

1752: SELECT polc.displayed_field,
1753: polc.lookup_code
1754: FROM po_lookup_codes polc,
1755: po_line_locations_all poll,
1756: po_headers_all poh
1757: WHERE poll.line_location_id = p_doc_line_loc_id
1758: AND poll.po_header_id = poh.po_header_id
1759: AND polc.lookup_type = 'CONTROL ACTIONS'
1760: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 4186: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;

4182: ,x_online_report_id OUT NOCOPY NUMBER--bug#5055417
4183: )
4184: IS
4185: l_doc_subtype PO_LINE_LOCATIONS_ALL.shipment_type%type;
4186: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
4187: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;
4188: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;
4189: l_document_version PO_HEADERS_ALL.revision_num%TYPE;
4190: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;

Line 4187: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;

4183: )
4184: IS
4185: l_doc_subtype PO_LINE_LOCATIONS_ALL.shipment_type%type;
4186: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
4187: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;
4188: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;
4189: l_document_version PO_HEADERS_ALL.revision_num%TYPE;
4190: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
4191: l_print_flag VARCHAR2(1);

Line 4188: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;

4184: IS
4185: l_doc_subtype PO_LINE_LOCATIONS_ALL.shipment_type%type;
4186: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
4187: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;
4188: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;
4189: l_document_version PO_HEADERS_ALL.revision_num%TYPE;
4190: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
4191: l_print_flag VARCHAR2(1);
4192: l_event_code VARCHAR2(30);

Line 4189: l_document_version PO_HEADERS_ALL.revision_num%TYPE;

4185: l_doc_subtype PO_LINE_LOCATIONS_ALL.shipment_type%type;
4186: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
4187: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;
4188: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;
4189: l_document_version PO_HEADERS_ALL.revision_num%TYPE;
4190: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
4191: l_print_flag VARCHAR2(1);
4192: l_event_code VARCHAR2(30);
4193: SUBTYPE busdocdates_tbl_type IS

Line 4190: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;

4186: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
4187: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;
4188: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;
4189: l_document_version PO_HEADERS_ALL.revision_num%TYPE;
4190: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
4191: l_print_flag VARCHAR2(1);
4192: l_event_code VARCHAR2(30);
4193: SUBTYPE busdocdates_tbl_type IS
4194: okc_manage_deliverables_grp.busdocdates_tbl_type;

Line 4304: from po_headers_all

4300: select conterms_exist_flag, start_date,
4301: end_date, decode(cancel_flag,'I',null,cancel_flag)
4302: into l_conterms_exist_flag, l_document_start_date,
4303: l_document_end_date, l_cancel_flag
4304: from po_headers_all
4305: where po_header_id = p_doc_header_id;
4306: d_pos := 70;
4307:
4308: IF (PO_LOG.d_stmt) THEN

Line 5133: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%type;

5129: ,x_valid_ctrl_ctn_tbl OUT NOCOPY PO_TBL_VARCHAR30)
5130: IS
5131: l_valid_actions_tbl g_lookup_code_tbl_type;
5132: l_displayed_field_tbl g_displayed_field_tbl_type;
5133: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%type;
5134: l_cons_trans_exist VARCHAR2(1);
5135: l_index NUMBER;
5136: l_agent_id NUMBER;
5137: l_item_id PO_LINES_ALL.item_Id%TYPE;

Line 5167: FROM po_headers_all

5163: --Get Document Sub type
5164: IF(p_doc_type IN (PO_CORE_S.g_doc_type_PO, PO_CORE_S.g_doc_type_PA)) THEN
5165: SELECT type_lookup_code
5166: INTO l_doc_subtype
5167: FROM po_headers_all
5168: WHERE po_header_id = p_doc_header_id;
5169: END IF;
5170: d_pos := 20;
5171: IF (PO_LOG.d_stmt) THEN