eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CONTROL_ITEMS_PVT dependencies on PA_OBJECT_RELATIONSHIPS

Line 1447: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

1443:
1444: end if;
1445:
1446: if (x_return_status = 'S') then
1447: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
1448: p_user_id => fnd_global.user_id,
1449: p_object_type_from => 'PA_CONTROL_ITEMS',
1450: p_object_id_from1 => to_char(p_from_ci_id),
1451: p_object_id_from2 => NULL,

Line 2116: FROM pa_object_relationships obj, pa_control_items ci

2112:
2113: CURSOR items_c IS
2114: SELECT obj.object_id_to1 included_ci_id
2115: ,ci.record_version_number record_version_number
2116: FROM pa_object_relationships obj, pa_control_items ci
2117: WHERE obj.object_type_from = 'PA_CONTROL_ITEMS'
2118: AND obj.object_type_to = 'PA_CONTROL_ITEMS'
2119: AND obj.relationship_type = 'CI_INCLUDED_ITEM'
2120: AND obj.object_id_from1 = p_ci_id

Line 2181: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

2177: IF p_validate_only = FND_API.G_TRUE THEN
2178: RETURN;
2179: END IF;
2180:
2181: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
2182: p_user_id => fnd_global.user_id,
2183: p_object_type_from => 'PA_CONTROL_ITEMS',
2184: p_object_id_from1 => to_char(p_ci_id),
2185: p_object_id_from2 => NULL,

Line 2265: FROM pa_object_relationships

2261: x_msg_data := '';
2262:
2263: SELECT object_relationship_id, record_version_number
2264: INTO l_object_relationship_id, l_record_version_number
2265: FROM pa_object_relationships
2266: WHERE object_type_from = 'PA_CONTROL_ITEMS'
2267: AND relationship_type = 'CI_REFERENCED_ITEM'
2268: AND object_type_to = 'PA_CONTROL_ITEMS'
2269: AND ( ( object_id_to1 = p_related_ci_id

Line 2278: pa_object_relationships_pkg.delete_row(

2274: IF p_validate_only = FND_API.G_TRUE THEN
2275: RETURN;
2276: END IF;
2277:
2278: pa_object_relationships_pkg.delete_row(
2279: p_object_relationship_id => l_object_relationship_id,
2280: p_object_type_from => 'PA_CONTROL_ITEMS',
2281: p_object_id_from1 => to_char(p_ci_id),
2282: p_object_id_from2 => NULL,

Line 2338: FROM pa_object_relationships

2334: )
2335: IS
2336: CURSOR items_c IS
2337: SELECT object_id_to1 related_ci_id
2338: FROM pa_object_relationships
2339: WHERE object_type_from = 'PA_CONTROL_ITEMS'
2340: AND object_type_to = 'PA_CONTROL_ITEMS'
2341: AND relationship_type = 'CI_REFERENCED_ITEM'
2342: AND object_id_from1 = p_ci_id

Line 2345: FROM pa_object_relationships

2341: AND relationship_type = 'CI_REFERENCED_ITEM'
2342: AND object_id_from1 = p_ci_id
2343: UNION ALL
2344: SELECT object_id_from1 related_ci_id
2345: FROM pa_object_relationships
2346: WHERE object_type_from = 'PA_CONTROL_ITEMS'
2347: AND object_type_to = 'PA_CONTROL_ITEMS'
2348: AND relationship_type = 'CI_REFERENCED_ITEM'
2349: AND object_id_to1 = p_ci_id;

Line 2428: FROM pa_object_relationships

2424: )
2425: IS
2426: CURSOR items_c IS
2427: SELECT object_relationship_id, object_id_to1, record_version_number
2428: FROM pa_object_relationships
2429: WHERE object_type_from = 'PA_CONTROL_ITEMS'
2430: AND object_type_to = 'PA_CONTROL_ITEMS'
2431: AND relationship_type = 'CI_INCLUDED_ITEM'
2432: AND object_id_from1 = p_ci_id;

Line 2455: pa_object_relationships_pkg.delete_row(

2451: END IF;
2452:
2453: FOR cur in items_c LOOP
2454:
2455: pa_object_relationships_pkg.delete_row(
2456: p_object_relationship_id => cur.object_relationship_id,
2457: p_object_type_from => 'PA_CONTROL_ITEMS',
2458: p_object_id_from1 => to_char(p_ci_id),
2459: p_object_id_from2 => NULL,

Line 2518: FROM pa_object_relationships

2514: )
2515: IS
2516: CURSOR items_c IS
2517: SELECT object_id_to1 related_ci_id
2518: FROM pa_object_relationships
2519: WHERE object_type_from = 'PA_CONTROL_ITEMS'
2520: AND object_type_to = 'PA_CONTROL_ITEMS'
2521: AND relationship_type = 'CI_REFERENCED_ITEM'
2522: AND object_id_from1 = p_from_ci_id

Line 2525: FROM pa_object_relationships

2521: AND relationship_type = 'CI_REFERENCED_ITEM'
2522: AND object_id_from1 = p_from_ci_id
2523: UNION ALL
2524: SELECT object_id_from1 related_ci_id
2525: FROM pa_object_relationships
2526: WHERE object_type_from = 'PA_CONTROL_ITEMS'
2527: AND object_type_to = 'PA_CONTROL_ITEMS'
2528: AND relationship_type = 'CI_REFERENCED_ITEM'
2529: AND object_id_to1 = p_from_ci_id;