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_ML_UTIL_PVT dependencies on CSI_II_RELATION_INTERFACE

Line 1640: UPDATE csi_ii_relation_interface cir

1636: LOOP
1637: COMMIT;
1638:
1639: --Changed for bug 5875269
1640: UPDATE csi_ii_relation_interface cir
1641: SET cir.object_id = decode(cir.object_id,NULL
1642: ,(SELECT cii.instance_id
1643: FROM csi_instance_interface cii
1644: WHERE cii.inst_interface_id = cir.object_interface_id)

Line 1686: FROM csi_ii_relation_interface cir

1682: SELECT rel_interface_id
1683: ,relationship_type_code
1684: ,object_id
1685: ,subject_id
1686: FROM csi_ii_relation_interface cir
1687: WHERE cir.object_id = p_object_id
1688: AND cir.process_status = 'R'
1689: AND cir.relationship_type_code<>'CONNECTED-TO';
1690: --

Line 1789: FROM csi_ii_relation_interface cir

1785: LOOP
1786: BEGIN
1787: SELECT cir.object_id
1788: INTO l_object_id
1789: FROM csi_ii_relation_interface cir
1790: WHERE cir.subject_id = l_subject_id
1791: AND cir.relationship_type_code = p_rel_type_code
1792: AND nvl(cir.relationship_end_date,(sysdate+1)) > sysdate
1793: AND EXISTS (SELECT 'x'

Line 1864: FROM csi_ii_relation_interface

1860: ,object_id
1861: ,subject_id
1862: ,relationship_type_code
1863: ,relationship_end_date
1864: FROM csi_ii_relation_interface
1865: WHERE trunc(source_transaction_date)
1866: BETWEEN nvl(l_txn_from_date,trunc(source_transaction_date))
1867: AND nvl(l_txn_to_date,trunc(source_transaction_date))
1868: AND nvl(transaction_identifier,'-1') = '-1'

Line 1878: FROM csi_ii_relation_interface

1874: CURSOR upd_ins_csr (pc_parallel_worker_id IN NUMBER, l_txn_from_date DATE, l_txn_to_date DATE) IS
1875: SELECT rel_interface_id
1876: ,subject_id
1877: ,relationship_type_code
1878: FROM csi_ii_relation_interface
1879: WHERE trunc(source_transaction_date)
1880: BETWEEN nvl(l_txn_from_date,trunc(source_transaction_date))
1881: AND nvl(l_txn_to_date,trunc(source_transaction_date))
1882: AND nvl(transaction_identifier,'-1') = '-1'

Line 1892: FROM csi_ii_relation_interface

1888: SELECT rel_interface_id
1889: ,subject_id
1890: ,relationship_type_code
1891: ,config_root_node
1892: FROM csi_ii_relation_interface
1893: WHERE trunc(source_transaction_date)
1894: BETWEEN nvl(l_txn_from_date,trunc(source_transaction_date))
1895: AND nvl(l_txn_to_date,trunc(source_transaction_date))
1896: AND nvl(transaction_identifier,'-1') = '-1'

Line 1927: FROM csi_ii_relation_interface

1923: ,attribute12
1924: ,attribute13
1925: ,attribute14
1926: ,attribute15
1927: FROM csi_ii_relation_interface
1928: WHERE trunc(source_transaction_date)
1929: BETWEEN nvl(l_txn_from_date,trunc(source_transaction_date))
1930: AND nvl(l_txn_to_date,trunc(source_transaction_date))
1931: AND nvl(transaction_identifier,'-1') = '-1'

Line 2361: l_upd_stmt := 'UPDATE csi_ii_relation_interface

2357: -- Update Interface Table
2358: IF l_rel_id_array.count > 0 THEN
2359: FND_File.Put_Line(Fnd_File.LOG,'Updating status in validate mode');
2360: BEGIN
2361: l_upd_stmt := 'UPDATE csi_ii_relation_interface
2362: SET error_text = :error_text
2363: ,process_status = :status
2364: WHERE rel_interface_id = :intf_id';
2365: l_num_of_rows := dbms_sql.open_cursor;

Line 2532: l_upd_stmt := 'UPDATE csi_ii_relation_interface

2528: -- Update Interface Table
2529: IF l_rel_id_array.count > 0 THEN
2530: FND_File.Put_Line(Fnd_File.LOG,'Updating status in update mode');
2531: BEGIN
2532: l_upd_stmt := 'UPDATE csi_ii_relation_interface
2533: SET error_text = :error_text
2534: ,process_status = :status
2535: WHERE rel_interface_id = :intf_id';
2536: l_num_of_rows := dbms_sql.open_cursor;

Line 2683: l_upd_stmt := 'UPDATE csi_ii_relation_interface

2679: -- Update Interface Table
2680: IF l_rel_id_array.count > 0 THEN
2681: FND_File.Put_Line(Fnd_File.LOG,'Updating status in re-update mode');
2682: BEGIN
2683: l_upd_stmt := 'UPDATE csi_ii_relation_interface
2684: SET error_text = :error_text
2685: ,process_status = :status
2686: WHERE rel_interface_id = :intf_id';
2687: l_num_of_rows := dbms_sql.open_cursor;

Line 2918: l_upd_stmt := 'UPDATE csi_ii_relation_interface

2914:
2915: IF l_rel_id_array.count > 0 THEN
2916: FND_File.Put_Line(Fnd_File.LOG,'Updating status in insert mode');
2917: BEGIN
2918: l_upd_stmt := 'UPDATE csi_ii_relation_interface
2919: SET process_status = :status
2920: WHERE rel_interface_id = :intf_id';
2921: l_num_of_rows := dbms_sql.open_cursor;
2922: dbms_sql.parse(l_num_of_rows,l_upd_stmt,dbms_sql.native);

Line 2944: FROM csi_ii_relation_interface

2940: CURSOR dup_csr IS
2941: SELECT subject_id
2942: ,relationship_type_code
2943: ,count(*)
2944: FROM csi_ii_relation_interface
2945: WHERE process_status='R'
2946: AND relationship_type_code <> 'CONNECTED-TO'
2947: GROUP BY subject_id,relationship_type_code
2948: HAVING count(*) > 1;

Line 2954: FROM csi_ii_relation_interface cir

2950: CURSOR upd_csr (p_rel_id IN NUMBER
2951: ,p_subject_id IN NUMBER
2952: ,p_rel_type IN VARCHAR2) IS
2953: SELECT cir.rel_interface_id
2954: FROM csi_ii_relation_interface cir
2955: WHERE cir.subject_id = p_subject_id
2956: AND cir.relationship_type_code = p_rel_type
2957: AND cir.rel_interface_id <> p_rel_id;
2958:

Line 2987: FROM csi_ii_relation_interface cir

2983: l_ret_relationship_id := -9999;
2984: BEGIN
2985: SELECT MAX(cir.rel_interface_id)
2986: INTO l_ret_relationship_id
2987: FROM csi_ii_relation_interface cir
2988: WHERE cir.subject_id = l_subject_id_upd(k)
2989: AND cir.relationship_type_code = l_rel_type_code_upd(k);
2990: END;
2991:

Line 3010: UPDATE csi_ii_relation_interface

3006:
3007: IF l_rel_id_tbl.count > 0
3008: THEN
3009: FORALL j IN l_rel_id_tbl.FIRST .. l_rel_id_tbl.LAST
3010: UPDATE csi_ii_relation_interface
3011: SET process_status='E'
3012: ,error_text='Duplicate subject_id record'
3013: ,parallel_worker_id=0
3014: WHERE rel_interface_id = l_rel_id_tbl(j);

Line 3027: FROM csi_ii_relation_interface

3023: SELECT object_id
3024: ,subject_id
3025: ,relationship_type_code
3026: ,count(*)
3027: FROM csi_ii_relation_interface
3028: WHERE process_status='R'
3029: GROUP BY object_id,subject_id,relationship_type_code
3030: HAVING count(*) > 1;
3031:

Line 3037: FROM csi_ii_relation_interface cir

3033: ,p_object_id IN NUMBER
3034: ,p_subject_id IN NUMBER
3035: ,p_rel_type IN VARCHAR2) IS
3036: SELECT cir.rel_interface_id
3037: FROM csi_ii_relation_interface cir
3038: WHERE cir.object_id = p_object_id
3039: AND cir.subject_id = p_subject_id
3040: AND cir.relationship_type_code = p_rel_type
3041: AND cir.rel_interface_id <> p_rel_id;

Line 3073: FROM csi_ii_relation_interface cir

3069: l_ret_relationship_id := -9999;
3070: BEGIN
3071: SELECT MAX(cir.rel_interface_id)
3072: INTO l_ret_relationship_id
3073: FROM csi_ii_relation_interface cir
3074: WHERE cir.subject_id = l_subject_id_upd(k)
3075: AND cir.object_id = l_object_id_upd(k)
3076: AND cir.relationship_type_code = l_rel_type_code_upd(k);
3077: END;

Line 3098: UPDATE csi_ii_relation_interface

3094:
3095: IF l_rel_id_tbl.count > 0
3096: THEN
3097: FORALL j IN l_rel_id_tbl.FIRST .. l_rel_id_tbl.LAST
3098: UPDATE csi_ii_relation_interface
3099: SET process_status='E'
3100: ,error_text='Duplicate record'
3101: ,parallel_worker_id=0
3102: WHERE rel_interface_id = l_rel_id_tbl(j);

Line 3115: FROM csi_ii_relation_interface

3111: SELECT object_id
3112: ,subject_id
3113: ,rel_interface_id
3114: ,relationship_type_code
3115: FROM csi_ii_relation_interface
3116: WHERE process_status='R';
3117: l_rel_tbl csi_ml_util_pvt.ii_rel_interface_tbl;
3118: l_error BOOLEAN :=FALSE;
3119: l_rel_id_array dbms_sql.Number_Table;

Line 3160: l_upd_stmt := 'UPDATE csi_ii_relation_interface

3156:
3157: IF l_rel_id_array.count > 0 THEN
3158: FND_File.Put_Line(Fnd_File.LOG,'Updating status in for parent child loop ');
3159: BEGIN
3160: l_upd_stmt := 'UPDATE csi_ii_relation_interface
3161: SET process_status = :status
3162: ,error_text = :error_text
3163: ,parallel_worker_id =0
3164: WHERE rel_interface_id = :intf_id';