1 PACKAGE OZF_AUTOPAY_PVT AS
2 /* $Header: ozfvatos.pls 120.3 2005/12/02 04:59:42 kdhulipa ship $ */
3
4 TYPE offer_type IS RECORD
5 ( cust_account_id number,
6 amount number,
7 offer_id number,
8 adjustment_type_id number
9 );
10
11 g_miss_offer_rec offer_type;
12 TYPE offer_tbl_type IS TABLE OF offer_type INDEX BY BINARY_INTEGER;
13 g_miss_offer_tbl offer_tbl_type;
14
15 ---------------------------------------------------------------------
16 -- PROCEDURE
17 -- Create_Claim_for_BD_Offer
18 --
19 -- PURPOSE
20 -- Create a claim for a backdated offer.
21 --
22 -- PARAMETERS
23 -- p_offer_tbl : list of offers info that a claim will be created on.
24 --
25 ---------------------------------------------------------------------
26 PROCEDURE Create_Claim_for_BD_Offer(
27 p_api_version IN NUMBER
28 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
29 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
30 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
31 ,x_return_status OUT NOCOPY VARCHAR2
32 ,x_msg_data OUT NOCOPY VARCHAR2
33 ,x_msg_count OUT NOCOPY NUMBER
34 ,p_offer_tbl IN offer_tbl_type
35 );
36
37 --------------------------------------------------------------------------------
38 -- API name : Start_Autopay
39 -- Type : Public
40 -- Pre-reqs : None
41 -- Function : Package that performs auto payment.
42 -- Parameters :
43 --
44 -- IN : p_run_mode IN VARCHAR2 Optional
45 -- : p_customer_id IN NUMBER Optional
46 -- : p_relationship_type IN VARCHAR2 Optional
47 -- : p_related_cust_account_id IN NUMBER Optional
48 -- : p_buy_group_party_id IN NUMBER Optional
49 -- : p_select_cust_children_flag IN VARCHAR2 Optional
50 -- : p_pay_to_customer IN VARCHAR2 Optional
51 -- : p_fund_id IN NUMBER Optional
52 -- : p_plan_type IN NUMBER Optional
53 -- : p_offer_type IN VARCHAR2 Optional
54 -- : p_plan_id IN NUMBER Optional
55 -- : p_product_category_id IN NUMBER Optional
56 -- : p_product_id IN NUMBER Optional
57 -- : p_end_date IN VARCHAR2 Optional
58 -- : p_org_id IN NUMBER Optional
59 --
60 -- Version : Current version 1.0
61 --
62 --------------------------------------------------------------------------------
63 PROCEDURE Start_Autopay (
64 ERRBUF OUT NOCOPY VARCHAR2,
65 RETCODE OUT NOCOPY NUMBER,
66 p_org_id IN NUMBER DEFAULT NULL,
67 p_run_mode IN VARCHAR2 := NULL,
68 p_customer_id IN NUMBER := NULL,
69 p_relationship_type IN VARCHAR2 := NULL,
70 p_related_cust_account_id IN NUMBER := NULL,
71 p_buy_group_party_id IN NUMBER := NULL,
72 p_select_cust_children_flag IN VARCHAR2 := 'N',
73 p_pay_to_customer IN VARCHAR2 := NULL,
74 p_fund_id IN NUMBER := NULL,
75 p_plan_type IN VARCHAR2 := NULL,
76 p_offer_type IN VARCHAR2 := NULL,
77 p_plan_id IN NUMBER := NULL,
78 p_product_category_id IN NUMBER := NULL,
79 p_product_id IN NUMBER := NULL,
80 p_end_date IN VARCHAR2,
81 p_group_by_offer IN VARCHAR2
82 );
83
84 END OZF_AUTOPAY_PVT;