eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_CLAIM_LINE_PVT

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

1413: --
1414: -- PARAMETERS
1415: -- p_summary_view : Available values
1416: -- 1. OZF_AUTOPAY_PVT -- 'AUTOPAY'
1417: -- 2. OZF_CLAIM_LINE_PVT --'ACTIVITY', 'PRODUCT', 'SCHEDULE'
1418: -- p_funds_util_flt :
1419: -- p_cust_account_id : Only be used for OZF_AUTOPAY_PVT
1420: -- x_utiz_sql_stmt : Return datatype is VARCHAR2(500)
1421: --

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

1419: -- p_cust_account_id : Only be used for OZF_AUTOPAY_PVT
1420: -- x_utiz_sql_stmt : Return datatype is VARCHAR2(500)
1421: --
1422: -- NOTE
1423: -- 1. This statement will be used for both OZF_AUTOPAY_PVT and OZF_CLAIM_LINE_PVT
1424: -- to get funds_utilized SQL statement by giving in search criteria.
1425: --
1426: -- HISTORY
1427: -- 25-JUN-2002 mchang Create.

Line 4855: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;

4851: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
4852: l_return_status VARCHAR2(1);
4853:
4854: l_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
4855: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;
4856: l_claim_rec OZF_CLAIM_PVT.claim_rec_type := p_claim_rec;
4857: l_claim_id NUMBER;
4858: l_cust_account_id NUMBER;
4859: l_plan_type VARCHAR2(30);

