APPS.AHL_WARRANTY_UTILS_PVT dependencies on AHL_WARRANTY_CONTRACTS_B

Line 102: FROM ahl_warranty_contracts_b

98: --fetch Start and End date, OVN, item_instance_id and expiry type for the Contract
99: CURSOR get_cont_details (c_warranty_contract_id IN NUMBER)
100: IS
101: SELECT active_start_date, active_end_date, contract_expiry_type,object_version_number,item_instance_id
102: FROM ahl_warranty_contracts_b
103: WHERE warranty_contract_id = c_warranty_contract_id
104: FOR UPDATE of expiration_date ;
105:
106:

Line 255: 'Before updating a row in AHL_WARRANTY_CONTRACTS_B. where contract id = '|| l_warranty_contract_id ||' and new expiration date = '|| l_exp_date

251: IF (l_log_statement >= l_log_current_level)THEN
252: fnd_log.string(
253: l_log_statement,
254: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
255: 'Before updating a row in AHL_WARRANTY_CONTRACTS_B. where contract id = '|| l_warranty_contract_id ||' and new expiration date = '|| l_exp_date
256: );
257: END IF;
258:
259: UPDATE AHL_WARRANTY_CONTRACTS_B SET EXPIRATION_DATE = l_exp_date,

Line 259: UPDATE AHL_WARRANTY_CONTRACTS_B SET EXPIRATION_DATE = l_exp_date,

255: 'Before updating a row in AHL_WARRANTY_CONTRACTS_B. where contract id = '|| l_warranty_contract_id ||' and new expiration date = '|| l_exp_date
256: );
257: END IF;
258:
259: UPDATE AHL_WARRANTY_CONTRACTS_B SET EXPIRATION_DATE = l_exp_date,
260: OBJECT_VERSION_NUMBER = l_cont_ovn+1,
261: LAST_UPDATE_DATE = sysdate,
262: LAST_UPDATED_BY = l_user_id,
263: LAST_UPDATE_LOGIN = l_login_id,

Line 349: FROM ahl_warranty_contracts_b;

345: --fetch all the Contracts in Active Status.
346: CURSOR get_active_cont_ids
347: IS
348: SELECT warranty_contract_id
349: FROM ahl_warranty_contracts_b;
350: --WHERE contract_status_code = 'ACTIVE';
351:
352: BEGIN
353: