DBA Data[Home] [Help]

APPS.OZF_AUTOPAY_PVT dependencies on OZF_CLAIM_ACCRUAL_PVT

Line 270: -- p_funds_util_flt IN OZF_Claim_Accrual_PVT.funds_util_flt_type

266: -- p_auto_claim_type_id IN number
267: -- p_autopay_periodicity IN number
268: -- p_autopay_periodicity_type IN VARCHAR2
269: -- p_offer_payment_method IN VARCHAR2
270: -- p_funds_util_flt IN OZF_Claim_Accrual_PVT.funds_util_flt_type
271: -- x_return_status OUT VARCHAR2
272: --
273: -- NOTES
274: ---------------------------------------------------------------------

Line 284: p_funds_util_flt IN OZF_Claim_Accrual_PVT.funds_util_flt_type,

280: p_auto_claim_type_id IN number,
281: p_autopay_periodicity IN number,
282: p_autopay_periodicity_type IN VARCHAR2,
283: p_offer_payment_method IN VARCHAR2,
284: p_funds_util_flt IN OZF_Claim_Accrual_PVT.funds_util_flt_type,
285: x_return_status OUT NOCOPY VARCHAR2
286: )
287: IS
288: l_amount number := p_amount;

Line 294: l_funds_util_flt OZF_Claim_Accrual_PVT.funds_util_flt_type := p_funds_util_flt;

290: l_last_pay_date date;
291: l_claim_id number;
292: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
293: l_claim_settle_rec OZF_CLAIM_PVT.claim_rec_type;
294: l_funds_util_flt OZF_Claim_Accrual_PVT.funds_util_flt_type := p_funds_util_flt;
295: l_plan_type VARCHAR2(30);
296:
297: CURSOR csr_cust_name(cv_cust_account_id IN NUMBER) IS
298: SELECT CONCAT(CONCAT(party.party_name, ' ('), CONCAT(ca.account_number, ') '))

Line 449: OZF_CLAIM_ACCRUAL_PVT.Create_Claim_For_Accruals(

445: ELSE
446: l_funds_util_flt.offer_payment_method := 'NULL';
447: END IF;
448:
449: OZF_CLAIM_ACCRUAL_PVT.Create_Claim_For_Accruals(
450: p_api_version => 1.0
451: ,p_init_msg_list => FND_API.g_false
452: ,p_commit => FND_API.g_false
453: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 615: l_funds_util_flt OZF_CLAIM_ACCRUAL_PVT.funds_util_flt_type := NULL;

611: from ozf_offer_adjustments_b
612: where list_header_id = p_id;
613:
614: l_customer_info g_customer_info_csr%rowtype;
615: l_funds_util_flt OZF_CLAIM_ACCRUAL_PVT.funds_util_flt_type := NULL;
616:
617: BEGIN
618:
619: SAVEPOINT BDOffer;

Line 895: l_funds_util_flt OZF_CLAIM_ACCRUAL_PVT.funds_util_flt_type := NULL;

891: TYPE EmpCurType IS REF CURSOR;
892: l_emp_csr NUMBER; --EmpCurType;
893:
894: l_stmt VARCHAR2(3000);
895: l_funds_util_flt OZF_CLAIM_ACCRUAL_PVT.funds_util_flt_type := NULL;
896:
897: l_cust_account_id number;
898: l_amount number;
899: l_customer_info g_customer_info_csr%rowtype;

Line 1123: OZF_Claim_Accrual_Pvt.Get_Utiz_Sql_Stmt(

1119: -- and all currency records are retrieved but they are
1120: -- grouped by currency_code
1121: -- The amount_remaining is in utiz_curency and not in functional currency
1122:
1123: OZF_Claim_Accrual_Pvt.Get_Utiz_Sql_Stmt(
1124: p_api_version => 1.0
1125: ,p_init_msg_list => FND_API.g_false
1126: ,p_commit => FND_API.g_false
1127: ,p_validation_level => FND_API.g_valid_level_full