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.PON_OPEN_INTERFACE_PVT dependencies on PO_DOC_STYLE_HEADERS

Line 5019: FROM po_doc_style_headers pdh, po_all_doc_style_Lines pdl

5015: BEGIN
5016: --Bug 16801033
5017: IF(l_doctype_id<>rfi_doctype_id) THEN
5018: SELECT pdl.DOCUMENT_SUBTYPE, pdh.style_id INTO l_contract_type, l_po_style_id
5019: FROM po_doc_style_headers pdh, po_all_doc_style_Lines pdl
5020: WHERE pdh.style_id = pdl.style_id
5021: AND pdh.status= 'ACTIVE'
5022: AND pdl.enabled_flag= 'Y'
5023: and Nvl(pdh.clm_flag,'N') = PON_CLM_UTIL_PKG.ISCLMRESP

Line 5155: OR NOT EXISTS(SELECT 'Y' FROM po_doc_style_headers WHERE STYLE_ID = l_po_style_id

5151: l_cp_login_id
5152: )
5153: --Bug 16801033
5154: WHEN ((l_doctype_id<>rfi_doctype_id AND (l_po_style_id IS NULL
5155: OR NOT EXISTS(SELECT 'Y' FROM po_doc_style_headers WHERE STYLE_ID = l_po_style_id
5156: and Nvl(clm_flag,'N') = PON_CLM_UTIL_PKG.ISCLMRESP)))
5157: OR (l_doctype_id=rfi_doctype_id AND (l_po_style_id IS not NULL OR l_po_style_name IS NOT null))
5158: )
5159: THEN INTO PON_INTERFACE_ERRORS

Line 6290: l_advances_flag po_doc_style_headers.advances_flag%TYPE;

6286: l_org_default_data org_default_data;
6287: l_document_type pon_auc_doctypes.internal_name%TYPE;
6288:
6289: -- po doc style related fields
6290: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
6291: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
6292: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
6293: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
6294: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;

Line 6291: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;

6287: l_document_type pon_auc_doctypes.internal_name%TYPE;
6288:
6289: -- po doc style related fields
6290: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
6291: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
6292: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
6293: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
6294: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;
6295: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;

Line 6292: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;

6288:
6289: -- po doc style related fields
6290: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
6291: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
6292: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
6293: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
6294: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;
6295: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;
6296: l_template_return_status VARCHAR2(1);

Line 6293: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;

6289: -- po doc style related fields
6290: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
6291: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
6292: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
6293: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
6294: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;
6295: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;
6296: l_template_return_status VARCHAR2(1);
6297: l_template_err_msg VARCHAR2(200);

Line 6294: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;

6290: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
6291: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
6292: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
6293: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
6294: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;
6295: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;
6296: l_template_return_status VARCHAR2(1);
6297: l_template_err_msg VARCHAR2(200);
6298: dummy1 VARCHAR2(100);

Line 6295: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;

6291: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
6292: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
6293: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
6294: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;
6295: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;
6296: l_template_return_status VARCHAR2(1);
6297: l_template_err_msg VARCHAR2(200);
6298: dummy1 VARCHAR2(100);
6299: dummy2 VARCHAR2(100);

Line 6653: l_advances_flag po_doc_style_headers.advances_flag%TYPE;

6649: l_org_default_data org_default_data;
6650: l_document_type pon_auc_doctypes.internal_name%TYPE;
6651: rfi_doctype_id pon_auction_Headers_all.doctype_id%TYPE;
6652: -- po doc style related fields
6653: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
6654: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
6655: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
6656: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
6657: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;

Line 6654: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;

6650: l_document_type pon_auc_doctypes.internal_name%TYPE;
6651: rfi_doctype_id pon_auction_Headers_all.doctype_id%TYPE;
6652: -- po doc style related fields
6653: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
6654: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
6655: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
6656: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
6657: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;
6658: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;

Line 6655: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;

6651: rfi_doctype_id pon_auction_Headers_all.doctype_id%TYPE;
6652: -- po doc style related fields
6653: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
6654: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
6655: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
6656: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
6657: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;
6658: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;
6659: dummy1 VARCHAR2(100);

Line 6656: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;

6652: -- po doc style related fields
6653: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
6654: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
6655: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
6656: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
6657: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;
6658: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;
6659: dummy1 VARCHAR2(100);
6660: dummy2 VARCHAR2(100);

Line 6657: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;

6653: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
6654: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
6655: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
6656: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
6657: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;
6658: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;
6659: dummy1 VARCHAR2(100);
6660: dummy2 VARCHAR2(100);
6661: dummy3 VARCHAR2(100);

Line 6658: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;

6654: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
6655: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
6656: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
6657: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;
6658: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;
6659: dummy1 VARCHAR2(100);
6660: dummy2 VARCHAR2(100);
6661: dummy3 VARCHAR2(100);
6662: dummy4 VARCHAR2(100);

Line 6685: FROM po_doc_style_headers pdh, po_all_doc_style_Lines pdl

6681: print_log('init_rule_based_header_data: Document not RFI ');
6682:
6683: SELECT pdl.DOCUMENT_SUBTYPE, pdh.style_id
6684: INTO neg_header_record_data.contract_type, neg_header_record_data.po_style_id
6685: FROM po_doc_style_headers pdh, po_all_doc_style_Lines pdl
6686: WHERE pdh.style_id = pdl.style_id
6687: AND pdh.status= 'ACTIVE'
6688: AND pdl.enabled_flag= 'Y'
6689: and Nvl(pdh.clm_flag,'N') = PON_CLM_UTIL_PKG.ISCLMRESP