APPS.GME_ERES_PKG dependencies on GME_ERES_GTMP

Line 5: *** Following procedure is used to insert ERES event in GME_ERES_GTMP table for ERES

1: Package BODY GME_ERES_PKG AS
2: /* $Header: GMEVERSB.pls 120.3.12000000.2 2007/03/06 21:31:31 adeshmuk ship $ */
3:
4: /****************************************************************************************
5: *** Following procedure is used to insert ERES event in GME_ERES_GTMP table for ERES
6: *** processing from form
7: ****************************************************************************************/
8:
9: PROCEDURE INSERT_EVENT(P_EVENT_NAME VARCHAR2,

Line 20: from GME_ERES_GTMP

16: P_PARENT_ERECORD_ID NUMBER,
17: X_STATUS OUT NOCOPY VARCHAR2) IS
18: CURSOR check_event_already_exisits IS
19: select count(*)
20: from GME_ERES_GTMP
21: where event_name = p_event_name
22: and event_key = p_event_key;
23: l_count number:=0;
24: l_ins_flag VARCHAR2(5);

Line 39: from GME_ERES_GTMP

35: ,gme_common_pvt.G_RESOURCE_REMOVED
36: ,gme_common_pvt.G_RESOURCE_UPDATE)
37: THEN
38: select count(*) into l_count
39: from GME_ERES_GTMP
40: where (event_name = gme_common_pvt.G_BATCHSTEP_ADDED
41: and event_key = substrb(P_EVENT_KEY,1,instrb(P_EVENT_KEY,'-',1,2)-1)) OR
42: (event_name = gme_common_pvt.G_ACTIVITY_ADDED
43: and event_key = substrb(P_EVENT_KEY,1,instrb(P_EVENT_KEY,'-',1,3)-1));

Line 46: from GME_ERES_GTMP

42: (event_name = gme_common_pvt.G_ACTIVITY_ADDED
43: and event_key = substrb(P_EVENT_KEY,1,instrb(P_EVENT_KEY,'-',1,3)-1));
44: IF l_count = 0 then
45: select count(*) into l_count
46: from GME_ERES_GTMP
47: where event_name in (gme_common_pvt.G_RESOURCE_ADDED )
48: and event_key = p_event_key;
49: IF (l_count > 0)
50: THEN

Line 52: delete GME_ERES_GTMP

48: and event_key = p_event_key;
49: IF (l_count > 0)
50: THEN
51: IF p_event_name = gme_common_pvt.G_RESOURCE_REMOVED THEN
52: delete GME_ERES_GTMP
53: where event_name in (gme_common_pvt.G_RESOURCE_ADDED )
54: and event_key = p_event_key;
55: end if;
56: l_ins_flag := 'N';

Line 60: delete GME_ERES_GTMP

56: l_ins_flag := 'N';
57: ELSE
58: if p_event_name = gme_common_pvt.G_RESOURCE_REMOVED
59: then
60: delete GME_ERES_GTMP
61: where event_name in (gme_common_pvt.G_RESOURCE_UPDATE)
62: and event_key = p_event_key;
63: end if;
64: l_ins_flag := 'Y';

Line 74: from GME_ERES_GTMP

70: ,gme_common_pvt.G_ACTIVITY_REMOVED
71: ,gme_common_pvt.G_ACTIVITY_UPDATED)
72: THEN
73: select count(*) into l_count
74: from GME_ERES_GTMP
75: where (event_name = gme_common_pvt.G_BATCHSTEP_ADDED
76: and event_key = substrb(P_EVENT_KEY,1,instrb(P_EVENT_KEY,'-',1,2)-1));
77: IF l_count = 0 then
78: select count(*) into l_count

Line 79: from GME_ERES_GTMP

75: where (event_name = gme_common_pvt.G_BATCHSTEP_ADDED
76: and event_key = substrb(P_EVENT_KEY,1,instrb(P_EVENT_KEY,'-',1,2)-1));
77: IF l_count = 0 then
78: select count(*) into l_count
79: from GME_ERES_GTMP
80: where event_name in (gme_common_pvt.G_ACTIVITY_ADDED )
81: and event_key = p_event_key;
82: IF (l_count > 0)
83: THEN

Line 85: delete GME_ERES_GTMP

81: and event_key = p_event_key;
82: IF (l_count > 0)
83: THEN
84: IF p_event_name = gme_common_pvt.G_ACTIVITY_REMOVED THEN
85: delete GME_ERES_GTMP
86: where event_name in (gme_common_pvt.G_ACTIVITY_ADDED )
87: and event_key = p_event_key;
88: end if;
89: l_ins_flag := 'N';

Line 93: delete GME_ERES_GTMP

89: l_ins_flag := 'N';
90: ELSE
91: if p_event_name = gme_common_pvt.G_ACTIVITY_REMOVED
92: then
93: delete GME_ERES_GTMP
94: where (event_name in (gme_common_pvt.G_ACTIVITY_UPDATED)
95: and event_key = p_event_key) OR
96: (event_name in (gme_common_pvt.G_RESOURCE_ADDED
97: ,gme_common_pvt.G_RESOURCE_REMOVED

Line 111: from GME_ERES_GTMP

107: gme_common_pvt.G_BATCHSTEP_REMOVED ,
108: gme_common_pvt.G_BATCHSTEP_UPDATE)
109: THEN
110: select count(*) into l_count
111: from GME_ERES_GTMP
112: where event_name = gme_common_pvt.G_BATCHSTEP_ADDED
113: and event_key = p_event_key;
114: IF (l_count > 0)
115: THEN

Line 117: delete GME_ERES_GTMP

113: and event_key = p_event_key;
114: IF (l_count > 0)
115: THEN
116: IF p_event_name = gme_common_pvt.G_BATCHSTEP_REMOVED THEN
117: delete GME_ERES_GTMP
118: where event_name in (gme_common_pvt.G_BATCHSTEP_ADDED )
119: and event_key = p_event_key;
120: end if;
121: l_ins_flag := 'N';

Line 125: delete GME_ERES_GTMP

121: l_ins_flag := 'N';
122: ELSE
123: if p_event_name = gme_common_pvt.G_BATCHSTEP_REMOVED
124: then
125: delete GME_ERES_GTMP
126: where (event_name in (gme_common_pvt.G_BATCHSTEP_UPDATE)
127: and event_key = p_event_key) OR
128: (event_name in (gme_common_pvt.G_RESOURCE_ADDED
129: ,gme_common_pvt.G_RESOURCE_REMOVED

Line 145: from GME_ERES_GTMP

141: ,gme_common_pvt.G_BATCHMTL_UPDATED)
142: THEN
143:
144: select count(*) into l_count
145: from GME_ERES_GTMP
146: where event_name = gme_common_pvt.G_BATCHMTL_ADDED
147: and event_key = p_event_key;
148: IF (l_count > 0)
149: THEN

Line 151: delete GME_ERES_GTMP

147: and event_key = p_event_key;
148: IF (l_count > 0)
149: THEN
150: IF p_event_name = gme_common_pvt.G_BATCHMTL_REMOVED THEN
151: delete GME_ERES_GTMP
152: where event_name in (gme_common_pvt.G_BATCHMTL_ADDED)
153: and event_key = p_event_key;
154: end if;
155: l_ins_flag := 'N';

Line 159: delete GME_ERES_GTMP

155: l_ins_flag := 'N';
156: ELSE
157: if p_event_name = gme_common_pvt.G_BATCHMTL_REMOVED
158: then
159: delete GME_ERES_GTMP
160: where (event_name in (gme_common_pvt.G_BATCHMTL_UPDATED)
161: and event_key = p_event_key);
162: end if;
163: l_ins_flag := 'Y';

Line 179: INSERT INTO GME_ERES_GTMP ( Event_name

175: l_XML_GEN_API := ' GME_ERES_PKG.GET_EVENT_XML('||''''||p_event_name||''','''||P_EVENT_KEY||''''||')';
176: ELSE
177: l_XML_GEN_API := null;
178: END IF;
179: INSERT INTO GME_ERES_GTMP ( Event_name
180: ,Event_key
181: ,Task
182: ,Action_code
183: ,User_KEY_LABEL