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: l_tax_rate_type VARCHAR2(100); --Bug 13724999

Line 328: FROM ZX_LINES

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

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

339:
340: IF (g_level_procedure >= g_current_runtime_level ) THEN
341: FND_LOG.STRING(g_level_procedure,
342: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
343: 'Inserting into ZX_LINES (+)');
344: FND_LOG.STRING(g_level_procedure,
345: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
346: 'Input Parameters : Tax_Line_Number='||TO_CHAR(p_tax_line_number)||
347: ', Application_Id='||TO_CHAR(p_application_id)||

Line 419: INSERT INTO ZX_LINES (TAX_LINE_ID,

415: END;
416: END IF;
417:
418:
419: INSERT INTO ZX_LINES (TAX_LINE_ID,
420: INTERNAL_ORGANIZATION_ID,
421: APPLICATION_ID,
422: ENTITY_CODE,
423: EVENT_CLASS_CODE,

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

1034:
1035: IF (g_level_procedure >= g_current_runtime_level ) THEN
1036: FND_LOG.STRING(g_level_procedure,
1037: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_Row',
1038: 'Inserting into ZX_LINES (-)');
1039: END IF;
1040:
1041: IF (g_level_procedure >= g_current_runtime_level ) THEN
1042: FND_LOG.STRING(g_level_procedure,

Line 1049: UPDATE ZX_LINES

1045: END IF;
1046:
1047: --Set recalculate_required_flag = 'Y' for all the tax lines for the same
1048: --trx line with compounding_tax_miss_flag = 'Y'.
1049: UPDATE ZX_LINES
1050: SET RECALC_REQUIRED_FLAG = p_recalc_required_flag
1051: WHERE APPLICATION_ID = p_application_id
1052: AND ENTITY_CODE = p_entity_code
1053: AND EVENT_CLASS_CODE = p_event_class_code

Line 1670: FROM ZX_LINES

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

Line 2537: ZX_LINES_DET_FACTORS_PKG.lock_line_det_factors (

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

Line 2904: FROM zx_lines

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

Line 2915: FROM zx_lines_summary

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

Line 3029: FROM zx_lines

3025:
3026: BEGIN
3027: SELECT tax_amt
3028: INTO l_detail_tax_amt
3029: FROM zx_lines
3030: WHERE tax_line_id = p_tax_line_id;
3031: EXCEPTION
3032: WHEN OTHERS THEN
3033: NULL;

Line 3139: SELECT zx_lines_s.nextval into l_tax_line_id

3135: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3136: 'Inside summary tax line criteria changed');
3137: END IF;
3138:
3139: SELECT zx_lines_s.nextval into l_tax_line_id
3140: FROM dual;
3141:
3142: SELECT MAX(ABS(tax_apportionment_line_number)) + 1
3143: INTO l_tax_apportionment_line_num

Line 3144: FROM zx_lines

3140: FROM dual;
3141:
3142: SELECT MAX(ABS(tax_apportionment_line_number)) + 1
3143: INTO l_tax_apportionment_line_num
3144: FROM zx_lines
3145: WHERE application_id = p_application_id
3146: AND entity_code = p_entity_code
3147: AND event_class_code = p_event_class_code
3148: AND trx_id = p_trx_id

Line 3153: FROM zx_lines

3149: AND trx_line_id = p_trx_line_id;
3150:
3151: SELECT NVL(MAX(tax_line_number),0) + 1
3152: INTO l_tax_line_number
3153: FROM zx_lines
3154: WHERE application_id = p_application_id
3155: AND entity_code = p_entity_code
3156: AND event_class_code = p_event_class_code
3157: AND trx_id = p_trx_id

Line 3161: UPDATE ZX_LINES

3157: AND trx_id = p_trx_id
3158: AND trx_line_id = p_trx_line_id
3159: AND trx_level_type = p_trx_level_type;
3160:
3161: UPDATE ZX_LINES
3162: SET cancel_flag = 'Y',
3163: tax_amt = 0,
3164: tax_apportionment_line_number = -1*l_tax_apportionment_line_num,
3165: unrounded_tax_amt = 0,

Line 3176: FROM zx_lines

3172: WHERE tax_line_id = p_tax_line_id;
3173:
3174: BEGIN
3175: select tax_line_id into l_offset_tax_line_id
3176: FROM zx_lines
3177: where application_id = p_application_id
3178: and entity_code = p_entity_code
3179: and event_class_code = p_event_class_code
3180: and offset_link_to_tax_line_id = p_tax_line_id

Line 3186: FROM zx_lines

3182: and trx_level_type = p_trx_level_type;
3183:
3184:
3185: SELECT trx_line_id into l_offset_trx_line_id
3186: FROM zx_lines
3187: WHERE tax_line_id = l_offset_tax_line_id;
3188:
3189: SELECT MAX(ABS(tax_apportionment_line_number)) + 1
3190: INTO l_tax_apportionment_line_num

Line 3191: FROM zx_lines

3187: WHERE tax_line_id = l_offset_tax_line_id;
3188:
3189: SELECT MAX(ABS(tax_apportionment_line_number)) + 1
3190: INTO l_tax_apportionment_line_num
3191: FROM zx_lines
3192: WHERE application_id = p_application_id
3193: AND entity_code = p_entity_code
3194: AND event_class_code = p_event_class_code
3195: AND trx_id = p_trx_id

Line 3198: UPDATE ZX_LINES

3194: AND event_class_code = p_event_class_code
3195: AND trx_id = p_trx_id
3196: AND trx_line_id = l_offset_trx_line_id;
3197:
3198: UPDATE ZX_LINES
3199: SET cancel_flag = 'Y',
3200: tax_amt = 0,
3201: tax_apportionment_line_number = -1*l_tax_apportionment_line_num,
3202: unrounded_tax_amt = 0,

Line 3545: FROM ZX_LINES

3541: SELECT CASE WHEN p_tax_amt_included_flag <> tax_amt_included_flag
3542: THEN 'Y'
3543: ELSE 'N' END
3544: INTO l_tax_amt_incl_changed
3545: FROM ZX_LINES
3546: WHERE TAX_LINE_ID = p_tax_line_id;
3547:
3548: UPDATE ZX_LINES
3549: SET TAX_REGIME_ID = p_tax_regime_id,

Line 3548: UPDATE ZX_LINES

3544: INTO l_tax_amt_incl_changed
3545: FROM ZX_LINES
3546: WHERE TAX_LINE_ID = p_tax_line_id;
3547:
3548: UPDATE ZX_LINES
3549: SET TAX_REGIME_ID = p_tax_regime_id,
3550: TAX_REGIME_CODE = p_tax_regime_code,
3551: TAX_ID = p_tax_id,
3552: TAX = p_tax,

Line 3631: 'Update recalc_required_flag in zx_lines');

3627:
3628: IF (g_level_procedure >= g_current_runtime_level ) THEN
3629: FND_LOG.STRING(g_level_procedure,
3630: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Update_Row',
3631: 'Update recalc_required_flag in zx_lines');
3632: END IF;
3633:
3634: BEGIN
3635: SELECT CTRL_EFF_OVRD_CALC_LINES_FLAG

Line 3661: UPDATE ZX_LINES

3657: IF p_manually_entered_flag = 'N' THEN
3658: -- this is system generated tax line :
3659: IF l_tax_amt_incl_changed = 'Y' THEN
3660: IF l_ctrl_ef_ov_cal_line_flag = 'Y' THEN
3661: UPDATE ZX_LINES
3662: SET RECALC_REQUIRED_FLAG = 'Y'
3663: WHERE APPLICATION_ID = p_application_id
3664: AND ENTITY_CODE = p_entity_code
3665: AND EVENT_CLASS_CODE = p_event_class_code

Line 3676: UPDATE ZX_LINES

3672:
3673: ELSE
3674: -- tax_amt_included_flag = 'N'
3675: IF p_compounding_tax_flag = 'Y' THEN
3676: UPDATE ZX_LINES
3677: SET RECALC_REQUIRED_FLAG = 'Y'
3678: WHERE APPLICATION_ID = p_application_id
3679: AND ENTITY_CODE = p_entity_code
3680: AND EVENT_CLASS_CODE = p_event_class_code

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

4014:
4015: IF (g_level_procedure >= g_current_runtime_level ) THEN
4016: FND_LOG.STRING(g_level_procedure,
4017: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row',
4018: 'Update zx_lines for delete and cancel flag (+)');
4019: END IF;
4020:
4021: UPDATE ZX_LINES
4022: SET DELETE_FLAG = 'Y',

Line 4021: UPDATE ZX_LINES

4017: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row',
4018: 'Update zx_lines for delete and cancel flag (+)');
4019: END IF;
4020:
4021: UPDATE ZX_LINES
4022: SET DELETE_FLAG = 'Y',
4023: SYNC_WITH_PRVDR_FLAG = DECODE(p_tax_provider_id,
4024: NULL, 'N', 'Y'),
4025: OBJECT_VERSION_NUMBER = NVL(p_object_version_number, OBJECT_VERSION_NUMBER + 1)

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

4027:
4028: IF (g_level_procedure >= g_current_runtime_level ) THEN
4029: FND_LOG.STRING(g_level_procedure,
4030: 'ZX.PLSQL.ZX_TRL_DETAIL_OVERRIDE_PKG.Delete_Row',
4031: 'Update zx_lines for delete and cancel flag (-)');
4032: END IF;
4033:
4034: IF (g_level_procedure >= g_current_runtime_level ) THEN
4035: FND_LOG.STRING(g_level_procedure,

Line 4064: -- obtain lock before update ZX_LINES_DET_FACTORS

4060: 'ZX_TRL_DETAIL_OVERRIDE_PKG: Override_Row(+)');
4061: END IF;
4062:
4063: --
4064: -- obtain lock before update ZX_LINES_DET_FACTORS
4065: --
4066: l_transaction_rec.application_id := p_application_id;
4067: l_transaction_rec.entity_code := p_entity_code;
4068: l_transaction_rec.event_class_code := p_event_class_code;

Line 4071: ZX_LINES_DET_FACTORS_PKG.lock_line_det_factors(

4067: l_transaction_rec.entity_code := p_entity_code;
4068: l_transaction_rec.event_class_code := p_event_class_code;
4069: l_transaction_rec.trx_id := p_trx_id;
4070:
4071: ZX_LINES_DET_FACTORS_PKG.lock_line_det_factors(
4072: l_transaction_rec,
4073: l_return_status );
4074:
4075: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 4076: UPDATE ZX_LINES_DET_FACTORS

4072: l_transaction_rec,
4073: l_return_status );
4074:
4075: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4076: UPDATE ZX_LINES_DET_FACTORS
4077: SET EVENT_ID = p_event_id
4078: WHERE APPLICATION_ID = p_application_id
4079: AND ENTITY_CODE = p_entity_code
4080: AND EVENT_CLASS_CODE = p_event_class_code

Line 4110: FROM ZX_LINES

4106: c_event_class_code VARCHAR2,
4107: c_entity_code VARCHAR2,
4108: c_trx_id NUMBER) IS
4109: SELECT *
4110: FROM ZX_LINES
4111: WHERE application_id = c_application_id
4112: AND entity_code = c_entity_code
4113: AND event_class_code = c_event_class_code
4114: AND trx_id = c_trx_id