PACKAGE: APPS.CSC_PROF_MODULE_GROUPS_PKG

Source

1 PACKAGE CSC_PROF_MODULE_GROUPS_PKG AUTHID CURRENT_USER as
2 /* $Header: csctpmgs.pls 115.14 2002/12/09 08:43:06 agaddam ship $ */
3 -- Start of Comments
4 -- Package name     : CSC_PROF_MODULE_GROUPS_PKG
5 -- Purpose          :
6 -- History          :
7 --  03 Nov 00 axsubram Added load_row for NLS (# 1487333)
8 --  26 Nov 02 JAmose  Addition of NOCOPY and the Removal of Fnd_Api.G_MISS*
9 --                    from the definition for the performance reason
10 -- NOTE             :
11 -- End of Comments
12 
13 PROCEDURE Insert_Row(
14           px_MODULE_GROUP_ID   IN OUT NOCOPY NUMBER,
15           p_FORM_FUNCTION_ID    NUMBER,
16           p_FORM_FUNCTION_NAME  VARCHAR2,
17           p_RESPONSIBILITY_ID    NUMBER,
18           p_RESP_APPL_ID    NUMBER,
19           p_PARTY_TYPE          VARCHAR2,
20           p_GROUP_ID            NUMBER,
21           p_DASHBOARD_GROUP_FLAG    VARCHAR2,
22           p_CURRENCY_CODE       VARCHAR2,
23           p_LAST_UPDATE_DATE    DATE,
24           p_LAST_UPDATED_BY     NUMBER,
25           p_CREATION_DATE       DATE,
26           p_CREATED_BY          NUMBER,
27           p_LAST_UPDATE_LOGIN   NUMBER,
28           p_SEEDED_FLAG         VARCHAR2,
29           p_APPLICATION_ID      NUMBER,
30           p_DASHBOARD_GROUP_ID  NUMBER);
31 
32 PROCEDURE Update_Row(
33           p_MODULE_GROUP_ID     NUMBER,
34           p_FORM_FUNCTION_ID    NUMBER,
35           p_FORM_FUNCTION_NAME  VARCHAR2,
36           p_RESPONSIBILITY_ID    NUMBER,
37           p_RESP_APPL_ID    NUMBER,
38           p_PARTY_TYPE          VARCHAR2,
39           p_GROUP_ID            NUMBER,
40           p_DASHBOARD_GROUP_FLAG    VARCHAR2,
41           p_CURRENCY_CODE       VARCHAR2,
42           p_LAST_UPDATE_DATE    DATE,
43           p_LAST_UPDATED_BY     NUMBER,
44           p_LAST_UPDATE_LOGIN   NUMBER,
45           p_SEEDED_FLAG         VARCHAR2,
46           p_APPLICATION_ID      NUMBER,
47           p_DASHBOARD_GROUP_ID  NUMBER);
48 
49 PROCEDURE Lock_Row(
50           p_MODULE_GROUP_ID     NUMBER,
51           p_FORM_FUNCTION_ID    NUMBER,
52           p_FORM_FUNCTION_NAME  VARCHAR2,
53           p_RESPONSIBILITY_ID    NUMBER,
54           p_RESP_APPL_ID    NUMBER,
55           p_PARTY_TYPE          VARCHAR2,
56           p_GROUP_ID            NUMBER,
57           p_DASHBOARD_GROUP_FLAG    VARCHAR2,
58           p_CURRENCY_CODE       VARCHAR2,
59           p_LAST_UPDATE_DATE    DATE,
60           p_LAST_UPDATED_BY     NUMBER,
61           p_CREATION_DATE       DATE,
62           p_CREATED_BY          NUMBER,
63           p_LAST_UPDATE_LOGIN   NUMBER,
64           p_SEEDED_FLAG         VARCHAR2,
65           p_APPLICATION_ID      NUMBER,
66           p_DASHBOARD_GROUP_ID  NUMBER);
67 
68 PROCEDURE Delete_Row(
69     p_MODULE_GROUP_ID  NUMBER);
70 
71 PROCEDURE Load_Row(
72           p_MODULE_GROUP_ID     NUMBER,
73           p_FORM_FUNCTION_ID    NUMBER,
74           p_FORM_FUNCTION_NAME  VARCHAR2,
75           p_RESPONSIBILITY_ID    NUMBER := NULL,
76           p_RESP_APPL_ID    NUMBER := NULL,
77           p_PARTY_TYPE          VARCHAR2,
78           p_GROUP_ID            NUMBER,
79           p_DASHBOARD_GROUP_FLAG    VARCHAR2,
80           p_CURRENCY_CODE       VARCHAR2,
81           p_LAST_UPDATE_DATE    DATE,
82           p_LAST_UPDATED_BY     NUMBER,
83           p_LAST_UPDATE_LOGIN   NUMBER,
84           p_SEEDED_FLAG         VARCHAR2,
85           p_APPLICATION_ID      NUMBER,
86           p_DASHBOARD_GROUP_ID  NUMBER,
87        	  P_Owner	        VARCHAR2);
88 
89 End CSC_PROF_MODULE_GROUPS_PKG;