[Home] [Help]
90: IN : p_auction_header_id NUMBER auction header id
91: IN : p_batch_id NUMBER batch id for which the defaulting will be done.
92:
93: COMMENT : This procedure will default various field in pon_item_prices_interface,
94: pon_auc_attributes_interface and pon_auc_price_elements_int
95: for lines being updated based on various conditions.
96: ======================================================================*/
97: procedure DEFAULT_PREV_ROUND_AMEND_LINES(
98: p_auction_header_id IN NUMBER,
329: p1.batch_id = p_batch_id
330: and p1.action = g_update_action;
331: END if;
332:
333: -- Update display_target_flag in pon_auc_attributes_interface for existing attributes
334: -- in lines being updated for attributes that have sequence number -10 and -20
335: update pon_auc_attributes_interface interface_attribute
336: set display_target_flag =
337: (select display_target_flag
331: END if;
332:
333: -- Update display_target_flag in pon_auc_attributes_interface for existing attributes
334: -- in lines being updated for attributes that have sequence number -10 and -20
335: update pon_auc_attributes_interface interface_attribute
336: set display_target_flag =
337: (select display_target_flag
338: from
339: pon_auction_attributes auction_attributes
563: g_cur_internal_line_num := p_interface_line_id;
564:
565: select nvl(max(SEQUENCE_NUMBER), 0) + p_template_sequence_number
566: into l_sequence_number
567: from pon_auc_attributes_interface
568: where batch_id = p_batch_id
569: and interface_line_id = p_interface_line_id
570: and response_type_name <> 'PON_FROM_TEMPLATE';
571: --}
603: BEGIN
604:
605: select ATTR_GROUP_SEQ_NUMBER
606: into l_attr_group_seq_number
607: from pon_auc_attributes_interface
608: where batch_id = p_batch_id
609: and interface_line_id = p_interface_line_id
610: and group_code = p_attr_group
611: and response_type_name <> 'PON_FROM_TEMPLATE'
621: -- number for the attributes in the line + the attribute group sequence number of
622: -- the attribute in the template
623: select nvl(max(ATTR_GROUP_SEQ_NUMBER), 0) + p_template_group_seq_number
624: into l_attr_group_seq_number
625: from pon_auc_attributes_interface
626: where batch_id = p_batch_id
627: and interface_line_id = p_interface_line_id
628: and response_type_name <> 'PON_FROM_TEMPLATE';
629:
665: BEGIN
666:
667: select nvl(max(ATTR_DISP_SEQ_NUMBER), 0) + p_template_disp_seq_number
668: into l_attr_disp_seq_number
669: from pon_auc_attributes_interface
670: where batch_id = p_batch_id and
671: interface_line_id = p_interface_line_id
672: and response_type_name <> 'PON_FROM_TEMPLATE'
673: and group_code = p_attr_group;
1532:
1533: PARAMETERS: NONE
1534:
1535: COMMENT : This procedure will add the attributes corresponding to the new
1536: lines from the PON_AUC_ATTRIBUTES_INTERFACE interface table to the
1537: PON_AUCTION_ATTRIBUTES transaction tables. The following sql will
1538: be used for the same. The logic for this is present in copyAttributes
1539: method in NegItemSpreadsheetAMImpl.
1540: ======================================================================*/
1609: sysdate,
1610: g_user_id,
1611: nvl(paa_int.group_name,g_default_section_name)
1612: from
1613: pon_auc_attributes_interface paa_int,
1614: pon_item_prices_interface p1
1615: where
1616: paa_int.batch_id= g_batch_id
1617: and p1.batch_id = paa_int.batch_id
1640:
1641: ii. Get the lines that have the attributes present in the
1642: template. We only require those attributes that have not been copied
1643: as part of the spreadsheet. These attributes can be identified using
1644: the field response_type_name in pon_auc_attributes_interface. The
1645: value of this field for all the attributes added will be 'PON_FROM_TEMPLATE"
1646: ======================================================================*/
1647: PROCEDURE ADD_ATTRIBUTE_SCORES is
1648:
1689: pon_auction_headers_all template,
1690: pon_attribute_scores template_attribute_score,
1691: pon_auction_attributes template_attribute,
1692: pon_auction_attributes auction_attributes,
1693: pon_auc_attributes_interface interface_attributes
1694: WHERE
1695: pah1.auction_header_id = g_auction_header_id
1696: and template.auction_header_id = pah1.template_id
1697: and template_attribute.auction_header_id = template.auction_header_id
2472: and not exists
2473: (select
2474: 1
2475: from
2476: pon_auc_attributes_interface interface_attributes
2477: where
2478: line_interface.batch_id = interface_attributes.batch_id
2479: and line_interface.auction_line_number = interface_attributes.auction_line_number
2480: and interface_attributes.auction_header_id = auction_attributes.auction_header_id
2511: and not exists
2512: (select
2513: 1
2514: from
2515: pon_auc_attributes_interface interface_attributes
2516: where
2517: line_interface.batch_id = interface_attributes.batch_id
2518: and line_interface.auction_line_number = interface_attributes.auction_line_number
2519: and interface_attributes.auction_header_id = auction_attributes.auction_header_id
2558: l_attr_group_seq_number,
2559: l_attr_disp_seq_number
2560: from
2561: pon_item_prices_interface line_interface,
2562: pon_auc_attributes_interface interface_attributes,
2563: pon_auction_attributes auction_attributes
2564: where
2565: interface_attributes.batch_id = g_batch_id
2566: and interface_attributes.auction_header_id = auction_attributes.auction_header_id
2658: g_user_id,
2659: sysdate,
2660: g_user_id
2661: from
2662: pon_auc_attributes_interface paa_int,
2663: pon_item_prices_interface p1
2664: where
2665: paa_int.batch_id= g_batch_id
2666: and p1.batch_id = paa_int.batch_id
3155: -- Clear the interface tables
3156: -- What is there is an error? need to clear these always
3157: IF(Nvl(p_commit,'Y') = 'Y') then
3158: delete from pon_item_prices_interface where batch_id = g_batch_id;
3159: delete from pon_auc_attributes_interface where batch_id = g_batch_id;
3160: delete from pon_auc_payments_interface where batch_id = g_batch_id;
3161: delete from pon_auc_price_differ_int where batch_id = g_batch_id;
3162: delete from pon_auc_price_elements_int where batch_id = g_batch_id;
3163: