APPS.ASO_APR_APPROVALS_PKG dependencies on ASO_APR_APPROVAL_DETAILS

Line 846: INSERT INTO aso_apr_approval_details

842: FETCH c2 INTO px_approval_det_id;
843: CLOSE c2;
844: END IF;
845:
846: INSERT INTO aso_apr_approval_details
847: (approval_det_id,
848: object_approval_id,
849: approver_person_id,
850: approver_user_id,

Line 1236: UPDATE aso_apr_approval_details

1232: 'N'
1233: );
1234: END IF;
1235:
1236: UPDATE aso_apr_approval_details
1237: SET approval_det_id = DECODE (
1238: p_approval_det_id,
1239: fnd_api.g_miss_num,
1240: approval_det_id,

Line 1518: FROM aso_apr_approval_details

1514: attribute1, attribute2, attribute3, attribute4, attribute5, attribute6,
1515: attribute7, attribute8, attribute9, attribute10, attribute11,
1516: attribute12, attribute13, attribute14, attribute15, CONTEXT,
1517: security_group_id, object_version_number
1518: FROM aso_apr_approval_details
1519: WHERE approval_det_id = p_approval_det_id
1520: FOR UPDATE OF approval_det_id NOWAIT;
1521:
1522: recinfo c%ROWTYPE;

Line 1583: DELETE FROM aso_apr_approval_details

1579: 'N'
1580: );
1581: END IF;
1582:
1583: DELETE FROM aso_apr_approval_details
1584: WHERE approval_det_id = p_approval_det_id;
1585:
1586: IF (SQL%NOTFOUND)
1587: THEN