APPS.PA_CONTROL_ITEMS_PVT dependencies on PA_OBJECT_RELATIONSHIPS

Line 1314: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

1310:
1311: end if;
1312:
1313: if (x_return_status = 'S') then
1314: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
1315: p_user_id => fnd_global.user_id,
1316: p_object_type_from => 'PA_CONTROL_ITEMS',
1317: p_object_id_from1 => to_char(p_from_ci_id),
1318: p_object_id_from2 => NULL,

Line 1951: FROM pa_object_relationships obj, pa_control_items ci

1947:
1948: CURSOR items_c IS
1949: SELECT obj.object_id_to1 included_ci_id
1950: ,ci.record_version_number record_version_number
1951: FROM pa_object_relationships obj, pa_control_items ci
1952: WHERE obj.object_type_from = 'PA_CONTROL_ITEMS'
1953: AND obj.object_type_to = 'PA_CONTROL_ITEMS'
1954: AND obj.relationship_type = 'CI_INCLUDED_ITEM'
1955: AND obj.object_id_from1 = p_ci_id

Line 2016: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

2012: IF p_validate_only = FND_API.G_TRUE THEN
2013: RETURN;
2014: END IF;
2015:
2016: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
2017: p_user_id => fnd_global.user_id,
2018: p_object_type_from => 'PA_CONTROL_ITEMS',
2019: p_object_id_from1 => to_char(p_ci_id),
2020: p_object_id_from2 => NULL,

Line 2100: FROM pa_object_relationships

2096: x_msg_data := '';
2097:
2098: SELECT object_relationship_id, record_version_number
2099: INTO l_object_relationship_id, l_record_version_number
2100: FROM pa_object_relationships
2101: WHERE object_type_from = 'PA_CONTROL_ITEMS'
2102: AND relationship_type = 'CI_REFERENCED_ITEM'
2103: AND object_type_to = 'PA_CONTROL_ITEMS'
2104: AND ( ( object_id_to1 = p_related_ci_id

Line 2113: pa_object_relationships_pkg.delete_row(

2109: IF p_validate_only = FND_API.G_TRUE THEN
2110: RETURN;
2111: END IF;
2112:
2113: pa_object_relationships_pkg.delete_row(
2114: p_object_relationship_id => l_object_relationship_id,
2115: p_object_type_from => 'PA_CONTROL_ITEMS',
2116: p_object_id_from1 => to_char(p_ci_id),
2117: p_object_id_from2 => NULL,

Line 2173: FROM pa_object_relationships

2169: )
2170: IS
2171: CURSOR items_c IS
2172: SELECT object_id_to1 related_ci_id
2173: FROM pa_object_relationships
2174: WHERE object_type_from = 'PA_CONTROL_ITEMS'
2175: AND object_type_to = 'PA_CONTROL_ITEMS'
2176: AND relationship_type = 'CI_REFERENCED_ITEM'
2177: AND object_id_from1 = p_ci_id

Line 2180: FROM pa_object_relationships

2176: AND relationship_type = 'CI_REFERENCED_ITEM'
2177: AND object_id_from1 = p_ci_id
2178: UNION ALL
2179: SELECT object_id_from1 related_ci_id
2180: FROM pa_object_relationships
2181: WHERE object_type_from = 'PA_CONTROL_ITEMS'
2182: AND object_type_to = 'PA_CONTROL_ITEMS'
2183: AND relationship_type = 'CI_REFERENCED_ITEM'
2184: AND object_id_to1 = p_ci_id;

Line 2263: FROM pa_object_relationships

2259: )
2260: IS
2261: CURSOR items_c IS
2262: SELECT object_relationship_id, object_id_to1, record_version_number
2263: FROM pa_object_relationships
2264: WHERE object_type_from = 'PA_CONTROL_ITEMS'
2265: AND object_type_to = 'PA_CONTROL_ITEMS'
2266: AND relationship_type = 'CI_INCLUDED_ITEM'
2267: AND object_id_from1 = p_ci_id;

Line 2290: pa_object_relationships_pkg.delete_row(

2286: END IF;
2287:
2288: FOR cur in items_c LOOP
2289:
2290: pa_object_relationships_pkg.delete_row(
2291: p_object_relationship_id => cur.object_relationship_id,
2292: p_object_type_from => 'PA_CONTROL_ITEMS',
2293: p_object_id_from1 => to_char(p_ci_id),
2294: p_object_id_from2 => NULL,

Line 2353: FROM pa_object_relationships

2349: )
2350: IS
2351: CURSOR items_c IS
2352: SELECT object_id_to1 related_ci_id
2353: FROM pa_object_relationships
2354: WHERE object_type_from = 'PA_CONTROL_ITEMS'
2355: AND object_type_to = 'PA_CONTROL_ITEMS'
2356: AND relationship_type = 'CI_REFERENCED_ITEM'
2357: AND object_id_from1 = p_from_ci_id

Line 2360: FROM pa_object_relationships

2356: AND relationship_type = 'CI_REFERENCED_ITEM'
2357: AND object_id_from1 = p_from_ci_id
2358: UNION ALL
2359: SELECT object_id_from1 related_ci_id
2360: FROM pa_object_relationships
2361: WHERE object_type_from = 'PA_CONTROL_ITEMS'
2362: AND object_type_to = 'PA_CONTROL_ITEMS'
2363: AND relationship_type = 'CI_REFERENCED_ITEM'
2364: AND object_id_to1 = p_from_ci_id;