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 479: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,

475:
476: PROCEDURE get_round_level_ptp_id(
477: p_Party_Type_Code IN VARCHAR2,
478: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
479: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
480: p_return_status OUT NOCOPY VARCHAR2,
481: p_error_buffer OUT NOCOPY VARCHAR2
482: );
483:

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

1425: --
1426: -- DESCRIPTION
1427: --
1428: -- This procedure determines the party_tax_profile_id used to get the
1429: -- rounding level code and rounding rule code from zx_party_tax_profile
1430: --
1431: PROCEDURE determine_round_level_and_rule(
1432: p_Party_Type_Code IN VARCHAR2,
1433: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

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

1430: --
1431: PROCEDURE determine_round_level_and_rule(
1432: p_Party_Type_Code IN VARCHAR2,
1433: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1434: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
1435: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
1436: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
1437: p_return_status OUT NOCOPY VARCHAR2,
1438: p_error_buffer OUT NOCOPY VARCHAR2,

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

1431: PROCEDURE determine_round_level_and_rule(
1432: p_Party_Type_Code IN VARCHAR2,
1433: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1434: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
1435: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
1436: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
1437: p_return_status OUT NOCOPY VARCHAR2,
1438: p_error_buffer OUT NOCOPY VARCHAR2,
1439: p_ship_third_pty_acct_id IN NUMBER,

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

1432: p_Party_Type_Code IN VARCHAR2,
1433: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1434: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
1435: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
1436: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
1437: p_return_status OUT NOCOPY VARCHAR2,
1438: p_error_buffer OUT NOCOPY VARCHAR2,
1439: p_ship_third_pty_acct_id IN NUMBER,
1440: p_bill_third_pty_acct_id IN NUMBER,

Line 1453: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

1449: l_rounding_level_basis VARCHAR(8);
1450: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
1451: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1452: l_account_id hz_cust_accounts.cust_account_id%TYPE;
1453: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1454: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1455: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
1456: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;
1457: l_ret_record_level VARCHAR2(30);

Line 1454: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

1450: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
1451: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1452: l_account_id hz_cust_accounts.cust_account_id%TYPE;
1453: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1454: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1455: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
1456: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;
1457: l_ret_record_level VARCHAR2(30);
1458:

Line 1662: -- rounding rule code from zx_party_tax_profile

1658: --
1659: -- DESCRIPTION
1660: --
1661: -- This procedure determines the party_tax_profile_id used to get the
1662: -- rounding rule code from zx_party_tax_profile
1663: --
1664: --
1665: PROCEDURE determine_rounding_rule(
1666: p_trx_line_index IN BINARY_INTEGER,

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

1669: p_tax_regime_code IN VARCHAR2,
1670: p_tax IN VARCHAR2,
1671: p_jurisdiction_code IN VARCHAR2,
1672: p_tax_determine_date IN DATE,
1673: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
1674: p_return_status OUT NOCOPY VARCHAR2,
1675: p_error_buffer OUT NOCOPY VARCHAR2) IS
1676:
1677: l_tax_prof_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

Line 1677: l_tax_prof_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

1673: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
1674: p_return_status OUT NOCOPY VARCHAR2,
1675: p_error_buffer OUT NOCOPY VARCHAR2) IS
1676:
1677: l_tax_prof_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
1678: l_tax_prof_name VARCHAR(30);
1679: l_rounding_level_basis VARCHAR(8);
1680:
1681: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;

Line 1684: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

1680:
1681: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
1682: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1683: l_account_id hz_cust_accounts.cust_account_id%TYPE;
1684: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1685: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1686: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
1687: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;
1688: l_ret_record_level VARCHAR2(30);

Line 1685: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;

1681: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
1682: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1683: l_account_id hz_cust_accounts.cust_account_id%TYPE;
1684: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1685: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1686: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
1687: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;
1688: l_ret_record_level VARCHAR2(30);
1689:

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

1901: p_tax_regime_code IN VARCHAR2,
1902: p_tax IN VARCHAR2,
1903: p_jurisdiction_code IN VARCHAR2,
1904: p_tax_determine_date IN DATE,
1905: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
1906: p_return_status OUT NOCOPY VARCHAR2,
1907: p_error_buffer OUT NOCOPY VARCHAR2) IS
1908:
1909: BEGIN

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

2039: --
2040: PROCEDURE get_round_level_ptp_id(
2041: p_Party_Type_Code IN VARCHAR2,
2042: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2043: p_tax_prof_id OUT NOCOPY ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
2044: p_return_status OUT NOCOPY VARCHAR2,
2045: p_error_buffer OUT NOCOPY VARCHAR2
2046: )
2047: IS

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

2132: --
2133:
2134: PROCEDURE get_rounding_level_and_rule(
2135: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2136: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
2137: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
2138: p_rnd_lvl_party_tax_prof_id
2139: OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE,
2140: p_rounding_lvl_party_type OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE,

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

2133:
2134: PROCEDURE get_rounding_level_and_rule(
2135: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2136: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
2137: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
2138: p_rnd_lvl_party_tax_prof_id
2139: OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE,
2140: p_rounding_lvl_party_type OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE,
2141: p_return_status OUT NOCOPY VARCHAR2,

Line 2145: l_tax_prof_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

2141: p_return_status OUT NOCOPY VARCHAR2,
2142: p_error_buffer OUT NOCOPY VARCHAR2
2143: )
2144: IS
2145: l_tax_prof_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
2146: l_rounding_level_code ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;
2147: l_rounding_rule_code ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;
2148: l_rounding_level_found BOOLEAN;
2149: l_rounding_rule_found BOOLEAN;

Line 2146: l_rounding_level_code ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;

2142: p_error_buffer OUT NOCOPY VARCHAR2
2143: )
2144: IS
2145: l_tax_prof_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
2146: l_rounding_level_code ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;
2147: l_rounding_rule_code ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;
2148: l_rounding_level_found BOOLEAN;
2149: l_rounding_rule_found BOOLEAN;
2150:

Line 2147: l_rounding_rule_code ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;

2143: )
2144: IS
2145: l_tax_prof_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
2146: l_rounding_level_code ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE;
2147: l_rounding_rule_code ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE;
2148: l_rounding_level_found BOOLEAN;
2149: l_rounding_rule_found BOOLEAN;
2150:
2151:

