DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_AUCTION_EXHIBIT_DETAILS

Line 10472: FROM pon_auction_exhibit_details

10468: ASSOCIATED_TO_LINE,
10469: EXHIBIT_DESCRIPTION
10470: BULK COLLECT INTO
10471: l_exhibit_number,l_iscdrl,l_associatedline,l_exhibit_description
10472: FROM pon_auction_exhibit_details
10473: WHERE auction_header_id=p_source_auction_header_id;
10474:
10475: IF (l_exhibit_number.count <> 0) THEN
10476: FOR x IN 1..l_exhibit_number.count

Line 10478: INSERT INTO pon_auction_exhibit_details

10474:
10475: IF (l_exhibit_number.count <> 0) THEN
10476: FOR x IN 1..l_exhibit_number.count
10477: LOOP
10478: INSERT INTO pon_auction_exhibit_details
10479: (AUCTION_HEADER_ID,
10480: EXHIBIT_NUMBER,
10481: IS_CDRL,
10482: ASSOCIATED_TO_LINE,

Line 10493: INSERT INTO pon_auction_exhibit_details

10489: (p_auction_header_id,l_exhibit_number(x),l_iscdrl(x),
10490: l_associatedline(x),l_exhibit_description(x),SYSDATE,p_user_id,SYSDATE,p_user_id);
10491: END LOOP;
10492: END IF;*/
10493: INSERT INTO pon_auction_exhibit_details
10494: (AUCTION_HEADER_ID,
10495: EXHIBIT_NUMBER,
10496: IS_CDRL,
10497: ASSOCIATED_TO_LINE,

Line 10513: FROM pon_auction_exhibit_details

10509: SYSDATE,
10510: p_user_id,
10511: SYSDATE,
10512: p_user_id
10513: FROM pon_auction_exhibit_details
10514: WHERE auction_header_id=p_source_auction_header_id
10515: /* When clauses are not retained, donot copy exhibits of type cdrls. */
10516: AND ((Nvl(p_retain_clauses, 'N') = 'Y') OR
10517: (Nvl(p_retain_clauses, 'N') = 'N' AND IS_CDRL = 'N')));