APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_AUCTION_SECTIONS

Line 3705: insert into pon_auction_sections

3701: --{
3702: --
3703: -- Cross Copy Logic For Section
3704: --
3705: insert into pon_auction_sections
3706: ( AUCTION_HEADER_ID,
3707: LINE_NUMBER,
3708: ATTRIBUTE_LIST_ID,
3709: SECTION_ID,

Line 3723: PON_AUCTION_SECTIONS_S.NEXTVAL,

3719: select
3720: p_auction_header_id,
3721: LINE_NUMBER,
3722: ATTRIBUTE_LIST_ID,
3723: PON_AUCTION_SECTIONS_S.NEXTVAL,
3724: -- Team Scoring
3725: -- Commenting the following line to allow copying of sections
3726: -- even in case of cross copy or draft copy as previous section
3727: -- id is needed while copying team assignments on the new document

Line 3739: FROM PON_AUCTION_SECTIONS

3735: SYSDATE,
3736: p_user_id,
3737: p_user_id,
3738: DECODE(p_doctype_id, g_rfq_doctype_id, TWO_PART_SECTION_TYPE, NULL)
3739: FROM PON_AUCTION_SECTIONS
3740: WHERE AUCTION_HEADER_ID = p_source_auction_header_id;
3741: --}
3742:
3743: END;

Line 11494: pon_auction_sections new_sections

11490: ,SYSDATE -- last_update_date
11491: ,p_user_id -- last_updated_by
11492: ,fnd_global.login_id -- last_update_login
11493: FROM
11494: pon_auction_sections new_sections
11495: ,pon_scoring_team_sections old_team_sections
11496: ,pon_scoring_teams new_team
11497: WHERE
11498: new_sections.auction_header_id = p_auction_header_id