APPS.OZF_CLAIM_LINE_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 1261: FROM ra_customer_trx_lines_all

1257:
1258: -- Bug#9957893 (+)
1259: CURSOR c_old_line_qty(cv_src_obj_line_id IN NUMBER) IS
1260: SELECT quantity_invoiced
1261: FROM ra_customer_trx_lines_all
1262: WHERE customer_trx_line_id = cv_src_obj_line_id;
1263:
1264: CURSOR c_tot_qty(cv_claim_id IN NUMBER, cv_source_object_line_id IN NUMBER) IS
1265: select NVL(sum(quantity),0) from ozf_claim_lines_all

Line 1378: OZF_Utility_PVT.debug_message('Old Quantity from ra_customer_trx_lines_all is ' || l_inv_quantity);

1374: FETCH c_old_line_qty INTO l_inv_quantity;
1375: CLOSE c_old_line_qty;
1376:
1377: IF OZF_DEBUG_HIGH_ON THEN
1378: OZF_Utility_PVT.debug_message('Old Quantity from ra_customer_trx_lines_all is ' || l_inv_quantity);
1379: OZF_Utility_PVT.debug_message('Current Claim Line Quantity is ' || l_claim_line_tbl(j).quantity);
1380: OZF_Utility_PVT.debug_message('Total Claim Line Quantity for source_object_line_id '|| l_claim_line_tbl(j).source_object_line_id || 'is ' || l_tot_quantity);
1381: END IF;
1382:

Line 3119: FROM ra_customer_trx_lines_all

3115:
3116: -- Bug#9957893 (+)
3117: CURSOR c_old_line_qty(cv_src_obj_line_id IN NUMBER) IS
3118: SELECT quantity_invoiced
3119: FROM ra_customer_trx_lines_all
3120: WHERE customer_trx_line_id = cv_src_obj_line_id;
3121: -- Bug#9957893 (-)
3122:
3123:

Line 3250: OZF_Utility_PVT.debug_message('Old Quantity from ra_customer_trx_lines_all is ' || l_inv_quantity);

3246: FETCH c_old_line_qty INTO l_inv_quantity;
3247: CLOSE c_old_line_qty;
3248:
3249: IF OZF_DEBUG_HIGH_ON THEN
3250: OZF_Utility_PVT.debug_message('Old Quantity from ra_customer_trx_lines_all is ' || l_inv_quantity);
3251: OZF_Utility_PVT.debug_message('Current Claim Line Quantity is ' || l_claim_line_tbl(j).quantity);
3252: OZF_Utility_PVT.debug_message('Total Quantity is ' || l_tot_quantity);
3253: END IF;
3254: