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_DETAIL_TAX_LINES_GT

Line 9: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,

5: p_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,
6: p_tax IN ZX_TAXES_B.TAX%TYPE,
7: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
8: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%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,

Line 18: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE);

14: p_return_status OUT NOCOPY VARCHAR2,
15: p_error_buffer OUT NOCOPY VARCHAR2);
16:
17: PROCEDURE set_null_columns(
18: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE);
19:
20: PROCEDURE set_flg_columns(
21: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE);
22:

Line 21: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE);

17: PROCEDURE set_null_columns(
18: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE);
19:
20: PROCEDURE set_flg_columns(
21: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE);
22:
23: PROCEDURE set_amt_columns(
24: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,
25: p_parent_tax_rate IN VARCHAR2,

Line 24: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,

20: PROCEDURE set_flg_columns(
21: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE);
22:
23: PROCEDURE set_amt_columns(
24: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,
25: p_parent_tax_rate IN VARCHAR2,
26: p_initial_tax_rate IN NUMBER,
27: p_return_status OUT NOCOPY VARCHAR2,
28: p_error_buffer OUT NOCOPY VARCHAR2);

Line 35: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,

31: PROCEDURE get_tax_status_id(
32: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
33: p_tax IN ZX_TAXES_B.TAX%TYPE,
34: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
35: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
36: p_tax_status_id OUT NOCOPY ZX_STATUS_B.TAX_STATUS_ID%TYPE,
37: p_return_status OUT NOCOPY VARCHAR2,
38: p_error_buffer OUT NOCOPY VARCHAR2);
39:

Line 43: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,

39:
40: PROCEDURE get_tax_id(
41: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
42: p_tax IN ZX_TAXES_B.TAX%TYPE,
43: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
44: p_tax_id OUT NOCOPY ZX_TAXES_B.TAX_ID%TYPE,
45: p_return_status OUT NOCOPY VARCHAR2,
46: p_error_buffer OUT NOCOPY VARCHAR2);
47:

Line 50: p_offset_tax_line_rec IN ZX_DETAIL_TAX_LINES_GT%ROWTYPE,

46: p_error_buffer OUT NOCOPY VARCHAR2);
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:

Line 56: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,

52: p_return_status OUT NOCOPY VARCHAR2,
53: p_error_buffer OUT NOCOPY VARCHAR2);
54:
55: PROCEDURE create_offset_tax_line(
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,

Line 82: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,

78: --
79: -- This procedure is the entry point to offset tax determination process
80:
81: PROCEDURE PROCESS_OFFSET_TAX(
82: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,
83: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
84: p_return_status OUT NOCOPY VARCHAR2,
85: p_error_buffer OUT NOCOPY VARCHAR2)
86:

Line 253: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,

249: p_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,
250: p_tax IN ZX_TAXES_B.TAX%TYPE,
251: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
252: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%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,

Line 273: c_tax_determine_date ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE)

269: (c_tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
270: c_tax ZX_TAXES_B.TAX%TYPE,
271: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
272: c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
273: c_tax_determine_date ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE)
274: IS
275:
276: SELECT tax_rate_id,
277: Rate_Type_Code,

Line 374: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE)

370: -- DESCRIPTION
371: -- This procedure sets the values of columns to NULL
372:
373: PROCEDURE set_null_columns(
374: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE)
375: IS
376: BEGIN
377: IF (g_level_statement >= g_current_runtime_level) THEN
378: FND_LOG.STRING(g_level_statement,

Line 441: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE)

437: -- DESCRIPTION
438: -- This procedure initializes the value of flag columns
439:
440: PROCEDURE set_flg_columns(
441: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE)
442: IS
443: BEGIN
444: IF (g_level_statement >= g_current_runtime_level) THEN
445: FND_LOG.STRING(g_level_statement,

Line 490: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,

486: -- DESCRIPTION
487: -- This procedure populates tax amount related columns
488:
489: PROCEDURE set_amt_columns(
490: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,
491: p_parent_tax_rate IN VARCHAR2,
492: p_initial_tax_rate IN NUMBER,
493: p_return_status OUT NOCOPY VARCHAR2,
494: p_error_buffer OUT NOCOPY VARCHAR2

Line 673: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,

669: PROCEDURE get_tax_status_id(
670: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
671: p_tax IN ZX_TAXES_B.TAX%TYPE,
672: p_tax_status_code IN ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
673: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
674: p_tax_status_id OUT NOCOPY ZX_STATUS_B.TAX_STATUS_ID%TYPE,
675: p_return_status OUT NOCOPY VARCHAR2,
676: p_error_buffer OUT NOCOPY VARCHAR2)
677:

Line 731: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,

727: --
728: PROCEDURE get_tax_id(
729: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
730: p_tax IN ZX_TAXES_B.TAX%TYPE,
731: p_tax_determine_date IN ZX_DETAIL_TAX_LINES_GT.TAX_DETERMINE_DATE%TYPE,
732: p_tax_id OUT NOCOPY ZX_TAXES_B.TAX_ID%TYPE,
733: p_return_status OUT NOCOPY VARCHAR2,
734: p_error_buffer OUT NOCOPY VARCHAR2)
735:

Line 792: p_offset_tax_line_rec IN ZX_DETAIL_TAX_LINES_GT%ROWTYPE,

788: -- it links to
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

Line 869: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE,

865: -- The procedure is used to create an offset tax line for a main tax line
866: -- which has offset_flag = 'Y'
867:
868: PROCEDURE create_offset_tax_line(
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,