APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_CLAIM_LINE_PVT

Line 1222: -- 2. OZF_CLAIM_LINE_PVT --'ACTIVITY', 'PRODUCT', 'SCHEDULE'

1218: --
1219: -- PARAMETERS
1220: -- p_summary_view : Available values
1221: -- 1. OZF_AUTOPAY_PVT -- 'AUTOPAY'
1222: -- 2. OZF_CLAIM_LINE_PVT --'ACTIVITY', 'PRODUCT', 'SCHEDULE'
1223: -- p_funds_util_flt :
1224: -- p_cust_account_id : Only be used for OZF_AUTOPAY_PVT
1225: -- x_utiz_sql_stmt : Return datatype is VARCHAR2(500)
1226: --

Line 1228: -- 1. This statement will be used for both OZF_AUTOPAY_PVT and OZF_CLAIM_LINE_PVT

1224: -- p_cust_account_id : Only be used for OZF_AUTOPAY_PVT
1225: -- x_utiz_sql_stmt : Return datatype is VARCHAR2(500)
1226: --
1227: -- NOTE
1228: -- 1. This statement will be used for both OZF_AUTOPAY_PVT and OZF_CLAIM_LINE_PVT
1229: -- to get funds_utilized SQL statement by giving in search criteria.
1230: --
1231: -- HISTORY
1232: -- 25-JUN-2002 mchang Create.

Line 4472: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;

4468: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
4469: l_return_status VARCHAR2(1);
4470:
4471: l_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
4472: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;
4473: l_claim_rec OZF_CLAIM_PVT.claim_rec_type := p_claim_rec;
4474: l_claim_id NUMBER;
4475: l_cust_account_id NUMBER;
4476: l_plan_type VARCHAR2(30);

Line 4796: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(

4792: l_line_tbl(i).claim_id := l_claim_id;
4793: END IF;
4794: END LOOP;
4795:
4796: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(
4797: p_api_version => 1.0
4798: ,p_init_msg_list => FND_API.g_false
4799: ,p_commit => FND_API.g_false
4800: ,p_validation_level => FND_API.g_valid_level_full

Line 5176: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;

5172:
5173: -- Added For Bug 7509079
5174: l_funds_util_flt funds_util_flt_type := p_funds_util_flt;
5175:
5176: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;
5177: l_cust_account_id NUMBER;
5178: l_plan_type VARCHAR2(30);
5179: l_plan_id NUMBER;
5180: l_product_level_type VARCHAR2(30);

Line 5399: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(

5395: DBMS_SQL.close_cursor(l_emp_csr);
5396:
5397: -- if earnings are found
5398: IF l_counter > 1 THEN
5399: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(
5400: p_api_version => 1.0
5401: ,p_init_msg_list => FND_API.g_false
5402: ,p_commit => FND_API.g_false
5403: ,p_validation_level => FND_API.g_valid_level_full

Line 5780: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;

5776: l_new_line_amount NUMBER;
5777: l_claim_amount NUMBER;
5778: l_claim_id NUMBER;
5779: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
5780: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;
5781: l_cust_trade_profile g_cust_trade_profile_csr%rowtype;
5782: l_payment_method VARCHAR2(30);
5783: l_cust_billto_acct_site_id NUMBER;
5784: l_vendor_id NUMBER;

Line 6138: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(

6134: l_line_tbl(i).claim_id := l_claim_id;
6135: END IF;
6136: END LOOP;
6137:
6138: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(
6139: p_api_version => 1.0
6140: ,p_init_msg_list => FND_API.g_false
6141: ,p_commit => FND_API.g_false
6142: ,p_validation_level => FND_API.g_valid_level_full

Line 9659: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;

9655: l_batch_line_id NUMBER;
9656:
9657: l_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
9658: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
9659: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;
9660: l_access_rec ams_access_pvt.access_rec_type;
9661:
9662: --User details added for bug 7578152
9663: l_resp_name VARCHAR2(100) := 'Oracle Trade Management User';

Line 10290: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(

10286: END IF;
10287: END LOOP;
10288:
10289: --Claim line creation
10290: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(
10291: p_api_version => 1.0
10292: ,p_init_msg_list => FND_API.g_false
10293: ,p_commit => FND_API.g_false
10294: ,p_validation_level => FND_API.g_valid_level_full