APPS.CN_RAM_ADJUSTMENTS_PKG dependencies on CN_TRX

Line 97: update cn_trx_lines

93: -- line_selection_mode = 'A' (All lines)
94: -- Adjustment was applied to all lines of the transactions.
95: if (adj.line_selection_mode = 'A') then
96:
97: update cn_trx_lines
98: set adjusted_flag = 'Y',
99: negated_flag = 'N',
100: collected_flag = 'N',
101: adj_batch_id = FLOOR(x_trx_identified_count/l_sys_batch_size)

Line 104: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl

100: collected_flag = 'N',
101: adj_batch_id = FLOOR(x_trx_identified_count/l_sys_batch_size)
102: where trx_line_id in (
103: select ctl.trx_line_id
104: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl
105: where cnt.not_trx_id = adj.not_trx_id and
106: ct.not_trx_id = cnt.not_trx_id and
107: ctl.trx_id = ct.trx_id and
108: cnt.source_trx_id = adj.customer_trx_id and

Line 130: update cn_trx_lines

126: -- line_selection_mode = 'S' (Specific line)
127: -- Adjustment was applied to a specific line only.
128: if (adj.line_selection_mode = 'S') then
129:
130: update cn_trx_lines
131: set adjusted_flag = 'Y',
132: negated_flag = 'N',
133: collected_flag = 'N',
134: adj_batch_id = FLOOR(x_trx_identified_count/l_sys_batch_size)

Line 137: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl

133: collected_flag = 'N',
134: adj_batch_id = FLOOR(x_trx_identified_count/l_sys_batch_size)
135: where trx_line_id in (
136: select ctl.trx_line_id
137: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl
138: where cnt.not_trx_id = adj.not_trx_id and
139: ct.not_trx_id = cnt.not_trx_id and
140: ctl.trx_id = ct.trx_id and
141: cnt.source_trx_id = adj.customer_trx_id and

Line 157: update cn_trx_lines

153: -- line_selection_mode = 'I' (Inventory item)
154: -- Adjustment was applied to all lines with a specific inventory item.
155: if (adj.line_selection_mode = 'I') then
156:
157: update cn_trx_lines
158: set adjusted_flag = 'Y',
159: negated_flag = 'N',
160: collected_flag = 'N',
161: adj_batch_id = FLOOR(x_trx_identified_count/l_sys_batch_size)

Line 164: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl

160: collected_flag = 'N',
161: adj_batch_id = FLOOR(x_trx_identified_count/l_sys_batch_size)
162: where trx_line_id in (
163: select ctl.trx_line_id
164: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl
165: where cnt.not_trx_id = adj.not_trx_id and
166: ct.not_trx_id = cnt.not_trx_id and
167: ctl.trx_id = ct.trx_id and
168: cnt.source_trx_id = adj.customer_trx_id and

Line 189: update cn_trx_lines

185: --
186: -- rewrite the update statement for performance issue
187: --
188: --old statement
189: update cn_trx_lines
190: set adjusted_flag = 'Y',
191: negated_flag = 'N',
192: collected_flag = 'N',
193: adj_batch_id = FLOOR(x_trx_identified_count/l_sys_batch_size)

Line 196: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl,

192: collected_flag = 'N',
193: adj_batch_id = FLOOR(x_trx_identified_count/l_sys_batch_size)
194: where trx_line_id in (
195: select ctl.trx_line_id
196: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl,
197: (select rctl.customer_trx_line_id
198: from ra_customer_trx_lines rctl
199: where rctl.customer_trx_id = adj.customer_trx_id and
200: exists

Line 219: update cn_trx_lines

215: )
216: AND org_id = x_org_id;
217:
218: /* -- new statement
219: update cn_trx_lines
220: set adjusted_flag = 'Y',
221: negated_flag = 'N',
222: collected_flag = 'N',
223: adj_batch_id = FLOOR(x_trx_identified_count/l_sys_batch_size)

Line 226: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl,

222: collected_flag = 'N',
223: adj_batch_id = FLOOR(x_trx_identified_count/l_sys_batch_size)
224: where trx_line_id in (
225: select ctl.trx_line_id
226: from cn_not_trx cnt, cn_trx ct, cn_trx_lines ctl,
227: mtl_item_categories mic
228: where cnt.not_trx_id = adj.not_trx_id and
229: ct.not_trx_id = cnt.not_trx_id and
230: ctl.trx_id = ct.trx_id and

Line 303: from cn_trx_lines ctl

299:
300: -- Get affected trx_line_id
301: CURSOR neg_trx_line_cursor IS
302: select ctl.trx_line_id
303: from cn_trx_lines ctl
304: where ctl.adjusted_flag = 'Y' and
305: ctl.negated_flag = 'N' and
306: ctl.collected_flag = 'N' and
307: ctl.event_id = cn_global.inv_event_id

Line 349: -- Set flags in cn_trx_lines

345: x_adjust_comments => l_adjust_comments);
346:
347: END LOOP;
348:
349: -- Set flags in cn_trx_lines
350: update cn_trx_lines
351: set negated_flag = 'Y'
352: where trx_line_id = nt.trx_line_id
353: AND org_id = x_org_id;

Line 350: update cn_trx_lines

346:
347: END LOOP;
348:
349: -- Set flags in cn_trx_lines
350: update cn_trx_lines
351: set negated_flag = 'Y'
352: where trx_line_id = nt.trx_line_id
353: AND org_id = x_org_id;
354: