DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_HELPER_PVT dependencies on PON_BIDDING_PARTIES

Line 968: PON_PRICE_ELEMENTS PPE, PON_BIDDING_PARTIES PBP

964: supplier_seq_number,value,creation_date,created_by,last_update_date,last_updated_by,last_update_login)
965: select distinct PPE.auction_header_id,PPE.price_element_type_id,PPE.pricing_basis,
966: PBP.sequence,null,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id
967: from
968: PON_PRICE_ELEMENTS PPE, PON_BIDDING_PARTIES PBP
969: where
970: PPE.auction_header_id = p_auction_header_id and
971: PBP.auction_header_id = p_auction_header_id and
972: PPE.line_number = p_line_number and

Line 1685: -- Call update on pon_bidding_parties only if this is

1681: END IF;
1682:
1683: END IF;
1684:
1685: -- Call update on pon_bidding_parties only if this is
1686: -- not a large negotiation
1687: IF (nvl (l_large_neg_enabled_flag, 'N') = 'N') THEN
1688:
1689: --Need to update pon_bidding_parties about the access_type

Line 1689: --Need to update pon_bidding_parties about the access_type

1685: -- Call update on pon_bidding_parties only if this is
1686: -- not a large negotiation
1687: IF (nvl (l_large_neg_enabled_flag, 'N') = 'N') THEN
1688:
1689: --Need to update pon_bidding_parties about the access_type
1690: --Any supplier who was restricted on the deleted lines
1691: --should now have access_type set to FULL
1692: UPDATE
1693: pon_bidding_parties

Line 1693: pon_bidding_parties

1689: --Need to update pon_bidding_parties about the access_type
1690: --Any supplier who was restricted on the deleted lines
1691: --should now have access_type set to FULL
1692: UPDATE
1693: pon_bidding_parties
1694: SET
1695: access_type = 'FULL'
1696: WHERE
1697: auction_header_id = p_auction_header_id AND

Line 2584: -- Need to update pon_bidding_parties about the access_type

2580: END IF;
2581:
2582: END IF; --}
2583:
2584: -- Need to update pon_bidding_parties about the access_type
2585: -- Any supplier who was restricted on the deleted lines
2586: -- should now have access_type set to FULL
2587: UPDATE
2588: pon_bidding_parties

Line 2588: pon_bidding_parties

2584: -- Need to update pon_bidding_parties about the access_type
2585: -- Any supplier who was restricted on the deleted lines
2586: -- should now have access_type set to FULL
2587: UPDATE
2588: pon_bidding_parties
2589: SET
2590: access_type = 'FULL'
2591: WHERE
2592: auction_header_id = p_auction_header_id AND