PACKAGE BODY: APPS.PO_AUTOCREATE_UDA_RULES_PKG

Source

1 PACKAGE BODY po_autocreate_uda_rules_pkg AS
2 /* $Header: PO_AUTOCREATE_UDA_RULES_PKG.plb 120.1 2010/04/07 15:18:15 ssreekum noship $ */
3 
4 
5 PROCEDURE load_row (
6       GROUP_NAME          IN   VARCHAR2,
7       SOURCE              IN   VARCHAR2,
8       TARGET              IN   VARCHAR2,
9       SOURCE_DOC_LEVEL    IN   VARCHAR2,
10       TARGET_DOC_LEVEL    IN   VARCHAR2,
11       PRIORITY1           IN   VARCHAR2,
12       PRIORITY2           IN   VARCHAR2,
13       PRIORITY3           IN   VARCHAR2,
14       PRIORITY4           IN   VARCHAR2,
15       PRIORITY5           IN   VARCHAR2,
16       GROUP_TYPE          IN   VARCHAR2,
17       GROUP_PROPERTY      IN   VARCHAR2,
18       CREATION_DATE       IN   DATE,
19       CREATED_BY          IN   NUMBER,
20       LAST_UPDATE_DATE    IN   DATE,
21       LAST_UPDATED_BY     IN   NUMBER,
22       LAST_UPDATE_LOGIN   IN   NUMBER
23    )
24 IS
25 BEGIN
26 
27    INSERT INTO PO_AUTOCREATE_UDA_RULES
28   (      GROUP_NAME
29         ,SOURCE
30         ,TARGET
31         ,SOURCE_DOC_LEVEL
32         ,TARGET_DOC_LEVEL
33         ,PRIORITY1
34         ,PRIORITY2
35         ,PRIORITY3
36         ,PRIORITY4
37         ,PRIORITY5
38         ,GROUP_TYPE
39         ,GROUP_PROPERTY
40         ,CREATION_DATE
41         ,CREATED_BY
42         ,LAST_UPDATE_DATE
43         ,LAST_UPDATED_BY
44         ,LAST_UPDATE_LOGIN
45 		)
46   VALUES
47   (  GROUP_NAME
48    , SOURCE
49    , TARGET
50    , SOURCE_DOC_LEVEL
51    , TARGET_DOC_LEVEL
52    , PRIORITY1
53    , PRIORITY2
54    , PRIORITY3
55    , PRIORITY4
56    , PRIORITY5
57    , GROUP_TYPE
58    , GROUP_PROPERTY
59    , CREATION_DATE
60    , CREATED_BY
61    , LAST_UPDATE_DATE
62    , LAST_UPDATED_BY
63    , LAST_UPDATE_LOGIN);
64 END;
65 BEGIN
66   DELETE FROM  po_autocreate_uda_rules;
67 END po_autocreate_uda_rules_pkg;