APPS.CN_PAYRUNS_PKG dependencies on CN_PAYRUNS

Line 1: PACKAGE cn_payruns_pkg AS

1: PACKAGE cn_payruns_pkg AS
2: -- $Header: cnprunts.pls 120.3 2005/09/22 13:00:01 rnagired ship $
3: PROCEDURE INSERT_RECORD (
4: x_payrun_id IN NUMBER,
5: x_name cn_payruns.NAME%TYPE,

Line 5: x_name cn_payruns.NAME%TYPE,

1: PACKAGE cn_payruns_pkg AS
2: -- $Header: cnprunts.pls 120.3 2005/09/22 13:00:01 rnagired ship $
3: PROCEDURE INSERT_RECORD (
4: x_payrun_id IN NUMBER,
5: x_name cn_payruns.NAME%TYPE,
6: x_pay_period_id cn_payruns.pay_period_id%TYPE,
7: x_incentive_type_code cn_payruns.incentive_type_code%TYPE,
8: x_pay_group_id cn_payruns.pay_group_id%TYPE,
9: x_pay_date cn_payruns.pay_date%TYPE,

Line 6: x_pay_period_id cn_payruns.pay_period_id%TYPE,

2: -- $Header: cnprunts.pls 120.3 2005/09/22 13:00:01 rnagired ship $
3: PROCEDURE INSERT_RECORD (
4: x_payrun_id IN NUMBER,
5: x_name cn_payruns.NAME%TYPE,
6: x_pay_period_id cn_payruns.pay_period_id%TYPE,
7: x_incentive_type_code cn_payruns.incentive_type_code%TYPE,
8: x_pay_group_id cn_payruns.pay_group_id%TYPE,
9: x_pay_date cn_payruns.pay_date%TYPE,
10: x_accounting_period_id cn_payruns.accounting_period_id%TYPE,

Line 7: x_incentive_type_code cn_payruns.incentive_type_code%TYPE,

3: PROCEDURE INSERT_RECORD (
4: x_payrun_id IN NUMBER,
5: x_name cn_payruns.NAME%TYPE,
6: x_pay_period_id cn_payruns.pay_period_id%TYPE,
7: x_incentive_type_code cn_payruns.incentive_type_code%TYPE,
8: x_pay_group_id cn_payruns.pay_group_id%TYPE,
9: x_pay_date cn_payruns.pay_date%TYPE,
10: x_accounting_period_id cn_payruns.accounting_period_id%TYPE,
11: x_batch_id cn_payruns.batch_id%TYPE,

Line 8: x_pay_group_id cn_payruns.pay_group_id%TYPE,

4: x_payrun_id IN NUMBER,
5: x_name cn_payruns.NAME%TYPE,
6: x_pay_period_id cn_payruns.pay_period_id%TYPE,
7: x_incentive_type_code cn_payruns.incentive_type_code%TYPE,
8: x_pay_group_id cn_payruns.pay_group_id%TYPE,
9: x_pay_date cn_payruns.pay_date%TYPE,
10: x_accounting_period_id cn_payruns.accounting_period_id%TYPE,
11: x_batch_id cn_payruns.batch_id%TYPE,
12: x_status cn_payruns.status%TYPE,

Line 9: x_pay_date cn_payruns.pay_date%TYPE,

5: x_name cn_payruns.NAME%TYPE,
6: x_pay_period_id cn_payruns.pay_period_id%TYPE,
7: x_incentive_type_code cn_payruns.incentive_type_code%TYPE,
8: x_pay_group_id cn_payruns.pay_group_id%TYPE,
9: x_pay_date cn_payruns.pay_date%TYPE,
10: x_accounting_period_id cn_payruns.accounting_period_id%TYPE,
11: x_batch_id cn_payruns.batch_id%TYPE,
12: x_status cn_payruns.status%TYPE,
13: x_created_by cn_payruns.created_by%TYPE,

Line 10: x_accounting_period_id cn_payruns.accounting_period_id%TYPE,

6: x_pay_period_id cn_payruns.pay_period_id%TYPE,
7: x_incentive_type_code cn_payruns.incentive_type_code%TYPE,
8: x_pay_group_id cn_payruns.pay_group_id%TYPE,
9: x_pay_date cn_payruns.pay_date%TYPE,
10: x_accounting_period_id cn_payruns.accounting_period_id%TYPE,
11: x_batch_id cn_payruns.batch_id%TYPE,
12: x_status cn_payruns.status%TYPE,
13: x_created_by cn_payruns.created_by%TYPE,
14: x_creation_date cn_payruns.creation_date%TYPE,

Line 11: x_batch_id cn_payruns.batch_id%TYPE,

7: x_incentive_type_code cn_payruns.incentive_type_code%TYPE,
8: x_pay_group_id cn_payruns.pay_group_id%TYPE,
9: x_pay_date cn_payruns.pay_date%TYPE,
10: x_accounting_period_id cn_payruns.accounting_period_id%TYPE,
11: x_batch_id cn_payruns.batch_id%TYPE,
12: x_status cn_payruns.status%TYPE,
13: x_created_by cn_payruns.created_by%TYPE,
14: x_creation_date cn_payruns.creation_date%TYPE,
15: x_object_version_number cn_payruns.object_version_number%TYPE,

Line 12: x_status cn_payruns.status%TYPE,

8: x_pay_group_id cn_payruns.pay_group_id%TYPE,
9: x_pay_date cn_payruns.pay_date%TYPE,
10: x_accounting_period_id cn_payruns.accounting_period_id%TYPE,
11: x_batch_id cn_payruns.batch_id%TYPE,
12: x_status cn_payruns.status%TYPE,
13: x_created_by cn_payruns.created_by%TYPE,
14: x_creation_date cn_payruns.creation_date%TYPE,
15: x_object_version_number cn_payruns.object_version_number%TYPE,
16: x_org_id cn_payruns.org_id%TYPE,

Line 13: x_created_by cn_payruns.created_by%TYPE,

9: x_pay_date cn_payruns.pay_date%TYPE,
10: x_accounting_period_id cn_payruns.accounting_period_id%TYPE,
11: x_batch_id cn_payruns.batch_id%TYPE,
12: x_status cn_payruns.status%TYPE,
13: x_created_by cn_payruns.created_by%TYPE,
14: x_creation_date cn_payruns.creation_date%TYPE,
15: x_object_version_number cn_payruns.object_version_number%TYPE,
16: x_org_id cn_payruns.org_id%TYPE,
17: x_payrun_mode cn_payruns.payrun_mode%TYPE

Line 14: x_creation_date cn_payruns.creation_date%TYPE,

10: x_accounting_period_id cn_payruns.accounting_period_id%TYPE,
11: x_batch_id cn_payruns.batch_id%TYPE,
12: x_status cn_payruns.status%TYPE,
13: x_created_by cn_payruns.created_by%TYPE,
14: x_creation_date cn_payruns.creation_date%TYPE,
15: x_object_version_number cn_payruns.object_version_number%TYPE,
16: x_org_id cn_payruns.org_id%TYPE,
17: x_payrun_mode cn_payruns.payrun_mode%TYPE
18: );

Line 15: x_object_version_number cn_payruns.object_version_number%TYPE,

11: x_batch_id cn_payruns.batch_id%TYPE,
12: x_status cn_payruns.status%TYPE,
13: x_created_by cn_payruns.created_by%TYPE,
14: x_creation_date cn_payruns.creation_date%TYPE,
15: x_object_version_number cn_payruns.object_version_number%TYPE,
16: x_org_id cn_payruns.org_id%TYPE,
17: x_payrun_mode cn_payruns.payrun_mode%TYPE
18: );
19:

Line 16: x_org_id cn_payruns.org_id%TYPE,

12: x_status cn_payruns.status%TYPE,
13: x_created_by cn_payruns.created_by%TYPE,
14: x_creation_date cn_payruns.creation_date%TYPE,
15: x_object_version_number cn_payruns.object_version_number%TYPE,
16: x_org_id cn_payruns.org_id%TYPE,
17: x_payrun_mode cn_payruns.payrun_mode%TYPE
18: );
19:
20: PROCEDURE LOCK_RECORD (x_rowid VARCHAR2, x_payrun_id NUMBER);

Line 17: x_payrun_mode cn_payruns.payrun_mode%TYPE

13: x_created_by cn_payruns.created_by%TYPE,
14: x_creation_date cn_payruns.creation_date%TYPE,
15: x_object_version_number cn_payruns.object_version_number%TYPE,
16: x_org_id cn_payruns.org_id%TYPE,
17: x_payrun_mode cn_payruns.payrun_mode%TYPE
18: );
19:
20: PROCEDURE LOCK_RECORD (x_rowid VARCHAR2, x_payrun_id NUMBER);
21:

Line 23: x_payrun_id cn_payruns.payrun_id%TYPE,

19:
20: PROCEDURE LOCK_RECORD (x_rowid VARCHAR2, x_payrun_id NUMBER);
21:
22: PROCEDURE UPDATE_RECORD (
23: x_payrun_id cn_payruns.payrun_id%TYPE,
24: x_name cn_payruns.NAME%TYPE := fnd_api.g_miss_char,
25: x_pay_period_id cn_payruns.pay_period_id%TYPE
26: := cn_api.g_miss_id,
27: x_incentive_type_code cn_payruns.incentive_type_code%TYPE

Line 24: x_name cn_payruns.NAME%TYPE := fnd_api.g_miss_char,

20: PROCEDURE LOCK_RECORD (x_rowid VARCHAR2, x_payrun_id NUMBER);
21:
22: PROCEDURE UPDATE_RECORD (
23: x_payrun_id cn_payruns.payrun_id%TYPE,
24: x_name cn_payruns.NAME%TYPE := fnd_api.g_miss_char,
25: x_pay_period_id cn_payruns.pay_period_id%TYPE
26: := cn_api.g_miss_id,
27: x_incentive_type_code cn_payruns.incentive_type_code%TYPE
28: := cn_api.g_miss_char,

Line 25: x_pay_period_id cn_payruns.pay_period_id%TYPE

21:
22: PROCEDURE UPDATE_RECORD (
23: x_payrun_id cn_payruns.payrun_id%TYPE,
24: x_name cn_payruns.NAME%TYPE := fnd_api.g_miss_char,
25: x_pay_period_id cn_payruns.pay_period_id%TYPE
26: := cn_api.g_miss_id,
27: x_incentive_type_code cn_payruns.incentive_type_code%TYPE
28: := cn_api.g_miss_char,
29: x_pay_group_id cn_payruns.pay_group_id%TYPE

Line 27: x_incentive_type_code cn_payruns.incentive_type_code%TYPE

23: x_payrun_id cn_payruns.payrun_id%TYPE,
24: x_name cn_payruns.NAME%TYPE := fnd_api.g_miss_char,
25: x_pay_period_id cn_payruns.pay_period_id%TYPE
26: := cn_api.g_miss_id,
27: x_incentive_type_code cn_payruns.incentive_type_code%TYPE
28: := cn_api.g_miss_char,
29: x_pay_group_id cn_payruns.pay_group_id%TYPE
30: := cn_api.g_miss_id,
31: x_pay_date cn_payruns.pay_date%TYPE

Line 29: x_pay_group_id cn_payruns.pay_group_id%TYPE

25: x_pay_period_id cn_payruns.pay_period_id%TYPE
26: := cn_api.g_miss_id,
27: x_incentive_type_code cn_payruns.incentive_type_code%TYPE
28: := cn_api.g_miss_char,
29: x_pay_group_id cn_payruns.pay_group_id%TYPE
30: := cn_api.g_miss_id,
31: x_pay_date cn_payruns.pay_date%TYPE
32: := fnd_api.g_miss_date,
33: x_accounting_period_id cn_payruns.accounting_period_id%TYPE

Line 31: x_pay_date cn_payruns.pay_date%TYPE

27: x_incentive_type_code cn_payruns.incentive_type_code%TYPE
28: := cn_api.g_miss_char,
29: x_pay_group_id cn_payruns.pay_group_id%TYPE
30: := cn_api.g_miss_id,
31: x_pay_date cn_payruns.pay_date%TYPE
32: := fnd_api.g_miss_date,
33: x_accounting_period_id cn_payruns.accounting_period_id%TYPE
34: := cn_api.g_miss_id,
35: x_batch_id cn_payruns.batch_id%TYPE := cn_api.g_miss_id,

Line 33: x_accounting_period_id cn_payruns.accounting_period_id%TYPE

29: x_pay_group_id cn_payruns.pay_group_id%TYPE
30: := cn_api.g_miss_id,
31: x_pay_date cn_payruns.pay_date%TYPE
32: := fnd_api.g_miss_date,
33: x_accounting_period_id cn_payruns.accounting_period_id%TYPE
34: := cn_api.g_miss_id,
35: x_batch_id cn_payruns.batch_id%TYPE := cn_api.g_miss_id,
36: x_status cn_payruns.status%TYPE := fnd_api.g_miss_char,
37: x_last_updated_by cn_payruns.last_updated_by%TYPE,

Line 35: x_batch_id cn_payruns.batch_id%TYPE := cn_api.g_miss_id,

31: x_pay_date cn_payruns.pay_date%TYPE
32: := fnd_api.g_miss_date,
33: x_accounting_period_id cn_payruns.accounting_period_id%TYPE
34: := cn_api.g_miss_id,
35: x_batch_id cn_payruns.batch_id%TYPE := cn_api.g_miss_id,
36: x_status cn_payruns.status%TYPE := fnd_api.g_miss_char,
37: x_last_updated_by cn_payruns.last_updated_by%TYPE,
38: x_last_update_date cn_payruns.last_update_date%TYPE,
39: x_last_update_login cn_payruns.last_update_login%TYPE,

Line 36: x_status cn_payruns.status%TYPE := fnd_api.g_miss_char,

32: := fnd_api.g_miss_date,
33: x_accounting_period_id cn_payruns.accounting_period_id%TYPE
34: := cn_api.g_miss_id,
35: x_batch_id cn_payruns.batch_id%TYPE := cn_api.g_miss_id,
36: x_status cn_payruns.status%TYPE := fnd_api.g_miss_char,
37: x_last_updated_by cn_payruns.last_updated_by%TYPE,
38: x_last_update_date cn_payruns.last_update_date%TYPE,
39: x_last_update_login cn_payruns.last_update_login%TYPE,
40: x_object_version_number cn_payruns.object_version_number%TYPE

Line 37: x_last_updated_by cn_payruns.last_updated_by%TYPE,

33: x_accounting_period_id cn_payruns.accounting_period_id%TYPE
34: := cn_api.g_miss_id,
35: x_batch_id cn_payruns.batch_id%TYPE := cn_api.g_miss_id,
36: x_status cn_payruns.status%TYPE := fnd_api.g_miss_char,
37: x_last_updated_by cn_payruns.last_updated_by%TYPE,
38: x_last_update_date cn_payruns.last_update_date%TYPE,
39: x_last_update_login cn_payruns.last_update_login%TYPE,
40: x_object_version_number cn_payruns.object_version_number%TYPE
41: );

Line 38: x_last_update_date cn_payruns.last_update_date%TYPE,

34: := cn_api.g_miss_id,
35: x_batch_id cn_payruns.batch_id%TYPE := cn_api.g_miss_id,
36: x_status cn_payruns.status%TYPE := fnd_api.g_miss_char,
37: x_last_updated_by cn_payruns.last_updated_by%TYPE,
38: x_last_update_date cn_payruns.last_update_date%TYPE,
39: x_last_update_login cn_payruns.last_update_login%TYPE,
40: x_object_version_number cn_payruns.object_version_number%TYPE
41: );
42:

Line 39: x_last_update_login cn_payruns.last_update_login%TYPE,

35: x_batch_id cn_payruns.batch_id%TYPE := cn_api.g_miss_id,
36: x_status cn_payruns.status%TYPE := fnd_api.g_miss_char,
37: x_last_updated_by cn_payruns.last_updated_by%TYPE,
38: x_last_update_date cn_payruns.last_update_date%TYPE,
39: x_last_update_login cn_payruns.last_update_login%TYPE,
40: x_object_version_number cn_payruns.object_version_number%TYPE
41: );
42:
43: PROCEDURE DELETE_RECORD (x_payrun_id NUMBER);

Line 40: x_object_version_number cn_payruns.object_version_number%TYPE

36: x_status cn_payruns.status%TYPE := fnd_api.g_miss_char,
37: x_last_updated_by cn_payruns.last_updated_by%TYPE,
38: x_last_update_date cn_payruns.last_update_date%TYPE,
39: x_last_update_login cn_payruns.last_update_login%TYPE,
40: x_object_version_number cn_payruns.object_version_number%TYPE
41: );
42:
43: PROCEDURE DELETE_RECORD (x_payrun_id NUMBER);
44: END cn_payruns_pkg;

Line 44: END cn_payruns_pkg;

40: x_object_version_number cn_payruns.object_version_number%TYPE
41: );
42:
43: PROCEDURE DELETE_RECORD (x_payrun_id NUMBER);
44: END cn_payruns_pkg;