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_AUC_INTERFACE_TABLE_PKG dependencies on PON_AUC_ATTRIBUTES_INTERFACE

Line 487: l_auction_header_id pon_auc_attributes_interface.auction_header_id%TYPE;

483: p_source VARCHAR2,
484: p_batch_id NUMBER,
485: p_party_id NUMBER
486: ) AS
487: l_auction_header_id pon_auc_attributes_interface.auction_header_id%TYPE;
488: l_message_suffix VARCHAR2(2);
489: l_hdr_attr_enable_weights VARCHAR2(1);
490: BEGIN
491: -- init vars

Line 495: from pon_auc_attributes_interface pai

491: -- init vars
492: BEGIN
493: select max(pai.auction_header_id)
494: into l_auction_header_id
495: from pon_auc_attributes_interface pai
496: where pai.batch_id = p_batch_id;
497:
498: select hdr_attr_enable_weights
499: into l_hdr_attr_enable_weights

Line 543: 'PON_AUC_ATTRIBUTES_INTERFACE',

539: values
540: (
541: selected_batch_id,
542: selected_interface_line_id,
543: 'PON_AUC_ATTRIBUTES_INTERFACE',
544: fnd_message.get_string('PON','PON_AUCTS_ATTR_WEIGHT'),
545: 'PON_AUC_WEIGHT_RANGE',
546: selected_weight
547: )

Line 570: 'PON_AUC_ATTRIBUTES_INTERFACE',

566: values
567: (
568: selected_batch_id,
569: selected_interface_line_id,
570: 'PON_AUC_ATTRIBUTES_INTERFACE',
571: fnd_message.get_string('PON','PON_AUC_SCORE'),
572: 'PON_AUCTS_DISP_ATTR_NO_SCORES',
573: selected_ATTR_MAX_SCORE
574: )

Line 596: 'PON_AUC_ATTRIBUTES_INTERFACE',

592: values
593: (
594: selected_batch_id,
595: selected_interface_line_id,
596: 'PON_AUC_ATTRIBUTES_INTERFACE',
597: fnd_message.get_string('PON','PON_AUC_SCORE'),
598: 'PON_AUC_INVALID_MAXSCORE_RANGE',
599: selected_ATTR_MAX_SCORE
600: )

Line 611: pon_auc_attributes_interface pai

607: pai.attr_max_score selected_attr_max_score,
608: pai.display_only_flag selected_display_only_flag
609:
610: from
611: pon_auc_attributes_interface pai
612:
613: where
614: pai.batch_id = p_batch_id;
615:

Line 636: l_auction_header_id pon_auc_attributes_interface.auction_header_id%TYPE;

632: p_batch_id NUMBER,
633: p_party_id NUMBER,
634: p_attr_type_header BOOLEAN
635: ) AS
636: l_auction_header_id pon_auc_attributes_interface.auction_header_id%TYPE;
637: l_message_suffix VARCHAR2(2);
638: l_group_pref_name VARCHAR2(40);
639: l_group_lookup_type VARCHAR2(40);
640: l_attr_type_header VARCHAR2(1);

Line 656: from pon_auc_attributes_interface pai

652:
653: BEGIN
654: select max(pai.auction_header_id)
655: into l_auction_header_id
656: from pon_auc_attributes_interface pai
657: where pai.batch_id = p_batch_id;
658:
659: select pon_auction_pkg.get_message_suffix(doc.internal_name)
660: into l_message_suffix

Line 687: update pon_auc_attributes_interface pai

