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

Line 13: p_tax_rate OUT NOCOPY ZX_LINES.TAX_RATE%TYPE,

9: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
10: p_tax_jurisdiction_code IN ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE,
11: p_tax_class IN ZX_RATES_B.TAX_CLASS%TYPE,
12: p_offset_tax_rate_id OUT NOCOPY ZX_RATES_B.TAX_RATE_ID%TYPE,
13: p_tax_rate OUT NOCOPY ZX_LINES.TAX_RATE%TYPE,
14: p_return_status OUT NOCOPY VARCHAR2,
15: p_error_buffer OUT NOCOPY VARCHAR2);
16:
17: PROCEDURE set_null_columns(

Line 51: p_old_offset_tax_line_id OUT NOCOPY ZX_LINES.TAX_LINE_ID%TYPE,

47:
48: PROCEDURE get_old_offset_tax_line_id(
49: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
50: p_offset_tax_line_rec IN ZX_DETAIL_TAX_LINES_GT%ROWTYPE,
51: p_old_offset_tax_line_id OUT NOCOPY ZX_LINES.TAX_LINE_ID%TYPE,
52: p_return_status OUT NOCOPY VARCHAR2,
53: p_error_buffer OUT NOCOPY VARCHAR2);
54:
55: PROCEDURE create_offset_tax_line(

Line 60: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,

56: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,
57: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
58: p_offset_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,
59: p_offset_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
60: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
61: p_initial_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
62: p_offset_tax IN ZX_TAXES_B.TAX%TYPE,
63: p_offset_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
64: p_return_status OUT NOCOPY VARCHAR2,

Line 61: p_initial_tax_rate IN ZX_LINES.TAX_RATE%TYPE,

57: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
58: p_offset_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,
59: p_offset_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
60: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
61: p_initial_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
62: p_offset_tax IN ZX_TAXES_B.TAX%TYPE,
63: p_offset_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
64: p_return_status OUT NOCOPY VARCHAR2,
65: p_error_buffer OUT NOCOPY VARCHAR2);

Line 90: l_offset_tax_rate ZX_LINES.TAX_RATE%TYPE;

86:
87: IS
88: l_tax_rate_id ZX_RATES_B.TAX_RATE_ID%TYPE;
89: l_offset_tax_rate_id ZX_RATES_B.TAX_RATE_ID%TYPE;
90: l_offset_tax_rate ZX_LINES.TAX_RATE%TYPE;
91: l_initial_tax_rate ZX_LINES.TAX_RATE%TYPE;
92: l_offset_tax ZX_TAXES_B.TAX%TYPE;
93: l_offset_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;
94: l_offset_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE;

Line 91: l_initial_tax_rate ZX_LINES.TAX_RATE%TYPE;

87: IS
88: l_tax_rate_id ZX_RATES_B.TAX_RATE_ID%TYPE;
89: l_offset_tax_rate_id ZX_RATES_B.TAX_RATE_ID%TYPE;
90: l_offset_tax_rate ZX_LINES.TAX_RATE%TYPE;
91: l_initial_tax_rate ZX_LINES.TAX_RATE%TYPE;
92: l_offset_tax ZX_TAXES_B.TAX%TYPE;
93: l_offset_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;
94: l_offset_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE;
95: l_offset_tax_rate_code ZX_RATES_B.OFFSET_TAX_RATE_CODE%TYPE;

Line 257: p_tax_rate OUT NOCOPY ZX_LINES.TAX_RATE%TYPE,

253: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
254: p_tax_jurisdiction_code IN ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE,
255: p_tax_class IN ZX_RATES_B.TAX_CLASS%TYPE,
256: p_offset_tax_rate_id OUT NOCOPY ZX_RATES_B.TAX_RATE_ID%TYPE,
257: p_tax_rate OUT NOCOPY ZX_LINES.TAX_RATE%TYPE,
258: p_return_status OUT NOCOPY VARCHAR2,
259: p_error_buffer OUT NOCOPY VARCHAR2)
260:
261: IS

Line 793: p_old_offset_tax_line_id OUT NOCOPY ZX_LINES.TAX_LINE_ID%TYPE,

