[Home] [Help]
PACKAGE: APPS.CSE_IPA_TRANS_PKG
Source
1 PACKAGE cse_ipa_trans_pkg AUTHID CURRENT_USER AS
2 /* $Header: CSEIPATS.pls 120.7 2006/09/11 23:07:13 brmanesh noship $ */
3
4 G_API_NAME CONSTANT VARCHAR2(30) := 'CSE_IPA_TRANS_PKG';
5
6 TYPE nl_pa_interface_rec_type IS RECORD (
7 transaction_source varchar2(30),
8 batch_name varchar2(50),
9 expenditure_ending_date date,
10 employee_number varchar2(30),
11 organization_name VARCHAR2(240),
12 expenditure_item_date date,
13 project_number varchar2(100),
14 task_number varchar2(100),
15 expenditure_type varchar2(150),
16 non_labor_resource varchar2(150),
17 non_labor_resource_org_name varchar2(60),
18 quantity number,
19 raw_cost number,
20 expenditure_comment varchar2(240),
21 transaction_status_code varchar2(2),
22 transaction_rejection_code varchar2(30),
23 expenditure_id number,
24 orig_transaction_reference varchar2(30),
25 attribute_category varchar2(30),
26 attribute1 varchar2(150),
27 attribute2 varchar2(150),
28 attribute3 varchar2(150),
29 attribute4 varchar2(150),
30 attribute5 varchar2(150),
31 attribute6 varchar2(150),
32 attribute7 varchar2(150),
33 attribute8 varchar2(150),
34 attribute9 varchar2(150),
35 attribute10 varchar2(150),
36 raw_cost_rate number,
37 interface_id number,
38 unmatched_negative_txn_flag varchar2(1),
39 expenditure_item_id number,
40 org_id number,
41 dr_code_combination_id number,
42 cr_code_combination_id number,
43 cdl_system_reference1 varchar2(30),
44 cdl_system_reference2 varchar2(30),
45 cdl_system_reference3 varchar2(30),
46 cdl_system_reference4 varchar2(30),
47 cdl_system_reference5 varchar2(30),
48 gl_date date,
49 burdened_cost number,
50 burdened_cost_rate number,
51 system_linkage varchar2(30),
52 txn_interface_id number,
53 user_transaction_source varchar2(80),
54 created_by number,
55 creation_date date,
56 last_updated_by number,
57 last_update_date date,
58 receipt_currency_amount number,
59 receipt_currency_code varchar2(15),
60 receipt_exchange_rate number,
61 denom_currency_code varchar2(15),
62 denom_raw_cost number,
63 denom_burdened_cost number,
64 acct_rate_date date,
65 acct_rate_type varchar2(30),
66 acct_exchange_rate number,
67 acct_raw_cost number,
68 acct_burdened_cost number,
69 acct_exchange_rounding_limit number,
70 project_currency_code varchar2(15),
71 project_rate_date date,
72 project_rate_type varchar2(30),
73 project_exchange_rate number,
74 orig_exp_txn_reference1 varchar2(60),
75 orig_exp_txn_reference2 varchar2(60),
76 orig_exp_txn_reference3 varchar2(60),
77 orig_user_exp_txn_reference varchar2(60),
78 vendor_number varchar2(30),
79 override_to_organization_name varchar2(60),
80 reversed_orig_txn_reference varchar2(30),
81 billable_flag varchar2(1),
82 person_business_group_name varchar2(60),
83 net_zero_adjustment_flag varchar2(1),
84 adjusted_expenditure_item_id number,
85 organization_id number,
86 inventory_item_id number,
87 po_number varchar2(20),
88 po_header_id number,
89 po_line_num number,
90 po_line_id number,
91 vendor_id number,
92 project_id number,
93 task_id number,
94 document_type varchar2(30),
95 document_distribution_type varchar2(30));
96
97 TYPE NL_PA_Interface_Tbl_TYPE IS TABLE OF NL_PA_Interface_Rec_TYPE INDEX BY BINARY_INTEGER;
98
99 PROCEDURE Populate_PA_Interface(
100 P_NL_PA_Interface_Tbl IN NL_PA_Interface_Tbl_TYPE,
101 x_Return_Status OUT NOCOPY VARCHAR2,
102 x_Error_Message OUT NOCOPY VARCHAR2);
103
104 PROCEDURE get_fa_asset_category (
105 p_item_id IN NUMBER,
106 p_inv_master_org_id IN NUMBER,
107 p_transaction_id IN NUMBER,
108 x_asset_category_id OUT NOCOPY NUMBER,
109 x_asset_category OUT NOCOPY VARCHAR2,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_error_message OUT NOCOPY VARCHAR2);
112
113 PROCEDURE get_fa_location_segment (
114 p_fa_location_id IN NUMBER,
115 p_transaction_id IN NUMBER,
116 x_fa_location OUT NOCOPY VARCHAR2,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_error_message OUT NOCOPY VARCHAR2);
119
120 PROCEDURE get_product_name (
121 p_project_id IN NUMBER,
122 p_transaction_id IN NUMBER,
123 x_product_name OUT NOCOPY VARCHAR2,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_error_message OUT NOCOPY VARCHAR2);
126
127 PROCEDURE get_grouping_attribute(
128 p_item_id IN NUMBER,
129 p_organization_id IN NUMBER,
130 p_project_id IN NUMBER,
131 p_fa_location_id IN NUMBER,
132 p_transaction_id IN NUMBER,
133 p_org_id IN NUMBER,
134 x_attribute8 OUT NOCOPY VARCHAR2,
135 x_attribute9 OUT NOCOPY VARCHAR2,
136 x_attribute10 OUT NOCOPY VARCHAR2,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_error_message OUT NOCOPY VARCHAR2);
139
140 END CSE_IPA_TRANS_PKG;