APPS.ASO_APR_APPROVALS_PKG dependencies on ASO_APR_RULES

Line 1570: INSERT INTO aso_apr_rules

1566: OPEN c2;
1567: FETCH c2 INTO px_rule_id;
1568: CLOSE c2;
1569: --End If;
1570: INSERT INTO aso_apr_rules
1571: (rule_id,
1572: oam_rule_id,
1573: rule_action_id,
1574: creation_date,

Line 1843: UPDATE aso_apr_rules

1839: 'N'
1840: );
1841: END IF;
1842:
1843: UPDATE aso_apr_rules
1844: SET rule_id = p_rule_id,
1845: oam_rule_id = DECODE (
1846: p_oam_rule_id,
1847: fnd_api.g_miss_num,

Line 2078: FROM aso_apr_rules

2074: object_approval_id, attribute1, attribute2, attribute3, attribute4,
2075: attribute5, attribute6, attribute7, attribute8, attribute9,
2076: attribute10, attribute11, attribute12, attribute13, attribute14,
2077: attribute15, CONTEXT, security_group_id, object_version_number
2078: FROM aso_apr_rules
2079: WHERE rule_id = p_rule_id
2080: FOR UPDATE OF rule_id NOWAIT;
2081:
2082: recinfo c%ROWTYPE;

Line 2143: DELETE FROM aso_apr_rules

2139: 'N'
2140: );
2141: END IF;
2142:
2143: DELETE FROM aso_apr_rules
2144: WHERE rule_id = p_rule_id;
2145:
2146: IF (SQL%NOTFOUND)
2147: THEN