eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PSP_ENC_SUM_TRAN

Source


1 PACKAGE PSP_ENC_SUM_TRAN AUTHID CURRENT_USER AS
2 /* $Header: PSPENSTS.pls 120.3 2006/07/13 07:40:41 spchakra noship $ */
3 
4 g_run_id		NUMBER(10);
5 --g_error_api_path	VARCHAR2(500) := '';
6 g_error_api_path	VARCHAR2(2000) := ''; --Added for bug 1776606
7 g_business_group_id	NUMBER;
8 g_set_of_books_id	NUMBER;
9 
10 PROCEDURE enc_sum_trans(
11 				errbuf	OUT NOCOPY VARCHAR2,
12 				retcode	OUT NOCOPY VARCHAR2,
13 				p_payroll_action_id IN NUMBER,
14 				p_business_group_id IN NUMBER,
15 				p_set_of_books_id IN NUMBER
16 				);
17 
18 PROCEDURE enc_batch_begin(	p_payroll_action_id IN NUMBER,
19 				p_return_status	OUT NOCOPY VARCHAR2
20 				);
21 
22 PROCEDURE enc_batch_end(	p_payroll_action_id IN NUMBER,
23 				p_return_status	OUT NOCOPY VARCHAR2
24 				);
25 
26 --PROCEDURE create_gl_enc_sum_lines(p_payroll_id IN NUMBER,
27 --				p_return_status	OUT NOCOPY VARCHAR2
28 --				);
29 
30 PROCEDURE insert_into_enc_sum_lines(
31 				p_enc_summary_line_id	OUT NOCOPY NUMBER,
32 				p_business_group_id	IN  NUMBER,
33 				p_enc_control_id	IN  NUMBER,
34 				p_time_period_id	IN  NUMBER,
35 				p_person_id		IN  NUMBER,
36 				p_assignment_id		IN  NUMBER,
37 				p_effective_date	IN  DATE,
38 				p_set_of_books_id	IN  NUMBER,
39 				p_gl_code_combination_id IN  NUMBER,
40 				p_project_id		IN  NUMBER,
41 				p_expenditure_organization_id IN  NUMBER,
42 				p_expenditure_type	IN  VARCHAR2,
43 				p_task_id		IN  NUMBER,
44 				p_award_id		IN  NUMBER,
45 				p_summary_amount	IN  NUMBER,
46 				p_dr_cr_flag		IN  VARCHAR2,
47 				p_status_code		IN  VARCHAR2,
48 				p_payroll_id		IN  NUMBER,
49 				p_gl_period_id		IN  NUMBER,
50 				p_gl_project_flag	IN  VARCHAR2,
51 				p_attribute_category	IN	VARCHAR2,		-- Introduced DFF parameters for bug fix 2908859
52 				p_attribute1		IN	VARCHAR2,
53 				p_attribute2		IN	VARCHAR2,
54 				p_attribute3		IN	VARCHAR2,
55 				p_attribute4		IN	VARCHAR2,
56 				p_attribute5		IN	VARCHAR2,
57 				p_attribute6		IN	VARCHAR2,
58 				p_attribute7		IN	VARCHAR2,
59 				p_attribute8		IN	VARCHAR2,
60 				p_attribute9		IN	VARCHAR2,
61 				p_attribute10		IN	VARCHAR2,
62 				p_return_status		OUT NOCOPY  VARCHAR2
63 				);
64 
65 PROCEDURE tr_to_gl_int(		p_payroll_action_id IN NUMBER,
66 				p_return_status	OUT NOCOPY  VARCHAR2
67 				);
68 
69 
70 PROCEDURE gl_je_source(
71 				p_user_je_source_name	OUT NOCOPY  VARCHAR2,
72 				p_return_status		OUT NOCOPY  VARCHAR2
73 				);
74 
75 PROCEDURE gl_je_cat(
76 				p_user_je_category_name	OUT NOCOPY  VARCHAR2,
77 				p_return_status		OUT NOCOPY  VARCHAR2
78 				);
79 
80 PROCEDURE enc_type(
81 				p_encumbrance_type_id	OUT NOCOPY  VARCHAR2,
82 				p_return_status		OUT NOCOPY  VARCHAR2
83 				);
84 
85 PROCEDURE gl_enc_tie_back(
86 --				p_enc_control_id	IN  NUMBER,
87 --				p_period_end_date	IN  DATE,
88 				p_payroll_action_id	IN  NUMBER,
89 				p_group_id		IN  NUMBER,
90                 		p_business_group_id 	IN  NUMBER,
91                 		p_set_of_books_id   	IN  NUMBER,
92                                 p_mode                  IN  VARCHAR2,--Added for bug 1776606.
93 				p_return_status		OUT NOCOPY VARCHAR2
94 				);
95 
96 PROCEDURE insert_into_gl_int  (
97 				p_set_of_books_id	IN  NUMBER,
98 				p_accounting_date	IN  DATE,
99 				p_currency_code		IN  VARCHAR2,
100 				p_user_je_category_name	IN  VARCHAR2,
101 				p_user_je_source_name	IN  VARCHAR2,
102 				p_encumbrance_type_id	IN  NUMBER,
103 				p_code_combination_id	IN  NUMBER,
104 				p_entered_dr		IN  NUMBER,
105 				p_entered_cr		IN  NUMBER,
106 				p_group_id		IN  NUMBER,
107 				p_reference1		IN  VARCHAR2,
108 				p_reference2		IN  VARCHAR2,
109 				p_reference4		IN  VARCHAR2,
110 				p_reference6		IN  VARCHAR2,
111 				p_reference10		IN  VARCHAR2,
112 				p_attribute1		IN  VARCHAR2,
113 				p_attribute2		IN  VARCHAR2,
114 				p_attribute3		IN  VARCHAR2,
115 				p_attribute4		IN  VARCHAR2,
116 				p_attribute5		IN  VARCHAR2,
117 				p_attribute6		IN  VARCHAR2,
118 				p_attribute7		IN  VARCHAR2,
119 				p_attribute8		IN  VARCHAR2,
120 				p_attribute9		IN  VARCHAR2,
121 				p_attribute10		IN  VARCHAR2,
122 				p_attribute11		IN  VARCHAR2,
123 				p_attribute12		IN  VARCHAR2,
124 				p_attribute13		IN  VARCHAR2,
125 				p_attribute14		IN  VARCHAR2,
126 				p_attribute15		IN  VARCHAR2,
127 				p_attribute16		IN  VARCHAR2,
128 				p_attribute17		IN  VARCHAR2,
129 				p_attribute18		IN  VARCHAR2,
130 				p_attribute19		IN  VARCHAR2,
131 				p_attribute20		IN  VARCHAR2,
132 				p_attribute21		IN  VARCHAR2,
133 				p_attribute22		IN  VARCHAR2,
134 				p_attribute23		IN  VARCHAR2,
135 				p_attribute24		IN  VARCHAR2,
136 				p_attribute25		IN  VARCHAR2,
137 				p_attribute26		IN  VARCHAR2,
138 				p_attribute27		IN  VARCHAR2,
139 				p_attribute28		IN  VARCHAR2,
140 				p_attribute29		IN  VARCHAR2,
141 				p_attribute30		IN  VARCHAR2,
142 				p_return_status		OUT NOCOPY  VARCHAR2
143 				);
144 
145 --PROCEDURE create_gms_enc_sum_lines(p_payroll_id IN NUMBER,
146 --				p_return_status		OUT NOCOPY  VARCHAR2
147 --				);
148 
149 PROCEDURE tr_to_gms_int(	p_payroll_action_id IN NUMBER,
150 				p_return_status		OUT NOCOPY  VARCHAR2
151 				);
152 
153 /*PROCEDURE gms_enc_tie_back(
154 				p_enc_control_id	IN  NUMBER,
155 				p_period_end_date	IN  DATE,
156 				p_gms_batch_name	IN  VARCHAR2,
157 				p_business_group_id	IN  NUMBER,
158 				p_set_of_books_id	IN  NUMBER,
159         		p_mode                  IN  VARCHAR2, --Added for bug 1776606
160 				p_return_status		OUT NOCOPY  VARCHAR2
161 				);*/
162 PROCEDURE gms_enc_tie_back(	p_payroll_action_id	IN		NUMBER,
163 				p_gms_batch_name	IN		VARCHAR2,
164 				p_business_group_id	IN		NUMBER,
165 				p_set_of_books_id	IN		NUMBER,
166 				p_return_status		OUT NOCOPY	VARCHAR2);
167 
168 END psp_enc_sum_tran;