eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TRL_DETAIL_OVERRIDE_PKG dependencies on ZX_LINES

Line 320: l_report_status_tracking ZX_LINES.legal_reporting_status%TYPE;

316: l_msg_count NUMBER;
317: l_msg_data VARCHAR2(1000);
318: l_tax_line_id NUMBER;
319: l_tax_reporting_flag ZX_EVNT_CLS_MAPPINGS.tax_reporting_flag%TYPE;
320: l_report_status_tracking ZX_LINES.legal_reporting_status%TYPE;
321: l_offset_tax_rate_code VARCHAR2(100);
322: l_offset_flag VARCHAR2(10);
323: l_offset_tax_flag VARCHAR2(100);
324:

Line 327: FROM ZX_LINES

323: l_offset_tax_flag VARCHAR2(100);
324:
325: CURSOR C IS
326: SELECT rowid
327: FROM ZX_LINES
328: WHERE TAX_LINE_ID = p_tax_line_id;
329:
330: BEGIN
331: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 342: 'Inserting into ZX_LINES (+)');

338:
339: IF (g_level_procedure >= g_current_runtime_level ) THEN
340: FND_LOG.STRING(g_level_procedure,
341: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
342: 'Inserting into ZX_LINES (+)');
343: FND_LOG.STRING(g_level_procedure,
344: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
345: 'p_entity_code '||p_entity_code);
346: FND_LOG.STRING(g_level_procedure,

Line 415: INSERT INTO ZX_LINES (TAX_LINE_ID,

411: END IF;
412: END;
413: END if;
414:
415: INSERT INTO ZX_LINES (TAX_LINE_ID,
416: INTERNAL_ORGANIZATION_ID,
417: APPLICATION_ID,
418: ENTITY_CODE,
419: EVENT_CLASS_CODE,

Line 1033: 'Inserting into ZX_LINES (-)');

1029:
1030: IF (g_level_procedure >= g_current_runtime_level ) THEN
1031: FND_LOG.STRING(g_level_procedure,
1032: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
1033: 'Inserting into ZX_LINES (-)');
1034: END IF;
1035:
1036: IF (g_level_procedure >= g_current_runtime_level ) THEN
1037: FND_LOG.STRING(g_level_procedure,

Line 1039: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update ZX_LINES (+)');

1035:
1036: IF (g_level_procedure >= g_current_runtime_level ) THEN
1037: FND_LOG.STRING(g_level_procedure,
1038: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row.',
1039: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update ZX_LINES (+)');
1040: END IF;
1041:
1042: --Set recalculate_required_flag = 'Y' for all the tax lines for the same
1043: --trx line with compounding_tax_miss_flag = 'Y'.

Line 1044: UPDATE ZX_LINES

1040: END IF;
1041:
1042: --Set recalculate_required_flag = 'Y' for all the tax lines for the same
1043: --trx line with compounding_tax_miss_flag = 'Y'.
1044: UPDATE ZX_LINES
1045: SET RECALC_REQUIRED_FLAG = p_recalc_required_flag
1046: WHERE APPLICATION_ID = p_application_id
1047: AND ENTITY_CODE = p_entity_code
1048: AND EVENT_CLASS_CODE = p_event_class_code

Line 1057: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update ZX_LINES (-)');

1053:
1054: IF (g_level_procedure >= g_current_runtime_level ) THEN
1055: FND_LOG.STRING(g_level_procedure,
1056: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row.',
1057: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Update ZX_LINES (-)');
1058: END IF;
1059:
1060: IF (g_level_procedure >= g_current_runtime_level ) THEN
1061: FND_LOG.STRING(g_level_procedure,

Line 1671: FROM ZX_LINES

1667: CREATION_DATE,
1668: LAST_UPDATED_BY,
1669: LAST_UPDATE_DATE,
1670: LAST_UPDATE_LOGIN
1671: FROM ZX_LINES
1672: WHERE TAX_LINE_ID = p_tax_line_id;
1673:
1674: Recinfo lines_csr%ROWTYPE;
1675:

Line 2538: ZX_LINES_DET_FACTORS_PKG.lock_line_det_factors (

2534: --l_transaction_rec.TAX_EVENT_CLASS_CODE := Recinfo.TAX_EVENT_CLASS_CODE ;
2535: --l_transaction_rec.TAX_EVENT_TYPE_CODE := Recinfo.TAX_EVENT_TYPE_CODE;
2536: --l_transaction_rec.DOC_EVENT_STATUS := Recinfo.DOC_EVENT_STATUS ;
2537:
2538: ZX_LINES_DET_FACTORS_PKG.lock_line_det_factors (
2539: l_transaction_rec,
2540: l_return_status );
2541: RETURN;
2542: ELSE

Line 2905: FROM zx_lines

2901: mrc_tax_line_flag,
2902: tax_only_line_flag,
2903: tax_apportionment_line_number,
2904: tax_amt
2905: FROM zx_lines
2906: WHERE application_id = p_appln_id
2907: AND entity_code = p_entity_cd
2908: AND event_class_code = p_event_cls_cd
2909: AND trx_id = p_transaction_id

Line 2916: FROM zx_lines_summary

2912: AND tax_line_id = p_tax_ln_id;
2913:
2914: CURSOR existing_summary_tax_line(l_tax_rate NUMBER) IS
2915: SELECT summary_tax_line_id
2916: FROM zx_lines_summary
2917: WHERE application_id = p_application_id
2918: AND entity_code = p_entity_code
2919: AND event_class_code = p_event_class_code
2920: AND trx_id = p_trx_id

Line 3007: 'Update ZX_LINES (+)');

3003:
3004: IF (g_level_procedure >= g_current_runtime_level ) THEN
3005: FND_LOG.STRING(g_level_procedure,
3006: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3007: 'Update ZX_LINES (+)');
3008: END IF;
3009:
3010: IF (g_level_procedure >= g_current_runtime_level ) THEN
3011: FND_LOG.STRING(g_level_procedure,

Line 3043: SELECT tax_amt INTO l_detail_tax_amt FROM zx_lines

3039:
3040: l_tax_rate := p_tax_rate;
3041:
3042: BEGIN
3043: SELECT tax_amt INTO l_detail_tax_amt FROM zx_lines
3044: WHERE tax_line_id = p_tax_line_id;
3045: EXCEPTION
3046: WHEN OTHERS THEN
3047: NULL;

Line 3203: SELECT zx_lines_s.nextval into l_tax_line_id

3199: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3200: 'inside if '||p_recalc_required_flag);
3201: END IF;
3202:
3203: SELECT zx_lines_s.nextval into l_tax_line_id
3204: FROM dual;
3205:
3206: SELECT MAX(ABS(tax_apportionment_line_number)) + 1
3207: INTO l_tax_apportionment_line_num

Line 3208: FROM zx_lines

3204: FROM dual;
3205:
3206: SELECT MAX(ABS(tax_apportionment_line_number)) + 1
3207: INTO l_tax_apportionment_line_num
3208: FROM zx_lines
3209: WHERE application_id = p_application_id
3210: AND entity_code = p_entity_code
3211: AND event_class_code = p_event_class_code
3212: AND trx_id = p_trx_id

Line 3217: FROM zx_lines

3213: AND trx_line_id = p_trx_line_id;
3214:
3215: SELECT NVL(MAX(tax_line_number),0) + 1
3216: INTO l_tax_line_number
3217: FROM zx_lines
3218: WHERE application_id = p_application_id
3219: AND entity_code = p_entity_code
3220: AND event_class_code = p_event_class_code
3221: AND trx_id = p_trx_id

Line 3225: UPDATE ZX_LINES

3221: AND trx_id = p_trx_id
3222: AND trx_line_id = p_trx_line_id
3223: AND trx_level_type = p_trx_level_type;
3224:
3225: UPDATE ZX_LINES
3226: SET cancel_flag = 'Y',
3227: tax_amt = 0,
3228: tax_apportionment_line_number = -1*l_tax_apportionment_line_num,
3229: unrounded_tax_amt = 0,

Line 3237: FROM zx_lines

3233: WHERE tax_line_id = p_tax_line_id;
3234:
3235: BEGIN
3236: select tax_line_id into l_offset_tax_line_id
3237: FROM zx_lines
3238: where application_id = p_application_id
3239: and entity_code = p_entity_code
3240: and event_class_code = p_event_class_code
3241: and offset_link_to_tax_line_id = p_tax_line_id;

Line 3245: FROM zx_lines

3241: and offset_link_to_tax_line_id = p_tax_line_id;
3242:
3243:
3244: SELECT trx_line_id into l_offset_trx_line_id
3245: FROM zx_lines
3246: WHERE tax_line_id = l_offset_tax_line_id;
3247:
3248: SELECT MAX(ABS(tax_apportionment_line_number)) + 1
3249: INTO l_tax_apportionment_line_num

Line 3250: FROM zx_lines

3246: WHERE tax_line_id = l_offset_tax_line_id;
3247:
3248: SELECT MAX(ABS(tax_apportionment_line_number)) + 1
3249: INTO l_tax_apportionment_line_num
3250: FROM zx_lines
3251: WHERE application_id = p_application_id
3252: AND entity_code = p_entity_code
3253: AND event_class_code = p_event_class_code
3254: AND trx_id = p_trx_id

Line 3257: UPDATE ZX_LINES

3253: AND event_class_code = p_event_class_code
3254: AND trx_id = p_trx_id
3255: AND trx_line_id = l_offset_trx_line_id;
3256:
3257: UPDATE ZX_LINES
3258: SET cancel_flag = 'Y',
3259: tax_amt = 0,
3260: tax_apportionment_line_number = -1*l_tax_apportionment_line_num,
3261: unrounded_tax_amt = 0,

Line 3593: UPDATE ZX_LINES

3589:
3590:
3591: IF l_same_line THEN
3592:
3593: UPDATE ZX_LINES
3594: SET TAX_REGIME_ID = p_tax_regime_id,
3595: TAX_REGIME_CODE = p_tax_regime_code,
3596: TAX_ID = p_tax_id,
3597: TAX = p_tax,

Line 3655: 'Update ZX_LINES (-)');

3651:
3652: IF (g_level_procedure >= g_current_runtime_level ) THEN
3653: FND_LOG.STRING(g_level_procedure,
3654: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3655: 'Update ZX_LINES (-)');
3656: END IF;
3657:
3658: IF (g_level_procedure >= g_current_runtime_level ) THEN
3659: FND_LOG.STRING(g_level_procedure,

Line 3661: 'Update RECALC_REQUIRED_FLAG in ZX_LINES (+)');

3657:
3658: IF (g_level_procedure >= g_current_runtime_level ) THEN
3659: FND_LOG.STRING(g_level_procedure,
3660: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3661: 'Update RECALC_REQUIRED_FLAG in ZX_LINES (+)');
3662: END IF;
3663:
3664: BEGIN
3665: SELECT CTRL_EFF_OVRD_CALC_LINES_FLAG

Line 3692: UPDATE ZX_LINES

3688: IF p_manually_entered_flag = 'N' THEN
3689: -- this is system generated tax line :
3690: IF p_tax_amt_included_flag = 'Y' THEN
3691: IF l_ctrl_ef_ov_cal_line_flag = 'Y' THEN
3692: UPDATE ZX_LINES
3693: SET RECALC_REQUIRED_FLAG = 'Y'
3694: WHERE APPLICATION_ID = p_application_id
3695: AND ENTITY_CODE = p_entity_code
3696: AND EVENT_CLASS_CODE = p_event_class_code

Line 3707: UPDATE ZX_LINES

3703:
3704: ELSE
3705: -- tax_amt_included_flag = 'N'
3706: IF p_compounding_tax_flag = 'Y' THEN
3707: UPDATE ZX_LINES
3708: SET RECALC_REQUIRED_FLAG = 'Y'
3709: WHERE APPLICATION_ID = p_application_id
3710: AND ENTITY_CODE = p_entity_code
3711: AND EVENT_CLASS_CODE = p_event_class_code

Line 3724: 'Update RECALC_REQUIRED_FLAG in ZX_LINES (-)');

3720:
3721: IF (g_level_procedure >= g_current_runtime_level ) THEN
3722: FND_LOG.STRING(g_level_procedure,
3723: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3724: 'Update RECALC_REQUIRED_FLAG in ZX_LINES (-)');
3725: END IF;
3726:
3727: IF (g_level_procedure >= g_current_runtime_level ) THEN
3728: FND_LOG.STRING(g_level_procedure,

Line 4055: 'Update zx_lines for delete and cancel flag (+)');

4051:
4052: IF (g_level_procedure >= g_current_runtime_level ) THEN
4053: FND_LOG.STRING(g_level_procedure,
4054: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row',
4055: 'Update zx_lines for delete and cancel flag (+)');
4056: END IF;
4057:
4058: UPDATE ZX_LINES
4059: SET DELETE_FLAG = 'Y',

Line 4058: UPDATE ZX_LINES

4054: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row',
4055: 'Update zx_lines for delete and cancel flag (+)');
4056: END IF;
4057:
4058: UPDATE ZX_LINES
4059: SET DELETE_FLAG = 'Y',
4060: SYNC_WITH_PRVDR_FLAG = DECODE(p_tax_provider_id,
4061: NULL, 'N', 'Y'),
4062: OBJECT_VERSION_NUMBER = NVL(p_object_version_number, OBJECT_VERSION_NUMBER + 1)

Line 4068: 'Update zx_lines for delete and cancel flag (-)');

4064:
4065: IF (g_level_procedure >= g_current_runtime_level ) THEN
4066: FND_LOG.STRING(g_level_procedure,
4067: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row',
4068: 'Update zx_lines for delete and cancel flag (-)');
4069: END IF;
4070:
4071: IF (g_level_procedure >= g_current_runtime_level ) THEN
4072: FND_LOG.STRING(g_level_procedure,

Line 4101: -- obtain lock before update ZX_LINES_DET_FACTORS

4097: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Override_Row(+)');
4098: END IF;
4099:
4100: --
4101: -- obtain lock before update ZX_LINES_DET_FACTORS
4102: --
4103: l_transaction_rec.application_id := p_application_id;
4104: l_transaction_rec.entity_code := p_entity_code;
4105: l_transaction_rec.event_class_code := p_event_class_code;

Line 4108: ZX_LINES_DET_FACTORS_PKG.lock_line_det_factors(

4104: l_transaction_rec.entity_code := p_entity_code;
4105: l_transaction_rec.event_class_code := p_event_class_code;
4106: l_transaction_rec.trx_id := p_trx_id;
4107:
4108: ZX_LINES_DET_FACTORS_PKG.lock_line_det_factors(
4109: l_transaction_rec,
4110: l_return_status );
4111:
4112: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 4113: UPDATE ZX_LINES_DET_FACTORS

4109: l_transaction_rec,
4110: l_return_status );
4111:
4112: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4113: UPDATE ZX_LINES_DET_FACTORS
4114: SET EVENT_ID = p_event_id
4115: WHERE APPLICATION_ID = p_application_id
4116: AND ENTITY_CODE = p_entity_code
4117: AND EVENT_CLASS_CODE = p_event_class_code

Line 4147: FROM ZX_LINES

4143: c_event_class_code VARCHAR2,
4144: c_entity_code VARCHAR2,
4145: c_trx_id NUMBER) IS
4146: SELECT *
4147: FROM ZX_LINES
4148: WHERE application_id = c_application_id
4149: AND entity_code = c_entity_code
4150: AND event_class_code = c_event_class_code
4151: AND trx_id = c_trx_id