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.

APPS.CN_PAYRUN_PVT dependencies on CN_PAYRUNS

Line 5: ( payrun_id cn_payruns.payrun_id%TYPE,

1: PACKAGE CN_Payrun_PVT as
2: -- $Header: cnvpruns.pls 120.3 2005/09/29 19:04:27 rnagired ship $
3:
4: TYPE Payrun_rec_type IS RECORD
5: ( payrun_id cn_payruns.payrun_id%TYPE,
6: name cn_payruns.name%TYPE,
7: pay_date cn_payruns.pay_date%TYPE,
8: accounting_period_id cn_payruns.accounting_period_id%TYPE,
9: batch_id cn_payruns.batch_id%TYPE,

Line 6: name cn_payruns.name%TYPE,

2: -- $Header: cnvpruns.pls 120.3 2005/09/29 19:04:27 rnagired ship $
3:
4: TYPE Payrun_rec_type IS RECORD
5: ( payrun_id cn_payruns.payrun_id%TYPE,
6: name cn_payruns.name%TYPE,
7: pay_date cn_payruns.pay_date%TYPE,
8: accounting_period_id cn_payruns.accounting_period_id%TYPE,
9: batch_id cn_payruns.batch_id%TYPE,
10: status cn_payruns.status%TYPE,

Line 7: pay_date cn_payruns.pay_date%TYPE,

3:
4: TYPE Payrun_rec_type IS RECORD
5: ( payrun_id cn_payruns.payrun_id%TYPE,
6: name cn_payruns.name%TYPE,
7: pay_date cn_payruns.pay_date%TYPE,
8: accounting_period_id cn_payruns.accounting_period_id%TYPE,
9: batch_id cn_payruns.batch_id%TYPE,
10: status cn_payruns.status%TYPE,
11: pay_period_id cn_payruns.pay_period_id%TYPE,

Line 8: accounting_period_id cn_payruns.accounting_period_id%TYPE,

4: TYPE Payrun_rec_type IS RECORD
5: ( payrun_id cn_payruns.payrun_id%TYPE,
6: name cn_payruns.name%TYPE,
7: pay_date cn_payruns.pay_date%TYPE,
8: accounting_period_id cn_payruns.accounting_period_id%TYPE,
9: batch_id cn_payruns.batch_id%TYPE,
10: status cn_payruns.status%TYPE,
11: pay_period_id cn_payruns.pay_period_id%TYPE,
12: pay_period_start_date cn_period_statuses.start_date%TYPE,

Line 9: batch_id cn_payruns.batch_id%TYPE,

5: ( payrun_id cn_payruns.payrun_id%TYPE,
6: name cn_payruns.name%TYPE,
7: pay_date cn_payruns.pay_date%TYPE,
8: accounting_period_id cn_payruns.accounting_period_id%TYPE,
9: batch_id cn_payruns.batch_id%TYPE,
10: status cn_payruns.status%TYPE,
11: pay_period_id cn_payruns.pay_period_id%TYPE,
12: pay_period_start_date cn_period_statuses.start_date%TYPE,
13: pay_period_end_date cn_period_statuses.end_date%TYPE,

Line 10: status cn_payruns.status%TYPE,

6: name cn_payruns.name%TYPE,
7: pay_date cn_payruns.pay_date%TYPE,
8: accounting_period_id cn_payruns.accounting_period_id%TYPE,
9: batch_id cn_payruns.batch_id%TYPE,
10: status cn_payruns.status%TYPE,
11: pay_period_id cn_payruns.pay_period_id%TYPE,
12: pay_period_start_date cn_period_statuses.start_date%TYPE,
13: pay_period_end_date cn_period_statuses.end_date%TYPE,
14: incentive_type_code cn_posting_details.incentive_type_code%TYPE,

Line 11: pay_period_id cn_payruns.pay_period_id%TYPE,

7: pay_date cn_payruns.pay_date%TYPE,
8: accounting_period_id cn_payruns.accounting_period_id%TYPE,
9: batch_id cn_payruns.batch_id%TYPE,
10: status cn_payruns.status%TYPE,
11: pay_period_id cn_payruns.pay_period_id%TYPE,
12: pay_period_start_date cn_period_statuses.start_date%TYPE,
13: pay_period_end_date cn_period_statuses.end_date%TYPE,
14: incentive_type_code cn_posting_details.incentive_type_code%TYPE,
15: pay_group_id cn_payruns.pay_group_id%TYPE,

Line 15: pay_group_id cn_payruns.pay_group_id%TYPE,

11: pay_period_id cn_payruns.pay_period_id%TYPE,
12: pay_period_start_date cn_period_statuses.start_date%TYPE,
13: pay_period_end_date cn_period_statuses.end_date%TYPE,
14: incentive_type_code cn_posting_details.incentive_type_code%TYPE,
15: pay_group_id cn_payruns.pay_group_id%TYPE,
16: --R12
17: org_id cn_payruns.org_id%TYPE,
18: object_version_number cn_payruns.object_version_number%TYPE
19: );

Line 17: org_id cn_payruns.org_id%TYPE,

13: pay_period_end_date cn_period_statuses.end_date%TYPE,
14: incentive_type_code cn_posting_details.incentive_type_code%TYPE,
15: pay_group_id cn_payruns.pay_group_id%TYPE,
16: --R12
17: org_id cn_payruns.org_id%TYPE,
18: object_version_number cn_payruns.object_version_number%TYPE
19: );
20: --============================================================================
21: -- Start of comments

Line 18: object_version_number cn_payruns.object_version_number%TYPE

14: incentive_type_code cn_posting_details.incentive_type_code%TYPE,
15: pay_group_id cn_payruns.pay_group_id%TYPE,
16: --R12
17: org_id cn_payruns.org_id%TYPE,
18: object_version_number cn_payruns.object_version_number%TYPE
19: );
20: --============================================================================
21: -- Start of comments
22: -- API name : Create_Payrun

Line 83: -- IN : p_payrun_id IN cn_payruns.payrun_id%TYPE

79: -- p_validation_level IN NUMBER Optional
80: -- OUT : x_return_status OUT VARCHAR2
81: -- x_msg_count OUT NUMBER
82: -- x_msg_data OUT VARCHAR2
83: -- IN : p_payrun_id IN cn_payruns.payrun_id%TYPE
84: -- p_action IN VARCHAR2
85: -- OUT : x_status OUT VARCHAR2
86: -- : x_loading_status OUT VARCHAR2
87: -- End of comments

Line 98: p_payrun_id IN cn_payruns.payrun_id%TYPE,

94: p_validation_level IN NUMBER,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
97: x_msg_data OUT NOCOPY VARCHAR2,
98: p_payrun_id IN cn_payruns.payrun_id%TYPE,
99: p_x_obj_ver_number IN OUT NOCOPY cn_payruns.object_version_number%TYPE,
100: p_action IN VARCHAR2,
101: x_status OUT NOCOPY VARCHAR2,
102: x_loading_status OUT NOCOPY VARCHAR2

Line 99: p_x_obj_ver_number IN OUT NOCOPY cn_payruns.object_version_number%TYPE,

95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
97: x_msg_data OUT NOCOPY VARCHAR2,
98: p_payrun_id IN cn_payruns.payrun_id%TYPE,
99: p_x_obj_ver_number IN OUT NOCOPY cn_payruns.object_version_number%TYPE,
100: p_action IN VARCHAR2,
101: x_status OUT NOCOPY VARCHAR2,
102: x_loading_status OUT NOCOPY VARCHAR2
103: );

Line 141: p_payrun_id IN cn_payruns.payrun_id%TYPE,

137: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,
141: p_payrun_id IN cn_payruns.payrun_id%TYPE,
142: p_validation_only IN VARCHAR2,
143: x_status OUT NOCOPY VARCHAR2,
144: x_loading_status OUT NOCOPY VARCHAR2
145: ) ;

Line 166: -- IN : p_Payrun_name IN cn_payruns.name%TYPE

162: -- Default = FND_API.G_VALID_LEVEL_FULL
163: -- OUT : x_return_status OUT VARCHAR2(1)
164: -- x_msg_count OUT NUMBER
165: -- x_msg_data OUT VARCHAR2(2000)
166: -- IN : p_Payrun_name IN cn_payruns.name%TYPE
167: --
168: -- OUT : x_loading_status OUT
169: -- Detailed Error Message
170: -- Version : Current version 1.0

Line 183: p_payrun_id IN cn_payruns.payrun_id%TYPE,

179: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_payrun_id IN cn_payruns.payrun_id%TYPE,
184: p_x_obj_ver_number IN OUT NOCOPY cn_payruns.object_version_number%TYPE,
185: x_status OUT NOCOPY VARCHAR2,
186: x_loading_status OUT NOCOPY VARCHAR2
187: ) ;

