APPS.ZX_TAXES_PKG dependencies on ZX_RECOVERY_TYPES_VL

Line 72: /*delete recovery - to remove recovery types from zx_recovery_types_vl*/

68: FND_GLOBAL.USER_ID,
69: FND_GLOBAL.LOGIN_ID
70: );
71: end insert_recovery;
72: /*delete recovery - to remove recovery types from zx_recovery_types_vl*/
73: procedure delete_recovery(
74: p_tax IN VARCHAR2,
75: p_tax_regime_code IN VARCHAR2,
76: p_recovery_type_code IN VARCHAR2

Line 81: FROM ZX_RECOVERY_TYPES_VL

77: )
78: is
79: CURSOR c_get_recovery_id is
80: SELECT RECOVERY_TYPE_ID
81: FROM ZX_RECOVERY_TYPES_VL
82: WHERE TAX = p_tax
83: AND TAX_REGIME_CODE = p_tax_regime_code
84: AND RECOVERY_TYPE_CODE = p_recovery_type_code;
85: l_recovery_type_id NUMBER;

Line 1208: /*Logic to insert/update records in ZX_RECOVERY_TYPES_VL table - all calls to insert into ZX_RECOVERY_TYPES has been

1204: X_REP_TAX_AUTHORITY_ID,
1205: X_COLL_TAX_AUTHORITY_ID
1206: );
1207: end if; /*Update on Jurisdictions/Registrations ends*/
1208: /*Logic to insert/update records in ZX_RECOVERY_TYPES_VL table - all calls to insert into ZX_RECOVERY_TYPES has been
1209: commented as fix for bug 2909723*/
1210: /*if(X_Live_For_Processing_Flag is null or X_LIVE_FOR_PROCESSING_Flag = 'N') THEN
1211: if(l_old_references.PRIMARY_RECOVERY_TYPE_CODE IS NULL AND X_PRIMARY_RECOVERY_TYPE_CODE IS NOT NULL) THEN
1212: insert_recovery(X_TAX,

Line 1283: /*Insert/Update of ZX_RECOVERY_TYPES_VL ends here*/

1279: exception when no_data_found then
1280: raise no_data_found;
1281: end;
1282: end if;
1283: /*Insert/Update of ZX_RECOVERY_TYPES_VL ends here*/
1284: update ZX_TAXES_B set
1285: ATTRIBUTE13 = X_ATTRIBUTE13,
1286: ATTRIBUTE14 = X_ATTRIBUTE14,
1287: ATTRIBUTE15 = X_ATTRIBUTE15,