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_TAX_ROUNDING_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 84: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,

80:
81: PROCEDURE Get_Supplier_Site(
82: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
83: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
84: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
85: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
86:
87: p_return_status OUT NOCOPY VARCHAR2);
88:

Line 85: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,

81: PROCEDURE Get_Supplier_Site(
82: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
83: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
84: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
85: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
86:
87: p_return_status OUT NOCOPY VARCHAR2);
88:
89: PROCEDURE Get_Reg_Site_Uses (

Line 93: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,

89: PROCEDURE Get_Reg_Site_Uses (
90: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
91: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
92: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
93: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
94: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
95: p_return_status OUT NOCOPY VARCHAR2);
96:
97: PROCEDURE Get_Registration_Accts(

Line 94: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,

90: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
91: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
92: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
93: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
94: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
95: p_return_status OUT NOCOPY VARCHAR2);
96:
97: PROCEDURE Get_Registration_Accts(
98: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,

Line 99: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,

95: p_return_status OUT NOCOPY VARCHAR2);
96:
97: PROCEDURE Get_Registration_Accts(
98: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
99: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
100: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
101: p_return_status OUT NOCOPY VARCHAR2 );
102:
103: PROCEDURE Get_Registration_Party(

Line 100: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,

96:
97: PROCEDURE Get_Registration_Accts(
98: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
99: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
100: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
101: p_return_status OUT NOCOPY VARCHAR2 );
102:
103: PROCEDURE Get_Registration_Party(
104: p_party_tax_profile_id IN ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,

Line 104: p_party_tax_profile_id IN ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,

100: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
101: p_return_status OUT NOCOPY VARCHAR2 );
102:
103: PROCEDURE Get_Registration_Party(
104: p_party_tax_profile_id IN ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
105: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
106: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
107: p_return_status OUT NOCOPY VARCHAR2 );
108:

Line 105: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,

101: p_return_status OUT NOCOPY VARCHAR2 );
102:
103: PROCEDURE Get_Registration_Party(
104: p_party_tax_profile_id IN ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
105: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
106: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
107: p_return_status OUT NOCOPY VARCHAR2 );
108:
109:

Line 106: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,

102:
103: PROCEDURE Get_Registration_Party(
104: p_party_tax_profile_id IN ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
105: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
106: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
107: p_return_status OUT NOCOPY VARCHAR2 );
108:
109:
110: PROCEDURE get_rounding_level(

Line 112: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,

108:
109:
110: PROCEDURE get_rounding_level(
111:
112: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
113: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
114: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
115: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
116: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

Line 113: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,

109:
110: PROCEDURE get_rounding_level(
111:
112: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
113: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
114: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
115: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
116: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
117: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,

Line 118: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,

114: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
115: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
116: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
117: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
118: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
119: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
120: p_return_status OUT NOCOPY VARCHAR2,
121: p_error_buffer OUT NOCOPY VARCHAR2
122: );

Line 119: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,

115: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
116: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
117: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
118: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
119: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
120: p_return_status OUT NOCOPY VARCHAR2,
121: p_error_buffer OUT NOCOPY VARCHAR2
122: );
123:

Line 134: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,

130:
131: PROCEDURE determine_round_level_and_rule(
132: p_Party_Type_Code IN VARCHAR2,
133: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
134: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
135: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
136: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
137: p_return_status OUT NOCOPY VARCHAR2,
138: p_error_buffer OUT NOCOPY VARCHAR2,

Line 135: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,

131: PROCEDURE determine_round_level_and_rule(
132: p_Party_Type_Code IN VARCHAR2,
133: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
134: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
135: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
136: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
137: p_return_status OUT NOCOPY VARCHAR2,
138: p_error_buffer OUT NOCOPY VARCHAR2,
139: p_ship_third_pty_acct_id IN NUMBER,

Line 136: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,

132: p_Party_Type_Code IN VARCHAR2,
133: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
134: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
135: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
136: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
137: p_return_status OUT NOCOPY VARCHAR2,
138: p_error_buffer OUT NOCOPY VARCHAR2,
139: p_ship_third_pty_acct_id IN NUMBER,
140: p_bill_third_pty_acct_id IN NUMBER,

Line 156: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,

152: p_tax_regime_code IN VARCHAR2,
153: p_tax IN VARCHAR2,
154: p_jurisdiction_code IN VARCHAR2,
155: p_tax_determine_date IN DATE,
156: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
157: p_return_status OUT NOCOPY VARCHAR2,
158: p_error_buffer OUT NOCOPY VARCHAR2);
159:
160: PROCEDURE get_rounding_info(

Line 471: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,

467:
468: PROCEDURE get_round_level_ptp_id(
469: p_Party_Type_Code IN VARCHAR2,
470: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
471: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
472: p_return_status OUT NOCOPY VARCHAR2,
473: p_error_buffer OUT NOCOPY VARCHAR2
474: );
475:

Line 1421: -- rounding level code and rounding rule code from zx_party_tax_profile

1417: --
1418: -- DESCRIPTION
1419: --
1420: -- This procedure determines the party_tax_profile_id used to get the
1421: -- rounding level code and rounding rule code from zx_party_tax_profile
1422: --
1423: PROCEDURE determine_round_level_and_rule(
1424: p_Party_Type_Code IN VARCHAR2,
1425: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

Line 1426: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,

1422: --
1423: PROCEDURE determine_round_level_and_rule(
1424: p_Party_Type_Code IN VARCHAR2,
1425: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1426: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
1427: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
1428: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
1429: p_return_status OUT NOCOPY VARCHAR2,
1430: p_error_buffer OUT NOCOPY VARCHAR2,

Line 1427: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,

1423: PROCEDURE determine_round_level_and_rule(
1424: p_Party_Type_Code IN VARCHAR2,
1425: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1426: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
1427: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
1428: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
1429: p_return_status OUT NOCOPY VARCHAR2,
1430: p_error_buffer OUT NOCOPY VARCHAR2,
1431: p_ship_third_pty_acct_id IN NUMBER,

Line 1428: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,

1424: p_Party_Type_Code IN VARCHAR2,
1425: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1426: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
1427: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
1428: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
1429: p_return_status OUT NOCOPY VARCHAR2,
1430: p_error_buffer OUT NOCOPY VARCHAR2,
1431: p_ship_third_pty_acct_id IN NUMBER,
1432: p_bill_third_pty_acct_id IN NUMBER,

Line 1445: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

1441: l_rounding_level_basis VARCHAR(8);
1442: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
1443: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1444: l_account_id hz_cust_accounts.cust_account_id%TYPE;
1445: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1446: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1447: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
1448: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;
1449: l_ret_record_level VARCHAR2(30);

Line 1446: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

1442: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
1443: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1444: l_account_id hz_cust_accounts.cust_account_id%TYPE;
1445: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1446: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1447: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
1448: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;
1449: l_ret_record_level VARCHAR2(30);
1450:

Line 1654: -- rounding rule code from zx_party_tax_profile

1650: --
1651: -- DESCRIPTION
1652: --
1653: -- This procedure determines the party_tax_profile_id used to get the
1654: -- rounding rule code from zx_party_tax_profile
1655: --
1656: --
1657: PROCEDURE determine_rounding_rule(
1658: p_trx_line_index IN BINARY_INTEGER,

Line 1665: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,

1661: p_tax_regime_code IN VARCHAR2,
1662: p_tax IN VARCHAR2,
1663: p_jurisdiction_code IN VARCHAR2,
1664: p_tax_determine_date IN DATE,
1665: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
1666: p_return_status OUT NOCOPY VARCHAR2,
1667: p_error_buffer OUT NOCOPY VARCHAR2) IS
1668:
1669: l_tax_prof_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

Line 1669: l_tax_prof_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

1665: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
1666: p_return_status OUT NOCOPY VARCHAR2,
1667: p_error_buffer OUT NOCOPY VARCHAR2) IS
1668:
1669: l_tax_prof_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
1670: l_tax_prof_name VARCHAR(30);
1671: l_rounding_level_basis VARCHAR(8);
1672:
1673: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;

Line 1676: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

1672:
1673: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
1674: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1675: l_account_id hz_cust_accounts.cust_account_id%TYPE;
1676: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1677: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1678: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
1679: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;
1680: l_ret_record_level VARCHAR2(30);

Line 1677: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

1673: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
1674: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1675: l_account_id hz_cust_accounts.cust_account_id%TYPE;
1676: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1677: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1678: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
1679: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;
1680: l_ret_record_level VARCHAR2(30);
1681:

Line 1897: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,

1893: p_tax_regime_code IN VARCHAR2,
1894: p_tax IN VARCHAR2,
1895: p_jurisdiction_code IN VARCHAR2,
1896: p_tax_determine_date IN DATE,
1897: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
1898: p_return_status OUT NOCOPY VARCHAR2,
1899: p_error_buffer OUT NOCOPY VARCHAR2) IS
1900:
1901: BEGIN

Line 2035: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,

2031: --
2032: PROCEDURE get_round_level_ptp_id(
2033: p_Party_Type_Code IN VARCHAR2,
2034: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2035: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
2036: p_return_status OUT NOCOPY VARCHAR2,
2037: p_error_buffer OUT NOCOPY VARCHAR2
2038: )
2039: IS

Line 2128: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,

2124: --
2125:
2126: PROCEDURE get_rounding_level_and_rule(
2127: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2128: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
2129: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
2130: p_rnd_lvl_party_tax_prof_id
2131: OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE,
2132: p_rounding_lvl_party_type OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE,

Line 2129: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,

2125:
2126: PROCEDURE get_rounding_level_and_rule(
2127: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2128: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
2129: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
2130: p_rnd_lvl_party_tax_prof_id
2131: OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE,
2132: p_rounding_lvl_party_type OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE,
2133: p_return_status OUT NOCOPY VARCHAR2,

Line 2137: l_tax_prof_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

2133: p_return_status OUT NOCOPY VARCHAR2,
2134: p_error_buffer OUT NOCOPY VARCHAR2
2135: )
2136: IS
2137: l_tax_prof_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
2138: l_rounding_level_code ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;
2139: l_rounding_rule_code ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;
2140: l_rounding_level_found BOOLEAN;
2141: l_rounding_rule_found BOOLEAN;

Line 2138: l_rounding_level_code ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;

2134: p_error_buffer OUT NOCOPY VARCHAR2
2135: )
2136: IS
2137: l_tax_prof_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
2138: l_rounding_level_code ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;
2139: l_rounding_rule_code ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;
2140: l_rounding_level_found BOOLEAN;
2141: l_rounding_rule_found BOOLEAN;
2142:

Line 2139: l_rounding_rule_code ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;

2135: )
2136: IS
2137: l_tax_prof_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
2138: l_rounding_level_code ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;
2139: l_rounding_rule_code ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;
2140: l_rounding_level_found BOOLEAN;
2141: l_rounding_rule_found BOOLEAN;
2142:
2143:

Line 7515: l_rounding_level_code ZX_PARTY_TAX_PROFILE.Rounding_Level_Code%TYPE;

7511: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
7512: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;
7513: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;
7514: l_unrounded_tax_amt ZX_LINES.UNROUNDED_TAX_AMT%TYPE;
7515: l_rounding_level_code ZX_PARTY_TAX_PROFILE.Rounding_Level_Code%TYPE;
7516: l_rnd_lvl_party_tax_prof_id ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE;
7517: l_rounding_lvl_party_type ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE;
7518:
7519:

Line 7742: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,

7738:
7739: PROCEDURE Get_Supplier_Site(
7740: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
7741: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
7742: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
7743: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
7744:
7745: p_return_status OUT NOCOPY VARCHAR2)
7746: IS

Line 7743: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,

7739: PROCEDURE Get_Supplier_Site(
7740: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
7741: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
7742: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
7743: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
7744:
7745: p_return_status OUT NOCOPY VARCHAR2)
7746: IS
7747:

Line 7878: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,

7874: PROCEDURE Get_Reg_Site_Uses (
7875: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
7876: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
7877: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
7878: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
7879: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
7880: p_return_status OUT NOCOPY VARCHAR2)
7881: IS
7882: CURSOR c_site_uses (

Line 7879: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,

7875: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
7876: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
7877: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
7878: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
7879: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
7880: p_return_status OUT NOCOPY VARCHAR2)
7881: IS
7882: CURSOR c_site_uses (
7883: c_site_use_id HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,

Line 8004: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,

8000: -- DESCRIPTION
8001:
8002: PROCEDURE Get_Registration_Accts(
8003: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8004: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8005: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8006: p_return_status OUT NOCOPY VARCHAR2 )
8007:
8008: IS

Line 8005: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,

8001:
8002: PROCEDURE Get_Registration_Accts(
8003: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8004: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8005: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8006: p_return_status OUT NOCOPY VARCHAR2 )
8007:
8008: IS
8009:

Line 8110: p_party_tax_profile_id IN ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,

8106: --
8107: -- DESCRIPTION
8108:
8109: PROCEDURE Get_Registration_Party(
8110: p_party_tax_profile_id IN ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
8111: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8112: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8113: p_return_status OUT NOCOPY VARCHAR2 )
8114: IS

Line 8111: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,

8107: -- DESCRIPTION
8108:
8109: PROCEDURE Get_Registration_Party(
8110: p_party_tax_profile_id IN ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
8111: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8112: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8113: p_return_status OUT NOCOPY VARCHAR2 )
8114: IS
8115:

Line 8112: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,

8108:
8109: PROCEDURE Get_Registration_Party(
8110: p_party_tax_profile_id IN ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
8111: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8112: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8113: p_return_status OUT NOCOPY VARCHAR2 )
8114: IS
8115:
8116: l_tbl_index binary_integer;

Line 8183: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,

8179: --
8180:
8181: PROCEDURE get_rounding_level(
8182:
8183: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
8184: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
8185: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
8186: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8187: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

Line 8184: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,

8180:
8181: PROCEDURE get_rounding_level(
8182:
8183: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
8184: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
8185: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
8186: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8187: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
8188: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,

Line 8189: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,

8185: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
8186: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8187: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
8188: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
8189: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8190: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8191: p_return_status OUT NOCOPY VARCHAR2,
8192: p_error_buffer OUT NOCOPY VARCHAR2
8193: )

Line 8190: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,

8186: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8187: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
8188: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
8189: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8190: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8191: p_return_status OUT NOCOPY VARCHAR2,
8192: p_error_buffer OUT NOCOPY VARCHAR2
8193: )
8194: IS