PACKAGE: APPS.GMD_PARAMETERS_HDR_PKG

Source

1 PACKAGE GMD_PARAMETERS_HDR_PKG AS
2 /* $Header: GMDPRHDS.pls 120.0 2005/05/26 00:58:19 appldev noship $ */
3 
4  /*======================================================================
5  --  PROCEDURE :
6  --   INSERT_ROW
7  --
8  --  DESCRIPTION:
9  --        This particular procedure insert rows in header table
10  --
11  --  HISTORY
12  --        Sriram.S  05-NOV-2004  Created
13  --===================================================================== */
14 PROCEDURE INSERT_ROW (
15   X_ROWID               IN OUT NOCOPY VARCHAR2,
16   X_PARAMETER_ID        IN NUMBER,
17   X_ORGANIZATION_ID     IN NUMBER,
18   X_LAB_IND             IN NUMBER,
19   X_PLANT_IND           IN NUMBER,
20   X_CREATION_DATE       IN DATE,
21   X_CREATED_BY          IN NUMBER,
22   X_LAST_UPDATE_DATE    IN DATE,
23   X_LAST_UPDATED_BY     IN NUMBER,
24   X_LAST_UPDATE_LOGIN   IN NUMBER
25 );
26 
27  /*======================================================================
28  --  PROCEDURE :
29  --   LOCK_ROW
30  --
31  --  DESCRIPTION:
32  --        This particular procedure lock rows in header table
33  --
34  --  HISTORY
35  --        Sriram.S  05-NOV-2004  Created
36  --===================================================================== */
37  PROCEDURE LOCK_ROW (
38   X_PARAMETER_ID        IN NUMBER,
39   X_ORGANIZATION_ID     IN NUMBER,
40   X_LAB_IND             IN NUMBER,
41   X_PLANT_IND           IN NUMBER
42  );
43 
44  /*======================================================================
45  --  PROCEDURE :
46  --   UPDATE_ROW
47  --
48  --  DESCRIPTION:
49  --        This particular procedure update rows in header table
50  --
51  --  HISTORY
52  --        Sriram.S  05-NOV-2004  Created
53  --===================================================================== */
54  PROCEDURE UPDATE_ROW (
55   X_PARAMETER_ID        IN NUMBER,
56   X_ORGANIZATION_ID     IN NUMBER,
57   X_LAB_IND             IN NUMBER,
58   X_PLANT_IND           IN NUMBER,
59   X_LAST_UPDATE_DATE    IN DATE,
60   X_LAST_UPDATED_BY     IN NUMBER,
61   X_LAST_UPDATE_LOGIN   IN NUMBER
62 );
63 
64  /*======================================================================
65  --  PROCEDURE :
66  --   DELETE_ROW
67  --
68  --  DESCRIPTION:
69  --        This particular procedure delete rows in header table
70  --
71  --  HISTORY
72  --        Sriram.S  05-NOV-2004  Created
73  --===================================================================== */
74 PROCEDURE DELETE_ROW (
75   X_PARAMETER_ID IN NUMBER
76 );
77 
78 END GMD_PARAMETERS_HDR_PKG;
79