APPS.AMS_DELIVERABLERULES_PVT dependencies on AMS_DELIVERABLES_ALL_B

Line 39: FROM ams_deliverables_all_b

35:
36: CURSOR c_custom_setup
37: IS
38: SELECT custom_setup_id
39: FROM ams_deliverables_all_b
40: WHERE deliverable_id = p_deliverable_id;
41:
42:
43: l_flag VARCHAR2(1) := 'N';

Line 140: FROM ams_deliverables_all_b

136:
137: CURSOR c_old_status IS
138: SELECT user_status_id, object_version_number,
139: status_code,custom_setup_id
140: FROM ams_deliverables_all_b
141: WHERE deliverable_id = p_deliverable_id;
142:
143: CURSOR c_budget_exist IS
144: SELECT 1

Line 319: UPDATE ams_deliverables_all_b

315:
316: END IF; --if deliverable is a content item
317: END IF; -- if new status code is "AVAILABLE"
318:
319: UPDATE ams_deliverables_all_b
320: SET user_status_id = p_new_status_id,
321: status_code = p_new_status_code,
322: status_date = SYSDATE,
323: private_flag = DECODE(p_new_status_code,'AVAILABLE','N',private_flag)