PACKAGE: APPS.GML_ACCT_GENERATE

Source

1 PACKAGE GML_ACCT_GENERATE AS
2 /* $Header: GMLACTGS.pls 120.1 2005/09/30 13:40:17 pbamb noship $ */
3 
4   PROCEDURE  generate_opm_acct(v_destination_type  VARCHAR2,
5 				v_inv_item_type VARCHAR2, v_subinv_type VARCHAR2,
6 				v_dest_org_id NUMBER, v_apps_item_id NUMBER,
7 				v_vendor_site_id NUMBER,
8 				v_cc_id  IN OUT NOCOPY NUMBER);
9 
10   PROCEDURE get_opm_account(v_dest_org_id NUMBER, v_apps_item_id NUMBER,
11                           v_vendor_site_id NUMBER, v_opm_account_type VARCHAR2,
12                           retcode  IN OUT NOCOPY NUMBER);
13 
14   PROCEDURE get_opm_account_type(v_destination_type VARCHAR2,
15                                 v_inv_item_type VARCHAR2, v_subinv_type VARCHAR2
16 ,
17                                 v_opm_account_type  OUT NOCOPY VARCHAR2);
18 
19    PROCEDURE process_trans (retcode  IN OUT NOCOPY NUMBER);
20    FUNCTION  default_mapping RETURN NUMBER;
21    FUNCTION  get_acctg_unit_no  RETURN VARCHAR2;
22    PROCEDURE get_acct_no(V_acct_no OUT NOCOPY VARCHAR2, V_acct_desc OUT NOCOPY VARCHAR2);
23 
24 
25   /* Package Variables.*/
26   P_itemglclass             ic_item_mst.GL_CLASS%TYPE;
27   P_acctg_unit_id           NUMBER;
28   P_base_currency           gl_curr_mst.CURRENCY_CODE%TYPE;
29   P_vend_gl_class           po_vend_mst.VENDGL_CLASS%TYPE;
30   P_whse_co_code            sy_orgn_mst.co_code%TYPE;
31   P_whse_orgn_code          sy_orgn_mst.orgn_code%TYPE;
32   P_cust_id                 NUMBER;
33   P_reason_code             VARCHAR2(10);
34   P_cust_gl_class           op_cust_mst.CUSTGL_CLASS%TYPE;
35   P_routing_id              NUMBER;
36   P_charge_id               NUMBER;
37   P_taxauth_id              NUMBER;
38   P_aqui_cost_id            NUMBER ;
39   P_resources               VARCHAR2(10);
40   P_cost_cmpntcls_id        NUMBER;
41   P_cost_analysis_code      cm_cmpt_dtl.COST_ANALYSIS_CODE%TYPE;
42   P_order_type              VARCHAR2(5);
43   P_sub_event_type          NUMBER(10) DEFAULT 10010;
44   P_shipvend_id             NUMBER;
45   P_to_whse                 ic_whse_mst.whse_code%TYPE;
46   P_item_no                 ic_item_mst.item_no%TYPE;
47   P_gl_item_id              NUMBER(10);
48   P_acct_id                 NUMBER (10);
49   P_acctg_unit_no           gl_accu_mst.ACCTG_UNIT_NO%TYPE;
50   P_acct_no                 gl_acct_mst.ACCT_NO%TYPE;
51   P_acct_desc               gl_acct_mst.ACCT_DESC%TYPE;
52   P_acct_ttl_num            NUMBER;
53   P_cc_id		    NUMBER;
54   P_gl_business_class_cat_id gl_acct_map.gl_business_class_cat_id%TYPE; /* B2312653 RVK */
55   P_gl_product_line_cat_id  gl_acct_map.gl_product_line_cat_id%TYPE; /* B2312653 RVK */
56 
57   PROCEDURE set_data (retcode IN OUT NOCOPY NUMBER);
58 
59   PROCEDURE get_acct_title(
60                         v_opm_account_type VARCHAR2,
61                         v_gltitles OUT NOCOPY NUMBER
62                         );
63 
64   PROCEDURE gen_combination_id(	v_co_code 		IN VARCHAR2,
65  				v_acct_id 		IN NUMBER,
66  				v_acctg_unit_id 	IN NUMBER,
67    				v_combination_id 	IN OUT NOCOPY NUMBER);
68 
69 
70   PROCEDURE parse_account(	v_co_code IN VARCHAR2,
71   				v_account IN VARCHAR2,
72   				v_type IN NUMBER,
73   				v_offset IN NUMBER,
74   				v_segment IN OUT NOCOPY fnd_flex_ext.SegmentArray,
75   				V_no_of_seg IN OUT NOCOPY NUMBER );
76 
77 
78 END GML_ACCT_GENERATE;