APPS.ASO_APR_APPROVALS_PKG dependencies on ASO_APR_APPROVAL_DETAILS

Line 837: INSERT INTO aso_apr_approval_details

833: FETCH c2 INTO px_approval_det_id;
834: CLOSE c2;
835: END IF;
836:
837: INSERT INTO aso_apr_approval_details
838: (approval_det_id,
839: object_approval_id,
840: approver_person_id,
841: approver_user_id,

Line 1155: UPDATE aso_apr_approval_details

1151: 'N'
1152: );
1153: END IF;
1154:
1155: UPDATE aso_apr_approval_details
1156: SET approval_det_id = DECODE (
1157: p_approval_det_id,
1158: fnd_api.g_miss_num,
1159: approval_det_id,

Line 1437: FROM aso_apr_approval_details

1433: attribute1, attribute2, attribute3, attribute4, attribute5, attribute6,
1434: attribute7, attribute8, attribute9, attribute10, attribute11,
1435: attribute12, attribute13, attribute14, attribute15, CONTEXT,
1436: security_group_id, object_version_number
1437: FROM aso_apr_approval_details
1438: WHERE approval_det_id = p_approval_det_id
1439: FOR UPDATE OF approval_det_id NOWAIT;
1440:
1441: recinfo c%ROWTYPE;

Line 1502: DELETE FROM aso_apr_approval_details

1498: 'N'
1499: );
1500: END IF;
1501:
1502: DELETE FROM aso_apr_approval_details
1503: WHERE approval_det_id = p_approval_det_id;
1504:
1505: IF (SQL%NOTFOUND)
1506: THEN