DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_AUCTION_ATTR_MAPPING_B

Line 13284: INSERT INTO PON_AUCTION_ATTR_MAPPING_B

13280: )
13281: IS
13282: BEGIN
13283: IF(g_neg_style_control.intgr_hdr_attr_flag = 'Y' OR g_neg_style_control.intgr_cat_line_attr_flag = 'Y') THEN
13284: INSERT INTO PON_AUCTION_ATTR_MAPPING_B
13285: (
13286: MAPPING_ID,
13287: AUCTION_HEADER_ID,
13288: LINE_NUMBER,

Line 13323: FROM PON_AUCTION_ATTR_MAPPING_B

13319: p_user_id,
13320: SYSDATE,
13321: MULTI_ROW_CODE,
13322: SECTION_ID
13323: FROM PON_AUCTION_ATTR_MAPPING_B
13324: WHERE AUCTION_HEADER_ID = p_source_auction_header_id
13325: AND MAPPING_TYPE = 'DOC_HEADER';
13326: END IF;
13327:

Line 13329: INSERT INTO PON_AUCTION_ATTR_MAPPING_B

13325: AND MAPPING_TYPE = 'DOC_HEADER';
13326: END IF;
13327:
13328: IF(g_neg_style_control.intgr_hdr_attr_flag = 'Y') THEN
13329: INSERT INTO PON_AUCTION_ATTR_MAPPING_B
13330: (
13331: MAPPING_ID,
13332: AUCTION_HEADER_ID,
13333: LINE_NUMBER,

Line 13373: FROM PON_AUCTION_ATTR_MAPPING_B B

13369: ( SELECT SECTION_ID
13370: FROM PON_AUCTION_SECTIONS S
13371: WHERE S.PREVIOUS_SECTION_ID = B.SECTION_ID
13372: AND S.AUCTION_HEADER_ID = p_auction_header_id) )
13373: FROM PON_AUCTION_ATTR_MAPPING_B B
13374: WHERE AUCTION_HEADER_ID = p_source_auction_header_id
13375: AND MAPPING_TYPE IN ('DOC_REQ', 'DOC_SEC_SCORE');
13376: END IF;
13377:

Line 13379: INSERT INTO PON_AUCTION_ATTR_MAPPING_B

13375: AND MAPPING_TYPE IN ('DOC_REQ', 'DOC_SEC_SCORE');
13376: END IF;
13377:
13378: IF(g_neg_style_control.intgr_cat_line_attr_flag = 'Y') THEN
13379: INSERT INTO PON_AUCTION_ATTR_MAPPING_B
13380: (
13381: MAPPING_ID,
13382: AUCTION_HEADER_ID,
13383: LINE_NUMBER,

Line 13418: FROM PON_AUCTION_ATTR_MAPPING_B

13414: p_user_id,
13415: SYSDATE,
13416: MULTI_ROW_CODE,
13417: SECTION_ID
13418: FROM PON_AUCTION_ATTR_MAPPING_B
13419: WHERE AUCTION_HEADER_ID = p_source_auction_header_id
13420: AND MAPPING_TYPE = 'CAT_LINE';
13421: END IF;
13422:

Line 13424: INSERT INTO PON_AUCTION_ATTR_MAPPING_B

13420: AND MAPPING_TYPE = 'CAT_LINE';
13421: END IF;
13422:
13423: IF(g_neg_style_control.intgr_item_line_attr_flag = 'Y') THEN
13424: INSERT INTO PON_AUCTION_ATTR_MAPPING_B
13425: (
13426: MAPPING_ID,
13427: AUCTION_HEADER_ID,
13428: LINE_NUMBER,

Line 13463: FROM PON_AUCTION_ATTR_MAPPING_B

13459: p_user_id,
13460: SYSDATE,
13461: MULTI_ROW_CODE,
13462: SECTION_ID
13463: FROM PON_AUCTION_ATTR_MAPPING_B
13464: WHERE AUCTION_HEADER_ID = p_source_auction_header_id
13465: AND MAPPING_TYPE IN ('ITEM_HEADER', 'ITEM_LINE');
13466: END IF;
13467: