APPS.ASO_APR_APPROVALS_PKG dependencies on ASO_APR_OBJ_APPROVALS

Line 70: INSERT INTO aso_apr_obj_approvals

66: OPEN c2;
67: FETCH c2 INTO px_object_approval_id;
68: CLOSE c2;
69:
70: INSERT INTO aso_apr_obj_approvals
71: (object_approval_id,
72: object_id,
73: object_type,
74: approval_instance_id,

Line 418: UPDATE aso_apr_obj_approvals

414: 'N'
415: );
416: END IF;
417:
418: UPDATE aso_apr_obj_approvals
419: SET object_id = DECODE (
420: p_object_id,
421: fnd_api.g_miss_num,
422: object_id,

Line 663: DELETE FROM aso_apr_obj_approvals

659: 'N'
660: );
661: END IF;
662:
663: DELETE FROM aso_apr_obj_approvals
664: WHERE object_approval_id = p_object_approval_id;
665:
666: IF (SQL%NOTFOUND)
667: THEN

Line 725: FROM aso_apr_obj_approvals

721: attribute8, attribute9, attribute10, attribute11, attribute12,
722: attribute13, attribute14, attribute15, CONTEXT, security_group_id,
723: object_version_number, requester_userid, requester_comments,
724: requester_group_id
725: FROM aso_apr_obj_approvals
726: WHERE object_approval_id = p_object_approval_id
727: FOR UPDATE OF object_approval_id NOWAIT;
728:
729: recinfo c%ROWTYPE;