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_NEGOTIATION_PUBLISH_PVT dependencies on PON_AUC_DOCTYPE_RULES

Line 7: TYPE DOCUMENT_TYPE_REQUIRED_RULE IS TABLE OF PON_AUC_DOCTYPE_RULES.REQUIRED_FLAG%TYPE INDEX BY PON_AUC_BIZRULES.NAME%TYPE;

3:
4: g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.PON_NEGOTIATION_PUBLISH_PVT.';
5:
6: TYPE DOCUMENT_TYPE_NAME IS TABLE OF PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE INDEX BY BINARY_INTEGER;
7: TYPE DOCUMENT_TYPE_REQUIRED_RULE IS TABLE OF PON_AUC_DOCTYPE_RULES.REQUIRED_FLAG%TYPE INDEX BY PON_AUC_BIZRULES.NAME%TYPE;
8: TYPE DOCUMENT_TYPE_VALIDITY_RULE IS TABLE OF PON_AUC_DOCTYPE_RULES.VALIDITY_FLAG%TYPE INDEX BY PON_AUC_BIZRULES.NAME%TYPE;
9:
10: g_document_type_required_rule DOCUMENT_TYPE_REQUIRED_RULE;
11: g_document_type_validity_rule DOCUMENT_TYPE_VALIDITY_RULE;

Line 8: TYPE DOCUMENT_TYPE_VALIDITY_RULE IS TABLE OF PON_AUC_DOCTYPE_RULES.VALIDITY_FLAG%TYPE INDEX BY PON_AUC_BIZRULES.NAME%TYPE;

4: g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.PON_NEGOTIATION_PUBLISH_PVT.';
5:
6: TYPE DOCUMENT_TYPE_NAME IS TABLE OF PON_AUC_DOCTYPES.DOCTYPE_GROUP_NAME%TYPE INDEX BY BINARY_INTEGER;
7: TYPE DOCUMENT_TYPE_REQUIRED_RULE IS TABLE OF PON_AUC_DOCTYPE_RULES.REQUIRED_FLAG%TYPE INDEX BY PON_AUC_BIZRULES.NAME%TYPE;
8: TYPE DOCUMENT_TYPE_VALIDITY_RULE IS TABLE OF PON_AUC_DOCTYPE_RULES.VALIDITY_FLAG%TYPE INDEX BY PON_AUC_BIZRULES.NAME%TYPE;
9:
10: g_document_type_required_rule DOCUMENT_TYPE_REQUIRED_RULE;
11: g_document_type_validity_rule DOCUMENT_TYPE_VALIDITY_RULE;
12: g_document_type_names DOCUMENT_TYPE_NAME;

Line 420: Nvl(pon_auc_doctype_rules.DEFAULT_VALUE,'N') INTO g_is_fed

416:
417: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = p_auction_header_id;
418:
419: SELECT
420: Nvl(pon_auc_doctype_rules.DEFAULT_VALUE,'N') INTO g_is_fed
421: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
422: , PON_AUC_BIZRULES pon_auc_bizrules
423: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
424: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id

Line 421: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules

417: SELECT doctype_id INTO l_doctype_id FROM pon_auction_headers_all WHERE auction_Header_id = p_auction_header_id;
418:
419: SELECT
420: Nvl(pon_auc_doctype_rules.DEFAULT_VALUE,'N') INTO g_is_fed
421: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
422: , PON_AUC_BIZRULES pon_auc_bizrules
423: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
424: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
425: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';

Line 423: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID

419: SELECT
420: Nvl(pon_auc_doctype_rules.DEFAULT_VALUE,'N') INTO g_is_fed
421: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
422: , PON_AUC_BIZRULES pon_auc_bizrules
423: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
424: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
425: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
426: EXCEPTION
427: WHEN No_Data_Found THEN

Line 424: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id

420: Nvl(pon_auc_doctype_rules.DEFAULT_VALUE,'N') INTO g_is_fed
421: FROM PON_AUC_DOCTYPE_RULES pon_auc_doctype_rules
422: , PON_AUC_BIZRULES pon_auc_bizrules
423: WHERE pon_auc_doctype_rules.BIZRULE_ID = pon_auc_bizrules.BIZRULE_ID
424: AND pon_auc_doctype_rules.DOCTYPE_ID = l_doctype_id
425: AND pon_auc_bizrules.NAME = 'FEDERAL_NEGOTIATION';
426: EXCEPTION
427: WHEN No_Data_Found THEN
428: g_is_fed := 'N';

Line 7112: PON_AUC_DOCTYPE_RULES DOCTYPE_RULE

7108: l_doctype_rule_required,
7109: l_doctype_rule_validity
7110: FROM
7111: PON_AUC_BIZRULES BIZRULE,
7112: PON_AUC_DOCTYPE_RULES DOCTYPE_RULE
7113: WHERE
7114: BIZRULE.BIZRULE_ID = DOCTYPE_RULE.BIZRULE_ID AND
7115: DOCTYPE_RULE.DOCTYPE_ID = p_doctype_id;
7116: