DBA Data[Home] [Help]

APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on ZX_API_PUB

Line 47: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

43: VAR_30_DUMMY CONSTANT VARCHAR2(30) := '@@@###$$$***===';
44: DATE_DUMMY CONSTANT DATE := TO_DATE('01-01-1951', 'DD-MM-YYYY');
45:
46: PROCEDURE fetch_tax_lines (
47: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
48: p_tax_line_tbl OUT NOCOPY tax_line_tbl_type,
49: x_return_status OUT NOCOPY VARCHAR2);
50:
51: PROCEDURE fetch_tax_distributions(

Line 52: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

48: p_tax_line_tbl OUT NOCOPY tax_line_tbl_type,
49: x_return_status OUT NOCOPY VARCHAR2);
50:
51: PROCEDURE fetch_tax_distributions(
52: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
53: p_tax_line_id IN NUMBER,
54: p_trx_line_dist_id IN NUMBER,
55: p_rec_nrec_dist_tbl IN OUT NOCOPY rec_nrec_dist_tbl_type,
56: p_rec_nrec_dist_begin_index IN NUMBER,

Line 80: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

76: p_rec_nrec_dist_tbl IN OUT NOCOPY REC_NREC_DIST_TBL_TYPE,
77: x_return_status OUT NOCOPY VARCHAR2);
78:
79: PROCEDURE delete_unnecessary_tax_dists(
80: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
81: x_return_status OUT NOCOPY VARCHAR2);
82:
83: PROCEDURE get_tax_jurisdiction_id(
84: p_tax_line_id IN NUMBER,

Line 90: p_event_class_rec IN OUT NOCOPY ZX_API_PUB.event_class_rec_type,

86: p_tax_jurisdiction_id OUT NOCOPY NUMBER,
87: x_return_status OUT NOCOPY VARCHAR2);
88:
89: PROCEDURE init_mand_columns(
90: p_event_class_rec IN OUT NOCOPY ZX_API_PUB.event_class_rec_type,
91: x_return_status OUT NOCOPY VARCHAR2);
92:
93: g_current_runtime_level NUMBER;
94: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 121: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,

