DBA Data[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;