APPS.AHL_WARRANTY_CONTRACTS_PVT dependencies on AHL_WARRANTY_CONT_CTR_B

Line 560: l_warranty_cont_ctr_id := AHL_WARRANTY_CONT_CTR_B_S.NEXTVAL;

556: OPEN warranty_contract_counter_csr(p_warranty_template_id, p_item_instance_id);
557: LOOP
558: FETCH warranty_contract_counter_csr INTO warranty_contract_counter_rec ;
559: EXIT WHEN warranty_contract_counter_csr%NOTFOUND;
560: l_warranty_cont_ctr_id := AHL_WARRANTY_CONT_CTR_B_S.NEXTVAL;
561:
562: INSERT INTO AHL_WARRANTY_CONT_CTR_B
563: (
564: WARRANTY_CNTRT_COUNTER_ID,

Line 562: INSERT INTO AHL_WARRANTY_CONT_CTR_B

558: FETCH warranty_contract_counter_csr INTO warranty_contract_counter_rec ;
559: EXIT WHEN warranty_contract_counter_csr%NOTFOUND;
560: l_warranty_cont_ctr_id := AHL_WARRANTY_CONT_CTR_B_S.NEXTVAL;
561:
562: INSERT INTO AHL_WARRANTY_CONT_CTR_B
563: (
564: WARRANTY_CNTRT_COUNTER_ID,
565: OBJECT_VERSION_NUMBER,
566: LAST_UPDATE_DATE,

Line 956: from AHL_WARRANTY_CONT_CTR_B B

952: -- for table AHL_WARRANTY_CONT_CTR_TL
953: delete from AHL_WARRANTY_CONT_CTR_TL T
954: where not exists
955: (select NULL
956: from AHL_WARRANTY_CONT_CTR_B B
957: where B.WARRANTY_CNTRT_COUNTER_ID = T.WARRANTY_CNTRT_COUNTER_ID
958: );
959:
960: update AHL_WARRANTY_CONT_CTR_TL T set (