APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_PRINT_FORM_FORMATS

Line 1201: l_print_doc_type PO_PRINT_FORM_FORMATS.document_type%TYPE;

1197: l_failure BOOLEAN;
1198: ext_attr_value_pairs_ind NUMBER;
1199: ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
1200: l_return_clm_err_message VARCHAR2(200);
1201: l_print_doc_type PO_PRINT_FORM_FORMATS.document_type%TYPE;
1202: msg_counter NUMBER;
1203: l_ret_clm_err_msg_txt VARCHAR2(2000);
1204: l_is_ord_off_idv varchar2(1) := 'N';
1205: l_is_clm_doc varchar2(1) := 'N';

Line 1573: FROM po_print_form_formats ppff

1569: FROM po_drafts phmv
1570: WHERE phmv.draft_id = p_draft_id
1571: AND NOT EXISTS (
1572: SELECT 1
1573: FROM po_print_form_formats ppff
1574: WHERE ppff.document_type = l_print_doc_type
1575: AND ppff.standard_form = phmv.clm_standard_form
1576: AND ppff.document_format = phmv.clm_document_format
1577: AND trunc(sysdate) <= trunc(nvl(ppff.inactive_date, sysdate +1))

Line 1616: FROM po_print_form_formats ppff

1612: FROM po_headers_all phmv
1613: WHERE phmv.po_header_id = l_document_id
1614: AND NOT EXISTS (
1615: SELECT 1
1616: FROM po_print_form_formats ppff
1617: WHERE ppff.document_type = l_print_doc_type
1618: AND ppff.standard_form = phmv.clm_standard_form
1619: AND ppff.document_format = phmv.clm_document_format
1620: AND trunc(sysdate) <= trunc(nvl(ppff.inactive_date, sysdate +1))