APPS.PO_SIGNATURE_PVT dependencies on PO_DOCUMENT_TYPES

Line 83: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;

79: funcmode IN VARCHAR2,
80: resultout OUT NOCOPY VARCHAR2) IS
81:
82: l_document_number PO_HEADERS_ALL.segment1%TYPE;
83: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
84: l_document_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
85: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
86: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;
87: l_revision PO_HEADERS_ALL.revision_num%TYPE;

Line 86: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;

82: l_document_number PO_HEADERS_ALL.segment1%TYPE;
83: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
84: l_document_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
85: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
86: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;
87: l_revision PO_HEADERS_ALL.revision_num%TYPE;
88: l_orgid PO_HEADERS_ALL.org_id%TYPE;
89: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;
90: l_username FND_USER.user_name%TYPE;

Line 168: FROM PO_DOCUMENT_TYPES

164:
165: BEGIN
166: SELECT type_name
167: INTO l_doc_display_name
168: FROM PO_DOCUMENT_TYPES
169: WHERE document_type_code = l_document_type
170: AND document_subtype = l_document_subtype;
171: EXCEPTION
172: WHEN NO_DATA_FOUND THEN

Line 313: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;

309: l_orgid PO_HEADERS_ALL.org_id%TYPE;
310: l_doc_string VARCHAR2(200);
311: l_preparer_user_name WF_USERS.name%TYPE;
312: l_progress VARCHAR2(300);
313: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;
314: l_binding_exception EXCEPTION;
315: /* Added for the bug 6358219 to fetch the legal_entity name */
316: l_legal_entity_id NUMBER;
317: x_legalentity_info xle_utilities_grp.LegalEntity_Rec;

Line 793: l_document_type_code PO_DOCUMENT_TYPES.document_type_code%TYPE;

789: funcmode IN VARCHAR2,
790: resultout OUT NOCOPY VARCHAR2) IS
791:
792: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
793: l_document_type_code PO_DOCUMENT_TYPES.document_type_code%TYPE;
794: l_document_sub_type_code PO_DOCUMENT_TYPES.document_subtype%TYPE;
795: l_erecord_id PO_ACCEPTANCES.erecord_id%TYPE;
796: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
797: l_employee_id PO_ACCEPTANCES.employee_id%TYPE;

Line 794: l_document_sub_type_code PO_DOCUMENT_TYPES.document_subtype%TYPE;

790: resultout OUT NOCOPY VARCHAR2) IS
791:
792: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
793: l_document_type_code PO_DOCUMENT_TYPES.document_type_code%TYPE;
794: l_document_sub_type_code PO_DOCUMENT_TYPES.document_subtype%TYPE;
795: l_erecord_id PO_ACCEPTANCES.erecord_id%TYPE;
796: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
797: l_employee_id PO_ACCEPTANCES.employee_id%TYPE;
798: l_user_id NUMBER;

Line 2028: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;

2024: resultout OUT NOCOPY VARCHAR2) IS
2025:
2026: l_req_signature VARCHAR2(1);
2027: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';
2028: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2029: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2030: l_progress VARCHAR2(300);
2031: l_doc_string VARCHAR2(200);
2032: l_preparer_user_name WF_USERS.name%TYPE;

Line 2112: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;

2108: l_api_name VARCHAR2(30) := 'is_signature_required';
2109: l_log_head VARCHAR2(100) := g_pkg_name || '.' || l_api_name;
2110: l_progress VARCHAR2(3);
2111:
2112: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2113: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2114: l_signature_required BOOLEAN;
2115: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';
2116: