292: SELECT DISTINCT
293: ATTR_GROUP_ID
294: , DATA_LEVEL_ID
295: , LINE_NUMBER
296: FROM PON_AUCTION_ATTR_MAPPING_B
297: WHERE AUCTION_HEADER_ID = p_header_id
298: AND MAPPING_TYPE IN ('DOC_HEADER','DOC_REQ', 'CAT_LINE', 'DOC_SEC_SCORE'); --Bug13471195 Header Mapping Issue
299:
300: CURSOR supp_mapping_setup_cursor(p_header_id IN NUMBER
306: , SEQUENCE_NUMBER
307: , MAPPING_TYPE
308: , RESPONSE
309: , ATTR_INT_NAME
310: FROM PON_AUCTION_ATTR_MAPPING_B
311: WHERE AUCTION_HEADER_ID = p_header_id
312: AND ATTR_GROUP_ID = p_attr_group_id
313: AND DATA_LEVEL_ID = p_data_level_id
314: AND ( ( LINE_NUMBER = p_line_number AND mapping_type IN ('DOC_REQ', 'CAT_LINE', 'DOC_SEC_SCORE') )
319: SELECT DISTINCT
320: ATTR_GROUP_ID
321: , DATA_LEVEL_ID
322: , LINE_NUMBER
323: FROM PON_AUCTION_ATTR_MAPPING_B
324: WHERE AUCTION_HEADER_ID = p_header_id
325: AND MAPPING_TYPE IN ('ITEM_LINE','ITEM_HEADER'); ----Bug13471195 Header Mapping Issue
326:
327: CURSOR item_mapping_setup_cursor(p_header_id IN NUMBER
332: SELECT SEQUENCE_NUMBER
333: , MAPPING_TYPE
334: , RESPONSE
335: , ATTR_INT_NAME
336: FROM PON_AUCTION_ATTR_MAPPING_B
337: WHERE AUCTION_HEADER_ID = p_header_id
338: AND ATTR_GROUP_ID = p_attr_group_id
339: AND DATA_LEVEL_ID = p_data_level_id
340: AND ( ( LINE_NUMBER = p_line_number AND mapping_type = 'ITEM_LINE' )