Line 7774: l_rounding_level_code ZX_PARTY_TAX_PROFILE.Rounding_Level_Code%TYPE;

7770: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
7771: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;
7772: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;
7773: l_unrounded_tax_amt ZX_LINES.UNROUNDED_TAX_AMT%TYPE;
7774: l_rounding_level_code ZX_PARTY_TAX_PROFILE.Rounding_Level_Code%TYPE;
7775: l_rnd_lvl_party_tax_prof_id ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE;
7776: l_rounding_lvl_party_type ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE;
7777:
7778:

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

7997:
7998: PROCEDURE Get_Supplier_Site(
7999: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8000: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
8001: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8002: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8003:
8004: p_return_status OUT NOCOPY VARCHAR2)
8005: IS

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

7998: PROCEDURE Get_Supplier_Site(
7999: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8000: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
8001: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8002: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8003:
8004: p_return_status OUT NOCOPY VARCHAR2)
8005: IS
8006:

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

8141: PROCEDURE Get_Reg_Site_Uses (
8142: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8143: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
8144: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
8145: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8146: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8147: p_return_status OUT NOCOPY VARCHAR2)
8148: IS
8149: CURSOR c_site_uses (

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

8142: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8143: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
8144: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
8145: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8146: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8147: p_return_status OUT NOCOPY VARCHAR2)
8148: IS
8149: CURSOR c_site_uses (
8150: c_site_use_id HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,

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

8267: -- DESCRIPTION
8268:
8269: PROCEDURE Get_Registration_Accts(
8270: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8271: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8272: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8273: p_return_status OUT NOCOPY VARCHAR2 )
8274:
8275: IS

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

8268:
8269: PROCEDURE Get_Registration_Accts(
8270: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8271: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8272: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8273: p_return_status OUT NOCOPY VARCHAR2 )
8274:
8275: IS
8276:

Line 8377: p_party_tax_profile_id IN ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,

8373: --
8374: -- DESCRIPTION
8375:
8376: PROCEDURE Get_Registration_Party(
8377: p_party_tax_profile_id IN ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
8378: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8379: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8380: p_return_status OUT NOCOPY VARCHAR2 )
8381: IS

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

8374: -- DESCRIPTION
8375:
8376: PROCEDURE Get_Registration_Party(
8377: p_party_tax_profile_id IN ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
8378: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8379: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8380: p_return_status OUT NOCOPY VARCHAR2 )
8381: IS
8382:

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

8375:
8376: PROCEDURE Get_Registration_Party(
8377: p_party_tax_profile_id IN ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE,
8378: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8379: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8380: p_return_status OUT NOCOPY VARCHAR2 )
8381: IS
8382:
8383: l_tbl_index binary_integer;

Line 8450: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,

8446: --
8447:
8448: PROCEDURE get_rounding_level(
8449:
8450: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
8451: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
8452: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
8453: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8454: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,

Line 8451: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,

8447:
8448: PROCEDURE get_rounding_level(
8449:
8450: p_parent_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
8451: p_site_ptp_id IN zx_party_tax_profile.party_tax_profile_id%TYPE,
8452: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
8453: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8454: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
8455: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,

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

8452: p_account_Type_Code IN zx_registrations.account_type_code%TYPE,
8453: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8454: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
8455: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
8456: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8457: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8458: p_return_status OUT NOCOPY VARCHAR2,
8459: p_error_buffer OUT NOCOPY VARCHAR2
8460: )

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

8453: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
8454: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
8455: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
8456: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
8457: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
8458: p_return_status OUT NOCOPY VARCHAR2,
8459: p_error_buffer OUT NOCOPY VARCHAR2
8460: )
8461: IS