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 735: update pon_auc_attributes_interface paai

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

Line 755: update pon_auc_attributes_interface paai

751: AND paai.auction_line_number <> -1;
752:
753: ELSE
754: -- For Header Case, if the Group Name is null, default General.
755: update pon_auc_attributes_interface paai
756: set paai.GROUP_NAME = (
757: select meaning
758: from fnd_lookup_values attrGrpFlv
759: where attrGrpFlv.lookup_type = 'PON_HEADER_ATTRIBUTE_GROUPS'

Line 796: 'PON_AUC_ATTRIBUTES_INTERFACE',

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

Line 822: 'PON_AUC_ATTRIBUTES_INTERFACE',

818: VALUES
819: (
820: selected_batch_id,
821: selected_interface_line_id,
822: 'PON_AUC_ATTRIBUTES_INTERFACE',
823: 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')),
824: 'PON_CAT_INVALID_VALUE',
825: selected_response_type_name
826: )

Line 848: 'PON_AUC_ATTRIBUTES_INTERFACE',

844: values
845: (
846: selected_batch_id,
847: selected_interface_line_id,
848: 'PON_AUC_ATTRIBUTES_INTERFACE',
849: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
850: 'PON_AUCTS_INV_PR_QT_VAL',
851: selected_display_target_flag
852: )

Line 877: 'PON_AUC_ATTRIBUTES_INTERFACE',

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

Line 902: 'PON_AUC_ATTRIBUTES_INTERFACE',

898: values
899: (
900: selected_batch_id,
901: selected_interface_line_id,
902: 'PON_AUC_ATTRIBUTES_INTERFACE',
903: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
904: 'PON_AUCTS_INV_PR_QT_VAL',
905: selected_display_target_flag
906: )

Line 926: 'PON_AUC_ATTRIBUTES_INTERFACE',

922: values
923: (
924: selected_batch_id,
925: selected_interface_line_id,
926: 'PON_AUC_ATTRIBUTES_INTERFACE',
927: fnd_message.get_string('PON','PON_AUCTS_TARGET_VALUE'),
928: 'PON_AUCTS_ATTR_SHOW_TARGET',
929: selected_value
930: )

Line 953: 'PON_AUC_ATTRIBUTES_INTERFACE',

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

Line 979: 'PON_AUC_ATTRIBUTES_INTERFACE',

975: values
976: (
977: selected_batch_id,
978: selected_interface_line_id,
979: 'PON_AUC_ATTRIBUTES_INTERFACE',
980: 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')),
981: 'PON_FIELD_MUST_BE_ENTERED',
982: selected_attribute_name
983: )

Line 1007: 'PON_AUC_ATTRIBUTES_INTERFACE',

1003: values
1004: (
1005: selected_batch_id,
1006: selected_interface_line_id,
1007: 'PON_AUC_ATTRIBUTES_INTERFACE',
1008: 'SEQUENCE_NUMBER',
1009: 'PON_CAT_DISP_SEQ_M',
1010: selected_sequence_number
1011: )

Line 1033: 'PON_AUC_ATTRIBUTES_INTERFACE',

1029: values
1030: (
1031: selected_batch_id,
1032: selected_interface_line_id,
1033: 'PON_AUC_ATTRIBUTES_INTERFACE',
1034: fnd_message.get_string('PON','PON_AUCTS_GROUP'),
1035: 'PON_AUCTS_INVALID_GROUP',
1036: selected_group_name
1037: )

Line 1059: 'PON_AUC_ATTRIBUTES_INTERFACE',

1055: values
1056: (
1057: selected_batch_id,
1058: selected_interface_line_id,
1059: 'PON_AUC_ATTRIBUTES_INTERFACE',
1060: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
1061: 'PON_AUC_INTERNAL_ATT_ERROR',
1062: fnd_message.get_string('PON','PON_CORE_NO')
1063: )

Line 1082: pon_auc_attributes_interface pai

1078: pai.internal_attr_flag selected_internal_attr_flag,
1079: pai.auction_line_number selected_auction_line_num
1080:
1081: from
1082: pon_auc_attributes_interface pai
1083: where
1084: pai.batch_id = p_batch_id;
1085:
1086: -- perform duplicate checks

Line 1099: 'PON_AUC_ATTRIBUTES_INTERFACE',

1095: )
1096: select
1097: pai1.batch_id,
1098: pai1.interface_line_id,
1099: 'PON_AUC_ATTRIBUTES_INTERFACE',
1100: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
1101: 'PON_REQUIREMENT_DUPLICATE_ATT',
1102: pai1.attribute_name
1103: from pon_auc_attributes_interface pai1,

