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 STANDARD

Line 63: allowed_values_table_data := allowed_values_table('CONTRACT','BLANKET','STANDARD');

59:
60: BEGIN
61: column_test_table_data.extend(31);
62: yn_data := allowed_values_table('Y','N');
63: allowed_values_table_data := allowed_values_table('CONTRACT','BLANKET','STANDARD');
64: object_data := allowed_value_column_object('CONTRACT_TYPE',allowed_values_table_data);
65: column_test_table_data(1) := object_data;
66: allowed_values_table_data := allowed_values_table('PUBLIC','PRIVATE','HIERARCHY');
67: object_data := allowed_value_column_object('SECURITY_LEVEL_CODE',allowed_values_table_data); --SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'PON_SECURITY_LEVEL_CODE' AND LANGUAGE=UserEnv('LANG'))

Line 4589: standard_form,

4585: INTGR_CAT_LINE_ASL_FLAG,
4586: INTERNAL_ONLY_FLAG,
4587: UDA_TEMPLATE_ID,
4588: UDA_TEMPLATE_DATE,
4589: standard_form,
4590: document_format
4591: ,ALLOW_WITHDRAW_FLAG,ALLOW_UNSOL_OFFER_LINES,ALLOW_MULTIPLE_ACTIVE_OFFERS,
4592: --EFFECTIVE_DATE,
4593: FAIR_OPP_NOTICE_FLAG , FEDERAL_PUBLICATION_EXCEPTION

Line 4886: neg_header_record_data.standard_form,

4882: neg_header_record_data.INTGR_CAT_LINE_ASL_FLAG,
4883: 'N',
4884: neg_header_record_data.UDA_TEMPLATE_ID,
4885: neg_header_record_data.UDA_TEMPLATE_DATE,
4886: neg_header_record_data.standard_form,
4887: neg_header_record_data.document_format
4888: ,neg_header_record_data.ALLOW_WITHDRAW_FLAG,neg_header_record_data.ALLOW_UNSOL_OFFER_LINES,neg_header_record_data.ALLOW_MULTIPLE_ACTIVE_OFFERS
4889: --,neg_header_record_data.EFFECTIVE_DATE
4890: ,neg_header_record_data.FAIR_OPP_NOTICE_FLAG

Line 5739: and STANDARD_FORM = neg_header_record_data.STANDARD_FORM

