[Home] [Help]
PACKAGE: APPS.PA_UBR_UER_SUMM_PKG
Source
1 PACKAGE PA_UBR_UER_SUMM_PKG AS
2 /* $Header: PABLUBRS.pls 120.1 2005/08/05 03:06:25 lveerubh noship $ */
3
4 /** Global Variables declaration **/
5 G_created_by NUMBER := NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
6 G_last_update_login NUMBER := NVL(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')), -1);
7 G_last_updated_by NUMBER := G_created_by;
8 G_creation_date DATE := SYSDATE;
9 G_last_update_date DATE := SYSDATE ;
10
11 G_fetch_size NUMBER := 1000;
12
13 G_ccid NUMBER := -1;
14 G_cost_seg_val VARCHAR2(60);
15 G_acct_seg_val VARCHAR2(60);
16
17 G_org_id_v NUMBER;
18 G_set_of_books_id NUMBER;
19 G_gl_period_name VARCHAR2(80);
20 G_gl_start_date DATE ;
21 G_gl_end_date DATE ;
22
23 G_p_gl_end_date DATE ;
24
25 G_p_from_project_number VARCHAR2(60);
26 G_p_to_project_number VARCHAR2(60);
27 G_p_gl_period_name VARCHAR2(60);
28 G_p_request_id NUMBER;
29
30 G_coa_id NUMBER;
31 G_sob NUMBER;
32 G_org_id NUMBER;
33 G_cost_seg_num NUMBER;
34 G_acct_seg_num NUMBER;
35
36 G_acct_appcol_name VARCHAR2(60);
37 G_acct_seg_name VARCHAR2(60);
38 G_acct_prompt VARCHAR2(60);
39 G_acct_value_set_name VARCHAR2(60);
40
41 G_cost_appcol_name VARCHAR2(60);
42 G_cost_seg_name VARCHAR2(60);
43 G_cost_prompt VARCHAR2(60);
44 G_cost_value_set_name VARCHAR2(60);
45
46 G_p_invoice_num NUMBER;
47 G_p_ubr_code_combination_id NUMBER;
48 G_p_invoice_line_num NUMBER;
49 G_p_period_name VARCHAR2(15);
50 G_x_inv_gl_header_id NUMBER;
51 G_x_inv_gl_line_num NUMBER;
52 G_x_inv_gl_header_name VARCHAR2(100);
53 G_x_inv_gl_batch_name VARCHAR2(100);
54
55 G_batch_name VARCHAR2(80);
56 G_code_combination_id NUMBER;
57 G_system_ref_3 VARCHAR2(80);
58 G_rev_period_name VARCHAR2(15);
59 G_x_rev_gl_header_id NUMBER;
60 G_x_rev_gl_line_num NUMBER;
61 G_x_rev_gl_header_name VARCHAR2(100);
62 G_x_rev_gl_batch_name VARCHAR2(100);
63
64 PROCEDURE Create_Ubr_Uer_Summary_Balance(
65 p_from_project_number IN VARCHAR2,
66 p_to_project_number IN VARCHAR2,
67 p_gl_period_name IN VARCHAR2 ,
68 p_request_id IN NUMBER );
69
70 FUNCTION Initialize( p_org_id NUMBER ) RETURN BOOLEAN;
71
72 PROCEDURE process_draft_revenues;
73
74 PROCEDURE process_ubr_uer_summary ( p_source IN VARCHAR2 , p_process_ubr_uer IN VARCHAR2 ) ;
75
76 PROCEDURE process_draft_invoices;
77
78 FUNCTION get_seg_val( p_acct_appcol_name VARCHAR2,
79 p_cost_appcol_name VARCHAR2,
80 p_seg_type VARCHAR2,
81 p_ccid NUMBER )
82 RETURN VARCHAR2;
83
84 FUNCTION get_gl_period_name( p_application_id NUMBER,
85 p_set_of_books_id NUMBER,
86 p_gl_date DATE )
87 RETURN VARCHAR2;
88 FUNCTION get_gl_period_name( p_org_id NUMBER,
89 p_gl_date DATE )
90 RETURN VARCHAR2;
91
92 FUNCTION get_gl_start_date( p_application_id NUMBER,
93 p_set_of_books_id NUMBER,
94 p_gl_period_name VARCHAR2 )
95 RETURN DATE;
96
97 PROCEDURE get_gl_start_date( p_gl_period_name IN VARCHAR2 ,
98 p_gl_start_date IN DATE,
99 x_gl_start_date_chr OUT NOCOPY VARCHAR2 );
100
101 FUNCTION get_inv_gl_header_id_line_num(
102 p_calling_place IN VARCHAR2,
103 p_ar_invoice_number IN NUMBER,
104 p_invoice_line_number IN NUMBER,
105 p_ubr_code_combination_id IN NUMBER,
106 p_period_name IN VARCHAR2 )
107 RETURN VARCHAR2;
108
109 FUNCTION get_rev_gl_header_id_line_num(
110 p_calling_place IN VARCHAR2,
111 p_batch_name IN VARCHAR2,
112 p_system_ref_3 IN VARCHAR2,
113 p_code_combination_id IN NUMBER,
114 p_period_name IN VARCHAR2 )
115 RETURN VARCHAR2;
116
117 END PA_UBR_UER_SUMM_PKG;