APPS.OZF_PARTNER_CLAIM_GRP dependencies on OZF_CLAIMS_ALL

Line 67: FROM ozf_claims_all

63: CURSOR csr_claim(cv_claim_id IN NUMBER) IS
64: SELECT claim_id
65: , claim_number
66: , amount
67: FROM ozf_claims_all
68: WHERE claim_id = cv_claim_id;
69:
70: l_claim_pub_rec CLAIM_REC_TYPE := p_claim_rec;
71: l_claim_pvt_rec OZF_Claim_PVT.claim_rec_type;

Line 91: l_source_object_class OZF_CLAIMS_ALL.source_object_class%TYPE;

87: AND lu.utilization_id = ut.utilization_id
88: AND ut.object_type = 'ORDER';
89:
90: l_claim_line_id NUMBER;
91: l_source_object_class OZF_CLAIMS_ALL.source_object_class%TYPE;
92: l_source_object_id OZF_CLAIMS_ALL.source_object_id%TYPE;
93:
94: -- [END OF BUG 4067282 FIXING]
95:

Line 92: l_source_object_id OZF_CLAIMS_ALL.source_object_id%TYPE;

88: AND ut.object_type = 'ORDER';
89:
90: l_claim_line_id NUMBER;
91: l_source_object_class OZF_CLAIMS_ALL.source_object_class%TYPE;
92: l_source_object_id OZF_CLAIMS_ALL.source_object_id%TYPE;
93:
94: -- [END OF BUG 4067282 FIXING]
95:
96: BEGIN

Line 438: FROM ozf_claims_all

434:
435: CURSOR csr_claim_obj_num(cv_claim_id IN NUMBER) IS
436: SELECT object_version_number
437: , org_id
438: FROM ozf_claims_all
439: WHERE claim_id = cv_claim_id;
440:
441:
442: -- [BEGIN OF BUG 4067282 FIXING]

Line 519: UPDATE ozf_claims_all

515: -- [END OF BUG 4067282 FIXING]
516:
517: IF p_status_code = 'APPROVED' THEN
518: BEGIN
519: UPDATE ozf_claims_all
520: SET status_code = 'APPROVED'
521: , user_status_id = OZF_UTILITY_PVT.get_default_user_status('OZF_CLAIM_STATUS', 'APPROVED')
522: WHERE claim_id = p_claim_id;
523: EXCEPTION