789:
790: PROCEDURE get_old_offset_tax_line_id(
791: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
792: p_offset_tax_line_rec IN ZX_DETAIL_TAX_LINES_GT%ROWTYPE,
793: p_old_offset_tax_line_id OUT NOCOPY ZX_LINES.TAX_LINE_ID%TYPE,
794: p_return_status OUT NOCOPY VARCHAR2,
795: p_error_buffer OUT NOCOPY VARCHAR2)
796: IS
797:

Line 800: -- (c_offset_link_to_tax_line_id ZX_LINES.OFFSET_LINK_TO_TAX_LINE_ID%TYPE)

796: IS
797:
798:
799: CURSOR get_old_offset_tax_line_id_csr
800: -- (c_offset_link_to_tax_line_id ZX_LINES.OFFSET_LINK_TO_TAX_LINE_ID%TYPE)
801: IS
802: SELECT tax_line_id
803: FROM ZX_LINES
804: WHERE APPLICATION_ID = p_offset_tax_line_rec.APPLICATION_ID

Line 803: FROM ZX_LINES

799: CURSOR get_old_offset_tax_line_id_csr
800: -- (c_offset_link_to_tax_line_id ZX_LINES.OFFSET_LINK_TO_TAX_LINE_ID%TYPE)
801: IS
802: SELECT tax_line_id
803: FROM ZX_LINES
804: WHERE APPLICATION_ID = p_offset_tax_line_rec.APPLICATION_ID
805: AND ENTITY_CODE = p_offset_tax_line_rec.ENTITY_CODE
806: AND EVENT_CLASS_CODE = p_offset_tax_line_rec.EVENT_CLASS_CODE
807: AND trx_id = p_offset_tax_line_rec.trx_id

Line 873: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,

869: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,
870: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
871: p_offset_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,
872: p_offset_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
873: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
874: p_initial_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
875: p_offset_tax IN ZX_TAXES_B.TAX%TYPE,
876: p_offset_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
877: p_return_status OUT NOCOPY VARCHAR2,

Line 874: p_initial_tax_rate IN ZX_LINES.TAX_RATE%TYPE,

870: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
871: p_offset_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,
872: p_offset_tax_rate_id IN ZX_RATES_B.TAX_RATE_ID%TYPE,
873: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
874: p_initial_tax_rate IN ZX_LINES.TAX_RATE%TYPE,
875: p_offset_tax IN ZX_TAXES_B.TAX%TYPE,
876: p_offset_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
877: p_return_status OUT NOCOPY VARCHAR2,
878: p_error_buffer OUT NOCOPY VARCHAR2)

Line 883: FROM zx_lines

879: IS
880:
881: CURSOR get_tax_line_number_csr IS
882: SELECT NVL(MAX(tax_line_number), 0) + 1
883: FROM zx_lines
884: WHERE application_id = p_offset_tax_line_rec.application_id
885: AND event_class_code = p_offset_tax_line_rec.event_class_code
886: AND entity_code = p_offset_tax_line_rec.entity_code
887: AND trx_id = p_offset_tax_line_rec.trx_id

Line 891: l_parent_tax_rate ZX_LINES.TAX_RATE%TYPE;

887: AND trx_id = p_offset_tax_line_rec.trx_id
888: AND trx_line_id = p_offset_tax_line_rec.trx_line_id
889: AND trx_level_type = p_offset_tax_line_rec.trx_level_type;
890:
891: l_parent_tax_rate ZX_LINES.TAX_RATE%TYPE;
892: l_old_offset_tax_line_id ZX_LINES.TAX_LINE_ID%TYPE;
893:
894: BEGIN
895: IF (g_level_statement >= g_current_runtime_level) THEN

Line 892: l_old_offset_tax_line_id ZX_LINES.TAX_LINE_ID%TYPE;

888: AND trx_line_id = p_offset_tax_line_rec.trx_line_id
889: AND trx_level_type = p_offset_tax_line_rec.trx_level_type;
890:
891: l_parent_tax_rate ZX_LINES.TAX_RATE%TYPE;
892: l_old_offset_tax_line_id ZX_LINES.TAX_LINE_ID%TYPE;
893:
894: BEGIN
895: IF (g_level_statement >= g_current_runtime_level) THEN
896: FND_LOG.STRING(g_level_statement,