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 1746: -- Call update on pon_bidding_parties only if this is

1742: END IF;
1743:
1744: END IF;
1745:
1746: -- Call update on pon_bidding_parties only if this is
1747: -- not a large negotiation
1748: IF (nvl (l_large_neg_enabled_flag, 'N') = 'N') THEN
1749:
1750: --Need to update pon_bidding_parties about the access_type

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

1746: -- Call update on pon_bidding_parties only if this is
1747: -- not a large negotiation
1748: IF (nvl (l_large_neg_enabled_flag, 'N') = 'N') THEN
1749:
1750: --Need to update pon_bidding_parties about the access_type
1751: --Any supplier who was restricted on the deleted lines
1752: --should now have access_type set to FULL
1753: UPDATE
1754: pon_bidding_parties

Line 1754: pon_bidding_parties

1750: --Need to update pon_bidding_parties about the access_type
1751: --Any supplier who was restricted on the deleted lines
1752: --should now have access_type set to FULL
1753: UPDATE
1754: pon_bidding_parties
1755: SET
1756: access_type = 'FULL'
1757: WHERE
1758: auction_header_id = p_auction_header_id AND

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

2724: END IF;
2725:
2726: END IF; --}
2727:
2728: -- Need to update pon_bidding_parties about the access_type
2729: -- Any supplier who was restricted on the deleted lines
2730: -- should now have access_type set to FULL
2731: UPDATE
2732: pon_bidding_parties

Line 2732: pon_bidding_parties

2728: -- Need to update pon_bidding_parties about the access_type
2729: -- Any supplier who was restricted on the deleted lines
2730: -- should now have access_type set to FULL
2731: UPDATE
2732: pon_bidding_parties
2733: SET
2734: access_type = 'FULL'
2735: WHERE
2736: auction_header_id = p_auction_header_id AND