683: -- bug 3373002
684: -- need to compare apple with apple, response type values are from fnd messages
685: -- so also validate against messages, not lookups.
686: IF ( p_attr_type_header ) THEN
687: update pon_auc_attributes_interface pai
688: set response_type = decode(response_type_name,
689: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
690: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
691: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',

Line 697: update pon_auc_attributes_interface pai

693: null)
694: where pai.batch_id = p_batch_id
695: and pai.response_type_name is not null;
696: ELSE
697: update pon_auc_attributes_interface pai
698: set response_type = decode(response_type_name,
699: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
700: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
701: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',

Line 711: pon_auc_attributes_interface

707: -- MANDATORY_FLAG
708: -- DISPLAY_ONLY_FLAG
709: -- INTERNAL_ATTR_FLAG
710: update
711: pon_auc_attributes_interface
712: set
713: mandatory_flag = decode(response_type,'REQUIRED','Y','N'),
714: display_only_flag = decode(response_type,'DISPLAY_ONLY','Y','N'),
715: internal_attr_flag = decode(response_type,'INTERNAL','Y','N')

Line 722: update pon_auc_attributes_interface paai

718:
719:
720: -- Not to be Done for Header Section.
721: IF ( not p_attr_type_header ) THEN
722: update pon_auc_attributes_interface paai
723: set paai.GROUP_CODE = (select nvl(ppp.preference_value,'GENERAL')
724: from pon_party_preferences ppp
725: where ppp.app_short_name = 'PON'
726: and ppp.preference_name = l_group_pref_name

Line 734: update pon_auc_attributes_interface paai

730:
731:
732: -- populate GROUP_CODE. Note that the comparison is case sensitive.
733:
734: update pon_auc_attributes_interface paai
735: set paai.GROUP_CODE = (
736: select lookup_code
737: from fnd_lookup_values attrGrpFlv
738: where lookup_type = l_group_lookup_type

Line 753: update pon_auc_attributes_interface paai

749: and paai.GROUP_NAME is not null;
750:
751: ELSE
752: -- For Header Case, if the Group Name is null, default General.
753: update pon_auc_attributes_interface paai
754: set paai.GROUP_NAME = (
755: select meaning
756: from fnd_lookup_values attrGrpFlv
757: where attrGrpFlv.lookup_type = 'PON_HEADER_ATTRIBUTE_GROUPS'

Line 793: 'PON_AUC_ATTRIBUTES_INTERFACE',

789: VALUES
790: (
791: selected_batch_id,
792: selected_interface_line_id,
793: 'PON_AUC_ATTRIBUTES_INTERFACE',
794: fnd_message.get_string('PON','PON_AUCTS_ATTR_DATATYPE'),
795: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP',
796: 'PON_AUCTS_ATTR_INVALID_TYPE', 'PON_AUCTS_REQ_INVALID_TYPE'),
797: selected_datatype

Line 819: 'PON_AUC_ATTRIBUTES_INTERFACE',

815: VALUES
816: (
817: selected_batch_id,
818: selected_interface_line_id,
819: 'PON_AUC_ATTRIBUTES_INTERFACE',
820: decode(l_group_pref_name,'LINE_ATTR_DEFAULT_GROUP',pon_auction_pkg.getMessage('PON_AUCTS_BID_RESPONSE',l_message_suffix),pon_auction_pkg.getMessage('PON_AUCTS_TYPE')),
821: 'PON_CAT_INVALID_VALUE',
822: selected_response_type_name
823: )

Line 845: 'PON_AUC_ATTRIBUTES_INTERFACE',

841: values
842: (
843: selected_batch_id,
844: selected_interface_line_id,
845: 'PON_AUC_ATTRIBUTES_INTERFACE',
846: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
847: 'PON_AUCTS_INV_PR_QT_VAL',
848: selected_display_target_flag
849: )

Line 874: 'PON_AUC_ATTRIBUTES_INTERFACE',

870: values
871: (
872: selected_batch_id,
873: selected_interface_line_id,
874: 'PON_AUC_ATTRIBUTES_INTERFACE',
875: fnd_message.get_string('PON','PON_AUCTS_ATTR_DATATYPE'),
876: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP',
877: 'PON_AUCTS_ATTR_INVALID_TYPE', 'PON_AUCTS_REQ_INVALID_TYPE'),
878: selected_datatype

Line 899: 'PON_AUC_ATTRIBUTES_INTERFACE',

895: values
896: (
897: selected_batch_id,
898: selected_interface_line_id,
899: 'PON_AUC_ATTRIBUTES_INTERFACE',
900: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
901: 'PON_AUCTS_INV_PR_QT_VAL',
902: selected_display_target_flag
903: )

Line 923: 'PON_AUC_ATTRIBUTES_INTERFACE',

919: values
920: (
921: selected_batch_id,
922: selected_interface_line_id,
923: 'PON_AUC_ATTRIBUTES_INTERFACE',
924: fnd_message.get_string('PON','PON_AUCTS_TARGET_VALUE'),
925: 'PON_AUCTS_ATTR_SHOW_TARGET',
926: selected_value
927: )

Line 950: 'PON_AUC_ATTRIBUTES_INTERFACE',

946: values
947: (
948: selected_batch_id,
949: selected_interface_line_id,
950: 'PON_AUC_ATTRIBUTES_INTERFACE',
951: pon_auction_pkg.getMessage('PON_AUCTS_ATTR_TARGET',l_message_suffix),
952: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP',
953: 'PON_AUCTS_ATTR_DISPLAY_TARGET', 'PON_AUCTS_REQ_DISPLAY_TARGET'),
954: selected_value

Line 976: 'PON_AUC_ATTRIBUTES_INTERFACE',

972: values
973: (
974: selected_batch_id,
975: selected_interface_line_id,
976: 'PON_AUC_ATTRIBUTES_INTERFACE',
977: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP', fnd_message.get_string('PON','PON_AUCTS_ATTR'), fnd_message.get_string('PON', 'PON_AUC_REQUIREMENT')),
978: 'PON_FIELD_MUST_BE_ENTERED',
979: selected_attribute_name
980: )

Line 1004: 'PON_AUC_ATTRIBUTES_INTERFACE',

1000: values
1001: (
1002: selected_batch_id,
1003: selected_interface_line_id,
1004: 'PON_AUC_ATTRIBUTES_INTERFACE',
1005: 'SEQUENCE_NUMBER',
1006: 'PON_CAT_DISP_SEQ_M',
1007: selected_sequence_number
1008: )

Line 1029: 'PON_AUC_ATTRIBUTES_INTERFACE',

1025: values
1026: (
1027: selected_batch_id,
1028: selected_interface_line_id,
1029: 'PON_AUC_ATTRIBUTES_INTERFACE',
1030: fnd_message.get_string('PON','PON_AUCTS_GROUP'),
1031: 'PON_AUCTS_INVALID_GROUP',
1032: selected_group_name
1033: )

Line 1055: 'PON_AUC_ATTRIBUTES_INTERFACE',

1051: values
1052: (
1053: selected_batch_id,
1054: selected_interface_line_id,
1055: 'PON_AUC_ATTRIBUTES_INTERFACE',
1056: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
1057: 'PON_AUC_INTERNAL_ATT_ERROR',
1058: fnd_message.get_string('PON','PON_CORE_NO')
1059: )

Line 1077: pon_auc_attributes_interface pai

1073: pai.group_code selected_group_code,
1074: pai.internal_attr_flag selected_internal_attr_flag
1075:
1076: from
1077: pon_auc_attributes_interface pai
1078: where
1079: pai.batch_id = p_batch_id;
1080:
1081: -- perform duplicate checks

Line 1094: 'PON_AUC_ATTRIBUTES_INTERFACE',

1090: )
1091: select
1092: pai1.batch_id,
1093: pai1.interface_line_id,
1094: 'PON_AUC_ATTRIBUTES_INTERFACE',
1095: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
1096: 'PON_REQUIREMENT_DUPLICATE_ATT',
1097: pai1.attribute_name
1098: from pon_auc_attributes_interface pai1,

Line 1098: from pon_auc_attributes_interface pai1,

1094: 'PON_AUC_ATTRIBUTES_INTERFACE',
1095: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
1096: 'PON_REQUIREMENT_DUPLICATE_ATT',
1097: pai1.attribute_name
1098: from pon_auc_attributes_interface pai1,
1099: pon_auc_attributes_interface pai2
1100: where pai1.batch_id = p_batch_id
1101: and pai1.batch_id = pai2.batch_id
1102: and pai1.auction_line_number = pai2.auction_line_number

Line 1099: pon_auc_attributes_interface pai2

1095: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
1096: 'PON_REQUIREMENT_DUPLICATE_ATT',
1097: pai1.attribute_name
1098: from pon_auc_attributes_interface pai1,
1099: pon_auc_attributes_interface pai2
1100: where pai1.batch_id = p_batch_id
1101: and pai1.batch_id = pai2.batch_id
1102: and pai1.auction_line_number = pai2.auction_line_number
1103: and upper(pai1.attribute_name) = upper(pai2.attribute_name)

Line 1117: 'PON_AUC_ATTRIBUTES_INTERFACE',

1113: )
1114: select
1115: pai1.batch_id,
1116: pai1.interface_line_id,
1117: 'PON_AUC_ATTRIBUTES_INTERFACE',
1118: fnd_message.get_string('PON','PON_AUCTS_ATTR'),
1119: 'PON_DUPLICATE_WARNING_ATTR',
1120: pai1.attribute_name
1121: from pon_auc_attributes_interface pai1,

Line 1121: from pon_auc_attributes_interface pai1,

1117: 'PON_AUC_ATTRIBUTES_INTERFACE',
1118: fnd_message.get_string('PON','PON_AUCTS_ATTR'),
1119: 'PON_DUPLICATE_WARNING_ATTR',
1120: pai1.attribute_name
1121: from pon_auc_attributes_interface pai1,
1122: pon_auc_attributes_interface pai2
1123: where pai1.batch_id = p_batch_id
1124: and pai1.batch_id = pai2.batch_id
1125: and pai1.interface_line_id = pai2.interface_line_id

Line 1122: pon_auc_attributes_interface pai2

1118: fnd_message.get_string('PON','PON_AUCTS_ATTR'),
1119: 'PON_DUPLICATE_WARNING_ATTR',
1120: pai1.attribute_name
1121: from pon_auc_attributes_interface pai1,
1122: pon_auc_attributes_interface pai2
1123: where pai1.batch_id = p_batch_id
1124: and pai1.batch_id = pai2.batch_id
1125: and pai1.interface_line_id = pai2.interface_line_id
1126: and upper(pai1.attribute_name) = upper(pai2.attribute_name)

Line 1143: 'PON_AUC_ATTRIBUTES_INTERFACE',

1139: )
1140: select
1141: pai1.batch_id,
1142: pai1.interface_line_id,
1143: 'PON_AUC_ATTRIBUTES_INTERFACE',
1144: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
1145: 'PON_REQUIREMENT_DUPLICATE_ATT',
1146: pai1.attribute_name
1147: from pon_auc_attributes_interface pai1,

Line 1147: from pon_auc_attributes_interface pai1,

1143: 'PON_AUC_ATTRIBUTES_INTERFACE',
1144: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
1145: 'PON_REQUIREMENT_DUPLICATE_ATT',
1146: pai1.attribute_name
1147: from pon_auc_attributes_interface pai1,
1148: pon_auction_attributes paa
1149: where pai1.batch_id = p_batch_id
1150: and paa.auction_header_id = pai1.auction_header_id
1151: and pai1.auction_line_number = -1

Line 1264: from pon_auc_attributes_interface

1260: -- select max sequence number (across all lines)
1261: BEGIN
1262: select nvl(max(sequence_number),0)
1263: into l_sequence_start
1264: from pon_auc_attributes_interface
1265: where batch_id = p_batch_id
1266: and sequence_number >= 0;
1267: l_sequence_start := l_sequence_start + 10;
1268: EXCEPTION

Line 1274: insert into pon_auc_attributes_interface (

1270: l_sequence_start := 0;
1271: END;
1272:
1273: -- insert template attributes for all lines
1274: insert into pon_auc_attributes_interface (
1275: BATCH_ID,
1276: INTERFACE_LINE_ID,
1277: AUCTION_LINE_NUMBER,
1278: AUCTION_HEADER_ID,

Line 1322: delete from pon_auc_attributes_interface pai1

1318: and ip.group_type <> 'GROUP'
1319: and att.auction_header_id = p_auction_template_id;
1320:
1321: -- resolve duplicate attributes by removing the Template attribute
1322: delete from pon_auc_attributes_interface pai1
1323: where rowid in (
1324: select pai1.rowid
1325: from pon_auc_attributes_interface pai2
1326: where pai1.batch_id = p_batch_id

Line 1325: from pon_auc_attributes_interface pai2

1321: -- resolve duplicate attributes by removing the Template attribute
1322: delete from pon_auc_attributes_interface pai1
1323: where rowid in (
1324: select pai1.rowid
1325: from pon_auc_attributes_interface pai2
1326: where pai1.batch_id = p_batch_id
1327: and pai1.batch_id = pai2.batch_id
1328: and pai1.interface_line_id = pai2.interface_line_id
1329: and pai1.attribute_name = pai2.attribute_name

Line 1563: INSERT INTO PON_AUC_ATTRIBUTES_INTERFACE (

1559: p_default_attr_group);
1560:
1561: -- bring over ip descriptors (base and catalog) for new lines
1562:
1563: INSERT INTO PON_AUC_ATTRIBUTES_INTERFACE (
1564: BATCH_ID,
1565: INTERFACE_LINE_ID,
1566: AUCTION_HEADER_ID,
1567: AUCTION_LINE_NUMBER,

Line 1612: from pon_auc_attributes_interface

1608: FROM icx_cat_agreement_attrs_v
1609: WHERE ((rt_category_id = 0 and p_ip_attr_default_option in ('ALL', 'BASE')) or
1610: (rt_category_id = line.ip_category_id and p_ip_attr_default_option in ('ALL', 'CATEGORY'))) and language = userenv('LANG') and
1611: upper(attribute_name) not in (select upper(attribute_name)
1612: from pon_auc_attributes_interface
1613: where batch_id = p_batch_id and
1614: interface_line_id = line.interface_line_id)
1615: ORDER BY nvl(sequence, l_max_ip_seq_num) asc);
1616:

Line 1653: from pon_auc_attributes_interface

1649: BEGIN
1650:
1651: delete from
1652: (select *
1653: from pon_auc_attributes_interface
1654: where auction_line_number in (select paip.line_number
1655: from pon_item_prices_interface p1,
1656: pon_auction_item_prices_all paip
1657: where p1.batch_id = p_batch_id and

Line 1693: INSERT INTO PON_AUC_ATTRIBUTES_INTERFACE (

1689: p_default_attr_group);
1690:
1691: -- bring over ip catalog descriptors for updated lines
1692:
1693: INSERT INTO PON_AUC_ATTRIBUTES_INTERFACE (
1694: BATCH_ID,
1695: INTERFACE_LINE_ID,
1696: AUCTION_HEADER_ID,
1697: AUCTION_LINE_NUMBER,

Line 1742: from pon_auc_attributes_interface

1738: FROM icx_cat_agreement_attrs_v
1739: WHERE rt_category_id = line.ip_category_id and
1740: language = userenv('LANG') and
1741: upper(attribute_name) not in (select upper(attribute_name)
1742: from pon_auc_attributes_interface
1743: where batch_id = p_batch_id and
1744: interface_line_id = line.interface_line_id)
1745: ORDER BY nvl(sequence, l_max_ip_seq_num) asc);
1746:

Line 1762: from pon_auc_attributes_interface

1758: BEGIN
1759:
1760: select nvl(max(sequence_number), 0)
1761: into l_max_attr_seq_num
1762: from pon_auc_attributes_interface
1763: where batch_id = p_batch_id and
1764: interface_line_id = p_interface_line_id;
1765:
1766: RETURN l_max_attr_seq_num;

Line 1781: from pon_auc_attributes_interface

1777: BEGIN
1778:
1779: select attr_group_seq_number
1780: into l_attr_group_seq_num
1781: from pon_auc_attributes_interface
1782: where batch_id = p_batch_id and
1783: interface_line_id = p_interface_line_id and
1784: group_code = p_attr_group and
1785: rownum = 1;

Line 1798: from pon_auc_attributes_interface

1794: -- find max group seq number and add 10
1795:
1796: select nvl(max(attr_group_seq_number), 0) + 10
1797: into l_attr_group_seq_num
1798: from pon_auc_attributes_interface
1799: where batch_id = p_batch_id and
1800: interface_line_id = p_interface_line_id;
1801:
1802: RETURN l_attr_group_seq_num;

Line 1817: from pon_auc_attributes_interface

1813: BEGIN
1814:
1815: select nvl(max(attr_disp_seq_number), 0)
1816: into l_attr_max_disp_seq_num
1817: from pon_auc_attributes_interface
1818: where batch_id = p_batch_id and
1819: interface_line_id = p_interface_line_id and
1820: group_code = p_attr_group;
1821: