[Home] [Help]
PACKAGE: APPS.OZF_FUND_UTILIZED_PUB
Source
1 PACKAGE OZF_FUND_UTILIZED_PUB AUTHID CURRENT_USER AS
2 /* $Header: OZFPFUTS.pls 120.11.12020000.2 2012/07/17 11:11:24 bkunjan ship $ */
3 /*#
4 * Use this package to create manual adjustments of types Decrease Committed and Earned Amounts,
5 * Decrease Committed Amount, Decrease Earned Amount, Increase Earned Amount, Decrease Paid Amount
6 * and Increase Paid Amount in Oracle Trade Management.
7 * @rep:scope public
8 * @rep:product OZF
9 * @rep:lifecycle active
10 * @rep:displayname Budget Adjustment Public API
11 * @rep:compatibility S
12 * @rep:businessevent None
13 * @rep:category BUSINESS_ENTITY OZF_BUDGET
14 */
15
16 /*flag to indicate whether the Account Generator Workflow gets called or not
17 'F' to call OZF Account Generator worflow
18 'T' to bypass OZF Account Generator worflow */
19 --ER:9382547
20 --ER:13069257 :
21 g_skip_acct_gen_flag VARCHAR2(1);
22
23 TYPE adjustment_rec_type IS RECORD
24 (fund_id NUMBER
25 ,fund_number VARCHAR2(30)
26 ,adjustment_type VARCHAR2(30)
27 ,adjustment_type_id NUMBER
28 ,amount NUMBER
29 ,currency_code VARCHAR2(30)
30 --nirprasa,12.2 nirprasa ER 8399134
31 --plan_amount = amount in activity currency or amount in document currency for null currency offers.
32 --plan_currency_code = activity currency or document currency for null currency offers.
33 ,plan_amount NUMBER
34 ,plan_currency_code VARCHAR2(30)
35 ,adjustment_date DATE
36 ,gl_date DATE
37 ,activity_type VARCHAR2(4)
38 ,activity_id NUMBER
39 ,offer_code VARCHAR2(30)
40 ,camp_schedule_id NUMBER
41 ,customer_type VARCHAR2(20)
42 ,cust_id NUMBER
43 ,cust_account_id NUMBER
44 ,bill_to_site_use_id NUMBER
45 ,ship_to_site_use_id NUMBER
46 ,document_type VARCHAR2(30)
47 ,document_number NUMBER
48 ,scan_type_id NUMBER
49 ,product_level_type VARCHAR2(10)
50 --amitamku bug 13557948
51 ,product_name VARCHAR2(1000)
52 ,product_id NUMBER
53 ,justification VARCHAR2(100)
54 ,orig_utilization_id NUMBER
55 ,gl_account_credit NUMBER
56 ,gl_account_debit NUMBER
57 ,approver_id NUMBER
58 ,org_id NUMBER
59 --ER:9382547 - Removed the column
60 -- ER:13069257
61 ,skip_acct_gen_flag VARCHAR2(1)
62 --DFF/order_line_id added for ER-6858324
63 ,order_line_id NUMBER
64 ,exchange_rate_date DATE --bug 8532055
65 ,attribute_category VARCHAR2(30)
66 ,attribute1 VARCHAR2(150)
67 ,attribute2 VARCHAR2(150)
68 ,attribute3 VARCHAR2(150)
69 ,attribute4 VARCHAR2(150)
70 ,attribute5 VARCHAR2(150)
71 ,attribute6 VARCHAR2(150)
72 ,attribute7 VARCHAR2(150)
73 ,attribute8 VARCHAR2(150)
74 ,attribute9 VARCHAR2(150)
75 ,attribute10 VARCHAR2(150)
76 ,attribute11 VARCHAR2(150)
77 ,attribute12 VARCHAR2(150)
78 ,attribute13 VARCHAR2(150)
79 ,attribute14 VARCHAR2(150)
80 ,attribute15 VARCHAR2(150)
81 --kdass - bug 9470625
82 ,cost_price NUMBER
83 ,cost_price_currency_code VARCHAR2(15)
84 ,discount_type VARCHAR2(30)
85 ,discount_amount NUMBER
86 ,discount_amount_currency_code VARCHAR2(15)
87 );
88
89 ---------------------------------------------------------------------
90 -- PROCEDURE
91 -- Create_Fund_Adjustment
92 --
93 -- PURPOSE
94 -- Create fund adjustment.
95 --
96 -- PARAMETERS
97 -- p_adj_rec: the new record to be inserted
98 --
99 -- HISTORY
100 -- 04/05/2005 kdass Created
101 ---------------------------------------------------------------------
102 /*#
103 * This procedure creates a fund adjustment.
104 * @param p_api_version Indicates the API version.
105 * @param p_init_msg_list Indicates whether to initialize the message stack.
106 * @param p_commit Indicates whether to commit within the program.
107 * @param p_validation_level Indicates the validation level.
108 * @param p_adj_rec Identifies the new record to be inserted.
109 * @param x_return_status Indicates the status of the program.
110 * @param x_msg_data Returns messages by the program
111 * @param x_msg_count Indicates the number of messages the program returned.
112 * @rep:scope public
113 * @rep:lifecycle active
114 * @rep:displayname Create Fund Adjustment
115 * @rep:compatibility S
116 * @rep:businessevent None
117 */
118 PROCEDURE Create_Fund_Adjustment(
119 p_api_version IN NUMBER
120 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
121 ,p_commit IN VARCHAR2 := fnd_api.g_false
122 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
123 ,p_adj_rec IN OZF_FUND_UTILIZED_PUB.adjustment_rec_type
124 ,x_return_status OUT NOCOPY VARCHAR2
125 ,x_msg_count OUT NOCOPY NUMBER
126 ,x_msg_data OUT NOCOPY VARCHAR2
127 );
128
129 --nirprasa - added for FP of Bug 9383565
130 PROCEDURE Create_Fund_Adjustment(
131 p_api_version IN NUMBER
132 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
133 ,p_commit IN VARCHAR2 := fnd_api.g_false
134 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
135 ,p_adj_rec IN OZF_FUND_UTILIZED_PUB.adjustment_rec_type
136 ,x_return_status OUT NOCOPY VARCHAR2
137 ,x_msg_count OUT NOCOPY NUMBER
138 ,x_msg_data OUT NOCOPY VARCHAR2
139 ,x_utilization_id OUT NOCOPY NUMBER
140 );
141
142 END OZF_FUND_UTILIZED_PUB;