APPS.FEM_BUDG_STATUS_CODES_PKG dependencies on FEM_BUDG_STATUS_CODES_B

Line 17: cursor C is select ROWID from FEM_BUDG_STATUS_CODES_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 FEM_BUDG_STATUS_CODES_B
18: where BUDGET_STATUS_CODE = X_BUDGET_STATUS_CODE
19: ;
20: begin
21: insert into FEM_BUDG_STATUS_CODES_B (

Line 21: insert into FEM_BUDG_STATUS_CODES_B (

17: cursor C is select ROWID from FEM_BUDG_STATUS_CODES_B
18: where BUDGET_STATUS_CODE = X_BUDGET_STATUS_CODE
19: ;
20: begin
21: insert into FEM_BUDG_STATUS_CODES_B (
22: PERSONAL_FLAG,
23: BUDGET_STATUS_CODE,
24: ENABLED_FLAG,
25: READ_ONLY_FLAG,

Line 95: from FEM_BUDG_STATUS_CODES_B

91: cursor c is select
92: PERSONAL_FLAG,
93: ENABLED_FLAG,
94: READ_ONLY_FLAG
95: from FEM_BUDG_STATUS_CODES_B
96: where BUDGET_STATUS_CODE = X_BUDGET_STATUS_CODE
97: for update of BUDGET_STATUS_CODE nowait;
98: recinfo c%rowtype;
99:

Line 155: update FEM_BUDG_STATUS_CODES_B set

151: X_LAST_UPDATED_BY in NUMBER,
152: X_LAST_UPDATE_LOGIN in NUMBER
153: ) is
154: begin
155: update FEM_BUDG_STATUS_CODES_B set
156: PERSONAL_FLAG = X_PERSONAL_FLAG,
157: ENABLED_FLAG = X_ENABLED_FLAG,
158: READ_ONLY_FLAG = X_READ_ONLY_FLAG,
159: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 194: delete from FEM_BUDG_STATUS_CODES_B

190: if (sql%notfound) then
191: raise no_data_found;
192: end if;
193:
194: delete from FEM_BUDG_STATUS_CODES_B
195: where BUDGET_STATUS_CODE = X_BUDGET_STATUS_CODE;
196:
197: if (sql%notfound) then
198: raise no_data_found;

Line 208: from FEM_BUDG_STATUS_CODES_B B

204: begin
205: delete from FEM_BUDG_STATUS_CODES_TL T
206: where not exists
207: (select NULL
208: from FEM_BUDG_STATUS_CODES_B B
209: where B.BUDGET_STATUS_CODE = T.BUDGET_STATUS_CODE
210: );
211:
212: update FEM_BUDG_STATUS_CODES_TL T set (