APPS.PON_MULTIPLE_RESPONSE_PKG dependencies on PON_CONTRACTS

Line 137: l_org_contract_status pon_contracts.contract_status%TYPE;

133: l_orig_amend_id pon_auction_headers_all.auction_header_id%TYPE;
134: l_terms_cond_apply VARCHAR2(1);
135: l_bid_count NUMBER;
136: -- for the bug 13984944
137: l_org_contract_status pon_contracts.contract_status%TYPE;
138: l_enabled_flag pon_contracts.enabled_flag%TYPE;
139: l_org_id pon_auction_headers_all.org_id%TYPE;
140: l_count_org NUMBER;
141:

Line 138: l_enabled_flag pon_contracts.enabled_flag%TYPE;

134: l_terms_cond_apply VARCHAR2(1);
135: l_bid_count NUMBER;
136: -- for the bug 13984944
137: l_org_contract_status pon_contracts.contract_status%TYPE;
138: l_enabled_flag pon_contracts.enabled_flag%TYPE;
139: l_org_id pon_auction_headers_all.org_id%TYPE;
140: l_count_org NUMBER;
141:
142: -- select bids on all amendments/previous round by the current user for the current site

Line 196: FROM pon_contracts

192: ELSE
193: -- for the bug 13984944
194: SELECT Count(*)
195: INTO l_count_org
196: FROM pon_contracts
197: WHERE NVL(org_id,-1) = l_org_id ;
198:
199: -- if terms and conditions not defined for the current operating unit set l_org_id to global.
200: IF(l_count_org = 0) THEN l_org_id := -1;

Line 205: FROM pon_contracts

201: ELSE
202: -- get the contract status for the current Operating Unit.
203: SELECT NVL(contract_status,'ACTIVE')
204: INTO l_org_contract_status
205: FROM pon_contracts
206: WHERE NVL(org_id,-1) = l_org_id
207: AND version_num = (select max(version_num) from pon_contracts where NVL(org_id,-1) = l_org_id);
208:
209: -- If the status is not Active set l_org_id global

Line 207: AND version_num = (select max(version_num) from pon_contracts where NVL(org_id,-1) = l_org_id);

203: SELECT NVL(contract_status,'ACTIVE')
204: INTO l_org_contract_status
205: FROM pon_contracts
206: WHERE NVL(org_id,-1) = l_org_id
207: AND version_num = (select max(version_num) from pon_contracts where NVL(org_id,-1) = l_org_id);
208:
209: -- If the status is not Active set l_org_id global
210: IF(l_org_contract_status <> 'ACTIVE') THEN
211: l_org_id := -1;

Line 215: -- check for any rows existance in pon_contracts table for l_org_id

211: l_org_id := -1;
212: END IF;
213: END IF;
214:
215: -- check for any rows existance in pon_contracts table for l_org_id
216:
217: SELECT Count(*)
218: INTO l_count_org
219: FROM pon_contracts

Line 219: FROM pon_contracts

215: -- check for any rows existance in pon_contracts table for l_org_id
216:
217: SELECT Count(*)
218: INTO l_count_org
219: FROM pon_contracts
220: WHERE NVL(org_id,-1) = l_org_id ;
221:
222: IF(l_count_org = 0) THEN l_enabled_flag := 'N';
223: ELSE

Line 227: FROM pon_contracts pc

223: ELSE
224: -- Check the enbled_flag for the Max Version Num of l_org_id
225: SELECT enabled_flag
226: INTO l_enabled_flag
227: FROM pon_contracts pc
228: WHERE NVL(org_id,-1) = l_org_id
229: AND version_num = (select max(version_num) from pon_contracts where NVL(org_id,-1) = l_org_id);
230: END IF;
231:

Line 229: AND version_num = (select max(version_num) from pon_contracts where NVL(org_id,-1) = l_org_id);

225: SELECT enabled_flag
226: INTO l_enabled_flag
227: FROM pon_contracts pc
228: WHERE NVL(org_id,-1) = l_org_id
229: AND version_num = (select max(version_num) from pon_contracts where NVL(org_id,-1) = l_org_id);
230: END IF;
231:
232: -- Creating fresh bid.
233: -- User must accept terms and conditions if contracts installed.