APPS.PON_BID_DEFAULTING_PKG dependencies on PON_CONTRACTS

Line 4409: l_org_contract_status pon_contracts.contract_status%TYPE;

4405: l_terms_cond_apply VARCHAR2(1);
4406:
4407: l_ignored_return pon_bid_headers.bid_number%TYPE;
4408: -- for the bug 13984944
4409: l_org_contract_status pon_contracts.contract_status%TYPE;
4410: l_enabled_flag pon_contracts.enabled_flag%TYPE;
4411: l_org_id pon_auction_headers_all.org_id%TYPE;
4412: l_count_org NUMBER;
4413:

Line 4410: l_enabled_flag pon_contracts.enabled_flag%TYPE;

4406:
4407: l_ignored_return pon_bid_headers.bid_number%TYPE;
4408: -- for the bug 13984944
4409: l_org_contract_status pon_contracts.contract_status%TYPE;
4410: l_enabled_flag pon_contracts.enabled_flag%TYPE;
4411: l_org_id pon_auction_headers_all.org_id%TYPE;
4412: l_count_org NUMBER;
4413:
4414: -- select bids on all amendments/previous round by the current user for the current site

Line 4660: FROM pon_contracts

4656: -- for the bug 13984944
4657: -- add NVL condition to org_id & contract_status columns
4658: SELECT Count(*)
4659: INTO l_count_org
4660: FROM pon_contracts
4661: WHERE NVL(org_id,-1) = l_org_id ;
4662:
4663: -- if terms and conditions not defined for the current operating unit set l_org_id to global.
4664: IF(l_count_org = 0) THEN l_org_id := -1;

Line 4669: FROM pon_contracts

4665: ELSE
4666: -- get the contract status for the current Operating Unit.
4667: SELECT NVL(contract_status,'ACTIVE')
4668: INTO l_org_contract_status
4669: FROM pon_contracts
4670: WHERE NVL(org_id,-1) = l_org_id
4671: AND version_num = (select max(version_num) from pon_contracts where NVL(org_id,-1) = l_org_id);
4672:
4673: -- If the status is not Active set l_org_id global

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

4667: SELECT NVL(contract_status,'ACTIVE')
4668: INTO l_org_contract_status
4669: FROM pon_contracts
4670: WHERE NVL(org_id,-1) = l_org_id
4671: AND version_num = (select max(version_num) from pon_contracts where NVL(org_id,-1) = l_org_id);
4672:
4673: -- If the status is not Active set l_org_id global
4674: IF(l_org_contract_status <> 'ACTIVE') THEN
4675: l_org_id := -1;

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

4675: l_org_id := -1;
4676: END IF;
4677: END IF;
4678:
4679: -- check for any rows existance in pon_contracts table for l_org_id
4680:
4681: SELECT Count(*)
4682: INTO l_count_org
4683: FROM pon_contracts

Line 4683: FROM pon_contracts

4679: -- check for any rows existance in pon_contracts table for l_org_id
4680:
4681: SELECT Count(*)
4682: INTO l_count_org
4683: FROM pon_contracts
4684: WHERE NVL(org_id,-1) = l_org_id ;
4685:
4686: IF(l_count_org = 0) THEN l_enabled_flag := 'N';
4687: ELSE

Line 4691: FROM pon_contracts pc

4687: ELSE
4688: -- Check the enbled_flag for the Max Version Num of l_org_id
4689: SELECT enabled_flag
4690: INTO l_enabled_flag
4691: FROM pon_contracts pc
4692: WHERE NVL(org_id,-1) = l_org_id
4693: AND version_num = (select max(version_num) from pon_contracts where NVL(org_id,-1) = l_org_id);
4694: END IF;
4695:

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

4689: SELECT enabled_flag
4690: INTO l_enabled_flag
4691: FROM pon_contracts pc
4692: WHERE NVL(org_id,-1) = l_org_id
4693: AND version_num = (select max(version_num) from pon_contracts where NVL(org_id,-1) = l_org_id);
4694: END IF;
4695:
4696: -- Creating fresh bid.
4697: -- User must accept terms and conditions if contracts installed.