117: | |
118: * ===========================================================================*/
119:
120: PROCEDURE determine_recovery(
121: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
122: x_return_status OUT NOCOPY VARCHAR2) IS
123:
124: CURSOR get_item_dist_csr(
125: c_trx_line_id zx_lines.trx_line_id%TYPE,

Line 1077: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

1073: | |
1074: * ===========================================================================*/
1075:
1076: PROCEDURE OVERRIDE_RECOVERY(
1077: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1078: x_return_status OUT NOCOPY VARCHAR2) IS
1079:
1080: l_tax_line_id NUMBER;
1081: l_rec_nrec_dist_tbl rec_nrec_dist_tbl_type;

Line 1545: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

1541: | |
1542: * ======================================================================*/
1543:
1544: PROCEDURE VALIDATE_DOCUMENT_FOR_TAX(
1545: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1546: p_transaction_rec IN ZX_API_PUB.transaction_rec_type,
1547: x_hold_status OUT NOCOPY ZX_API_PUB.HOLD_CODES_TBL_TYPE,
1548: x_validate_status OUT NOCOPY VARCHAR2, -- bug fix 3541452
1549: x_return_status OUT NOCOPY VARCHAR2) IS

Line 1546: p_transaction_rec IN ZX_API_PUB.transaction_rec_type,

1542: * ======================================================================*/
1543:
1544: PROCEDURE VALIDATE_DOCUMENT_FOR_TAX(
1545: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1546: p_transaction_rec IN ZX_API_PUB.transaction_rec_type,
1547: x_hold_status OUT NOCOPY ZX_API_PUB.HOLD_CODES_TBL_TYPE,
1548: x_validate_status OUT NOCOPY VARCHAR2, -- bug fix 3541452
1549: x_return_status OUT NOCOPY VARCHAR2) IS
1550:

Line 1547: x_hold_status OUT NOCOPY ZX_API_PUB.HOLD_CODES_TBL_TYPE,

1543:
1544: PROCEDURE VALIDATE_DOCUMENT_FOR_TAX(
1545: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1546: p_transaction_rec IN ZX_API_PUB.transaction_rec_type,
1547: x_hold_status OUT NOCOPY ZX_API_PUB.HOLD_CODES_TBL_TYPE,
1548: x_validate_status OUT NOCOPY VARCHAR2, -- bug fix 3541452
1549: x_return_status OUT NOCOPY VARCHAR2) IS
1550:
1551: CURSOR get_hold_status_csr IS

Line 3908: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

3904: | |
3905: * ======================================================================*/
3906:
3907: PROCEDURE fetch_tax_lines (
3908: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
3909: p_tax_line_tbl OUT NOCOPY tax_line_tbl_type,
3910: x_return_status OUT NOCOPY VARCHAR2) IS
3911:
3912: detail_ctr number;

Line 4054: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

4050: | |
4051: * ======================================================================*/
4052:
4053: PROCEDURE fetch_tax_distributions(
4054: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4055: p_tax_line_id IN NUMBER,
4056: p_trx_line_dist_id IN NUMBER,
4057: p_rec_nrec_dist_tbl IN OUT NOCOPY rec_nrec_dist_tbl_type,
4058: p_rec_nrec_dist_begin_index IN NUMBER,

Line 4675: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

4671: END populate_mandatory_columns;
4672:
4673:
4674: PROCEDURE update_exchange_rate (
4675: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4676: p_ledger_id IN NUMBER,
4677: p_currency_conversion_rate IN NUMBER,
4678: p_currency_conversion_type IN VARCHAR2,
4679: p_currency_conversion_date IN DATE,

Line 5738: p_pa_item_info_tbl IN OUT NOCOPY ZX_API_PUB.pa_item_info_tbl_type,

5734: | HISTORY: |
5735: | Apr-05-2005 Created for bug fix 4220119 |
5736: * =======================================================================*/
5737: PROCEDURE is_recoverability_affected(
5738: p_pa_item_info_tbl IN OUT NOCOPY ZX_API_PUB.pa_item_info_tbl_type,
5739: x_return_status OUT NOCOPY VARCHAR2) IS
5740:
5741: CURSOR get_tax_dists_csr(
5742: c_application_id zx_rec_nrec_dist.application_id%TYPE,

Line 6164: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

6160: | account_ccid |
6161: | |
6162: * ============================================================================*/
6163: PROCEDURE delete_unnecessary_tax_dists(
6164: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
6165: x_return_status OUT NOCOPY VARCHAR2) IS
6166:
6167: TYPE NUMERIC_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6168:

Line 6354: p_tax_dist_id_tbl IN ZX_API_PUB.tax_dist_id_tbl_type,

6350:
6351: END delete_unnecessary_tax_dists;
6352:
6353: PROCEDURE update_posting_flag(
6354: p_tax_dist_id_tbl IN ZX_API_PUB.tax_dist_id_tbl_type,
6355: x_return_status OUT NOCOPY VARCHAR2) IS
6356:
6357: l_error_buffer VARCHAR2(200);
6358:

Line 6466: l_event_class_rec ZX_API_PUB.event_class_rec_type;

6462: FROM hz_geography_types_b gt
6463: WHERE gt.geography_type = c_override_geo_type)
6464: ORDER BY 2 desc;
6465:
6466: l_event_class_rec ZX_API_PUB.event_class_rec_type;
6467: l_content_owner_id NUMBER;
6468: l_tax_id NUMBER;
6469: l_acc_src_tax_rate_id NUMBER;
6470: l_tax_rate_id NUMBER;

Line 6831: p_event_class_rec IN OUT NOCOPY ZX_API_PUB.event_class_rec_type,

6827:
6828: END get_tax_jurisdiction_id;
6829:
6830: PROCEDURE init_mand_columns(
6831: p_event_class_rec IN OUT NOCOPY ZX_API_PUB.event_class_rec_type,
6832: x_return_status OUT NOCOPY VARCHAR2) IS
6833:
6834: l_error_buffer VARCHAR2(200);
6835: BEGIN

Line 6866: IF ZX_API_PUB.G_DATA_TRANSFER_MODE <> 'TAB' THEN

6862: ZX_SECURITY.G_ICX_SESSION_ID := null;
6863: -- dbms_session.set_context('my_ctx','SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
6864: ZX_SECURITY.name_value('SESSIONID',to_char(ZX_SECURITY.G_ICX_SESSION_ID));
6865: END IF;
6866: IF ZX_API_PUB.G_DATA_TRANSFER_MODE <> 'TAB' THEN
6867: ZX_VALID_INIT_PARAMS_PKG.calculate_tax(x_return_status => x_return_status,
6868: p_event_class_rec => p_event_class_rec);
6869:
6870: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN