184:
185: --Bug# 8414563 fixed by ateotia(+)
186: CURSOR g_duplicated_line_count_csr (p_resale_batch_id IN NUMBER) IS
187: SELECT count(1)
188: FROM ozf_resale_lines_int_all
189: WHERE status_code = G_BATCH_ADJ_DUPLICATED
190: AND resale_batch_id = p_resale_batch_id;
191:
192: CURSOR g_tracing_flag_csr (p_resale_line_int_id IN NUMBER) IS
190: AND resale_batch_id = p_resale_batch_id;
191:
192: CURSOR g_tracing_flag_csr (p_resale_line_int_id IN NUMBER) IS
193: SELECT tracing_flag
194: FROM ozf_resale_lines_int_all
195: WHERE resale_line_int_id = p_resale_line_int_id;
196: --Bug# 8414563 fixed by ateotia(-)
197:
198: ---------------------------------------------------------------------