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_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.clm_document_number%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.clm_document_number%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 192: FROM PO_DOCUMENT_TYPES

188:
189: BEGIN
190: SELECT type_name
191: INTO l_doc_display_name
192: FROM PO_DOCUMENT_TYPES
193: WHERE document_type_code = l_document_type
194: AND document_subtype = l_document_subtype;
195: EXCEPTION
196: WHEN NO_DATA_FOUND THEN

Line 386: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;

382: l_orgid PO_HEADERS_ALL.org_id%TYPE;
383: l_doc_string VARCHAR2(200);
384: l_preparer_user_name WF_USERS.name%TYPE;
385: l_progress VARCHAR2(300);
386: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;
387: l_binding_exception EXCEPTION;
388: /* Added for the bug 6358219 to fetch the legal_entity name */
389: l_legal_entity_id NUMBER;
390: x_legalentity_info xle_utilities_grp.LegalEntity_Rec;

Line 921: l_document_type_code PO_DOCUMENT_TYPES.document_type_code%TYPE;

917: funcmode IN VARCHAR2,
918: resultout OUT NOCOPY VARCHAR2) IS
919:
920: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
921: l_document_type_code PO_DOCUMENT_TYPES.document_type_code%TYPE;
922: l_document_sub_type_code PO_DOCUMENT_TYPES.document_subtype%TYPE;
923: l_erecord_id PO_ACCEPTANCES.erecord_id%TYPE;
924: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
925: l_employee_id PO_ACCEPTANCES.employee_id%TYPE;

Line 922: l_document_sub_type_code PO_DOCUMENT_TYPES.document_subtype%TYPE;

918: resultout OUT NOCOPY VARCHAR2) IS
919:
920: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
921: l_document_type_code PO_DOCUMENT_TYPES.document_type_code%TYPE;
922: l_document_sub_type_code PO_DOCUMENT_TYPES.document_subtype%TYPE;
923: l_erecord_id PO_ACCEPTANCES.erecord_id%TYPE;
924: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
925: l_employee_id PO_ACCEPTANCES.employee_id%TYPE;
926: l_user_id NUMBER;

Line 2386: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;

2382: resultout OUT NOCOPY VARCHAR2) IS
2383:
2384: l_req_signature VARCHAR2(1);
2385: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';
2386: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2387: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2388: l_progress VARCHAR2(300);
2389: l_doc_string VARCHAR2(200);
2390: l_preparer_user_name WF_USERS.name%TYPE;

Line 2470: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;

2466: l_api_name VARCHAR2(30) := 'is_signature_required';
2467: l_log_head VARCHAR2(100) := g_pkg_name || '.' || l_api_name;
2468: l_progress VARCHAR2(3);
2469:
2470: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2471: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2472: l_signature_required BOOLEAN;
2473: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';
2474: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE; --CLM Apprvl

Line 4266: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;

4262: actid IN NUMBER,
4263: funcmode IN VARCHAR2,
4264: resultout OUT NOCOPY VARCHAR2) IS
4265:
4266: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
4267: l_document_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;
4268: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
4269: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;
4270: l_progress VARCHAR2(300);

Line 4267: l_document_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;

4263: funcmode IN VARCHAR2,
4264: resultout OUT NOCOPY VARCHAR2) IS
4265:
4266: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
4267: l_document_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;
4268: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
4269: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;
4270: l_progress VARCHAR2(300);
4271: l_doc_string VARCHAR2(200);

Line 4400: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;

4396: l_api_name VARCHAR2(30) := 'get_acceptance_mode';
4397: l_log_head VARCHAR2(100) := g_pkg_name || '.' || l_api_name;
4398: l_progress VARCHAR2(3);
4399:
4400: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
4401: l_document_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;
4402: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
4403: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;
4404: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';

Line 4401: l_document_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;

4397: l_log_head VARCHAR2(100) := g_pkg_name || '.' || l_api_name;
4398: l_progress VARCHAR2(3);
4399:
4400: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
4401: l_document_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;
4402: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
4403: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;
4404: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';
4405: l_acceptance_mode VARCHAR2(30);