[Home] [Help]
PACKAGE: APPS.OZF_TP_ACCRUAL_PVT
Source
1 PACKAGE OZF_TP_ACCRUAL_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvtpas.pls 120.1.12020000.6 2012/11/30 06:11:53 nepanda ship $ */
3
4
5 -- Default number of records fetch per call
6 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
7
8
9 G_IFACE_CALLER CONSTANT VARCHAR2(30) :='IFACE';
10 G_RESALE_CALLER CONSTANT VARCHAR2(30) :='RESALE';
11 G_CONC_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
12
13 -- Added for Bug # 14584673
14 TYPE ozf_draft_accrual_rec_type IS RECORD(
15 DRAFT_UTILIZATION_ID NUMBER,
16 DRAFT_RUN_ID NUMBER,
17 OBJECT_TYPE VARCHAR2(30),
18 OBJECT_ID NUMBER,
19 LAST_UPDATE_DATE DATE,
20 LAST_UPDATED_BY NUMBER,
21 LAST_UPDATE_LOGIN NUMBER,
22 CREATION_DATE DATE,
23 CREATED_BY NUMBER,
24 REQUEST_ID NUMBER,
25 PROGRAM_APPLICATION_ID NUMBER,
26 PROGRAM_ID NUMBER,
27 PROGRAM_UPDATE_DATE DATE,
28 UTILIZATION_TYPE VARCHAR2(30),
29 PLAN_TYPE VARCHAR2(30),
30 PLAN_ID NUMBER,
31 ACCTD_AMOUNT NUMBER,
32 EXCHANGE_RATE_TYPE VARCHAR2(30),
33 EXCHANGE_RATE_DATE DATE,
34 EXCHANGE_RATE NUMBER,
35 ORG_ID NUMBER,
36 PRODUCT_ID NUMBER,
37 CUST_ACCOUNT_ID NUMBER,
38 PRODUCT_LEVEL_TYPE VARCHAR2(30),
39 PLAN_CURR_AMOUNT NUMBER,
40 ACTIVITY_PRODUCT_ID NUMBER,
41 BILLTO_CUST_ACCOUNT_ID NUMBER,
42 REFERENCE_TYPE VARCHAR2(30),
43 REFERENCE_ID NUMBER,
44 SHIP_TO_SITE_USE_ID NUMBER,
45 BILL_TO_SITE_USE_ID NUMBER,
46 PLAN_CURRENCY_CODE VARCHAR2(30),
47 DISCOUNT_TYPE VARCHAR2(30),
48 DISCOUNT_AMOUNT NUMBER,
49 DISCOUNT_AMOUNT_CURRENCY_CODE VARCHAR2(30),
50 LIST_LINE_ID NUMBER
51 );
52 TYPE ozf_draft_accrual_tbl_type IS TABLE OF ozf_draft_accrual_rec_type INDEX BY BINARY_INTEGER;
53
54 ---------------------------------------------------------------------
55 -- PROCEDURE
56 -- Validate_Order_Record
57 --
58 -- PURPOSE
59 -- This procedure validates the order information
60 -- These are validation specific to chargeback process
61 --
62 -- PARAMETERS
63 --
64 --
65 -- NOTES
66 ---------------------------------------------------------------------
67 PROCEDURE Validate_Order_Record(
68 p_api_version IN NUMBER
69 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
70 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
71 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
72 ,p_resale_batch_id IN NUMBER
73 ,p_caller_type IN VARCHAR2
74 ,x_return_status OUT NOCOPY VARCHAR2
75 ,x_msg_data OUT NOCOPY VARCHAR2
76 ,x_msg_count OUT NOCOPY NUMBER
77 );
78
79 ---------------------------------------------------------------------
80 -- PROCEDURE
81 -- Process_Order
82 --
83 -- PURPOSE
84 -- This is the main API for Third party accrual. It reads the order information of dicrect customers
85 -- and creates accruals based on the result of the pricing simulation.
86 --
87 -- PARAMETERS
88 --
89 --
90 -- NOTES
91 ---- Bug 14194884 - TPA In Draft Mode ER - Added two new parameters.p_run_mode and p_draft_run_id
92 ---------------------------------------------------------------------
93 PROCEDURE Process_Order (
94 p_api_version IN NUMBER
95 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
96 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
97 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
98 ,p_resale_batch_id IN NUMBER
99 ,p_run_mode IN VARCHAR2 := NULL
100 ,p_draft_run_id IN NUMBER := NULL
101 ,x_return_status OUT NOCOPY VARCHAR2
102 ,x_msg_data OUT NOCOPY VARCHAR2
103 ,x_msg_count OUT NOCOPY NUMBER
104 );
105
106 ---------------------------------------------------------------------
107 -- PROCEDURE
108 -- Process_Resale
109 --
110 -- PURPOSE
111 -- Process resale order information. Reads date from ozf_reasle_lines table.
112 --
113 -- PARAMETERS
114 --
115 -- NOTES
116 --
117 ---------------------------------------------------------------------
118 PROCEDURE Process_Resale
119 (
120 p_api_version IN NUMBER
121 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
122 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
123 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
124 ,p_resale_batch_id IN NUMBER
125 ,x_return_status OUT NOCOPY VARCHAR2
126 ,x_msg_data OUT NOCOPY VARCHAR2
127 ,x_msg_count OUT NOCOPY NUMBER
128 );
129
130
131 PROCEDURE Process_TP_ACCRUAL (
132 p_api_version IN NUMBER
133 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
134 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
135 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
136 ,p_data_source_code IN VARCHAR2 := NULL
137 ,p_run_mode IN VARCHAR2 -- Bug 14194884 - TPA In Draft Mode ER : Added new parameter Run Mode
138 ,x_return_status OUT NOCOPY VARCHAR2
139 ,x_msg_data OUT NOCOPY VARCHAR2
140 ,x_msg_count OUT NOCOPY NUMBER
141 );
142
143 ---------------------------------------------------------------------
144 -- PROCEDURE
145 -- Start_TP_ACCRUAL
146 --
147 -- PURPOSE
148 -- This procedure to initiate concurrent program to process third party accrual.
149 -- It is to for backword compatibility issue on 11.5.9
150 --
151 -- PARAMETERS
152 --
153 --
154 -- NOTES
155 ---------------------------------------------------------------------
156 PROCEDURE Start_TP_ACCRUAL (
157 ERRBUF OUT NOCOPY VARCHAR2,
158 RETCODE OUT NOCOPY NUMBER,
159 p_org_id IN NUMBER DEFAULT NULL, -- nepanda : Fix for bug # 15900683
160 p_data_source_code IN VARCHAR2 := NULL,
161 p_run_mode IN VARCHAR2 := NULL -- Bug 14194884 - TPA In Draft Mode ER : Added new parameter Run Mode
162 );
163
164 END OZF_TP_ACCRUAL_PVT;