APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_II_RELATIONSHIPS_H

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 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 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 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 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 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