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_POAPPROVAL_INIT1 dependencies on PO_DOCUMENT_TYPES

Line 540: ** po document types.

536: and lookup_code = p_closed_code;
537:
538: /* Bug# 2616433: kagarwal
539: ** Desc: We will get the document type display value from
540: ** po document types.
541: */
542:
543: cursor c3(p_doc_type varchar2, p_doc_subtype varchar2) is
544: select type_name

Line 545: from po_document_types

541: */
542:
543: cursor c3(p_doc_type varchar2, p_doc_subtype varchar2) is
544: select type_name
545: from po_document_types
546: where document_type_code = p_doc_type
547: and document_subtype = p_doc_subtype;
548:
549:

Line 968: ** po document types.

964: */
965:
966: /* Bug# 2616433: kagarwal
967: ** Desc: We will get the document type display value from
968: ** po document types.
969: */
970:
971: cursor c3(p_doc_type varchar2, p_doc_subtype varchar2) is
972: select type_name

Line 973: from po_document_types

969: */
970:
971: cursor c3(p_doc_type varchar2, p_doc_subtype varchar2) is
972: select type_name
973: from po_document_types
974: where document_type_code = p_doc_type
975: and document_subtype = p_doc_subtype;
976:
977: /*

Line 1691: l_document_type PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE;

1687:
1688: l_tl_line_rec l_temp_labor_lines_csr%ROWTYPE;
1689:
1690: l_document_id PO_HEADERS.po_header_id%TYPE;
1691: l_document_type PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE;
1692: l_document_subtype PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE;
1693: l_is_new_document VARCHAR2(1);
1694: l_contractor_or_job VARCHAR2(500);
1695: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;

Line 1692: l_document_subtype PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE;

1688: l_tl_line_rec l_temp_labor_lines_csr%ROWTYPE;
1689:
1690: l_document_id PO_HEADERS.po_header_id%TYPE;
1691: l_document_type PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE;
1692: l_document_subtype PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE;
1693: l_is_new_document VARCHAR2(1);
1694: l_contractor_or_job VARCHAR2(500);
1695: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;
1696: l_approver_user_name WF_USERS.name%TYPE;