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 895: UPDATE ozf_claim_lines_all

891: i := l_x_line_tbl.FIRST;
892: IF i IS NOT NULL THEN
893: LOOP
894: IF p_claim_line_tbl(i).item_id = l_x_line_tbl(i).inventory_item_id THEN
895: UPDATE ozf_claim_lines_all
896: SET payment_reference_id = l_x_line_tbl(i).line_id
897: , payment_reference_number = l_x_line_tbl(i).line_number
898: WHERE claim_line_id = p_claim_line_tbl(i).claim_line_id;
899: END IF;

Line 1243: -- reset payment status in ozf_claim_lines_all

1239: RAISE FND_API.g_exc_unexpected_error;
1240: END IF;
1241: END IF;
1242:
1243: -- reset payment status in ozf_claim_lines_all
1244: BEGIN
1245: UPDATE ozf_claim_lines_all
1246: SET payment_status = 'PENDING'
1247: WHERE claim_id = p_claim_id;

Line 1245: UPDATE ozf_claim_lines_all

1241: END IF;
1242:
1243: -- reset payment status in ozf_claim_lines_all
1244: BEGIN
1245: UPDATE ozf_claim_lines_all
1246: SET payment_status = 'PENDING'
1247: WHERE claim_id = p_claim_id;
1248: EXCEPTION
1249: WHEN OTHERS THEN