1 PACKAGE PSA_xfr_to_gl_pkg AS
2 /* $Header: PSAMFG2S.pls 120.2 2006/09/15 10:59:49 agovil noship $*/
3
4 PROCEDURE Transfer_to_gl (errbuf OUT NOCOPY VARCHAR2,
5 retcode OUT NOCOPY VARCHAR2,
6 p_set_of_books_id IN NUMBER,
7 p_gl_date_from IN VARCHAR2,
8 p_gl_date_to IN VARCHAR2,
9 p_gl_posted_date IN VARCHAR2,
10 p_parent_req_id IN NUMBER,
11 p_summary_flag IN VARCHAR2,
12 p_pst_ctrl_id IN NUMBER);
13
14 PROCEDURE Mfar_trx_to_gl (errbuf OUT NOCOPY VARCHAR2,
15 retcode OUT NOCOPY VARCHAR2,
16 p_set_of_books_id IN NUMBER,
17 p_gl_date_from IN VARCHAR2,
18 p_gl_date_to IN VARCHAR2,
19 p_gl_posted_date IN VARCHAR2,
20 p_summary_flag IN VARCHAR2);
21
22 PROCEDURE Mfar_rcpt_to_gl (errbuf OUT NOCOPY VARCHAR2,
23 retcode OUT NOCOPY VARCHAR2,
24 p_set_of_books_id IN NUMBER,
25 p_gl_date_from IN VARCHAR2,
26 p_gl_date_to IN VARCHAR2,
27 p_gl_posted_date IN VARCHAR2,
28 p_summary_flag IN VARCHAR2);
29
30 PROCEDURE Mfar_adj_to_gl (errbuf OUT NOCOPY VARCHAR2,
31 retcode OUT NOCOPY VARCHAR2,
32 p_set_of_books_id IN NUMBER,
33 p_gl_date_from IN VARCHAR2,
34 p_gl_date_to IN VARCHAR2,
35 p_gl_posted_date IN VARCHAR2,
36 p_summary_flag IN VARCHAR2);
37
38 PROCEDURE Misc_rct_to_gl (errbuf OUT NOCOPY VARCHAR2,
39 retcode OUT NOCOPY VARCHAR2,
40 p_set_of_books_id IN NUMBER,
41 p_gl_date_from IN VARCHAR2,
42 p_gl_date_to IN VARCHAR2,
43 p_gl_posted_date IN VARCHAR2);
44
45 PROCEDURE Populate_global_variables;
46
47 PROCEDURE Upd_seg_in_gl_interface ;
48
49 -- Bug 3621280
50 PROCEDURE Reverse_core_entries_if_any (errbuf OUT NOCOPY VARCHAR2,
51 retcode OUT NOCOPY VARCHAR2,
52 p_set_of_books_id IN NUMBER,
53 p_error_message OUT NOCOPY VARCHAR2);
54
55
56 FUNCTION Get_entered_dr_rct (p_lookup_code IN NUMBER,
57 p_amount IN NUMBER,
58 p_discount IN NUMBER DEFAULT NULL,
59 p_ue_discount IN NUMBER DEFAULT NULL) RETURN NUMBER;
60
61 FUNCTION Get_entered_cr_rct (p_lookup_code IN NUMBER,
62 p_amount IN NUMBER,
63 p_discount IN NUMBER DEFAULT NULL,
64 p_ue_discount IN NUMBER DEFAULT NULL) RETURN NUMBER;
65
66 FUNCTION Get_entered_cr_crm (p_lookup_code IN NUMBER,
67 p_amount IN NUMBER) RETURN NUMBER;
68
69 FUNCTION Get_entered_dr_crm (p_lookup_code IN NUMBER,
70 p_amount IN NUMBER) RETURN NUMBER;
71
72 FUNCTION get_entered_dr_adj (p_lookup_code IN NUMBER,
73 p_amount IN NUMBER) RETURN NUMBER;
74
75 FUNCTION Get_entered_cr_adj (p_lookup_code IN NUMBER,
76 p_amount IN NUMBER) RETURN NUMBER;
77
78 FUNCTION Get_adj_ccid (p_adjustment_id IN NUMBER) RETURN NUMBER;
79
80
81 FUNCTION Get_entered_dr_rct_clear (p_lookup_code IN NUMBER,
82 p_amount IN NUMBER,
83 p_curr_status IN VARCHAR2,
84 p_prev_status IN VARCHAR2) RETURN NUMBER;
85
86 FUNCTION Get_entered_cr_rct_clear (p_lookup_code IN NUMBER,
87 p_amount IN NUMBER,
88 p_curr_status IN VARCHAR2,
89 p_prev_status IN VARCHAR2) RETURN NUMBER;
90
91 FUNCTION clear_reversal_lines(p_lookup_code IN NUMBER,
92 p_amount IN NUMBER,
93 p_crh_status IN VARCHAR2,
94 p_crh_first_record_flag IN VARCHAR2,
95 p_rev_crh_id IN NUMBER) RETURN varchar2 ;
96
97
98 FUNCTION Get_misc_ard_id (p_misc_cash_dist_id IN NUMBER) RETURN NUMBER;
99
100 FUNCTION Get_adj_ard_id (p_adjustment_id IN NUMBER) RETURN NUMBER;
101
102 PROCEDURE Mfar_rcpt_to_gl_CB
103 (errbuf OUT NOCOPY VARCHAR2,
104 retcode OUT NOCOPY VARCHAR2,
105 p_set_of_books_id IN NUMBER,
106 p_gl_date_from IN VARCHAR2,
107 p_gl_date_to IN VARCHAR2,
108 p_gl_posted_date IN VARCHAR2,
109 p_summary_flag IN VARCHAR2);
110
111 PROCEDURE Misc_rct_to_gl_CB
112 (errbuf OUT NOCOPY VARCHAR2,
113 retcode OUT NOCOPY VARCHAR2,
114 p_set_of_books_id IN NUMBER,
115 p_gl_date_from IN VARCHAR2,
116 p_gl_date_to IN VARCHAR2,
117 p_gl_posted_date IN VARCHAR2);
118
119 END PSA_xfr_to_gl_pkg ;