Line 1103: from pon_auc_attributes_interface pai1,

1099: 'PON_AUC_ATTRIBUTES_INTERFACE',
1100: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
1101: 'PON_REQUIREMENT_DUPLICATE_ATT',
1102: pai1.attribute_name
1103: from pon_auc_attributes_interface pai1,
1104: pon_auc_attributes_interface pai2
1105: where pai1.batch_id = p_batch_id
1106: and pai1.batch_id = pai2.batch_id
1107: and pai1.auction_line_number = pai2.auction_line_number

Line 1104: pon_auc_attributes_interface pai2

1100: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
1101: 'PON_REQUIREMENT_DUPLICATE_ATT',
1102: pai1.attribute_name
1103: from pon_auc_attributes_interface pai1,
1104: pon_auc_attributes_interface pai2
1105: where pai1.batch_id = p_batch_id
1106: and pai1.batch_id = pai2.batch_id
1107: and pai1.auction_line_number = pai2.auction_line_number
1108: and upper(pai1.attribute_name) = upper(pai2.attribute_name)

Line 1122: 'PON_AUC_ATTRIBUTES_INTERFACE',

1118: )
1119: select
1120: pai1.batch_id,
1121: pai1.interface_line_id,
1122: 'PON_AUC_ATTRIBUTES_INTERFACE',
1123: fnd_message.get_string('PON','PON_AUCTS_ATTR'),
1124: 'PON_DUPLICATE_WARNING_ATTR',
1125: pai1.attribute_name
1126: from pon_auc_attributes_interface pai1,

Line 1126: from pon_auc_attributes_interface pai1,

1122: 'PON_AUC_ATTRIBUTES_INTERFACE',
1123: fnd_message.get_string('PON','PON_AUCTS_ATTR'),
1124: 'PON_DUPLICATE_WARNING_ATTR',
1125: pai1.attribute_name
1126: from pon_auc_attributes_interface pai1,
1127: pon_auc_attributes_interface pai2
1128: where pai1.batch_id = p_batch_id
1129: and pai1.batch_id = pai2.batch_id
1130: and pai1.interface_line_id = pai2.interface_line_id

Line 1127: pon_auc_attributes_interface pai2

1123: fnd_message.get_string('PON','PON_AUCTS_ATTR'),
1124: 'PON_DUPLICATE_WARNING_ATTR',
1125: pai1.attribute_name
1126: from pon_auc_attributes_interface pai1,
1127: pon_auc_attributes_interface pai2
1128: where pai1.batch_id = p_batch_id
1129: and pai1.batch_id = pai2.batch_id
1130: and pai1.interface_line_id = pai2.interface_line_id
1131: and upper(pai1.attribute_name) = upper(pai2.attribute_name)

Line 1148: 'PON_AUC_ATTRIBUTES_INTERFACE',

1144: )
1145: select
1146: pai1.batch_id,
1147: pai1.interface_line_id,
1148: 'PON_AUC_ATTRIBUTES_INTERFACE',
1149: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
1150: 'PON_REQUIREMENT_DUPLICATE_ATT',
1151: pai1.attribute_name
1152: from pon_auc_attributes_interface pai1,

Line 1152: from pon_auc_attributes_interface pai1,

1148: 'PON_AUC_ATTRIBUTES_INTERFACE',
1149: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
1150: 'PON_REQUIREMENT_DUPLICATE_ATT',
1151: pai1.attribute_name
1152: from pon_auc_attributes_interface pai1,
1153: pon_auction_attributes paa
1154: where pai1.batch_id = p_batch_id
1155: and paa.auction_header_id = pai1.auction_header_id
1156: and pai1.auction_line_number = -1

Line 1269: from pon_auc_attributes_interface

1265: -- select max sequence number (across all lines)
1266: BEGIN
1267: select nvl(max(sequence_number),0)
1268: into l_sequence_start
1269: from pon_auc_attributes_interface
1270: where batch_id = p_batch_id
1271: and sequence_number >= 0;
1272: l_sequence_start := l_sequence_start + 10;
1273: EXCEPTION

