APPS.AHL_WARRANTY_UTILS_PVT dependencies on AHL_WARRANTY_TEMPLATES_B

Line 504: FROM ahl_warranty_templates_b

500: --fetch Enabled Templates from template table
501: CURSOR disable_templates_csr
502: IS
503: SELECT warranty_template_id,object_version_number,enabled_flag
504: FROM ahl_warranty_templates_b
505: WHERE SYSDATE > nvl(active_end_date,SYSDATE)
506: AND enabled_flag = 'Y'
507: FOR UPDATE of enabled_flag ;
508:

Line 545: fnd_file.put_line(fnd_file.log, 'before updating table AHL_WARRANTY_TEMPLATES_B, rows = ' || csrTbl.COUNT );

541:
542: l_user_id := to_number(fnd_global.USER_ID);
543: l_login_id := to_number(fnd_global.LOGIN_ID);
544:
545: fnd_file.put_line(fnd_file.log, 'before updating table AHL_WARRANTY_TEMPLATES_B, rows = ' || csrTbl.COUNT );
546:
547: FOR i IN 1..csrTbl.COUNT
548: LOOP
549: UPDATE AHL_WARRANTY_TEMPLATES_B SET ENABLED_FLAG = 'N',

Line 549: UPDATE AHL_WARRANTY_TEMPLATES_B SET ENABLED_FLAG = 'N',

545: fnd_file.put_line(fnd_file.log, 'before updating table AHL_WARRANTY_TEMPLATES_B, rows = ' || csrTbl.COUNT );
546:
547: FOR i IN 1..csrTbl.COUNT
548: LOOP
549: UPDATE AHL_WARRANTY_TEMPLATES_B SET ENABLED_FLAG = 'N',
550: OBJECT_VERSION_NUMBER = csrTbl(i).object_version_number+1,
551: LAST_UPDATE_DATE = SYSDATE,
552: LAST_UPDATED_BY = l_user_id,
553: LAST_UPDATE_LOGIN = l_login_id,

Line 559: fnd_file.put_line(fnd_file.log, 'After updating table AHL_WARRANTY_TEMPLATES_B successfully');

555: WHERE WARRANTY_TEMPLATE_ID = csrTbl(i).warranty_template_id;
556:
557: END LOOP;
558:
559: fnd_file.put_line(fnd_file.log, 'After updating table AHL_WARRANTY_TEMPLATES_B successfully');
560:
561: -- set the output
562: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Successfully disables '|| csrTbl.COUNT ||' Warranty Templates having end date less than '||sysdate);
563:

Line 647: FROM ahl_warranty_templates_b

643: --fetch Vendor ID record from the template table
644: CURSOR update_enabled_flag_csr (c_vendor_id IN NUMBER)
645: IS
646: SELECT warranty_template_id,warranty_vendor_id,object_version_number,enabled_flag
647: FROM ahl_warranty_templates_b
648: WHERE warranty_vendor_id = c_vendor_id
649: FOR UPDATE of enabled_flag ;
650: */
651:

Line 700: UPDATE AHL_WARRANTY_TEMPLATES_B SET ENABLED_FLAG = 'N',

696: END IF;
697:
698: -- Logic
699: FORALL i in p_warranty_vendor_id_tbl.first .. p_warranty_vendor_id_tbl.last
700: UPDATE AHL_WARRANTY_TEMPLATES_B SET ENABLED_FLAG = 'N',
701: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
702: LAST_UPDATE_DATE = sysdate,
703: LAST_UPDATED_BY = l_user_id,
704: LAST_UPDATE_LOGIN = l_login_id

Line 715: UPDATE AHL_WARRANTY_TEMPLATES_B SET ENABLED_FLAG = 'N',

711: FOR csr_index in update_enabled_flag_csr(p_warranty_vendor_id)
712: LOOP
713:
714:
715: UPDATE AHL_WARRANTY_TEMPLATES_B SET ENABLED_FLAG = 'N',
716: OBJECT_VERSION_NUMBER = csr_index.object_version_number+1,
717: LAST_UPDATE_DATE = sysdate,
718: LAST_UPDATED_BY = l_user_id,
719: LAST_UPDATE_LOGIN = l_login_id,