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.CSI_WIP_TRXS_PKG dependencies on CSI_II_RELATIONSHIPS

Line 2094: FROM csi_ii_relationships

2090: l_rltn_exists := 'N';
2091:
2092: SELECT 'Y'
2093: INTO l_rltn_exists
2094: FROM csi_ii_relationships
2095: WHERE subject_id = p_assy_comp_map_tbl(l_ind).comp_instance_id
2096: AND object_id = p_assy_comp_map_tbl(l_ind).assy_instance_id
2097: AND relationship_type_code = 'COMPONENT-OF'
2098: AND active_end_date is NULL OR active_end_date > sysdate;

Line 2125: DEBUG('Error in csi_ii_relationships_pub.create_relationship, call to csi_process_txn_pvt.check_and_break_relation');

2121: p_csi_txn_rec => px_csi_txn_rec ,
2122: x_return_status => x_return_status);
2123:
2124: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2125: DEBUG('Error in csi_ii_relationships_pub.create_relationship, call to csi_process_txn_pvt.check_and_break_relation');
2126: RAISE fnd_api.g_exc_error;
2127: END IF;
2128: -- End fix for bug 5655955 ( Bug 13503707)
2129: --End bug#13929565

Line 2137: p_pkg_name => 'csi_ii_relationships_pub',

