APPS.CSL_CSI_ITEM_INSTANCES_ACC_PKG dependencies on CSL_CSI_ITEM_ATTR_ACC

Line 109: AND civ.ATTRIBUTE_VALUE_ID NOT IN (SELECT ATTRIBUTE_VALUE_ID from CSL_CSI_ITEM_ATTR_ACC)

105: WHERE civ.attribute_id = ciea.attribute_id
106: AND civ.instance_id = acc.instance_id
107: AND NVL(ciea.active_start_date, sysdate) <= sysdate
108: AND NVL(ciea.active_end_date, sysdate) >= sysdate
109: AND civ.ATTRIBUTE_VALUE_ID NOT IN (SELECT ATTRIBUTE_VALUE_ID from CSL_CSI_ITEM_ATTR_ACC)
110: AND civ.last_update_date > b_last_run_date;
111:
112: r_insert_diffs c_insert_diffs%ROWTYPE;
113:

Line 117: csl_csi_item_instances_acc csiacc, CSL_CSI_ITEM_ATTR_ACC acc

113:
114: CURSOR c_updates(b_last_run_date date) IS
115: SELECT acc.ACCESS_ID, acc.RESOURCE_ID
116: FROM CSI_IEA_VALUES civ, CSI_I_EXTENDED_ATTRIBS ciea,
117: csl_csi_item_instances_acc csiacc, CSL_CSI_ITEM_ATTR_ACC acc
118: WHERE civ.attribute_id = ciea.attribute_id
119: AND civ.instance_id = csiacc.instance_id
120: AND civ.ATTRIBUTE_VALUE_ID = acc.ATTRIBUTE_VALUE_ID
121: AND NVL(ciea.active_start_date, sysdate) <= sysdate

Line 134: AND civ.ATTRIBUTE_VALUE_ID IN (SELECT ATTRIBUTE_VALUE_ID from CSL_CSI_ITEM_ATTR_ACC)

130: WHERE civ.attribute_id = ciea.attribute_id
131: AND civ.instance_id = acc.instance_id
132: AND NVL(ciea.active_start_date, sysdate) <= sysdate
133: AND NVL(ciea.active_end_date, sysdate) < sysdate
134: AND civ.ATTRIBUTE_VALUE_ID IN (SELECT ATTRIBUTE_VALUE_ID from CSL_CSI_ITEM_ATTR_ACC)
135: AND civ.last_update_date > b_last_run_date;
136: r_end_dates c_end_dates%ROWTYPE;
137:
138: CURSOR c_deletes(b_last_run_date date) IS

Line 140: from CSL_CSI_ITEM_ATTR_ACC

136: r_end_dates c_end_dates%ROWTYPE;
137:
138: CURSOR c_deletes(b_last_run_date date) IS
139: SELECT ATTRIBUTE_VALUE_ID, RESOURCE_ID
140: from CSL_CSI_ITEM_ATTR_ACC
141: where ATTRIBUTE_VALUE_ID NOT IN (SELECT ATTRIBUTE_VALUE_ID from CSI_IEA_VALUES)
142: */
143:
144: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

Line 146: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR_ACC';

142: */
143:
144: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
145: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_ATTR');
146: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR_ACC';
147: l_pk1_name CONSTANT VARCHAR2(30) := 'ATTRIBUTE_VALUE_ID';
148: l_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR';
149:
150: l_current_run_date date;

Line 261: 'CSL_CSI_ITEM_ATTR_ACC',

257: p_status := 'ERROR';
258: p_message := 'Error in CSL_CSI_ITEM_INSTANCES_ACC_PKG.CON_ITEM_ATTR: ' || substr(SQLERRM, 1, 2000);
259: jtm_message_log_pkg.Log_Msg
260: (0,
261: 'CSL_CSI_ITEM_ATTR_ACC',
262: 'Exception occured in CON_ITEM_ATTR ',
263: JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
264:
265: END;

Line 288: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR_ACC';

284: r_item_attr c_item_attr%ROWTYPE;
285:
286: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
287: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_ATTR');
288: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR_ACC';
289: l_pk1_name CONSTANT VARCHAR2(30) := 'ATTRIBUTE_VALUE_ID';
290: l_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR';
291:
292: BEGIN

Line 351: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR_ACC';

347: r_item_attr c_item_attr%ROWTYPE;
348:
349: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
350: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_ATTR');
351: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR_ACC';
352: l_pk1_name CONSTANT VARCHAR2(30) := 'ATTRIBUTE_VALUE_ID';
353: l_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR';
354:
355: BEGIN