APPS.GMD_ACTIVITIES_PKG dependencies on GMD_ACTIVITIES_B

Line 17: cursor C is select ROWID from GMD_ACTIVITIES_B

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from GMD_ACTIVITIES_B
18: where ACTIVITY = X_ACTIVITY
19: ;
20: begin
21: insert into GMD_ACTIVITIES_B (

Line 21: insert into GMD_ACTIVITIES_B (

17: cursor C is select ROWID from GMD_ACTIVITIES_B
18: where ACTIVITY = X_ACTIVITY
19: ;
20: begin
21: insert into GMD_ACTIVITIES_B (
22: ACTIVITY,
23: COST_ANALYSIS_CODE,
24: DELETE_MARK,
25: TEXT_CODE,

Line 96: from GMD_ACTIVITIES_B

92: COST_ANALYSIS_CODE,
93: DELETE_MARK,
94: TEXT_CODE,
95: TRANS_CNT
96: from GMD_ACTIVITIES_B
97: where ACTIVITY = X_ACTIVITY
98: for update of ACTIVITY nowait;
99: recinfo c%rowtype;
100:

Line 156: update GMD_ACTIVITIES_B set

152: X_LAST_UPDATED_BY in NUMBER,
153: X_LAST_UPDATE_LOGIN in NUMBER
154: ) is
155: begin
156: update GMD_ACTIVITIES_B set
157: COST_ANALYSIS_CODE = X_COST_ANALYSIS_CODE,
158: DELETE_MARK = X_DELETE_MARK,
159: TEXT_CODE = X_TEXT_CODE,
160: TRANS_CNT = X_TRANS_CNT,

Line 196: update GMD_ACTIVITIES_B

192: if (sql%notfound) then
193: raise no_data_found;
194: end if; */
195:
196: update GMD_ACTIVITIES_B
197: set delete_mark = 1
198: where ACTIVITY = X_ACTIVITY;
199:
200: if (sql%notfound) then

Line 211: from GMD_ACTIVITIES_B B

207: begin
208: delete from GMD_ACTIVITIES_TL T
209: where not exists
210: (select NULL
211: from GMD_ACTIVITIES_B B
212: where B.ACTIVITY = T.ACTIVITY
213: );
214:
215: update GMD_ACTIVITIES_TL T set (