[Home] [Help]
PACKAGE: APPS.CSTPALTY
Source
1 PACKAGE CSTPALTY AS
2 /* $Header: CSTALTYS.pls 120.2.12010000.3 2008/11/25 09:01:12 anjha ship $ */
3
4 TYPE cst_ae_txn_rec_type IS RECORD (
5 event_type_id VARCHAR2(30),
6 txn_action_id NUMBER(15),
7 txn_src_type_id NUMBER(15),
8 txn_src_id NUMBER(15),
9 txn_type_id NUMBER(15),
10 txn_type_flag VARCHAR2(10),
11 --wip_txn_type NUMBER(15),
12 txn_type VARCHAR2(30),
13 transaction_id NUMBER(15),
14 inventory_item_id NUMBER(15),
15 set_of_books_id NUMBER(15),
16 legal_entity_id NUMBER(15),
17 cost_type_id NUMBER(15),
18 cost_group_id NUMBER(15),
19 xfer_cost_group_id NUMBER(15),
20 primary_quantity NUMBER,
21 subinventory_code VARCHAR2(10),
22 xfer_organization_id NUMBER(15),
23 xfer_subinventory VARCHAR2(10),
24 xfer_transaction_id NUMBER(15),
25 dist_acct_id NUMBER(15),
26 currency_code VARCHAR2(15),
27 currency_conv_type VARCHAR2(30),
28 currency_conv_date DATE,
29 currency_conv_rate NUMBER,
30 ae_category varchar2(15),
31 accounting_period_id NUMBER(15),
32 accounting_period_name VARCHAR2(15),
33 accounting_date DATE,
34 organization_id NUMBER(15),
35 mat_account NUMBER(15),
36 mat_ovhd_account NUMBER(15),
37 res_account NUMBER(15),
38 osp_account NUMBER(15),
39 ovhd_account NUMBER(15),
40 -- Retro Changes -------------------------------------------
41 credit_account NUMBER DEFAULT NULL,
42 unit_price NUMBER DEFAULT NULL,
43 prior_unit_price NUMBER DEFAULT NULL,
44 po_distribution_id NUMBER DEFAULT NULL,
45 ------------------------------------------------------------
46 flow_schedule NUMBER(15),
47 exp_item NUMBER,
48 category_id NUMBER ,
49 source_table VARCHAR2(15),
50 source_id NUMBER,
51 description VARCHAR2(240),
52 wip_entity_type NUMBER,
53 line_id NUMBER,
54 encum_amount NUMBER,
55 encum_account NUMBER,
56 encum_type_id NUMBER,
57 -- Added for Revenue / COGS Matching --
58 so_issue_acct_type NUMBER,
59 om_line_id NUMBER,
60 cogs_percentage NUMBER,
61 expense_account_id NUMBER,
62 lcm_flag VARCHAR2(1),
63 debit_account NUMBER
64 );
65
66 TYPE cst_ae_line_rec_type IS RECORD (
67 ae_line_type NUMBER(5),
68 description VARCHAR2(240),
69 account NUMBER(15),
70 currency_code VARCHAR2(15),
71 currency_conv_type VARCHAR2(30),
72 currency_conv_date DATE,
73 currency_conv_rate NUMBER,
74 -- Retroactive Pricing - Patchset J ------------
75 accounted_value NUMBER,
76 entered_value NUMBER,
77 ------------------------------------------------
78 entered_dr NUMBER,
79 entered_cr NUMBER,
80 accounted_dr NUMBER,
81 accounted_cr NUMBER,
82 source_table VARCHAR2(30),
83 source_id NUMBER,
84 rate_or_amount NUMBER,
85 basis_type NUMBER,
86 resource_id NUMBER,
87 cost_element_id NUMBER,
88 activity_id NUMBER,
89 repetitive_schedule_id NUMBER,
90 overhead_basis_factor NUMBER,
91 basis_resource_id NUMBER,
92 transaction_value NUMBER,
93 actual_flag VARCHAR2(1),
94 encum_type_id NUMBER,
95 po_distribution_id NUMBER,
96 wip_entity_id NUMBER,
97 reference1 VARCHAR2(240),
98 reference2 VARCHAR2(240),
99 reference3 VARCHAR2(240),
100 reference4 VARCHAR2(240),
101 reference5 VARCHAR2(240),
102 reference6 VARCHAR2(240),
103 reference7 VARCHAR2(240),
104 reference8 VARCHAR2(240),
105 reference9 VARCHAR2(240),
106 reference10 VARCHAR2(240)
107 );
108
109 TYPE cst_ae_curr_rec_type IS RECORD (
110 pri_currency VARCHAR2(15),
111 alt_currency VARCHAR2(15),
112 currency_conv_type VARCHAR2(30),
113 currency_conv_date DATE,
114 currency_conv_rate NUMBER
115 );
116
117 TYPE cst_ae_acct_rec_type IS RECORD (
118 account NUMBER,
119 mat_account NUMBER,
120 mat_ovhd_account NUMBER,
121 res_account NUMBER,
122 osp_account NUMBER,
123 ovhd_account NUMBER
124 );
125
126 TYPE cst_ae_err_rec_type IS RECORD (
127 l_err_num NUMBER,
128 l_err_code VARCHAR2(240),
129 l_err_msg VARCHAR2(240)
130 );
131
132 TYPE cst_ae_par_rec_type IS RECORD (
133 legal_entity NUMBER,
134 cost_type_id NUMBER,
135 cost_group_id NUMBER,
136 period_id NUMBER
137 );
138
139
140 TYPE cst_ae_line_tbl_type IS TABLE OF cst_ae_line_rec_type;
141
142 END CSTPALTY;
143