PACKAGE: APPS.FND_SEQ_CATEGORIES_PKG

Source

1 PACKAGE FND_SEQ_CATEGORIES_PKG AUTHID CURRENT_USER AS
2 /* $Header: AFSNCATS.pls 115.0 99/07/16 23:31:02 porting ship  $ */
3 
4     TYPE cat_rec IS RECORD (cat_code FND_DOC_SEQUENCE_CATEGORIES.code%TYPE);
5 
6   --
7   -- Procedure
8   --   check_unique_cat
9   -- Purpose
10   --   Checks before insert that the category to be inserted is unique
11   --   If category code is not unique, shows error message.
12   -- History
13   --   08-SEP-98   H. Lankinen   Created
14   -- Arguments
15   --   x_application_id           The application id
16   --   x_category_code            The category code
17   -- Example
18   --   FND_SEQ_CATEGORIES_PKG.check_unique_cat(
19   --     222, 'CONS');
20   --
21 
22 
23   PROCEDURE check_unique_cat( x_application_id      IN   NUMBER,
24 			      x_category_code       IN   VARCHAR2);
25 
26   --
27   -- Procedure
28   --   insert_cat
29   -- Purpose
30   --   Insert into FND_DOC_SEQUENCE_CATEGORIES table for each
31   --   new created category.
32   -- History
33   --   08-SEP-98   H. Lankinen   Created
34   -- Arguments
35   --   x_application_id           The application id
36   --   x_category_code            The category code
37   --   x_category_name            The category name
38   --   x_description              The category description
39   --   x_table_name               The table name
40   --   x_last_updated_by          The who column
41   --   x_created_by               The who column
42   --   x_last_update_login        The who column
43   -- Example
44   --   FND_SEQ_CATEGORIES_PKG.insert_cat(
45   --     222, 'CONS', 'Consulting Invoice', 'Consulting Invoice',
46   --    'RA_CUSTOMER_TRX_ALL', 1,1,1 );
47   -- Notes
48   --
49 
50 
51   PROCEDURE insert_cat( x_application_id         NUMBER,
52 			x_category_code          VARCHAR2,
53                         x_category_name          VARCHAR2,
54                         x_description            VARCHAR2,
55 			x_table_name	     VARCHAR2,
56                         x_last_updated_by        NUMBER,
57                         x_created_by             NUMBER,
58                         x_last_update_login      NUMBER );
59 
60 
61   --
62   -- Procedure
63   --   update_cat
64   -- Purpose
65   --   Update FND_DOC_SEQUENCE_CATEGORIES table for each
66   --   new updated category.
67   -- History
68   --   08-SEP-98   H. Lankinen   Created
69   -- Arguments
70   --   x_application_id           The Application id
71   --   x_category_code            The category code
72   --   x_category_name            The category name
73   --   x_description              The cateogrty description
74   --   x_last_updated_by          The last person id who update the row
75   -- Example
76   --   FND_SEQ_CATEGORIES_PKG.update_cat(
77   --     222, 'CONS', 'Consulting Invoice', 'Consulting Invoice',1 );
78   -- Notes
79   --
80 
81   PROCEDURE update_cat(  x_application_id         NUMBER,
82 			 x_category_code          VARCHAR2,
83 			 x_category_name          VARCHAR2,
84                          x_description            VARCHAR2,
85                          x_last_updated_by        NUMBER );
86 
87 END FND_SEQ_CATEGORIES_PKG;