APPS.OZF_OM_PAYMENT_PVT dependencies on OZF_CLAIM_LINES

Line 321: FROM ozf_claim_lines

317: , rate
318: , claim_currency_amount
319: , tax_code
320: , payment_status
321: FROM ozf_claim_lines
322: WHERE claim_id = cv_claim_id;
323:
324: i PLS_INTEGER := 1;
325:

Line 901: UPDATE ozf_claim_lines_all

897: i := l_x_line_tbl.FIRST;
898: IF i IS NOT NULL THEN
899: LOOP
900: IF p_claim_line_tbl(i).item_id = l_x_line_tbl(i).inventory_item_id THEN
901: UPDATE ozf_claim_lines_all
902: SET payment_reference_id = l_x_line_tbl(i).line_id
903: , payment_reference_number = l_x_line_tbl(i).line_number
904: WHERE claim_line_id = p_claim_line_tbl(i).claim_line_id;
905: END IF;

Line 1249: -- reset payment status in ozf_claim_lines_all

1245: RAISE FND_API.g_exc_unexpected_error;
1246: END IF;
1247: END IF;
1248:
1249: -- reset payment status in ozf_claim_lines_all
1250: BEGIN
1251: UPDATE ozf_claim_lines_all
1252: SET payment_status = 'PENDING'
1253: WHERE claim_id = p_claim_id;

Line 1251: UPDATE ozf_claim_lines_all

1247: END IF;
1248:
1249: -- reset payment status in ozf_claim_lines_all
1250: BEGIN
1251: UPDATE ozf_claim_lines_all
1252: SET payment_status = 'PENDING'
1253: WHERE claim_id = p_claim_id;
1254: EXCEPTION
1255: WHEN OTHERS THEN