Line 184: p_x_obj_ver_number IN OUT NOCOPY cn_payruns.object_version_number%TYPE,

180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_payrun_id IN cn_payruns.payrun_id%TYPE,
184: p_x_obj_ver_number IN OUT NOCOPY cn_payruns.object_version_number%TYPE,
185: x_status OUT NOCOPY VARCHAR2,
186: x_loading_status OUT NOCOPY VARCHAR2
187: ) ;
188:

Line 197: p_name cn_payruns.name%TYPE,

193: --============================================================================
194: PROCEDURE delete_payrun_conc
195: ( errbuf OUT NOCOPY VARCHAR2,
196: retcode OUT NOCOPY NUMBER ,
197: p_name cn_payruns.name%TYPE,
198: --R12
199: p_org_name hr_operating_units.name%TYPE );
200: --============================================================================
201: --Name : Build Bee API

Line 218: p_payrun_id IN cn_payruns.payrun_id%TYPE,

214: --Description : Procedure to Populate CCIDs
215: --============================================================================
216: FUNCTION populate_ccids
217: (
218: p_payrun_id IN cn_payruns.payrun_id%TYPE,
219: p_salesrep_id IN cn_payment_worksheets.salesrep_id%TYPE,
220: --p_start_date IN DATE,
221: --p_end_date IN DATE,
222: -- Bug 3866089 (the same as 11.5.8 bug 3841926, 11.5.10 3866116) by jjhuang on 11/1/04