DBA Data[Home] [Help]

APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on ZX_API_PUB

Line 133: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

129: );
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,

Line 150: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

146: );
147:
148: PROCEDURE determine_rounding_rule(
149: p_trx_line_index IN BINARY_INTEGER,
150: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
151: p_party_type_code IN VARCHAR2,
152: p_tax_regime_code IN VARCHAR2,
153: p_tax IN VARCHAR2,
154: p_jurisdiction_code IN VARCHAR2,

Line 359: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

355: p_sum_unrnd_tax_amt OUT NOCOPY NUMBER,
356: p_sum_rnd_tax_amt OUT NOCOPY NUMBER,
357: p_sum_rnd_tax_curr OUT NOCOPY NUMBER,
358: p_sum_rnd_funcl_curr OUT NOCOPY NUMBER,
359: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
360: p_return_status OUT NOCOPY VARCHAR2,
361: p_error_buffer OUT NOCOPY VARCHAR2
362: );
363:

Line 454: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

450: PROCEDURE convert_and_round_lin_lvl_curr(
451: p_conversion_rate IN NUMBER,
452: p_conversion_type IN VARCHAR2,
453: p_conversion_date IN DATE,
454: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
455: p_return_status OUT NOCOPY VARCHAR2,
456: p_error_buffer OUT NOCOPY VARCHAR2
457: );
458:

Line 463: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

459: PROCEDURE convert_and_round_hdr_lvl_curr(
460: p_conversion_rate IN NUMBER,
461: p_conversion_type IN VARCHAR2,
462: p_conversion_date IN DATE,
463: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
464: p_return_status OUT NOCOPY VARCHAR2,
465: p_error_buffer OUT NOCOPY VARCHAR2
466: );
467:

Line 470: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

466: );
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: );

