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_PRODUCT_INTEGRATION_PKG dependencies on ZX_LINES

Line 2074: zx_lines_det_factors

2070: trx_business_category,
2071: product_fisc_classification,
2072: product_category
2073: from
2074: zx_lines_det_factors
2075: where application_id = c_application_id
2076: and entity_code = c_entity_code
2077: and event_class_code = c_event_class_code
2078: and trx_id = c_trx_id

Line 2104: from ZX_LINES

2100: tax_exception_id,
2101: tax_currency_conversion_date,
2102: tax_currency_conversion_rate,
2103: tax_currency_conversion_type
2104: from ZX_LINES
2105: where application_id = c_application_id
2106: and entity_code = c_entity_code
2107: and event_class_code = c_event_class_code
2108: and trx_level_type = c_trx_level_type

Line 4244: FROM ZX_LINES_DET_FACTORS

4240: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOCUMENT_SUB_TYPE(p_index),
4241: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_INTENDED_USE(p_index),
4242: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ASSESSABLE_VALUE(p_index),
4243: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_TYPE(p_index)
4244: FROM ZX_LINES_DET_FACTORS
4245: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_index)
4246: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_index)
4247: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_index)
4248: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_index)

Line 4582: SELECT zx_lines_s.NEXTVAL

4578:
4579: l_user_id := fnd_global.user_id;
4580: l_date := sysdate;
4581:
4582: SELECT zx_lines_s.NEXTVAL
4583: INTO ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_line_id
4584: FROM dual;
4585:
4586: -- standard who columns

Line 5141: l_adjusted_doc_tax_line_id ZX_LINES.adjusted_doc_tax_line_id%TYPE;

5137: l_error_buffer VARCHAR2(240);
5138: l_return_status VARCHAR2(1);
5139:
5140: -- Start : Added for Bug#8669930
5141: l_adjusted_doc_tax_line_id ZX_LINES.adjusted_doc_tax_line_id%TYPE;
5142:
5143: CURSOR get_adjusted_doc_tax_line_id
5144: (c_tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
5145: c_tax zx_taxes_b.tax%TYPE,

Line 5146: c_apportionment_line_number zx_lines.tax_apportionment_line_number%type) IS

5142:
5143: CURSOR get_adjusted_doc_tax_line_id
5144: (c_tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
5145: c_tax zx_taxes_b.tax%TYPE,
5146: c_apportionment_line_number zx_lines.tax_apportionment_line_number%type) IS
5147: SELECT tax_line_id FROM zx_lines
5148: WHERE application_id =
5149: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_id_dist_tbl)
5150: AND entity_code =

Line 5147: SELECT tax_line_id FROM zx_lines

5143: CURSOR get_adjusted_doc_tax_line_id
5144: (c_tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
5145: c_tax zx_taxes_b.tax%TYPE,
5146: c_apportionment_line_number zx_lines.tax_apportionment_line_number%type) IS
5147: SELECT tax_line_id FROM zx_lines
5148: WHERE application_id =
5149: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_id_dist_tbl)
5150: AND entity_code =
5151: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_id_dist_tbl)

Line 6604: | This procedure fetch detail tax lines from zx_lines |

6600: | PROCEDURE |
6601: | fetch_manual_tax_lines |
6602: | |
6603: | DESCRIPTION |
6604: | This procedure fetch detail tax lines from zx_lines |
6605: | |
6606: | SCOPE - Private |
6607: | |
6608: | MODIFICATION HISTORY |

Line 6619: SELECT * FROM zx_lines

6615: p_index IN BINARY_INTEGER,
6616: x_return_status OUT NOCOPY VARCHAR2)
6617: IS
6618: CURSOR get_manual_tax_lines IS
6619: SELECT * FROM zx_lines
6620: WHERE trx_id = p_event_class_rec.trx_id
6621: AND application_id = p_event_class_rec.application_id
6622: AND event_class_code = p_event_class_rec.event_class_code
6623: AND entity_code = p_event_class_rec.entity_code

Line 6636: l_current_line_amt ZX_LINES.line_amt%TYPE;

6632: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
6633: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
6634: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
6635: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
6636: l_current_line_amt ZX_LINES.line_amt%TYPE;
6637: l_tax_class VARCHAR2(30);
6638: l_tax_date DATE;
6639: l_tax_determine_date DATE;
6640: l_tax_point_date DATE;

Line 6845: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines (p_index,

6841: IF (l_begin_index IS NOT NULL) THEN
6842: l_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;
6843: END IF;
6844:
6845: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines (p_index,
6846: l_begin_index,
6847: l_end_index,
6848: x_return_status,
6849: l_error_buffer );

Line 6856: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');

6852: IF (g_level_statement >= g_current_runtime_level ) THEN
6853: FND_LOG.STRING(g_level_statement,
6854: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines',
6855: 'Incorrect RETURN_STATUS after calling '||
6856: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
6857: FND_LOG.STRING(g_level_statement,
6858: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.fetch_manual_tax_lines',
6859: 'RETURN_STATUS = ' || x_return_status);
6860: FND_LOG.STRING(g_level_statement,

Line 6910: SELECT * FROM zx_lines

6906: x_return_status OUT NOCOPY VARCHAR2)
6907: IS
6908: -- Cursor --
6909: CURSOR get_manual_tax_lines IS
6910: SELECT * FROM zx_lines
6911: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_index)
6912: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_index)
6913: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_index)
6914: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id( p_index)

Line 7296: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines(

7292: l_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;
7293: END IF;
7294:
7295: -- copy transaction info to new tax lines for new tax_lines created here
7296: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines(
7297: p_trx_line_index => p_index ,
7298: p_begin_index => l_begin_index,
7299: p_end_index => l_end_index,
7300: p_return_status => x_return_status ,

Line 7308: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');

7304: IF (g_level_statement >= g_current_runtime_level ) THEN
7305: FND_LOG.STRING(g_level_statement,
7306: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.get_manual_tax_lines_for_cm',
7307: 'Incorrect return_status after calling ' ||
7308: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
7309: FND_LOG.STRING(g_level_statement,
7310: 'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG.get_manual_tax_lines_for_cm',
7311: 'RETURN_STATUS = ' || x_return_status);
7312: FND_LOG.STRING(g_level_statement,