APPS.OZF_AUTOPAY_PVT dependencies on OZF_CLAIM_ACCRUAL_PVT

Line 298: -- p_funds_util_flt IN OZF_Claim_Accrual_PVT.funds_util_flt_type

294: -- p_auto_claim_type_id IN number
295: -- p_autopay_periodicity IN number
296: -- p_autopay_periodicity_type IN VARCHAR2
297: -- p_offer_payment_method IN VARCHAR2
298: -- p_funds_util_flt IN OZF_Claim_Accrual_PVT.funds_util_flt_type
299: -- x_return_status OUT VARCHAR2
300: --
301: -- NOTES
302: ---------------------------------------------------------------------

Line 312: p_funds_util_flt IN OZF_Claim_Accrual_PVT.funds_util_flt_type,

308: p_auto_claim_type_id IN number,
309: p_autopay_periodicity IN number,
310: p_autopay_periodicity_type IN VARCHAR2,
311: p_offer_payment_method IN VARCHAR2,
312: p_funds_util_flt IN OZF_Claim_Accrual_PVT.funds_util_flt_type,
313: x_return_status OUT NOCOPY VARCHAR2
314: )
315: IS
316: l_amount number := p_amount;

Line 322: l_funds_util_flt OZF_Claim_Accrual_PVT.funds_util_flt_type := p_funds_util_flt;

318: l_last_pay_date date;
319: l_claim_id number;
320: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
321: l_claim_settle_rec OZF_CLAIM_PVT.claim_rec_type;
322: l_funds_util_flt OZF_Claim_Accrual_PVT.funds_util_flt_type := p_funds_util_flt;
323: l_plan_type VARCHAR2(30);
324:
325: CURSOR csr_cust_name(cv_cust_account_id IN NUMBER) IS
326: SELECT CONCAT(CONCAT(party.party_name, ' ('), CONCAT(ca.account_number, ') '))

Line 493: OZF_CLAIM_ACCRUAL_PVT.Create_Claim_For_Accruals(

489: ELSE
490: l_funds_util_flt.offer_payment_method := 'NULL';
491: END IF;
492:
493: OZF_CLAIM_ACCRUAL_PVT.Create_Claim_For_Accruals(
494: p_api_version => 1.0
495: ,p_init_msg_list => FND_API.g_false
496: ,p_commit => FND_API.g_false
497: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 660: l_funds_util_flt OZF_CLAIM_ACCRUAL_PVT.funds_util_flt_type := NULL;

656: from ozf_offer_adjustments_b
657: where list_header_id = p_id;
658:
659: l_customer_info g_customer_info_csr%rowtype;
660: l_funds_util_flt OZF_CLAIM_ACCRUAL_PVT.funds_util_flt_type := NULL;
661:
662: BEGIN
663:
664: SAVEPOINT BDOffer;

Line 940: l_funds_util_flt OZF_CLAIM_ACCRUAL_PVT.funds_util_flt_type := NULL;

936: TYPE EmpCurType IS REF CURSOR;
937: l_emp_csr NUMBER; --EmpCurType;
938:
939: l_stmt VARCHAR2(3000);
940: l_funds_util_flt OZF_CLAIM_ACCRUAL_PVT.funds_util_flt_type := NULL;
941:
942: l_cust_account_id number;
943: l_amount number;
944: l_customer_info g_customer_info_csr%rowtype;

Line 967: l_currency_rec OZF_CLAIM_ACCRUAL_PVT.currency_rec_type;

963: --Multiorg Changes
964: m NUMBER := 0;
965: l_org_id OZF_UTILITY_PVT.operating_units_tbl;
966:
967: l_currency_rec OZF_CLAIM_ACCRUAL_PVT.currency_rec_type;
968:
969: BEGIN
970:
971: SAVEPOINT AutoPay;

Line 1176: OZF_Claim_Accrual_Pvt.Get_Utiz_Sql_Stmt(

1172:
1173: --//Populating Currency record set
1174: l_currency_rec.universal_currency_code := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');
1175:
1176: OZF_Claim_Accrual_Pvt.Get_Utiz_Sql_Stmt(
1177: p_api_version => 1.0
1178: ,p_init_msg_list => FND_API.g_false
1179: ,p_commit => FND_API.g_false
1180: ,p_validation_level => FND_API.g_valid_level_full