2133: END LOOP;
2134: END IF;
2135:
2136: api_log(
2137: p_pkg_name => 'csi_ii_relationships_pub',
2138: p_api_name => 'create_relationship');
2139:
2140: csi_ii_relationships_pub.create_relationship(
2141: p_api_version => 1.0,

Line 2140: csi_ii_relationships_pub.create_relationship(

2136: api_log(
2137: p_pkg_name => 'csi_ii_relationships_pub',
2138: p_api_name => 'create_relationship');
2139:
2140: csi_ii_relationships_pub.create_relationship(
2141: p_api_version => 1.0,
2142: p_commit => fnd_api.g_false,
2143: p_init_msg_list => fnd_api.g_true,
2144: p_validation_level => fnd_api.g_valid_level_full,

Line 2152: debug('Error in csi_ii_relationships_pub.create_relationship.');

2148: x_msg_count => l_msg_count,
2149: x_msg_data => l_msg_data);
2150:
2151: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2152: debug('Error in csi_ii_relationships_pub.create_relationship.');
2153: RAISE fnd_api.g_exc_error;
2154: END IF;
2155:
2156:

Line 2367: FROM csi_ii_relationships cir,

2363: l_alloc_count number := 0;
2364: BEGIN
2365: SELECT count(*)
2366: INTO l_alloc_count
2367: FROM csi_ii_relationships cir,
2368: csi_item_instances cii
2369: WHERE cir.object_id = p_object_id
2370: AND cir.relationship_type_code = 'COMPONENT-OF'
2371: AND sysdate BETWEEN nvl(cir.active_start_date, sysdate-1)

Line 2553: FROM csi_ii_relationships cir,

2549: IS
2550:
2551: CURSOR comp_cur (p_object_id in number, p_comp_item_id in number) IS
2552: SELECT cir.subject_id, cii.quantity
2553: FROM csi_ii_relationships cir,
2554: csi_item_instances cii
2555: WHERE cir.object_id = p_object_id
2556: AND cir.relationship_type_code = 'COMPONENT-OF'
2557: AND cii.instance_id = cir.subject_id

Line 2602: FROM csi_ii_relationships cir,

2598: l_alloc_qty number := 0;
2599: BEGIN
2600: SELECT sum(cii.quantity)
2601: INTO l_alloc_qty
2602: FROM csi_ii_relationships cir,
2603: csi_item_instances cii
2604: WHERE cir.object_id = p_object_id
2605: AND cir.relationship_type_code = 'COMPONENT-OF'
2606: AND cii.instance_id = cir.subject_id

Line 3083: FROM csi_ii_relationships cir,

3079: IS
3080:
3081: CURSOR rltns_cur(p_parent_instance_id IN number) IS
3082: SELECT cir.subject_id, cii.quantity
3083: FROM csi_ii_relationships cir,
3084: csi_item_instances cii
3085: WHERE cir.object_id = p_parent_instance_id
3086: AND cir.relationship_type_code = 'COMPONENT-OF'
3087: AND cii.instance_id = cir.subject_id

Line 5145: FROM csi_ii_relationships

5141: LOOP
5142: BEGIN
5143: SELECT object_id
5144: INTO l_inst_tbl(l_ind).attribute1
5145: FROM csi_ii_relationships
5146: WHERE subject_id = l_inst_tbl(l_ind).instance_id
5147: AND relationship_type_code = 'COMPONENT-OF';
5148: EXCEPTION
5149: WHEN no_data_found THEN

Line 5521: from csi_item_instances ci1, csi_item_instances ci2, csi_ii_relationships cir

5517: AND mmt.transaction_type_id = 17;
5518:
5519: CURSOR child_item_csr (p_inventory_item_id IN NUMBER, p_serial_number IN varchar2) IS
5520: select cir.subject_id,ci2.quantity
5521: from csi_item_instances ci1, csi_item_instances ci2, csi_ii_relationships cir
5522: where ci1.instance_id = cir.object_id
5523: and ci1.inventory_item_id = p_inventory_item_id
5524: and ci1.serial_number = p_serial_number
5525: and ci2.inventory_item_id = p_mmt_rec.inventory_item_id

Line 5644: FROM csi_ii_relationships

5640: BEGIN
5641: SELECT 'Y', object_id, active_start_date, active_end_date
5642: INTO l_relation_found , l_parent_instance_id, l_active_start_date,
5643: l_active_end_date
5644: FROM csi_ii_relationships
5645: WHERE subject_id = l_instances_tbl(1).instance_id
5646: AND relationship_type_code = 'COMPONENT-OF'
5647: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)
5648: AND nvl(active_end_date, sysdate+1);

Line 5693: from csi_item_instances ci1, csi_item_instances ci2, csi_ii_relationships cir

5689:
5690: BEGIN
5691: select cir.subject_id,ci2.quantity
5692: into l_instance_id, l_quantity
5693: from csi_item_instances ci1, csi_item_instances ci2, csi_ii_relationships cir
5694: where ci1.instance_id = cir.object_id
5695: and ci1.inventory_item_id = l_inv_item_id
5696: and ci1.serial_number = l_serial_number
5697: and ci2.inventory_item_id = p_mmt_rec.inventory_item_id

Line 6679: FROM csi_ii_relationships

6675: SELECT relationship_id,
6676: object_version_number
6677: INTO l_iir_rec.relationship_id,
6678: l_iir_rec.object_version_number
6679: FROM csi_ii_relationships
6680: WHERE object_id = l_obj_instance_id
6681: AND subject_id = l_sub_instance_id;
6682: EXCEPTION
6683: WHEN no_data_found THEN

Line 6851: p_pkg_name => 'csi_ii_relationships_pub',

6847: debug('create_relationship.COUNT :'||l_c_iir_tbl.COUNT);
6848:
6849: IF l_c_iir_tbl.COUNT > 0 THEN
6850: api_log(
6851: p_pkg_name => 'csi_ii_relationships_pub',
6852: p_api_name => 'create_relationship');
6853:
6854: csi_ii_relationships_pub.create_relationship(
6855: p_api_version => 1.0,

Line 6854: csi_ii_relationships_pub.create_relationship(

6850: api_log(
6851: p_pkg_name => 'csi_ii_relationships_pub',
6852: p_api_name => 'create_relationship');
6853:
6854: csi_ii_relationships_pub.create_relationship(
6855: p_api_version => 1.0,
6856: p_commit => fnd_api.g_false,
6857: p_init_msg_list => fnd_api.g_true,
6858: p_validation_level => fnd_api.g_valid_level_full,

Line 6874: p_pkg_name => 'csi_ii_relationships_pub',

6870: debug('update_relationship.COUNT :'||l_u_iir_tbl.COUNT);
6871:
6872: IF l_u_iir_tbl.COUNT > 0 THEN
6873: api_log(
6874: p_pkg_name => 'csi_ii_relationships_pub',
6875: p_api_name => 'update_relationship');
6876:
6877: debug('No code here yet for update relationship...');
6878:

Line 7070: api_log(p_pkg_name => 'csi_ii_relationships_pub',p_api_name => 'create_relationship');

7066: debug('total components : '||l_ii_rltns_tbl.COUNT);
7067:
7068: IF l_ii_rltns_tbl.COUNT > 0 THEN
7069:
7070: api_log(p_pkg_name => 'csi_ii_relationships_pub',p_api_name => 'create_relationship');
7071:
7072: csi_ii_relationships_pub.create_relationship(
7073: p_api_version => 1.0,
7074: p_commit => fnd_api.g_false,

Line 7072: csi_ii_relationships_pub.create_relationship(

7068: IF l_ii_rltns_tbl.COUNT > 0 THEN
7069:
7070: api_log(p_pkg_name => 'csi_ii_relationships_pub',p_api_name => 'create_relationship');
7071:
7072: csi_ii_relationships_pub.create_relationship(
7073: p_api_version => 1.0,
7074: p_commit => fnd_api.g_false,
7075: p_init_msg_list => fnd_api.g_true,
7076: p_validation_level => fnd_api.g_valid_level_full,