APPS.AHL_PRD_DF_APPR_PVT dependencies on AHL_UNIT_DEFERRALS_B

Line 47: SELECT unit_effectivity_id from ahl_unit_deferrals_b

43: l_df_header_info_rec AHL_PRD_DF_PVT.df_header_info_rec_type;
44: l_df_schedules_tbl AHL_PRD_DF_PVT.df_schedules_tbl_type;
45:
46: CURSOR unit_effectivity_id_csr(p_unit_deferral_id IN NUMBER) IS
47: SELECT unit_effectivity_id from ahl_unit_deferrals_b
48: WHERE unit_deferral_id = p_unit_deferral_id;
49:
50: l_unit_effectivity_id NUMBER;
51:

Line 1162: SELECT unit_effectivity_id from ahl_unit_deferrals_b

1158: l_return_status VARCHAR2(1);
1159: l_approver_note VARCHAR2(4000);
1160:
1161: CURSOR unit_effectivity_id_csr(p_unit_deferral_id IN NUMBER) IS
1162: SELECT unit_effectivity_id from ahl_unit_deferrals_b
1163: WHERE unit_deferral_id = p_unit_deferral_id;
1164:
1165: l_unit_effectivity_id NUMBER;
1166:

Line 1404: UPDATE AHL_UNIT_DEFERRALS_B

1400: SET approver_notes = substrb(l_error_msg,1,4000)
1401: WHERE unit_deferral_id = l_object_id
1402: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1403:
1404: UPDATE AHL_UNIT_DEFERRALS_B
1405: SET approval_status_code = 'DEFERRAL_REJECTED',
1406: object_version_number = object_version_number + 1,
1407: last_update_date = sysdate,
1408: last_updated_by = fnd_global.user_id,

Line 1425: UPDATE AHL_UNIT_DEFERRALS_B

1421: SET approver_notes = substrb(l_error_msg,1,4000)
1422: WHERE unit_deferral_id = l_object_id
1423: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1424:
1425: UPDATE AHL_UNIT_DEFERRALS_B
1426: SET approval_status_code = 'DEFERRAL_REJECTED',
1427: object_version_number = object_version_number + 1,
1428: last_update_date = sysdate,
1429: last_updated_by = fnd_global.user_id,

Line 1570: UPDATE AHL_UNIT_DEFERRALS_B

1566: SET approver_notes = substrb(l_error_msg,1,4000)
1567: WHERE unit_deferral_id = l_object_id
1568: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1569:
1570: UPDATE AHL_UNIT_DEFERRALS_B
1571: SET approval_status_code = 'DEFERRAL_REJECTED',
1572: object_version_number = object_version_number + 1,
1573: last_update_date = sysdate,
1574: last_updated_by = fnd_global.user_id,

Line 1591: UPDATE AHL_UNIT_DEFERRALS_B

1587: SET approver_notes = substrb(l_error_msg,1,4000)
1588: WHERE unit_deferral_id = l_object_id
1589: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1590:
1591: UPDATE AHL_UNIT_DEFERRALS_B
1592: SET approval_status_code = 'DEFERRAL_REJECTED',
1593: object_version_number = object_version_number + 1,
1594: last_update_date = sysdate,
1595: last_updated_by = fnd_global.user_id,