APPS.ASO_APR_APPROVALS_PKG dependencies on ASO_APR_RULES

Line 1651: INSERT INTO aso_apr_rules

1647: OPEN c2;
1648: FETCH c2 INTO px_rule_id;
1649: CLOSE c2;
1650: --End If;
1651: INSERT INTO aso_apr_rules
1652: (rule_id,
1653: oam_rule_id,
1654: rule_action_id,
1655: creation_date,

Line 1924: UPDATE aso_apr_rules

1920: 'N'
1921: );
1922: END IF;
1923:
1924: UPDATE aso_apr_rules
1925: SET rule_id = p_rule_id,
1926: oam_rule_id = DECODE (
1927: p_oam_rule_id,
1928: fnd_api.g_miss_num,

Line 2159: FROM aso_apr_rules

2155: object_approval_id, attribute1, attribute2, attribute3, attribute4,
2156: attribute5, attribute6, attribute7, attribute8, attribute9,
2157: attribute10, attribute11, attribute12, attribute13, attribute14,
2158: attribute15, CONTEXT, security_group_id, object_version_number
2159: FROM aso_apr_rules
2160: WHERE rule_id = p_rule_id
2161: FOR UPDATE OF rule_id NOWAIT;
2162:
2163: recinfo c%ROWTYPE;

Line 2224: DELETE FROM aso_apr_rules

2220: 'N'
2221: );
2222: END IF;
2223:
2224: DELETE FROM aso_apr_rules
2225: WHERE rule_id = p_rule_id;
2226:
2227: IF (SQL%NOTFOUND)
2228: THEN