APPS.ZX_DET_FACTOR_TEMPL_PKG dependencies on ZX_DET_FACTOR_TEMPL_B

Line 26: cursor C is select ROWID from ZX_DET_FACTOR_TEMPL_B

22: X_PROGRAM_ID in NUMBER,
23: X_PROGRAM_LOGIN_ID in NUMBER,
24: X_OBJECT_VERSION_NUMBER in NUMBER) is
25:
26: cursor C is select ROWID from ZX_DET_FACTOR_TEMPL_B
27: where DET_FACTOR_TEMPL_ID = X_DET_FACTOR_TEMPL_ID;
28: begin
29: insert into ZX_DET_FACTOR_TEMPL_B (
30: DET_FACTOR_TEMPL_ID,

Line 29: insert into ZX_DET_FACTOR_TEMPL_B (

25:
26: cursor C is select ROWID from ZX_DET_FACTOR_TEMPL_B
27: where DET_FACTOR_TEMPL_ID = X_DET_FACTOR_TEMPL_ID;
28: begin
29: insert into ZX_DET_FACTOR_TEMPL_B (
30: DET_FACTOR_TEMPL_ID,
31: DET_FACTOR_TEMPL_CODE,
32: TAX_REGIME_CODE,
33: LEDGER_ID,

Line 135: from ZX_DET_FACTOR_TEMPL_B

131: REQUEST_ID,
132: PROGRAM_APPLICATION_ID,
133: PROGRAM_ID,
134: PROGRAM_LOGIN_ID
135: from ZX_DET_FACTOR_TEMPL_B
136: where DET_FACTOR_TEMPL_ID = X_DET_FACTOR_TEMPL_ID
137: for update of DET_FACTOR_TEMPL_ID nowait;
138:
139: recinfo c%rowtype;

Line 223: update ZX_DET_FACTOR_TEMPL_B set

219: X_PROGRAM_LOGIN_ID in NUMBER,
220: X_OBJECT_VERSION_NUMBER in NUMBER) is
221: begin
222:
223: update ZX_DET_FACTOR_TEMPL_B set
224: DET_FACTOR_TEMPL_CODE = X_DET_FACTOR_TEMPL_CODE,
225: TAX_REGIME_CODE = X_TAX_REGIME_CODE,
226: LEDGER_ID = X_LEDGER_ID,
227: CHART_OF_ACCOUNTS_ID = X_CHART_OF_ACCOUNTS_ID,

Line 275: delete from ZX_DET_FACTOR_TEMPL_B

271: if (sql%notfound) then
272: raise no_data_found;
273: end if;
274:
275: delete from ZX_DET_FACTOR_TEMPL_B
276: where DET_FACTOR_TEMPL_ID = X_DET_FACTOR_TEMPL_ID;
277:
278: if (sql%notfound) then
279: raise no_data_found;

Line 294: from ZX_DET_FACTOR_TEMPL_B B

290: begin
291:
292: delete from ZX_DET_FACTOR_TEMPL_TL T
293: where not exists (select NULL
294: from ZX_DET_FACTOR_TEMPL_B B
295: where B.DET_FACTOR_TEMPL_ID = T.DET_FACTOR_TEMPL_ID);
296:
297: update ZX_DET_FACTOR_TEMPL_TL T
298: set (DET_FACTOR_TEMPL_NAME, DET_FACTOR_TEMPL_DESC) =

Line 369: insert into ZX_DET_FACTOR_TEMPL_B (DET_FACTOR_TEMPL_ID,

365: begin
366:
367: if x_det_factor_templ_id.count <> 0 then
368: forall i in x_det_factor_templ_id.first..x_det_factor_templ_id.last
369: insert into ZX_DET_FACTOR_TEMPL_B (DET_FACTOR_TEMPL_ID,
370: DET_FACTOR_TEMPL_CODE,
371: TAX_REGIME_CODE,
372: LEDGER_ID,
373: CHART_OF_ACCOUNTS_ID,