DBA Data[Home] [Help]

PACKAGE: APPS.JL_ZZ_AR_TX_LGL_MSG_PKG

Source


1 PACKAGE JL_ZZ_AR_TX_LGL_MSG_PKG AS
2 /* $Header: jlzztlms.pls 120.2 2003/03/03 19:36:29 opedrega ship $ */
3 
4   PROCEDURE Insert_Row
5        (X_rowid                     IN OUT NOCOPY VARCHAR2,
6         X_rule_id                                 NUMBER,
7         X_rule_data_id                            NUMBER,
8         X_exception_code                          VARCHAR2,
9         X_message_id                              NUMBER,
10         X_inventory_item_flag                     VARCHAR2,
11         X_inventory_organization_id               NUMBER,
12         X_start_date_active                       DATE,
13         X_end_date_active                         DATE,
14         X_org_id                                  NUMBER,
15         X_last_update_date                        DATE,
16         X_last_updated_by                         NUMBER,
17         X_last_update_login                       NUMBER,
18         X_creation_date                           DATE,
19         X_created_by                              NUMBER,
20         X_calling_sequence          IN            VARCHAR2);
21 
22   PROCEDURE Lock_Row
23        (X_rowid                                   VARCHAR2,
24         X_rule_id                                 NUMBER,
25         X_rule_data_id                            NUMBER,
26         X_exception_code                          VARCHAR2,
27         X_message_id                              NUMBER,
28         X_inventory_item_flag                     VARCHAR2,
29         X_inventory_organization_id               NUMBER,
30         X_start_date_active                       DATE,
31         X_end_date_active                         DATE,
32         X_org_id                                  NUMBER,
33         X_last_update_date                        DATE,
34         X_last_updated_by                         NUMBER,
35         X_last_update_login                       NUMBER,
36         X_creation_date                           DATE,
37         X_created_by                              NUMBER,
38         X_calling_sequence          IN            VARCHAR2);
39 
40   PROCEDURE Update_Row
41        (X_rowid                                   VARCHAR2,
42         X_rule_id                                 NUMBER,
43         X_rule_data_id                            NUMBER,
44         X_exception_code                          VARCHAR2,
45         X_message_id                              NUMBER,
46         X_inventory_item_flag                     VARCHAR2,
47         X_inventory_organization_id               NUMBER,
48         X_start_date_active                       DATE,
49         X_end_date_active                         DATE,
50         X_org_id                                  NUMBER,
51         X_last_update_date                        DATE,
52         X_last_updated_by                         NUMBER,
53         X_last_update_login                       NUMBER,
54         X_creation_date                           DATE,
55         X_created_by                              NUMBER,
56         X_calling_sequence          IN            VARCHAR2);
57 
58   PROCEDURE Delete_Row
59        (X_rowid         VARCHAR2) ;
60 
61   PROCEDURE Check_Unique
62        (X_rowid                                   VARCHAR2,
63         X_rule_id                                 NUMBER,
64         X_rule_data_id                            NUMBER,
65         X_exception_code                          VARCHAR2,
66         X_org_id                                  NUMBER);
67 
68 END JL_ZZ_AR_TX_LGL_MSG_PKG;