Line 5314: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(

5310: END IF;
5311: END LOOP;
5312: END IF;
5313:
5314: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(
5315: p_api_version => 1.0
5316: ,p_init_msg_list => FND_API.g_false
5317: ,p_commit => FND_API.g_false
5318: ,p_validation_level => FND_API.g_valid_level_full

Line 5470: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;

5466: l_api_name CONSTANT VARCHAR2(30) := 'Create_Claim_Existing_Accruals';
5467: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
5468: l_return_status VARCHAR2(1);
5469: l_funds_util_flt OZF_CLAIM_ACCRUAL_PVT.funds_util_flt_type;
5470: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;
5471: l_claim_rec OZF_CLAIM_PVT.claim_rec_type := p_claim_rec;
5472: l_claim_id NUMBER;
5473: l_cust_account_id NUMBER;
5474: l_plan_type VARCHAR2(30);

Line 5822: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(

5818: l_line_tbl(i).claim_id := l_claim_id;
5819: END IF;
5820: END LOOP;
5821:
5822: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(
5823: p_api_version => 1.0
5824: ,p_init_msg_list => FND_API.g_false
5825: ,p_commit => FND_API.g_false
5826: ,p_validation_level => FND_API.g_valid_level_full

Line 6222: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;

6218:
6219: -- Added For Bug 7509079
6220: l_funds_util_flt funds_util_flt_type := p_funds_util_flt;
6221:
6222: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;
6223: l_cust_account_id NUMBER;
6224: l_plan_type VARCHAR2(30);
6225: l_plan_id NUMBER;
6226: l_product_level_type VARCHAR2(30);

Line 6491: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(

6487: DBMS_SQL.close_cursor(l_emp_csr);
6488:
6489: -- if earnings are found
6490: IF l_counter > 1 THEN
6491: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(
6492: p_api_version => 1.0
6493: ,p_init_msg_list => FND_API.g_false
6494: ,p_commit => FND_API.g_false
6495: ,p_validation_level => FND_API.g_valid_level_full

Line 6870: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;

6866: l_new_line_amount NUMBER;
6867: l_claim_amount NUMBER;
6868: l_claim_id NUMBER;
6869: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
6870: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;
6871: l_cust_trade_profile g_cust_trade_profile_csr%rowtype;
6872: l_payment_method VARCHAR2(30);
6873: l_cust_billto_acct_site_id NUMBER;
6874: l_vendor_id NUMBER;

Line 7207: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(

7203: l_line_tbl(i).claim_id := l_claim_id;
7204: END IF;
7205: END LOOP;
7206:
7207: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(
7208: p_api_version => 1.0
7209: ,p_init_msg_list => FND_API.g_false
7210: ,p_commit => FND_API.g_false
7211: ,p_validation_level => FND_API.g_valid_level_full

Line 7360: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;

7356: l_new_line_amount NUMBER;
7357: l_claim_amount NUMBER;
7358: l_claim_id NUMBER;
7359: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
7360: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;
7361: l_cust_trade_profile g_cust_trade_profile_csr%rowtype;
7362: l_payment_method VARCHAR2(30);
7363: l_cust_billto_acct_site_id NUMBER;
7364: l_vendor_id NUMBER;

Line 7691: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(

7687: l_line_tbl(i).claim_id := l_claim_id;
7688: END IF;
7689: END LOOP;
7690:
7691: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(
7692: p_api_version => 1.0
7693: ,p_init_msg_list => FND_API.g_false
7694: ,p_commit => FND_API.g_false
7695: ,p_validation_level => FND_API.g_valid_level_full

Line 9629: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;

9625: l_new_total_units NUMBER := 0; --EA
9626: l_offer_quantity NUMBER := 0; --EA
9627:
9628: -- Added for fix 11793070
9629: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;
9630:
9631: CURSOR csr_function_currency(cv_org_id NUMBER) IS
9632: SELECT gs.currency_code
9633: FROM gl_sets_of_books gs

Line 9751: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(

9747: l_line_tbl(1).PERFORMANCE_ATTACHED_FLAG := 'F';
9748: l_line_tbl(1).SELECT_CUST_CHILDREN_FLAG := 'F';
9749:
9750: -- Create Claim Line
9751: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(
9752: p_api_version => 1.0
9753: ,p_init_msg_list => FND_API.g_false
9754: ,p_commit => FND_API.g_false
9755: ,p_validation_level => FND_API.g_valid_level_full

Line 11915: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;

11911: l_batch_line_id NUMBER;
11912:
11913: l_funds_util_flt ozf_claim_accrual_pvt.funds_util_flt_type;
11914: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
11915: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;
11916: l_access_rec ams_access_pvt.access_rec_type;
11917:
11918: --User details added for bug 7578152
11919: l_resp_name VARCHAR2(100) := 'Oracle Trade Management User';

Line 12697: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(

12693: END IF;
12694: END LOOP;
12695:
12696: --Claim line creation
12697: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(
12698: p_api_version => 1.0
12699: ,p_init_msg_list => FND_API.g_false
12700: ,p_commit => FND_API.g_false
12701: ,p_validation_level => FND_API.g_valid_level_full

Line 12925: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;

12921: l_msg_count NUMBER;
12922: l_msg_data VARCHAR2(2000);
12923:
12924: l_funds_util_flt funds_util_flt_type := p_funds_util_flt;
12925: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;
12926: l_claim_line_tbl OZF_Claim_Line_PVT.claim_line_tbl_type;
12927:
12928:
12929: CURSOR csr_claim_header(cv_claim_id IN NUMBER) IS

Line 12926: l_claim_line_tbl OZF_Claim_Line_PVT.claim_line_tbl_type;

12922: l_msg_data VARCHAR2(2000);
12923:
12924: l_funds_util_flt funds_util_flt_type := p_funds_util_flt;
12925: l_line_tbl OZF_CLAIM_LINE_PVT.claim_line_tbl_type;
12926: l_claim_line_tbl OZF_Claim_Line_PVT.claim_line_tbl_type;
12927:
12928:
12929: CURSOR csr_claim_header(cv_claim_id IN NUMBER) IS
12930: SELECT created_from

Line 12989: OZF_Claim_Line_PVT.Delete_Claim_Line_Tbl(

12985: CLOSE claim_line_id_csr;
12986:
12987: IF(l_claim_line_tbl.COUNT > 0 ) THEN
12988: OZF_Utility_PVT.debug_message('Deleting the Non promotional Lines');
12989: OZF_Claim_Line_PVT.Delete_Claim_Line_Tbl(
12990: p_api_version => l_api_version
12991: ,p_init_msg_list => FND_API.g_false
12992: ,p_commit => FND_API.g_false
12993: ,p_validation_level => FND_API.g_valid_level_full

Line 13023: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(

13019: l_line_tbl(1).PERFORMANCE_ATTACHED_FLAG := 'F';
13020: l_line_tbl(1).SELECT_CUST_CHILDREN_FLAG := 'F';
13021:
13022: -- Create Claim Line
13023: OZF_CLAIM_LINE_PVT.Create_Claim_Line_Tbl(
13024: p_api_version => 1.0
13025: ,p_init_msg_list => FND_API.g_false
13026: ,p_commit => FND_API.g_false
13027: ,p_validation_level => FND_API.g_valid_level_full

Line 13063: OZF_Claim_Line_PVT.split_claim_line

13059: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
13060: RAISE FND_API.g_exc_error;
13061: END IF;
13062: -- Auto split the Claim Line if there is multiple product associated with the same offer
13063: OZF_Claim_Line_PVT.split_claim_line
13064: (
13065: p_api_version => 1.0
13066: ,p_init_msg_list => FND_API.g_false
13067: ,p_commit => FND_API.g_false