[Home] [Help]
PACKAGE: APPS.OZF_FUND_UTILIZED_PUB
Source
1 PACKAGE OZF_FUND_UTILIZED_PUB AS
2 /* $Header: OZFPFUTS.pls 120.4 2008/03/18 05:19:08 psomyaju 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 g_skip_acct_gen_flag VARCHAR2(1);
20
21 TYPE adjustment_rec_type IS RECORD
22 (fund_id NUMBER
23 ,fund_number VARCHAR2(30)
24 ,adjustment_type VARCHAR2(30)
25 ,adjustment_type_id NUMBER
26 ,amount NUMBER
27 ,currency_code VARCHAR2(30)
28 ,adjustment_date DATE
29 ,gl_date DATE
30 ,activity_type VARCHAR2(4)
31 ,activity_id NUMBER
32 ,offer_code VARCHAR2(30)
33 ,camp_schedule_id NUMBER
34 ,customer_type VARCHAR2(20)
35 ,cust_id NUMBER
36 ,cust_account_id NUMBER
37 ,bill_to_site_use_id NUMBER
38 ,ship_to_site_use_id NUMBER
39 ,document_type VARCHAR2(30)
40 ,document_number NUMBER
41 ,scan_type_id NUMBER
42 ,product_level_type VARCHAR2(10)
43 ,product_name VARCHAR2(50)
44 ,product_id NUMBER
45 ,justification VARCHAR2(100)
46 ,orig_utilization_id NUMBER
47 ,gl_account_credit NUMBER
48 ,gl_account_debit NUMBER
49 ,approver_id NUMBER
50 ,org_id NUMBER
51 ,skip_acct_gen_flag VARCHAR2(1)
52 --DFF/order_line_id added for ER-6858324
53 ,order_line_id NUMBER
54 ,attribute_category VARCHAR2(30)
55 ,attribute1 VARCHAR2(150)
56 ,attribute2 VARCHAR2(150)
57 ,attribute3 VARCHAR2(150)
58 ,attribute4 VARCHAR2(150)
59 ,attribute5 VARCHAR2(150)
60 ,attribute6 VARCHAR2(150)
61 ,attribute7 VARCHAR2(150)
62 ,attribute8 VARCHAR2(150)
63 ,attribute9 VARCHAR2(150)
64 ,attribute10 VARCHAR2(150)
65 ,attribute11 VARCHAR2(150)
66 ,attribute12 VARCHAR2(150)
67 ,attribute13 VARCHAR2(150)
68 ,attribute14 VARCHAR2(150)
69 ,attribute15 VARCHAR2(150)
70 );
71
72 ---------------------------------------------------------------------
73 -- PROCEDURE
74 -- Create_Fund_Adjustment
75 --
76 -- PURPOSE
77 -- Create fund adjustment.
78 --
79 -- PARAMETERS
80 -- p_adj_rec: the new record to be inserted
81 --
82 -- HISTORY
83 -- 04/05/2005 kdass Created
84 ---------------------------------------------------------------------
85 /*#
86 * This procedure creates a fund adjustment.
87 * @param p_api_version Indicates the API version.
88 * @param p_init_msg_list Indicates whether to initialize the message stack.
89 * @param p_commit Indicates whether to commit within the program.
90 * @param p_validation_level Indicates the validation level.
91 * @param p_adj_rec Identifies the new record to be inserted.
92 * @param x_return_status Indicates the status of the program.
93 * @param x_msg_data Returns messages by the program
94 * @param x_msg_count Indicates the number of messages the program returned.
95 * @rep:scope public
96 * @rep:lifecycle active
97 * @rep:displayname Create Fund Adjustment
98 * @rep:compatibility S
99 * @rep:businessevent None
100 */
101 PROCEDURE Create_Fund_Adjustment(
102 p_api_version IN NUMBER
103 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
104 ,p_commit IN VARCHAR2 := fnd_api.g_false
105 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
106 ,p_adj_rec IN OZF_FUND_UTILIZED_PUB.adjustment_rec_type
107 ,x_return_status OUT NOCOPY VARCHAR2
108 ,x_msg_count OUT NOCOPY NUMBER
109 ,x_msg_data OUT NOCOPY VARCHAR2
110 );
111
112 END OZF_FUND_UTILIZED_PUB;