APPS.ZX_DETERMINING_FACTORS_PKG dependencies on ZX_DETERMINING_FACTORS_B

Line 39: FROM ZX_DETERMINING_FACTORS_B

35: X_OBJECT_VERSION_NUMBER NUMBER) IS
36:
37: CURSOR C IS
38: SELECT ROWID
39: FROM ZX_DETERMINING_FACTORS_B
40: WHERE DETERMINING_FACTOR_ID = X_DETERMINING_FACTOR_ID;
41:
42: BEGIN
43: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 49: INSERT INTO ZX_DETERMINING_FACTORS_B (DETERMINING_FACTOR_ID,

45: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.INSERT_ROW.BEGIN',
46: 'ZX_DETERMINING_FACTORS_PKG.INSERT_ROW (+)');
47: END IF;
48:
49: INSERT INTO ZX_DETERMINING_FACTORS_B (DETERMINING_FACTOR_ID,
50: DETERMINING_FACTOR_CODE,
51: DETERMINING_FACTOR_CLASS_CODE,
52: VALUE_SET,
53: TAX_PARAMETER_CODE,

Line 174: FROM ZX_DETERMINING_FACTORS_B

170: INTERNAL_FLAG,
171: RECORD_ONLY_FLAG,
172: REQUEST_ID,
173: OBJECT_VERSION_NUMBER
174: FROM ZX_DETERMINING_FACTORS_B
175: WHERE DETERMINING_FACTOR_ID = X_DETERMINING_FACTOR_ID
176: FOR UPDATE OF DETERMINING_FACTOR_ID NOWAIT;
177: RECINFO C%ROWTYPE;
178:

Line 301: UPDATE ZX_DETERMINING_FACTORS_B

297: 'ZX.PLSQL.ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW.BEGIN',
298: 'ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW (+)');
299: END IF;
300:
301: UPDATE ZX_DETERMINING_FACTORS_B
302: SET DETERMINING_FACTOR_CODE = X_DETERMINING_FACTOR_CODE,
303: DETERMINING_FACTOR_CLASS_CODE = X_DETERMINING_FACTOR_CLASS_COD,
304: VALUE_SET = X_VALUE_SET,
305: TAX_PARAMETER_CODE = X_TAX_PARAMETER_CODE,

Line 366: DELETE FROM ZX_DETERMINING_FACTORS_B

362: IF (sql%notfound) THEN
363: RAISE NO_DATA_FOUND;
364: END IF;
365:
366: DELETE FROM ZX_DETERMINING_FACTORS_B
367: WHERE DETERMINING_FACTOR_ID = X_DETERMINING_FACTOR_ID;
368:
369: IF (sql%notfound) THEN
370: RAISE NO_DATA_FOUND;

Line 392: FROM ZX_DETERMINING_FACTORS_B B

388: END IF;
389:
390: DELETE FROM ZX_DET_FACTORS_TL T
391: WHERE NOT EXISTS (SELECT NULL
392: FROM ZX_DETERMINING_FACTORS_B B
393: WHERE B.DETERMINING_FACTOR_ID = T.DETERMINING_FACTOR_ID);
394:
395: UPDATE ZX_DET_FACTORS_TL T
396: SET (DETERMINING_FACTOR_NAME,

Line 463: FROM ZX_DETERMINING_FACTORS_B

459: L_DET_FACTOR_NAME VARCHAR2(150);
460: X_ROWID ROWID;
461: CURSOR C IS
462: SELECT ROWID
463: FROM ZX_DETERMINING_FACTORS_B
464: WHERE DETERMINING_FACTOR_CLASS_CODE = X_DETERMINING_FACTOR_CLASS_COD
465: AND DETERMINING_FACTOR_CODE = X_DETERMINING_FACTOR_CODE;
466: BEGIN
467: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 477: SELECT Zx_Determining_Factors_B_S.nextval INTO L_DETERMINING_FACTOR_ID FROM DUAL;

473: OPEN C;
474: FETCH C INTO X_ROWID;
475: IF (C%NOTFOUND) THEN
476: BEGIN
477: SELECT Zx_Determining_Factors_B_S.nextval INTO L_DETERMINING_FACTOR_ID FROM DUAL;
478: /*Get the DETERMINING_FACTOR_NAME from HZ_GEOGRAPHIES for DETERMINING_FACTOR_CODE*/
479: SELECT GEOGRAPHY_TYPE_NAME INTO L_DET_FACTOR_NAME FROM HZ_GEOGRAPHY_TYPES_VL
480: WHERE GEOGRAPHY_TYPE = X_DETERMINING_FACTOR_CODE
481: AND GEOGRAPHY_USE= (DECODE(X_DETERMINING_FACTOR_CLASS_COD, 'GEOGRAPHY', 'MASTER_REF', 'TAX'))