DBA Data[Home] [Help]

APPS.PO_POAPPROVAL_INIT1 dependencies on PO_DOCUMENT_TYPES

Line 436: ** po document types.

432: and lookup_code = p_closed_code;
433:
434: /* Bug# 2616433: kagarwal
435: ** Desc: We will get the document type display value from
436: ** po document types.
437: */
438:
439: cursor c3(p_doc_type varchar2, p_doc_subtype varchar2) is
440: select type_name

Line 441: from po_document_types

437: */
438:
439: cursor c3(p_doc_type varchar2, p_doc_subtype varchar2) is
440: select type_name
441: from po_document_types
442: where document_type_code = p_doc_type
443: and document_subtype = p_doc_subtype;
444:
445: /*

Line 762: ** po document types.

758: */
759:
760: /* Bug# 2616433: kagarwal
761: ** Desc: We will get the document type display value from
762: ** po document types.
763: */
764:
765: cursor c3(p_doc_type varchar2, p_doc_subtype varchar2) is
766: select type_name

Line 767: from po_document_types

763: */
764:
765: cursor c3(p_doc_type varchar2, p_doc_subtype varchar2) is
766: select type_name
767: from po_document_types
768: where document_type_code = p_doc_type
769: and document_subtype = p_doc_subtype;
770:
771: /*

Line 1459: l_document_type PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE;

1455:
1456: l_tl_line_rec l_temp_labor_lines_csr%ROWTYPE;
1457:
1458: l_document_id PO_HEADERS.po_header_id%TYPE;
1459: l_document_type PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE;
1460: l_document_subtype PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE;
1461: l_is_new_document VARCHAR2(1);
1462: l_contractor_or_job VARCHAR2(500);
1463: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;

Line 1460: l_document_subtype PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE;

1456: l_tl_line_rec l_temp_labor_lines_csr%ROWTYPE;
1457:
1458: l_document_id PO_HEADERS.po_header_id%TYPE;
1459: l_document_type PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE;
1460: l_document_subtype PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE;
1461: l_is_new_document VARCHAR2(1);
1462: l_contractor_or_job VARCHAR2(500);
1463: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;
1464: l_approver_user_name WF_USERS.name%TYPE;