[Home] [Help]
88: IN : p_auction_header_id NUMBER auction header id
89: IN : p_batch_id NUMBER batch id for which the defaulting will be done.
90:
91: COMMENT : This procedure will default various field in pon_item_prices_interface,
92: pon_auc_attributes_interface and pon_auc_price_elements_int
93: for lines being updated based on various conditions.
94: ======================================================================*/
95: procedure DEFAULT_PREV_ROUND_AMEND_LINES(
96: p_auction_header_id IN NUMBER,
324: p1.batch_id = p_batch_id
325: and p1.action = g_update_action;
326: END if;
327:
328: -- Update display_target_flag in pon_auc_attributes_interface for existing attributes
329: -- in lines being updated for attributes that have sequence number -10 and -20
330: update pon_auc_attributes_interface interface_attribute
331: set display_target_flag =
332: (select display_target_flag
326: END if;
327:
328: -- Update display_target_flag in pon_auc_attributes_interface for existing attributes
329: -- in lines being updated for attributes that have sequence number -10 and -20
330: update pon_auc_attributes_interface interface_attribute
331: set display_target_flag =
332: (select display_target_flag
333: from
334: pon_auction_attributes auction_attributes
558: g_cur_internal_line_num := p_interface_line_id;
559:
560: select nvl(max(SEQUENCE_NUMBER), 0) + p_template_sequence_number
561: into l_sequence_number
562: from pon_auc_attributes_interface
563: where batch_id = p_batch_id
564: and interface_line_id = p_interface_line_id
565: and response_type_name <> 'PON_FROM_TEMPLATE';
566: --}
598: BEGIN
599:
600: select ATTR_GROUP_SEQ_NUMBER
601: into l_attr_group_seq_number
602: from pon_auc_attributes_interface
603: where batch_id = p_batch_id
604: and interface_line_id = p_interface_line_id
605: and group_code = p_attr_group
606: and response_type_name <> 'PON_FROM_TEMPLATE'
616: -- number for the attributes in the line + the attribute group sequence number of
617: -- the attribute in the template
618: select nvl(max(ATTR_GROUP_SEQ_NUMBER), 0) + p_template_group_seq_number
619: into l_attr_group_seq_number
620: from pon_auc_attributes_interface
621: where batch_id = p_batch_id
622: and interface_line_id = p_interface_line_id
623: and response_type_name <> 'PON_FROM_TEMPLATE';
624:
660: BEGIN
661:
662: select nvl(max(ATTR_DISP_SEQ_NUMBER), 0) + p_template_disp_seq_number
663: into l_attr_disp_seq_number
664: from pon_auc_attributes_interface
665: where batch_id = p_batch_id and
666: interface_line_id = p_interface_line_id
667: and response_type_name <> 'PON_FROM_TEMPLATE'
668: and group_code = p_attr_group;
1310:
1311: PARAMETERS: NONE
1312:
1313: COMMENT : This procedure will add the attributes corresponding to the new
1314: lines from the PON_AUC_ATTRIBUTES_INTERFACE interface table to the
1315: PON_AUCTION_ATTRIBUTES transaction tables. The following sql will
1316: be used for the same. The logic for this is present in copyAttributes
1317: method in NegItemSpreadsheetAMImpl.
1318: ======================================================================*/
1387: sysdate,
1388: g_user_id,
1389: nvl(paa_int.group_name,g_default_section_name)
1390: from
1391: pon_auc_attributes_interface paa_int,
1392: pon_item_prices_interface p1
1393: where
1394: paa_int.batch_id= g_batch_id
1395: and p1.batch_id = paa_int.batch_id
1418:
1419: ii. Get the lines that have the attributes present in the
1420: template. We only require those attributes that have not been copied
1421: as part of the spreadsheet. These attributes can be identified using
1422: the field response_type_name in pon_auc_attributes_interface. The
1423: value of this field for all the attributes added will be 'PON_FROM_TEMPLATE"
1424: ======================================================================*/
1425: PROCEDURE ADD_ATTRIBUTE_SCORES is
1426:
1467: pon_auction_headers_all template,
1468: pon_attribute_scores template_attribute_score,
1469: pon_auction_attributes template_attribute,
1470: pon_auction_attributes auction_attributes,
1471: pon_auc_attributes_interface interface_attributes
1472: WHERE
1473: pah1.auction_header_id = g_auction_header_id
1474: and template.auction_header_id = pah1.template_id
1475: and template_attribute.auction_header_id = template.auction_header_id
2211: and not exists
2212: (select
2213: 1
2214: from
2215: pon_auc_attributes_interface interface_attributes
2216: where
2217: line_interface.batch_id = interface_attributes.batch_id
2218: and line_interface.auction_line_number = interface_attributes.auction_line_number
2219: and interface_attributes.auction_header_id = auction_attributes.auction_header_id
2250: and not exists
2251: (select
2252: 1
2253: from
2254: pon_auc_attributes_interface interface_attributes
2255: where
2256: line_interface.batch_id = interface_attributes.batch_id
2257: and line_interface.auction_line_number = interface_attributes.auction_line_number
2258: and interface_attributes.auction_header_id = auction_attributes.auction_header_id
2297: l_attr_group_seq_number,
2298: l_attr_disp_seq_number
2299: from
2300: pon_item_prices_interface line_interface,
2301: pon_auc_attributes_interface interface_attributes,
2302: pon_auction_attributes auction_attributes
2303: where
2304: interface_attributes.batch_id = g_batch_id
2305: and interface_attributes.auction_header_id = auction_attributes.auction_header_id
2397: g_user_id,
2398: sysdate,
2399: g_user_id
2400: from
2401: pon_auc_attributes_interface paa_int,
2402: pon_item_prices_interface p1
2403: where
2404: paa_int.batch_id= g_batch_id
2405: and p1.batch_id = paa_int.batch_id
2893:
2894: -- Clear the interface tables
2895: -- What is there is an error? need to clear these always
2896: delete from pon_item_prices_interface where batch_id = g_batch_id;
2897: delete from pon_auc_attributes_interface where batch_id = g_batch_id;
2898: delete from pon_auc_payments_interface where batch_id = g_batch_id;
2899: delete from pon_auc_price_differ_int where batch_id = g_batch_id;
2900: delete from pon_auc_price_elements_int where batch_id = g_batch_id;
2901: