[Home] [Help]
PACKAGE: APPS.CN_PAYRUNS_PKG
Source
1 PACKAGE cn_payruns_pkg AUTHID CURRENT_USER 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,
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 );
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
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,
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;