APPS.AMS_APPR_HIST_PVT dependencies on AMS_APPROVAL_HISTORY

Line 281: FROM AMS_APPROVAL_HISTORY

277:
278:
279: CURSOR c_get_appr_hist IS
280: SELECT *
281: FROM AMS_APPROVAL_HISTORY
282: WHERE object_id = p_appr_hist_rec.object_id
283: AND object_type_code = p_appr_hist_rec.object_type_code
284: AND approval_type = p_appr_hist_rec.approval_type
285: AND sequence_num = p_appr_hist_rec.sequence_num;

Line 610: 'ams_approval_history',

606: IF p_validation_mode = JTF_PLSQL_API.g_create
607: AND p_appr_hist_rec.object_id IS NOT NULL
608: THEN
609: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
610: 'ams_approval_history',
611: 'object_id = ''' || p_appr_hist_rec.object_id ||''''
612: );
613: END IF;
614:

Line 780: FROM ams_approval_history

776: l_return_status VARCHAR2(1);
777:
778: CURSOR c_complete IS
779: SELECT *
780: FROM ams_approval_history
781: WHERE object_id = p_appr_hist_rec.object_id;
782: l_appr_hist_rec c_complete%ROWTYPE;
783: BEGIN
784: x_complete_rec := p_appr_hist_rec;