Line 1279: insert into pon_auc_attributes_interface (

1275: l_sequence_start := 0;
1276: END;
1277:
1278: -- insert template attributes for all lines
1279: insert into pon_auc_attributes_interface (
1280: BATCH_ID,
1281: INTERFACE_LINE_ID,
1282: AUCTION_LINE_NUMBER,
1283: AUCTION_HEADER_ID,

Line 1327: delete from pon_auc_attributes_interface pai1

1323: and ip.group_type <> 'GROUP'
1324: and att.auction_header_id = p_auction_template_id;
1325:
1326: -- resolve duplicate attributes by removing the Template attribute
1327: delete from pon_auc_attributes_interface pai1
1328: where rowid in (
1329: select pai1.rowid
1330: from pon_auc_attributes_interface pai2
1331: where pai1.batch_id = p_batch_id

Line 1330: from pon_auc_attributes_interface pai2

1326: -- resolve duplicate attributes by removing the Template attribute
1327: delete from pon_auc_attributes_interface pai1
1328: where rowid in (
1329: select pai1.rowid
1330: from pon_auc_attributes_interface pai2
1331: where pai1.batch_id = p_batch_id
1332: and pai1.batch_id = pai2.batch_id
1333: and pai1.interface_line_id = pai2.interface_line_id
1334: and pai1.attribute_name = pai2.attribute_name

Line 1568: INSERT INTO PON_AUC_ATTRIBUTES_INTERFACE (

1564: p_default_attr_group);
1565:
1566: -- bring over ip descriptors (base and catalog) for new lines
1567:
1568: INSERT INTO PON_AUC_ATTRIBUTES_INTERFACE (
1569: BATCH_ID,
1570: INTERFACE_LINE_ID,
1571: AUCTION_HEADER_ID,
1572: AUCTION_LINE_NUMBER,

Line 1617: from pon_auc_attributes_interface

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

Line 1658: from pon_auc_attributes_interface

1654: BEGIN
1655:
1656: delete from
1657: (select *
1658: from pon_auc_attributes_interface
1659: where auction_line_number in (select paip.line_number
1660: from pon_item_prices_interface p1,
1661: pon_auction_item_prices_all paip
1662: where p1.batch_id = p_batch_id and

Line 1698: INSERT INTO PON_AUC_ATTRIBUTES_INTERFACE (

1694: p_default_attr_group);
1695:
1696: -- bring over ip catalog descriptors for updated lines
1697:
1698: INSERT INTO PON_AUC_ATTRIBUTES_INTERFACE (
1699: BATCH_ID,
1700: INTERFACE_LINE_ID,
1701: AUCTION_HEADER_ID,
1702: AUCTION_LINE_NUMBER,

Line 1747: from pon_auc_attributes_interface

1743: FROM icx_cat_agreement_attrs_v
1744: WHERE rt_category_id = line.ip_category_id and
1745: language = userenv('LANG') and
1746: upper(attribute_name) not in (select upper(attribute_name)
1747: from pon_auc_attributes_interface
1748: where batch_id = p_batch_id and
1749: interface_line_id = line.interface_line_id)
1750: ORDER BY nvl(sequence, l_max_ip_seq_num) asc);
1751:

Line 1767: from pon_auc_attributes_interface

1763: BEGIN
1764:
1765: select nvl(max(sequence_number), 0)
1766: into l_max_attr_seq_num
1767: from pon_auc_attributes_interface
1768: where batch_id = p_batch_id and
1769: interface_line_id = p_interface_line_id;
1770:
1771: RETURN l_max_attr_seq_num;

Line 1786: from pon_auc_attributes_interface

1782: BEGIN
1783:
1784: select attr_group_seq_number
1785: into l_attr_group_seq_num
1786: from pon_auc_attributes_interface
1787: where batch_id = p_batch_id and
1788: interface_line_id = p_interface_line_id and
1789: group_code = p_attr_group and
1790: rownum = 1;

Line 1803: from pon_auc_attributes_interface

1799: -- find max group seq number and add 10
1800:
1801: select nvl(max(attr_group_seq_number), 0) + 10
1802: into l_attr_group_seq_num
1803: from pon_auc_attributes_interface
1804: where batch_id = p_batch_id and
1805: interface_line_id = p_interface_line_id;
1806:
1807: RETURN l_attr_group_seq_num;

Line 1822: from pon_auc_attributes_interface

1818: BEGIN
1819:
1820: select nvl(max(attr_disp_seq_number), 0)
1821: into l_attr_max_disp_seq_num
1822: from pon_auc_attributes_interface
1823: where batch_id = p_batch_id and
1824: interface_line_id = p_interface_line_id and
1825: group_code = p_attr_group;
1826:

Line 1836: l_auction_header_id pon_auc_attributes_interface.auction_header_id%TYPE;

1832: p_source VARCHAR2,
1833: p_batch_id NUMBER,
1834: p_party_id NUMBER
1835: ) AS
1836: l_auction_header_id pon_auc_attributes_interface.auction_header_id%TYPE;
1837: l_message_suffix VARCHAR2(2);
1838: l_hdr_attr_enable_weights VARCHAR2(1);
1839: BEGIN
1840: -- init vars

Line 1844: from pon_auc_attributes_interface pai

1840: -- init vars
1841: BEGIN
1842: select max(pai.auction_header_id)
1843: into l_auction_header_id
1844: from pon_auc_attributes_interface pai
1845: where pai.batch_id = p_batch_id;
1846:
1847: select hdr_attr_enable_weights
1848: into l_hdr_attr_enable_weights

Line 1893: 'PON_AUC_ATTRIBUTES_INTERFACE',

1889: values
1890: (
1891: selected_batch_id,
1892: selected_interface_line_id,
1893: 'PON_AUC_ATTRIBUTES_INTERFACE',
1894: fnd_message.get_string('PON','PON_AUCTS_ATTR_WEIGHT'),
1895: 'PON_AUC_WEIGHT_RANGE',
1896: selected_weight
1897: )

Line 1921: 'PON_AUC_ATTRIBUTES_INTERFACE',

1917: values
1918: (
1919: selected_batch_id,
1920: selected_interface_line_id,
1921: 'PON_AUC_ATTRIBUTES_INTERFACE',
1922: fnd_message.get_string('PON','PON_AUC_SCORE'),
1923: 'PON_AUCTS_DISP_ATTR_NO_SCORES',
1924: selected_ATTR_MAX_SCORE
1925: )

Line 1948: 'PON_AUC_ATTRIBUTES_INTERFACE',

1944: values
1945: (
1946: selected_batch_id,
1947: selected_interface_line_id,
1948: 'PON_AUC_ATTRIBUTES_INTERFACE',
1949: fnd_message.get_string('PON','PON_AUC_SCORE'),
1950: 'PON_AUC_INVALID_MAXSCORE_RANGE',
1951: selected_ATTR_MAX_SCORE
1952: )

Line 1964: pon_auc_attributes_interface pai

1960: pai.display_only_flag selected_display_only_flag,
1961: pai.action selected_action
1962:
1963: from
1964: pon_auc_attributes_interface pai
1965:
1966: where
1967: pai.batch_id = p_batch_id;
1968:

Line 1981: l_auction_header_id pon_auc_attributes_interface.auction_header_id%TYPE;

1977: p_batch_id NUMBER,
1978: p_party_id NUMBER,
1979: p_attr_type_header BOOLEAN
1980: ) AS
1981: l_auction_header_id pon_auc_attributes_interface.auction_header_id%TYPE;
1982: l_message_suffix VARCHAR2(2);
1983: l_group_pref_name VARCHAR2(40);
1984: l_group_lookup_type VARCHAR2(40);
1985: l_attr_type_header VARCHAR2(1);

Line 2001: from pon_auc_attributes_interface pai

1997:
1998: BEGIN
1999: select max(pai.auction_header_id)
2000: into l_auction_header_id
2001: from pon_auc_attributes_interface pai
2002: where pai.batch_id = p_batch_id;
2003:
2004: select pon_auction_pkg.get_message_suffix(doc.internal_name)
2005: into l_message_suffix

Line 2032: update pon_auc_attributes_interface pai

2028: -- bug 3373002
2029: -- need to compare apple with apple, response type values are from fnd messages
2030: -- so also validate against messages, not lookups.
2031: IF ( p_attr_type_header ) THEN
2032: update pon_auc_attributes_interface pai
2033: set response_type = decode(response_type_name,
2034: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
2035: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
2036: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',

Line 2042: update pon_auc_attributes_interface pai

2038: null)
2039: where pai.batch_id = p_batch_id
2040: and pai.response_type_name is not null;
2041: ELSE
2042: update pon_auc_attributes_interface pai
2043: set response_type = decode(response_type_name,
2044: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
2045: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
2046: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',

Line 2056: pon_auc_attributes_interface

2052: -- MANDATORY_FLAG
2053: -- DISPLAY_ONLY_FLAG
2054: -- INTERNAL_ATTR_FLAG
2055: update
2056: pon_auc_attributes_interface
2057: set
2058: mandatory_flag = decode(response_type,'REQUIRED','Y','N'),
2059: display_only_flag = decode(response_type,'DISPLAY_ONLY','Y','N'),
2060: internal_attr_flag = decode(response_type,'INTERNAL','Y','N')

Line 2067: update pon_auc_attributes_interface paai

2063:
2064:
2065: -- Not to be Done for Header Section.
2066: IF ( not p_attr_type_header ) THEN
2067: update pon_auc_attributes_interface paai
2068: set paai.GROUP_CODE = (select nvl(ppp.preference_value,'GENERAL')
2069: from pon_party_preferences ppp
2070: where ppp.app_short_name = 'PON'
2071: and ppp.preference_name = l_group_pref_name

Line 2080: update pon_auc_attributes_interface paai

2076:
2077:
2078: -- populate GROUP_CODE. Note that the comparison is case sensitive.
2079:
2080: update pon_auc_attributes_interface paai
2081: set paai.GROUP_CODE = (
2082: select lookup_code
2083: from fnd_lookup_values attrGrpFlv
2084: where lookup_type = l_group_lookup_type

Line 2100: update pon_auc_attributes_interface paai

2096: AND paai.auction_line_number <> -1;
2097:
2098: ELSE
2099: -- For Header Case, if the Group Name is null, default General.
2100: update pon_auc_attributes_interface paai
2101: set paai.GROUP_NAME = (
2102: select meaning
2103: from fnd_lookup_values attrGrpFlv
2104: where attrGrpFlv.lookup_type = 'PON_HEADER_ATTRIBUTE_GROUPS'

Line 2142: 'PON_AUC_ATTRIBUTES_INTERFACE',

2138: VALUES
2139: (
2140: selected_batch_id,
2141: selected_interface_line_id,
2142: 'PON_AUC_ATTRIBUTES_INTERFACE',
2143: fnd_message.get_string('PON','PON_AUCTS_ATTR_DATATYPE'),
2144: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP',
2145: 'PON_AUCTS_ATTR_INVALID_TYPE', 'PON_AUCTS_REQ_INVALID_TYPE'),
2146: selected_datatype

Line 2169: 'PON_AUC_ATTRIBUTES_INTERFACE',

2165: VALUES
2166: (
2167: selected_batch_id,
2168: selected_interface_line_id,
2169: 'PON_AUC_ATTRIBUTES_INTERFACE',
2170: 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')),
2171: 'PON_CAT_INVALID_VALUE',
2172: selected_response_type_name
2173: )

Line 2196: 'PON_AUC_ATTRIBUTES_INTERFACE',

2192: values
2193: (
2194: selected_batch_id,
2195: selected_interface_line_id,
2196: 'PON_AUC_ATTRIBUTES_INTERFACE',
2197: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
2198: 'PON_AUCTS_INV_PR_QT_VAL',
2199: selected_display_target_flag
2200: )

Line 2226: 'PON_AUC_ATTRIBUTES_INTERFACE',

2222: values
2223: (
2224: selected_batch_id,
2225: selected_interface_line_id,
2226: 'PON_AUC_ATTRIBUTES_INTERFACE',
2227: fnd_message.get_string('PON','PON_AUCTS_ATTR_DATATYPE'),
2228: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP',
2229: 'PON_AUCTS_ATTR_INVALID_TYPE', 'PON_AUCTS_REQ_INVALID_TYPE'),
2230: selected_datatype

Line 2252: 'PON_AUC_ATTRIBUTES_INTERFACE',

2248: values
2249: (
2250: selected_batch_id,
2251: selected_interface_line_id,
2252: 'PON_AUC_ATTRIBUTES_INTERFACE',
2253: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
2254: 'PON_AUCTS_INV_PR_QT_VAL',
2255: selected_display_target_flag
2256: )

Line 2277: 'PON_AUC_ATTRIBUTES_INTERFACE',

2273: values
2274: (
2275: selected_batch_id,
2276: selected_interface_line_id,
2277: 'PON_AUC_ATTRIBUTES_INTERFACE',
2278: fnd_message.get_string('PON','PON_AUCTS_TARGET_VALUE'),
2279: 'PON_AUCTS_ATTR_SHOW_TARGET',
2280: selected_value
2281: )

Line 2305: 'PON_AUC_ATTRIBUTES_INTERFACE',

2301: values
2302: (
2303: selected_batch_id,
2304: selected_interface_line_id,
2305: 'PON_AUC_ATTRIBUTES_INTERFACE',
2306: pon_auction_pkg.getMessage('PON_AUCTS_ATTR_TARGET',l_message_suffix),
2307: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP',
2308: 'PON_AUCTS_ATTR_DISPLAY_TARGET', 'PON_AUCTS_REQ_DISPLAY_TARGET'),
2309: selected_value

Line 2332: 'PON_AUC_ATTRIBUTES_INTERFACE',

2328: values
2329: (
2330: selected_batch_id,
2331: selected_interface_line_id,
2332: 'PON_AUC_ATTRIBUTES_INTERFACE',
2333: 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')),
2334: 'PON_FIELD_MUST_BE_ENTERED',
2335: selected_attribute_name
2336: )

Line 2361: 'PON_AUC_ATTRIBUTES_INTERFACE',

2357: values
2358: (
2359: selected_batch_id,
2360: selected_interface_line_id,
2361: 'PON_AUC_ATTRIBUTES_INTERFACE',
2362: 'SEQUENCE_NUMBER',
2363: 'PON_CAT_DISP_SEQ_M',
2364: selected_sequence_number
2365: )

Line 2388: 'PON_AUC_ATTRIBUTES_INTERFACE',

2384: values
2385: (
2386: selected_batch_id,
2387: selected_interface_line_id,
2388: 'PON_AUC_ATTRIBUTES_INTERFACE',
2389: fnd_message.get_string('PON','PON_AUCTS_GROUP'),
2390: 'PON_AUCTS_INVALID_GROUP',
2391: selected_group_name
2392: )

Line 2415: 'PON_AUC_ATTRIBUTES_INTERFACE',

2411: values
2412: (
2413: selected_batch_id,
2414: selected_interface_line_id,
2415: 'PON_AUC_ATTRIBUTES_INTERFACE',
2416: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
2417: 'PON_AUC_INTERNAL_ATT_ERROR',
2418: fnd_message.get_string('PON','PON_CORE_NO')
2419: )

Line 2441: 'PON_AUC_ATTRIBUTES_INTERFACE',

2437: values
2438: (
2439: selected_batch_id,
2440: selected_interface_line_id,
2441: 'PON_AUC_ATTRIBUTES_INTERFACE',
2442: fnd_message.get_string('PON','PON_AUCTS_ATTR_WEIGHT'),
2443: 'PON_AUC_INVALID_WEIGHT',
2444: fnd_message.get_string('PON','PON_CORE_NO')
2445: )

Line 2467: pon_auc_attributes_interface pai

2463: pai.action selected_action,
2464: pai.auction_line_number selected_auction_line_num
2465:
2466: from
2467: pon_auc_attributes_interface pai
2468: where
2469: pai.batch_id = p_batch_id;
2470:
2471: -- perform duplicate checks

Line 2484: 'PON_AUC_ATTRIBUTES_INTERFACE',

2480: )
2481: select
2482: pai1.batch_id,
2483: pai1.interface_line_id,
2484: 'PON_AUC_ATTRIBUTES_INTERFACE',
2485: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
2486: 'PON_REQUIREMENT_DUPLICATE_ATT',
2487: pai1.attribute_name
2488: from pon_auc_attributes_interface pai1,

Line 2488: from pon_auc_attributes_interface pai1,

2484: 'PON_AUC_ATTRIBUTES_INTERFACE',
2485: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
2486: 'PON_REQUIREMENT_DUPLICATE_ATT',
2487: pai1.attribute_name
2488: from pon_auc_attributes_interface pai1,
2489: pon_auc_attributes_interface pai2
2490: where pai1.batch_id = p_batch_id
2491: and pai1.batch_id = pai2.batch_id
2492: and pai1.auction_line_number = pai2.auction_line_number

Line 2489: pon_auc_attributes_interface pai2

2485: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
2486: 'PON_REQUIREMENT_DUPLICATE_ATT',
2487: pai1.attribute_name
2488: from pon_auc_attributes_interface pai1,
2489: pon_auc_attributes_interface pai2
2490: where pai1.batch_id = p_batch_id
2491: and pai1.batch_id = pai2.batch_id
2492: and pai1.auction_line_number = pai2.auction_line_number
2493: and upper(pai1.attribute_name) = upper(pai2.attribute_name)

Line 2508: 'PON_AUC_ATTRIBUTES_INTERFACE',

2504: )
2505: select
2506: pai1.batch_id,
2507: pai1.interface_line_id,
2508: 'PON_AUC_ATTRIBUTES_INTERFACE',
2509: fnd_message.get_string('PON','PON_AUCTS_ATTR'),
2510: 'PON_DUPLICATE_WARNING_ATTR',
2511: pai1.attribute_name
2512: from pon_auc_attributes_interface pai1,

Line 2512: from pon_auc_attributes_interface pai1,

2508: 'PON_AUC_ATTRIBUTES_INTERFACE',
2509: fnd_message.get_string('PON','PON_AUCTS_ATTR'),
2510: 'PON_DUPLICATE_WARNING_ATTR',
2511: pai1.attribute_name
2512: from pon_auc_attributes_interface pai1,
2513: pon_auc_attributes_interface pai2
2514: where pai1.batch_id = p_batch_id
2515: and pai1.batch_id = pai2.batch_id
2516: and pai1.interface_line_id = pai2.interface_line_id

Line 2513: pon_auc_attributes_interface pai2

2509: fnd_message.get_string('PON','PON_AUCTS_ATTR'),
2510: 'PON_DUPLICATE_WARNING_ATTR',
2511: pai1.attribute_name
2512: from pon_auc_attributes_interface pai1,
2513: pon_auc_attributes_interface pai2
2514: where pai1.batch_id = p_batch_id
2515: and pai1.batch_id = pai2.batch_id
2516: and pai1.interface_line_id = pai2.interface_line_id
2517: and upper(pai1.attribute_name) = upper(pai2.attribute_name)

Line 2535: 'PON_AUC_ATTRIBUTES_INTERFACE',

2531: )
2532: select
2533: pai1.batch_id,
2534: pai1.interface_line_id,
2535: 'PON_AUC_ATTRIBUTES_INTERFACE',
2536: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
2537: 'PON_REQUIREMENT_DUPLICATE_ATT',
2538: pai1.attribute_name
2539: from pon_auc_attributes_interface pai1,

Line 2539: from pon_auc_attributes_interface pai1,

2535: 'PON_AUC_ATTRIBUTES_INTERFACE',
2536: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
2537: 'PON_REQUIREMENT_DUPLICATE_ATT',
2538: pai1.attribute_name
2539: from pon_auc_attributes_interface pai1,
2540: pon_auction_attributes paa
2541: where pai1.batch_id = p_batch_id
2542: and paa.auction_header_id = pai1.auction_header_id
2543: and pai1.auction_line_number = -1

Line 2628: l_TABLE_NAME PON_INTERFACE_ERRORS.TABLE_NAME%TYPE :='PON_AUC_ATTRIBUTES_INTERFACE';

2624: --p_in_rec.l_SCORING_METHOD PON_AUCTION_ATTRIBUTES.SCORING_METHOD%TYPE,
2625: x_return_status OUT NOCOPY VARCHAR
2626: )
2627: IS
2628: l_TABLE_NAME PON_INTERFACE_ERRORS.TABLE_NAME%TYPE :='PON_AUC_ATTRIBUTES_INTERFACE';
2629: --p_in_rec.l_KNOCKOUT_SCORE PON_AUCTION_ATTRIBUTES.KNOCKOUT_SCORE%TYPE:=NULL;
2630: l_status NUMBER;
2631: BEGIN
2632: x_return_status := 'Y';