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_DIAGNOSTICS_PKG dependencies on CSI_II_RELATIONSHIPS

Line 377: select CSI_II_RELATIONSHIPS_H_S.nextval

373: ,p_rel_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
374: ) IS
375: BEGIN
376: FOR i in p_ii_relationship_tbl.FIRST .. p_ii_relationship_tbl.LAST LOOP
377: select CSI_II_RELATIONSHIPS_H_S.nextval
378: into p_rel_hist_tbl(i) from dual;
379: --
380: p_ii_relationship_rec_tab.RELATIONSHIP_ID(i) := p_ii_relationship_tbl(i).RELATIONSHIP_ID;
381: p_ii_relationship_rec_tab.RELATIONSHIP_TYPE_CODE(i) := p_ii_relationship_tbl(i).RELATIONSHIP_TYPE_CODE;

Line 1268: csi_ii_relationships_pub.get_relationships(

1264:
1265: g_iir_qry_rec.object_id := g_inst_rec.instance_id;
1266: g_iir_qry_rec.relationship_type_code := 'COMPONENT-OF';
1267:
1268: csi_ii_relationships_pub.get_relationships(
1269: p_api_version => 1.0,
1270: p_commit => fnd_api.g_false,
1271: p_init_msg_list => fnd_api.g_true,
1272: p_validation_level => fnd_api.g_valid_level_full,

Line 1294: FROM csi_ii_relationships

1290: l_iir_tbl(iir_ind) := g_iir_tbl(l_ind);
1291:
1292: SELECT object_version_number
1293: INTO l_iir_tbl(iir_ind).object_version_number
1294: FROM csi_ii_relationships
1295: WHERE relationship_id = l_iir_tbl(iir_ind).relationship_id;
1296: END LOOP;
1297: END IF;
1298:

Line 1305: csi_ii_relationships_pub.get_relationships(

1301:
1302: g_iir_qry_rec.subject_id := g_inst_rec.instance_id;
1303: g_iir_qry_rec.relationship_type_code := 'COMPONENT-OF';
1304:
1305: csi_ii_relationships_pub.get_relationships(
1306: p_api_version => 1.0,
1307: p_commit => fnd_api.g_false,
1308: p_init_msg_list => fnd_api.g_true,
1309: p_validation_level => fnd_api.g_valid_level_full,

Line 1330: FROM csi_ii_relationships

1326: iir_ind := iir_ind + 1;
1327: l_iir_tbl(iir_ind) := g_iir_tbl(l_ind);
1328: SELECT object_version_number
1329: INTO l_iir_tbl(iir_ind).object_version_number
1330: FROM csi_ii_relationships
1331: WHERE relationship_id = l_iir_tbl(iir_ind).relationship_id;
1332:
1333: END LOOP;
1334: END IF;

Line 1337: csi_ii_relationships_pub.update_relationship (

1333: END LOOP;
1334: END IF;
1335:
1336: IF l_iir_tbl.COUNT > 0 THEN
1337: csi_ii_relationships_pub.update_relationship (
1338: p_api_version => 1.0,
1339: p_commit => fnd_api.g_false,
1340: p_init_msg_list => fnd_api.g_true,
1341: p_validation_level => fnd_api.g_valid_level_full,

Line 1758: csi_ii_relationships_pub.get_relationships(

1754: -- Add Get Relationships API
1755: p_rel_query_rec := p_temp_rel_query_rec;
1756: p_rel_query_rec.object_id := p_instance_id;
1757: p_rel_query_rec.relationship_type_code := 'COMPONENT-OF';
1758: csi_ii_relationships_pub.get_relationships(
1759: p_api_version => 1.0,
1760: p_commit => fnd_api.g_false,
1761: p_init_msg_list => l_init_msg_list,
1762: p_validation_level => fnd_api.g_valid_level_full,

Line 1795: csi_ii_relationships_pub.get_relationships(

1791: --
1792: p_rel_query_rec := p_temp_rel_query_rec;
1793: p_rel_query_rec.subject_id := p_instance_id;
1794: p_rel_query_rec.relationship_type_code := 'COMPONENT-OF';
1795: csi_ii_relationships_pub.get_relationships(
1796: p_api_version => 1.0,
1797: p_commit => fnd_api.g_false,
1798: p_init_msg_list => l_init_msg_list,
1799: p_validation_level => fnd_api.g_valid_level_full,

Line 2709: INSERT INTO CSI_II_RELATIONSHIPS_H(

2705: --
2706: -- Insert into History
2707: log('Before inserting into Relationships history');
2708: FORALL i in 1 .. l_ii_relationship_rec_tab.relationship_id.count
2709: INSERT INTO CSI_II_RELATIONSHIPS_H(
2710: RELATIONSHIP_HISTORY_ID
2711: ,RELATIONSHIP_ID
2712: ,TRANSACTION_ID
2713: ,NEW_SUBJECT_ID

Line 9297: from CSI_II_RELATIONSHIPS cir

9293: active_start_date,active_end_date,display_order,mandatory_flag,context,
9294: attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,
9295: attribute9,attribute10,attribute11,attribute12,attribute13,attribute14,attribute15,
9296: object_version_number
9297: from CSI_II_RELATIONSHIPS cir
9298: where cir.object_id = p_object_id
9299: and cir.relationship_type_code = l_rel_type_code
9300: and ((cir.active_end_date is null) or (cir.active_end_date > sysdate))
9301: and EXISTS (select 'x'

Line 9672: from CSI_II_RELATIONSHIPS

9668: End if;
9669: Begin
9670: select 'x'
9671: into l_exists
9672: from CSI_II_RELATIONSHIPS
9673: where subject_id = instance_id_mig(i)
9674: and relationship_type_code = l_rel_type_code
9675: and ((active_end_date is null) or (active_end_date > sysdate));
9676: usage_code_mig(i) := 'IN_RELATIONSHIP';

Line 9698: FROM CSI_II_RELATIONSHIPS_H

9694: --
9695: PROCEDURE Update_Full_dump_flag IS
9696: CURSOR CSI_REL_CUR IS
9697: SELECT relationship_history_id
9698: FROM CSI_II_RELATIONSHIPS_H
9699: WHERE nvl(MIGRATED_FLAG,'N') = 'Y'
9700: AND full_dump_flag <> 'Y';
9701: --
9702: CURSOR CSI_SYS_CUR IS

Line 9722: update CSI_II_RELATIONSHIPS_H

9718: FETCH CSI_REL_CUR BULK COLLECT INTO
9719: rel_history_id_mig
9720: LIMIT MAX_BUFFER_SIZE;
9721: FORALL j in 1 .. rel_history_id_mig.count
9722: update CSI_II_RELATIONSHIPS_H
9723: set full_dump_flag = 'Y'
9724: where relationship_history_id = rel_history_id_mig(j);
9725: commit;
9726: --

Line 11033: from CSI_II_RELATIONSHIPS

11029: --
11030: PROCEDURE Delete_Dup_Relationship IS
11031: CURSOR CSI_REL_CUR IS
11032: select object_id,subject_id,relationship_type_code,count(*)
11033: from CSI_II_RELATIONSHIPS
11034: where active_end_date is null
11035: and nvl(migrated_flag,'N') = 'Y'
11036: group by object_id,subject_id,relationship_type_code
11037: having count(*) > 1;

Line 11045: from CSI_II_RELATIONSHIPS cir

11041: ,p_object_id IN NUMBER
11042: ,p_subject_id IN NUMBER
11043: ,p_rel_type IN VARCHAR2) IS
11044: select cir.relationship_id
11045: from CSI_II_RELATIONSHIPS cir
11046: where cir.object_id = p_object_id
11047: and cir.subject_id = p_subject_id
11048: and cir.relationship_type_code = p_rel_type
11049: and cir.active_end_date is null

Line 11052: and not exists (select 'x' from CSI_II_RELATIONSHIPS_H cirh

11048: and cir.relationship_type_code = p_rel_type
11049: and cir.active_end_date is null
11050: and nvl(cir.migrated_flag,'N') = 'Y'
11051: and cir.relationship_id <> p_rel_id
11052: and not exists (select 'x' from CSI_II_RELATIONSHIPS_H cirh
11053: where cirh.relationship_id = cir.relationship_id
11054: and nvl(cirh.migrated_flag,'N') = 'N');
11055: --
11056: l_ret_relationship_id NUMBER;

Line 11085: from CSI_II_RELATIONSHIPS cir

11081: -- Try to get the relationship which has non-migrated txns
11082: Begin
11083: select max(cir.relationship_id)
11084: into l_ret_relationship_id
11085: from CSI_II_RELATIONSHIPS cir
11086: where cir.object_id = l_object_id_mig(k)
11087: and cir.subject_id = l_subject_id_mig(k)
11088: and cir.relationship_type_code = l_rel_type_code_mig(k)
11089: and cir.active_end_date is null

Line 11091: and exists (select 'x' from CSI_II_RELATIONSHIPS_H cirh

11087: and cir.subject_id = l_subject_id_mig(k)
11088: and cir.relationship_type_code = l_rel_type_code_mig(k)
11089: and cir.active_end_date is null
11090: and nvl(cir.migrated_flag,'N') = 'Y'
11091: and exists (select 'x' from CSI_II_RELATIONSHIPS_H cirh
11092: where cirh.relationship_id = cir.relationship_id
11093: and nvl(cirh.migrated_flag,'N') = 'N');
11094: End;
11095: --

Line 11100: from CSI_II_RELATIONSHIPS

11096: IF nvl(l_ret_relationship_id,-9999) = -9999 THEN
11097: Begin
11098: select max(relationship_id)
11099: into l_ret_relationship_id
11100: from CSI_II_RELATIONSHIPS
11101: where object_id = l_object_id_mig(k)
11102: and subject_id = l_subject_id_mig(k)
11103: and relationship_type_code = l_rel_type_code_mig(k)
11104: and active_end_date is null

Line 11128: DELETE FROM CSI_II_RELATIONSHIPS_H

11124: END IF;
11125: --
11126: IF l_rel_id_tbl.count > 0 THEN
11127: FORALL j in l_rel_id_tbl.FIRST .. l_rel_id_tbl.LAST
11128: DELETE FROM CSI_II_RELATIONSHIPS_H
11129: WHERE relationship_id = l_rel_id_tbl(j);
11130: commit;
11131: --
11132: FORALL j in l_rel_id_tbl.FIRST .. l_rel_id_tbl.LAST

Line 11133: DELETE FROM CSI_II_RELATIONSHIPS

11129: WHERE relationship_id = l_rel_id_tbl(j);
11130: commit;
11131: --
11132: FORALL j in l_rel_id_tbl.FIRST .. l_rel_id_tbl.LAST
11133: DELETE FROM CSI_II_RELATIONSHIPS
11134: WHERE relationship_id = l_rel_id_tbl(j);
11135: commit;
11136: END IF;
11137: END Delete_Dup_Relationship;

Line 11240: CSI_II_RELATIONSHIPS cir

11236: CURSOR REL_CUR IS
11237: select cii.instance_id,cii.inventory_item_id,cii.inv_master_organization_id,
11238: cir.relationship_id
11239: from CSI_ITEM_INSTANCES cii,
11240: CSI_II_RELATIONSHIPS cir
11241: where nvl(cii.active_end_date,(sysdate+1)) > sysdate
11242: and cir.subject_id = cii.instance_id
11243: and cir.relationship_type_code = 'COMPONENT-OF'
11244: and nvl(cir.active_end_date,(sysdate+1)) > sysdate;

Line 11363: UPDATE CSI_II_RELATIONSHIPS

11359: END IF;
11360: -- Update the Relationship end_date.
11361: IF l_rel_tbl.count > 0 THEN
11362: FORALL i in l_rel_tbl.FIRST .. l_rel_tbl.LAST
11363: UPDATE CSI_II_RELATIONSHIPS
11364: set active_end_date = sysdate
11365: where relationship_id = l_rel_tbl(i);
11366: --
11367: commit;

Line 11541: UPDATE CSI_II_RELATIONSHIPS

11537: commit;
11538: -- Update the Relationship end_date back to null.
11539: IF l_rel_tbl.count > 0 THEN
11540: FORALL i in l_rel_tbl.FIRST .. l_rel_tbl.LAST
11541: UPDATE CSI_II_RELATIONSHIPS
11542: set active_end_date = null
11543: where relationship_id = l_rel_tbl(i);
11544: --
11545: commit;