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 253: p_tax_rate OUT NOCOPY ZX_LINES.TAX_RATE%TYPE,

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

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

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

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

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

Line 800: FROM ZX_LINES

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

Line 871: p_tax_rate IN ZX_LINES.TAX_RATE%TYPE,

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

Line 872: p_initial_tax_rate IN ZX_LINES.TAX_RATE%TYPE,

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

Line 881: FROM zx_lines

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

Line 889: l_parent_tax_rate ZX_LINES.TAX_RATE%TYPE;

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

Line 890: l_old_offset_tax_line_id ZX_LINES.TAX_LINE_ID%TYPE;

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