5735: AND LANGUAGE = USERENV('LANG')
5736: AND ENABLED_FLAG = 'Y'
5737: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1) AND NVL(END_DATE_ACTIVE, SYSDATE + 1)
5738: AND lookup_code IN (SELECT DOCUMENT_FORMAT FROM PO_PRINT_FORM_FORMATS WHERE DOCUMENT_TYPE = 'PO_SOL_STD_FORM'
5739: and STANDARD_FORM = neg_header_record_data.STANDARD_FORM
5740: AND SYSDATE < Nvl(inactive_date,SYSDATE + 1))))
5741: THEN INTO PON_INTERFACE_ERRORS
5742: (
5743: INTERFACE_TYPE ,

Line 5863: /* STANDARD_FORM */

5859: l_cp_user_id,
5860: SYSDATE,
5861: l_cp_login_id)
5862:
5863: /* STANDARD_FORM */
5864: WHEN ( neg_header_record_data.STANDARD_FORM IS NULL AND isFederal = 1)
5865: THEN INTO PON_INTERFACE_ERRORS
5866: (
5867: INTERFACE_TYPE ,

Line 5864: WHEN ( neg_header_record_data.STANDARD_FORM IS NULL AND isFederal = 1)

5860: SYSDATE,
5861: l_cp_login_id)
5862:
5863: /* STANDARD_FORM */
5864: WHEN ( neg_header_record_data.STANDARD_FORM IS NULL AND isFederal = 1)
5865: THEN INTO PON_INTERFACE_ERRORS
5866: (
5867: INTERFACE_TYPE ,
5868: ERROR_MESSAGE_NAME,

Line 5881: 'PON_STANDARD_FORM_NULL',

5877: )
5878: VALUES
5879: (
5880: g_interface_type,
5881: 'PON_STANDARD_FORM_NULL',
5882: p_batch_id,
5883: 'AUCTION_TITLE',
5884: NULL,
5885: l_cp_user_id,

Line 5891: WHEN (isFederal = 1 AND neg_header_record_data.STANDARD_FORM NOT IN (SELECT LOOKUP_CODE

5887: l_cp_user_id,
5888: SYSDATE,
5889: l_cp_login_id)
5890:
5891: WHEN (isFederal = 1 AND neg_header_record_data.STANDARD_FORM NOT IN (SELECT LOOKUP_CODE
5892: FROM FND_LOOKUP_VALUES
5893: WHERE LOOKUP_TYPE = 'PO_SOL_STD_FORM'
5894: AND LANGUAGE = USERENV('LANG')
5895: AND ENABLED_FLAG = 'Y'

Line 5899: AND LOOKUP_CODE IN(SELECT STANDARD_FORM

5895: AND ENABLED_FLAG = 'Y'
5896: AND SYSDATE BETWEEN
5897: NVL(START_DATE_ACTIVE, SYSDATE - 1)
5898: AND NVL(END_DATE_ACTIVE, SYSDATE + 1)
5899: AND LOOKUP_CODE IN(SELECT STANDARD_FORM
5900: FROM PO_PRINT_FORM_FORMATS
5901: WHERE DOCUMENT_TYPE = 'PO_SOL_STD_FORM')
5902: ))
5903: THEN INTO PON_INTERFACE_ERRORS

Line 5919: 'PON_STANDARD_FORM_INVALID',

5915: )
5916: VALUES
5917: (
5918: g_interface_type,
5919: 'PON_STANDARD_FORM_INVALID',
5920: p_batch_id,
5921: 'AUCTION_TITLE',
5922: NULL,
5923: l_cp_user_id,

Line 5934: (neg_header_record_data.standard_form IS NULL OR neg_header_record_data.document_format IS NULL)) THEN

5930:
5931: IF(PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(neg_header_record_data.doctype_id)=1) THEN
5932:
5933: IF ( p_is_amendment <> 'Y' AND
5934: (neg_header_record_data.standard_form IS NULL OR neg_header_record_data.document_format IS NULL)) THEN
5935:
5936: INSERT INTO PON_INTERFACE_ERRORS
5937: (
5938: INTERFACE_TYPE ,

Line 5954: 'STANDARD_FORM',

5950: (
5951: g_interface_type,
5952: 'PON_FIELD_MUST_BE_ENTERED',
5953: p_batch_id,
5954: 'STANDARD_FORM',
5955: NULL,
5956: l_cp_user_id,
5957: SYSDATE,
5958: l_cp_user_id,

Line 5969: AND (doctype_name NOT in ('REQUEST_FOR_QUOTE','SOLICITATION') OR neg_header_record_data.contract_type <> 'STANDARD'))

5965:
5966:
5967: INSERT ALL
5968: WHEN(neg_header_record_data.progress_payment_flag = 'Y'
5969: AND (doctype_name NOT in ('REQUEST_FOR_QUOTE','SOLICITATION') OR neg_header_record_data.contract_type <> 'STANDARD'))
5970: THEN INTO PON_INTERFACE_ERRORS
5971: (
5972: INTERFACE_TYPE ,
5973: ERROR_MESSAGE_NAME,

Line 6443: standard_form,

6439: staggered_closing_interval,
6440: enforce_prevrnd_bid_price_flag,
6441: auto_extend_min_trigger_rank,
6442: two_part_flag,
6443: standard_form,
6444: document_format,
6445: amendment_description,
6446: creation_date,
6447: created_by,

Line 6580: neg_header_record_data.standard_form,

6576: neg_header_record_data.staggered_closing_interval,
6577: neg_header_record_data.enforce_prevrnd_bid_price_flag,
6578: neg_header_record_data.auto_extend_min_trigger_rank,
6579: neg_header_record_data.two_part_flag,
6580: neg_header_record_data.standard_form,
6581: neg_header_record_data.document_format,
6582: neg_header_record_data.amendment_description,
6583: neg_header_record_data.creation_date,
6584: neg_header_record_data.created_by,

Line 6904: IF ( neg_header_record_data.standard_form IS NULL AND p_is_amendment <> 'Y') THEN

6900: END;
6901:
6902:
6903: BEGIN
6904: IF ( neg_header_record_data.standard_form IS NULL AND p_is_amendment <> 'Y') THEN
6905: SELECT STANDARD_FORM,DOCUMENT_FORMAT
6906: INTO neg_header_record_data.standard_form,neg_header_record_data.document_format
6907: FROM PO_PRINT_FORM_FORMATS
6908: WHERE FORM_SOURCE='PON'

Line 6905: SELECT STANDARD_FORM,DOCUMENT_FORMAT

6901:
6902:
6903: BEGIN
6904: IF ( neg_header_record_data.standard_form IS NULL AND p_is_amendment <> 'Y') THEN
6905: SELECT STANDARD_FORM,DOCUMENT_FORMAT
6906: INTO neg_header_record_data.standard_form,neg_header_record_data.document_format
6907: FROM PO_PRINT_FORM_FORMATS
6908: WHERE FORM_SOURCE='PON'
6909: AND DEFAULT_FLAG='Y'

Line 6906: INTO neg_header_record_data.standard_form,neg_header_record_data.document_format

6902:
6903: BEGIN
6904: IF ( neg_header_record_data.standard_form IS NULL AND p_is_amendment <> 'Y') THEN
6905: SELECT STANDARD_FORM,DOCUMENT_FORMAT
6906: INTO neg_header_record_data.standard_form,neg_header_record_data.document_format
6907: FROM PO_PRINT_FORM_FORMATS
6908: WHERE FORM_SOURCE='PON'
6909: AND DEFAULT_FLAG='Y'
6910: AND DOCUMENT_TYPE='PO_SOL_STD_FORM'

Line 7560: standard_form= Nvl(neg_header_record_data.standard_form, paha.standard_form),

7556: FIRST_LINE_CLOSE_DATE = Nvl(neg_header_record_data.FIRST_LINE_CLOSE_DATE , paha.FIRST_LINE_CLOSE_DATE ),
7557: STAGGERED_CLOSING_INTERVAL = Nvl(neg_header_record_data.STAGGERED_CLOSING_INTERVAL , paha.STAGGERED_CLOSING_INTERVAL ),
7558: ENFORCE_PREVRND_BID_PRICE_FLAG= Nvl(neg_header_record_data.ENFORCE_PREVRND_BID_PRICE_FLAG, paha.ENFORCE_PREVRND_BID_PRICE_FLAG),
7559: AUTO_EXTEND_MIN_TRIGGER_RANK = Nvl(neg_header_record_data.AUTO_EXTEND_MIN_TRIGGER_RANK , paha.AUTO_EXTEND_MIN_TRIGGER_RANK ),
7560: standard_form= Nvl(neg_header_record_data.standard_form, paha.standard_form),
7561: document_format= Nvl(neg_header_record_data.document_format, paha.document_format)
7562: WHERE auction_header_id = p_auction_Header_id;
7563:
7564: END update_amendment_header;