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.CSM_CSI_ITEM_ATTR_EVENT_PKG dependencies on CSI_IEA_VALUES

Line 50: CURSOR l_csi_iea_values_ins_csr

46: WHERE package_name = 'CSM_CSI_ITEM_ATTR_EVENT_PKG'
47: AND procedure_name = 'REFRESH_ACC';
48:
49: -- process inserts
50: CURSOR l_csi_iea_values_ins_csr
51: IS
52: SELECT attrval.attribute_value_id,
53: ii_acc.instance_id,
54: ii_acc.user_id

Line 57: csi_iea_values attrval,

53: ii_acc.instance_id,
54: ii_acc.user_id
55: FROM csm_item_instances_acc ii_acc,
56: csi_item_instances cii,
57: csi_iea_values attrval,
58: csi_i_extended_attribs attr
59: WHERE ii_acc.instance_id = cii.instance_id
60: AND cii.location_type_code <> 'INVENTORY'
61: AND attrval.instance_id = cii.instance_id

Line 73: CURSOR l_csi_iea_values_upd_csr(p_last_upd_date DATE)

69: AND acc.attribute_value_id = attrval.attribute_value_id
70: );
71:
72: --process updates
73: CURSOR l_csi_iea_values_upd_csr(p_last_upd_date DATE)
74: IS
75: SELECT acc.access_id,
76: acc.user_id
77: FROM csm_csi_item_attr_acc acc,

Line 78: csi_iea_values attrval,

74: IS
75: SELECT acc.access_id,
76: acc.user_id
77: FROM csm_csi_item_attr_acc acc,
78: csi_iea_values attrval,
79: csi_i_extended_attribs attr
80: WHERE acc.attribute_value_id = attrval.attribute_value_id
81: AND attrval.attribute_id = attr.attribute_id
82: AND SYSDATE BETWEEN NVL(attrval.active_start_date, SYSDATE) AND NVL(attrval.active_end_date, SYSDATE)

Line 87: CURSOR l_csi_iea_values_del_csr

83: AND SYSDATE BETWEEN NVL(attr.active_start_date, SYSDATE) AND NVL(attr.active_end_date, SYSDATE)
84: AND attrval.last_update_date > p_last_upd_date;
85:
86: --process deletes
87: CURSOR l_csi_iea_values_del_csr
88: IS
89: SELECT acc.access_id,
90: acc.attribute_value_id,
91: acc.user_id

Line 97: csi_iea_values attrval,

93: WHERE NOT EXISTS
94: (SELECT 1
95: FROM csm_item_instances_acc ii_acc,
96: csi_item_instances cii,
97: csi_iea_values attrval,
98: csi_i_extended_attribs attr
99: WHERE ii_acc.instance_id = cii.instance_id
100: AND cii.location_type_code <> 'INVENTORY'
101: AND attrval.instance_id = cii.instance_id

Line 117: FOR r_csi_iea_values_del_rec IN l_csi_iea_values_del_csr LOOP

113: FETCH l_last_run_date_csr INTO l_prog_update_date;
114: CLOSE l_last_run_date_csr;
115:
116: -- process deletes
117: FOR r_csi_iea_values_del_rec IN l_csi_iea_values_del_csr LOOP
118: CSM_ACC_PKG.Delete_acc
119: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
120: ,P_ACC_TABLE_NAME => g_acc_table_name1
121: ,P_PK1_NAME => g_pk1_name1

Line 122: ,P_PK1_NUM_VALUE => r_csi_iea_values_del_rec.attribute_value_id

118: CSM_ACC_PKG.Delete_acc
119: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
120: ,P_ACC_TABLE_NAME => g_acc_table_name1
121: ,P_PK1_NAME => g_pk1_name1
122: ,P_PK1_NUM_VALUE => r_csi_iea_values_del_rec.attribute_value_id
123: ,P_USER_ID => r_csi_iea_values_del_rec.user_id
124: );
125: END LOOP;
126:

Line 123: ,P_USER_ID => r_csi_iea_values_del_rec.user_id

119: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
120: ,P_ACC_TABLE_NAME => g_acc_table_name1
121: ,P_PK1_NAME => g_pk1_name1
122: ,P_PK1_NUM_VALUE => r_csi_iea_values_del_rec.attribute_value_id
123: ,P_USER_ID => r_csi_iea_values_del_rec.user_id
124: );
125: END LOOP;
126:
127: -- process updates

Line 128: FOR r_csi_iea_values_upd_rec IN l_csi_iea_values_upd_csr(l_prog_update_date) LOOP

124: );
125: END LOOP;
126:
127: -- process updates
128: FOR r_csi_iea_values_upd_rec IN l_csi_iea_values_upd_csr(l_prog_update_date) LOOP
129: CSM_ACC_PKG.Update_acc
130: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
131: ,P_ACC_TABLE_NAME => g_acc_table_name1
132: ,P_ACCESS_ID => r_csi_iea_values_upd_rec.access_id

Line 132: ,P_ACCESS_ID => r_csi_iea_values_upd_rec.access_id

128: FOR r_csi_iea_values_upd_rec IN l_csi_iea_values_upd_csr(l_prog_update_date) LOOP
129: CSM_ACC_PKG.Update_acc
130: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
131: ,P_ACC_TABLE_NAME => g_acc_table_name1
132: ,P_ACCESS_ID => r_csi_iea_values_upd_rec.access_id
133: ,P_USER_ID => r_csi_iea_values_upd_rec.user_id
134: );
135: END LOOP;
136:

Line 133: ,P_USER_ID => r_csi_iea_values_upd_rec.user_id

129: CSM_ACC_PKG.Update_acc
130: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
131: ,P_ACC_TABLE_NAME => g_acc_table_name1
132: ,P_ACCESS_ID => r_csi_iea_values_upd_rec.access_id
133: ,P_USER_ID => r_csi_iea_values_upd_rec.user_id
134: );
135: END LOOP;
136:
137: -- process inserts

Line 138: FOR r_csi_iea_values_ins_rec IN l_csi_iea_values_ins_csr LOOP

134: );
135: END LOOP;
136:
137: -- process inserts
138: FOR r_csi_iea_values_ins_rec IN l_csi_iea_values_ins_csr LOOP
139: CSM_ACC_PKG.Insert_Acc
140: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
141: ,P_ACC_TABLE_NAME => g_acc_table_name1
142: ,P_SEQ_NAME => g_acc_sequence_name1

Line 144: ,P_PK1_NUM_VALUE => r_csi_iea_values_ins_rec.attribute_value_id

140: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
141: ,P_ACC_TABLE_NAME => g_acc_table_name1
142: ,P_SEQ_NAME => g_acc_sequence_name1
143: ,P_PK1_NAME => g_pk1_name1
144: ,P_PK1_NUM_VALUE => r_csi_iea_values_ins_rec.attribute_value_id
145: ,P_USER_ID => r_csi_iea_values_ins_rec.user_id
146: );
147: END LOOP;
148:

Line 145: ,P_USER_ID => r_csi_iea_values_ins_rec.user_id

141: ,P_ACC_TABLE_NAME => g_acc_table_name1
142: ,P_SEQ_NAME => g_acc_sequence_name1
143: ,P_PK1_NAME => g_pk1_name1
144: ,P_PK1_NUM_VALUE => r_csi_iea_values_ins_rec.attribute_value_id
145: ,P_USER_ID => r_csi_iea_values_ins_rec.user_id
146: );
147: END LOOP;
148:
149: -- set the program update date in jtm_con_request_data to sysdate