Line 1095: ZX_API_PUB.add_msg(

1091: FND_MESSAGE.SET_TOKEN('TO_CURRENCY', p_to_currency);
1092: FND_MESSAGE.SET_TOKEN('CURRENCY_CONV_DATE', p_conversion_date);
1093: FND_MESSAGE.SET_TOKEN('TRX_CURRENCY_CONV_DATE',p_trx_conversion_date);
1094: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
1095: ZX_API_PUB.add_msg(
1096: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1097: ELSE
1098: FND_MSG_PUB.Add;
1099: END IF;

Line 1180: ZX_API_PUB.add_msg(

1176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1177: p_error_buffer := 'EURO code not found in FND_CURRENCIES';
1178: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1179: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
1180: ZX_API_PUB.add_msg(
1181: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1182: ELSE
1183: FND_MSG_PUB.Add;
1184: END IF;

Line 1425: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

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,
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,

Line 1659: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

1655: --
1656: --
1657: PROCEDURE determine_rounding_rule(
1658: p_trx_line_index IN BINARY_INTEGER,
1659: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1660: p_party_type_code IN VARCHAR2,
1661: p_tax_regime_code IN VARCHAR2,
1662: p_tax IN VARCHAR2,
1663: p_jurisdiction_code IN VARCHAR2,

Line 1892: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

1888: -- This procedure gets the rounding rule through party hierachy
1889: --
1890: PROCEDURE get_rounding_rule(
1891: p_trx_line_index IN BINARY_INTEGER,
1892: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_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,

Line 2034: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

2030: -- This procedure determines the party_tax_profile_id.
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: )

Line 2127: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

2123: -- and the rounding_rule based on rounding party hierarchy
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,

Line 2356: IF ZX_API_PUB.G_DATA_TRANSFER_MODE = 'TAB' THEN

2352:
2353: -- determine account, account_site, account_site_use information
2354: -- from first transaction line
2355: --
2356: IF ZX_API_PUB.G_DATA_TRANSFER_MODE = 'TAB' THEN
2357: OPEN get_acct_site_info_csr;
2358: FETCH get_acct_site_info_csr INTO
2359: l_ship_third_pty_acct_id, l_bill_third_pty_acct_id,
2360: l_ship_third_pty_acct_site_id, l_bill_third_pty_acct_site_id,

Line 2366: IF ( ZX_API_PUB.G_DATA_TRANSFER_MODE = 'WIN' ) THEN --Bug 5103375

2362: l_tax_determine_date;
2363: CLOSE get_acct_site_info_csr;
2364: ELSE
2365:
2366: IF ( ZX_API_PUB.G_DATA_TRANSFER_MODE = 'WIN' ) THEN --Bug 5103375
2367: OPEN get_lines_det_factors;
2368: FETCH get_lines_det_factors INTO
2369: l_ship_third_pty_acct_id, l_bill_third_pty_acct_id,
2370: l_ship_third_pty_acct_site_id, l_bill_third_pty_acct_site_id,

Line 5200: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

5196: p_sum_unrnd_tax_amt OUT NOCOPY NUMBER,
5197: p_sum_rnd_tax_amt OUT NOCOPY NUMBER,
5198: p_sum_rnd_tax_curr OUT NOCOPY NUMBER,
5199: p_sum_rnd_funcl_curr OUT NOCOPY NUMBER,
5200: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
5201: p_return_status OUT NOCOPY VARCHAR2,
5202: p_error_buffer OUT NOCOPY VARCHAR2
5203: )
5204: IS

Line 5509: ZX_API_PUB.add_msg(

5505:
5506: FND_MESSAGE.SET_NAME('ZX','ZX_QTY_TAX_NO_EXCHG_RATE_TYPE');
5507: FND_MESSAGE.SET_TOKEN('TAX_CURRENCY', p_tax_currency_code);
5508: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
5509: ZX_API_PUB.add_msg(
5510: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5511: ELSE
5512: FND_MSG_PUB.Add;
5513: END IF;

Line 5527: ZX_API_PUB.add_msg(

5523:
5524: FND_MESSAGE.SET_NAME('ZX','ZX_QTY_TAX_NO_EXCHG_RATE_TYPE');
5525: FND_MESSAGE.SET_TOKEN('TAX_CURRENCY', p_tax_currency_code);
5526: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_id IS NOT NULL THEN
5527: ZX_API_PUB.add_msg(
5528: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
5529: ELSE
5530: FND_MSG_PUB.Add;
5531: END IF;

Line 5729: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

5725: --
5726: -- Rewritten by lxzhang for bug fix 5417887
5727:
5728: PROCEDURE perform_rounding(
5729: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
5730: p_return_status OUT NOCOPY VARCHAR2,
5731: p_error_buffer OUT NOCOPY VARCHAR2
5732: )
5733: IS

Line 6643: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

6639: PROCEDURE convert_and_round_lin_lvl_curr(
6640: p_conversion_rate IN NUMBER,
6641: p_conversion_type IN VARCHAR2,
6642: p_conversion_date IN DATE,
6643: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
6644: p_return_status OUT NOCOPY VARCHAR2,
6645: p_error_buffer OUT NOCOPY VARCHAR2
6646: )
6647: IS

Line 6855: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

6851: PROCEDURE convert_and_round_hdr_lvl_curr(
6852: p_conversion_rate IN NUMBER,
6853: p_conversion_type IN VARCHAR2,
6854: p_conversion_date IN DATE,
6855: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
6856: p_return_status OUT NOCOPY VARCHAR2,
6857: p_error_buffer OUT NOCOPY VARCHAR2
6858: )
6859: IS

Line 7408: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

7404: PROCEDURE convert_and_round_curr(
7405: p_conversion_rate IN OUT NOCOPY NUMBER,
7406: p_conversion_type IN VARCHAR2,
7407: p_conversion_date IN DATE,
7408: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
7409: p_return_status OUT NOCOPY VARCHAR2,
7410: p_error_buffer OUT NOCOPY VARCHAR2
7411: )
7412: IS

Line 7513: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;

7509: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7510: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%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;