[Home] [Help]
PACKAGE: APPS.GMF_GET_MAPPINGS
Source
1 PACKAGE GMF_GET_MAPPINGS AS
2 /* $Header: gmfactms.pls 120.2 2006/10/03 15:46:27 rseshadr noship $ */
3
4 TYPE account_mappings IS TABLE OF gl_acct_map%ROWTYPE
5 INDEX BY BINARY_INTEGER;
6
7 TYPE my_order_by IS TABLE OF NUMBER(2)
8 INDEX BY BINARY_INTEGER;
9
10 TYPE my_opm_seg_values IS TABLE OF gl_acct_mst.acct_no%TYPE
11 INDEX BY BINARY_INTEGER;
12 my_accounts account_mappings;
13 no_of_rows NUMBER DEFAULT 0;
14 opm_segment_val my_opm_seg_values;
15
16 PROCEDURE get_account_mappings (v_co_code VARCHAR2,
17 v_orgn_code VARCHAR2,
18 v_whse_code VARCHAR2,
19 v_item_id NUMBER,
20 v_vendor_id NUMBER,
21 v_cust_id NUMBER,
22 v_reason_code VARCHAR2,
23 v_icgl_class VARCHAR2,
24 v_vendgl_class VARCHAR2,
25 v_custgl_class VARCHAR2,
26 v_currency_code VARCHAR2,
27 v_routing_id NUMBER,
28 v_charge_id NUMBER,
29 v_taxauth_id NUMBER,
30 v_aqui_cost_id NUMBER,
31 v_resources VARCHAR2,
32 v_cost_cmpntcls_id NUMBER,
33 v_cost_analysis_code VARCHAR2,
34 v_order_type NUMBER,
35 v_sub_event_type NUMBER,
36 v_source NUMBER DEFAULT 0,
37 v_business_class_cat_id NUMBER DEFAULT 0,
38 v_product_line_cat_id NUMBER DEFAULT 0,
39 v_line_type NUMBER DEFAULT NULL,
40 v_ar_trx_type_id NUMBER DEFAULT 0
41 );
42 FUNCTION get_account_value(v_acct_ttl_type NUMBER) RETURN NUMBER;
43
44 TYPE A_segment IS TABLE OF VARCHAR(150) INDEX BY BINARY_INTEGER;
45
46 PROCEDURE parse_account(p_co_code VARCHAR2,
47 p_acct IN VARCHAR2,
48 p_of_seg IN OUT NOCOPY A_segment);
49 PROCEDURE get_of_seg(p_co_code IN VARCHAR2,
50 p_acct_id NUMBER,
51 p_acctg_unit_id IN NUMBER,
52 p_of_seg IN OUT NOCOPY A_segment,
53 rc IN OUT NOCOPY NUMBER);
54
55 sv_gl_acct_map gl_acct_map%ROWTYPE;
56 sv_acctg_unit_id gl_accu_map.acctg_unit_id%TYPE;
57 sv_sub_event_type gl_sevt_ttl.sub_event_type%TYPE;
58
59 PROCEDURE get_account_mappings ( v_co_code IN OUT NOCOPY VARCHAR2,
60 v_orgn_code VARCHAR2,
61 v_whse_code VARCHAR2,
62 v_item_id NUMBER,
63 v_vendor_id NUMBER,
64 v_cust_id NUMBER,
65 v_reason_code VARCHAR2,
66 v_icgl_class VARCHAR2,
67 v_vendgl_class VARCHAR2,
68 v_custgl_class VARCHAR2,
69 v_currency_code VARCHAR2,
70 v_routing_id NUMBER,
71 v_charge_id NUMBER,
72 v_taxauth_id NUMBER,
73 v_aqui_cost_id NUMBER,
74 v_resources VARCHAR2,
75 v_cost_cmpntcls_id NUMBER,
76 v_cost_analysis_code VARCHAR2,
77 v_order_type NUMBER,
78 v_sub_event_type NUMBER,
79 v_acct_ttl_type NUMBER,
80 v_acct_id IN OUT NOCOPY NUMBER,
81 v_acctg_unit_id IN OUT NOCOPY NUMBER,
82 v_source NUMBER DEFAULT 0,
83 v_business_class_cat_id NUMBER DEFAULT 0,
84 v_product_line_cat_id NUMBER DEFAULT 0,
85 v_line_type NUMBER DEFAULT NULL,
86 v_ar_trx_type_id NUMBER DEFAULT 0
87 );
88
89 FUNCTION fstrcmp(p_col IN VARCHAR2, p_val IN VARCHAR2) RETURN NUMBER;
90 PRAGMA RESTRICT_REFERENCES(fstrcmp, WNDS, WNPS, RNPS);
91
92 FUNCTION fnumcmp(p_col IN NUMBER, p_val IN NUMBER) RETURN NUMBER;
93 PRAGMA RESTRICT_REFERENCES(fnumcmp, WNDS, WNPS, RNPS);
94
95 FUNCTION get_opm_segment_values(p_account_value IN VARCHAR2,
96 p_co_code IN VARCHAR2,
97 p_type IN NUMBER) RETURN my_opm_seg_values;
98
99 TYPE opm_account IS RECORD (
100 acctg_unit_id NUMBER,
101 acct_id NUMBER);
102
103 FUNCTION parse_ccid(
104 pi_co_code IN gl_plcy_mst.co_code%TYPE,
105 pi_code_combination_id IN NUMBER,
106 pi_create_acct IN NUMBER DEFAULT 1)
107 RETURN opm_account ;
108 -- DETERMINISTIC
109
110 END GMF_GET_MAPPINGS;