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_TRL_MANAGE_TAX_PKG dependencies on ZX_API_PUB

Line 124: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

120: | PROCEDURE Create_Detail_Lines : Insert tax lines into ZX_LINES table. |
121: * ===========================================================================*/
122:
123: PROCEDURE Create_Detail_Lines (
124: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
125: x_return_status OUT NOCOPY VARCHAR2
126: ) IS
127:
128: l_row_count NUMBER;

Line 130: l_msg_context_info_rec ZX_API_PUB.CONTEXT_INFO_REC_TYPE;

126: ) IS
127:
128: l_row_count NUMBER;
129: l_error_buffer VARCHAR2(100);
130: l_msg_context_info_rec ZX_API_PUB.CONTEXT_INFO_REC_TYPE;
131:
132:
133: BEGIN
134:

Line 821: ZX_API_PUB.add_msg(l_msg_context_info_rec);

817: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines',
818: 'Return Status = '||x_return_status);
819: END IF;
820: FND_MESSAGE.SET_NAME('ZX','ZX_TRL_RECORD_ALREADY_EXISTS');
821: ZX_API_PUB.add_msg(l_msg_context_info_rec);
822:
823: WHEN OTHERS THEN
824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
825: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 842: (p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

838: | Update_Freeze_Flag event |
839: * ===========================================================================*/
840:
841: PROCEDURE Summarization_For_Freeze_Event
842: (p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
843: x_return_status OUT NOCOPY VARCHAR2) IS
844:
845: l_error_buffer VARCHAR2(100);
846: l_use_null_summary_id_flag VARCHAR2(1);

Line 956: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

952: *============================================================================*/
953:
954: PROCEDURE Delete_Detail_Lines
955: (x_return_status OUT NOCOPY VARCHAR2,
956: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
957:
958: l_row_count NUMBER;
959: l_error_buffer VARCHAR2(100);
960:

Line 1126: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

1122: | ZX_LINES_SUMMARY for a given transaction details |
1123: * ===========================================================================*/
1124: PROCEDURE Delete_Summary_Lines
1125: (x_return_status OUT NOCOPY VARCHAR2,
1126: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
1127:
1128: l_row_count NUMBER;
1129: l_error_buffer VARCHAR2(100);
1130: l_TRX_ID number;

Line 1209: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

1205: * ===========================================================================*/
1206:
1207: PROCEDURE Delete_Loose_Tax_Distributions
1208: (x_return_status OUT NOCOPY VARCHAR2,
1209: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
1210:
1211: l_row_count NUMBER;
1212: l_error_buffer VARCHAR2(100);
1213:

Line 1308: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

1304: * ===========================================================================*/
1305:
1306: PROCEDURE Delete_Tax_Distributions(
1307: x_return_status OUT NOCOPY VARCHAR2,
1308: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
1309:
1310: l_row_count NUMBER;
1311: l_error_buffer VARCHAR2(100);
1312:

Line 1388: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

1384: | PROCEDURE Delete_Transaction: Deletes the tax lines in the repository |
1385: * ===========================================================================*/
1386: PROCEDURE Delete_Transaction
1387: (x_return_status OUT NOCOPY VARCHAR2,
1388: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
1389:
1390: l_api_version CONSTANT NUMBER := 1.0;
1391: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Transaction';
1392: l_row_count NUMBER;

Line 1395: l_msg_context_info_rec ZX_API_PUB.CONTEXT_INFO_REC_TYPE

1391: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Transaction';
1392: l_row_count NUMBER;
1393: l_error_buffer VARCHAR2(100);
1394:
1395: l_msg_context_info_rec ZX_API_PUB.CONTEXT_INFO_REC_TYPE
1396: ;
1397:
1398: -- This cursor will check if any tax lines has frozen distributions
1399: CURSOR check_frozen_child IS

Line 1453: ZX_API_PUB.add_msg(l_msg_context_info_rec);

1449: x_return_status := FND_API.G_RET_STS_ERROR;
1450:
1451:
1452: FND_MESSAGE.SET_NAME('ZX','ZX_CHILD_FROZEN');
1453: ZX_API_PUB.add_msg(l_msg_context_info_rec);
1454: RETURN;
1455: END IF;
1456: CLOSE check_frozen_child;
1457:

Line 1558: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

1554: * ===========================================================================*/
1555:
1556: PROCEDURE Cancel_Transaction
1557: (x_return_status OUT NOCOPY VARCHAR2,
1558: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
1559:
1560: l_row_count NUMBER;
1561: l_error_buffer VARCHAR2(100);
1562:

Line 2101: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

2097: * ===============================================================================*/
2098:
2099: PROCEDURE Purge_Transaction
2100: (x_return_status OUT NOCOPY VARCHAR2,
2101: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
2102:
2103: l_return_status VARCHAR2(1);
2104: l_error_buffer VARCHAR2(100);
2105:

Line 2184: p_transaction_line_rec IN ZX_API_PUB.TRANSACTION_LINE_REC_TYPE) IS

2180: * ===========================================================================*/
2181:
2182: PROCEDURE Mark_Detail_Tax_Lines_Delete
2183: (x_return_status OUT NOCOPY VARCHAR2,
2184: p_transaction_line_rec IN ZX_API_PUB.TRANSACTION_LINE_REC_TYPE) IS
2185:
2186: l_row_count NUMBER;
2187: l_freeze_dists_num NUMBER;
2188: l_error_buffer VARCHAR2(100);

Line 2720: -- ZX_API_PUB.add_msg(l_msg_context_info_rec);

2716: -- bug#4893261- move to wrapper since do not
2717: -- have event_class_rec here to set message index
2718: --
2719: -- FND_MESSAGE.SET_NAME('ZX','ZX_TRL_RECORD_ALREADY_EXISTS');
2720: -- ZX_API_PUB.add_msg(l_msg_context_info_rec);
2721:
2722:
2723: WHEN OTHERS THEN
2724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2745: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

2741: *============================================================================*/
2742:
2743: PROCEDURE Delete_Dist_Marked_For_Delete
2744: (x_return_status OUT NOCOPY VARCHAR2,
2745: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
2746:
2747: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Dist_Marked_For_Delete';
2748: l_error_buffer VARCHAR2(100);
2749: l_msg_context_info_rec ZX_API_PUB.CONTEXT_INFO_REC_TYPE

Line 2749: l_msg_context_info_rec ZX_API_PUB.CONTEXT_INFO_REC_TYPE

2745: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
2746:
2747: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Dist_Marked_For_Delete';
2748: l_error_buffer VARCHAR2(100);
2749: l_msg_context_info_rec ZX_API_PUB.CONTEXT_INFO_REC_TYPE
2750: ;
2751:
2752: BEGIN
2753:

Line 2796: ZX_API_PUB.add_msg(l_msg_context_info_rec);

2792: 'Return Status = '||x_return_status);
2793: END IF;
2794:
2795: FND_MESSAGE.SET_NAME('ZX','ZX_TRL_NULL_VALUES');
2796: ZX_API_PUB.add_msg(l_msg_context_info_rec);
2797:
2798: ELSE
2799: IF (g_level_procedure >= g_current_runtime_level ) THEN
2800: FND_LOG.STRING(g_level_procedure,

Line 2977: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

2973: *================================================================================*/
2974:
2975: PROCEDURE Update_TaxLine_Rec_Nrec_Amt
2976: (x_return_status OUT NOCOPY VARCHAR2,
2977: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
2978:
2979: l_error_buffer VARCHAR2(100);
2980:
2981: BEGIN

Line 3140: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

3136: *============================================================================*/
3137:
3138: PROCEDURE Update_Freeze_Flag
3139: (x_return_status OUT NOCOPY VARCHAR2,
3140: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
3141:
3142: l_return_status VARCHAR2(1);
3143: l_error_buffer VARCHAR2(100);
3144: l_use_null_summary_id_flag VARCHAR2(1);

Line 3336: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

3332: *============================================================================*/
3333:
3334: PROCEDURE Update_Item_Dist_Changed_Flag
3335: (x_return_status OUT NOCOPY VARCHAR2,
3336: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
3337:
3338: l_error_buffer VARCHAR2(100);
3339:
3340: BEGIN

Line 3399: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

3395: *============================================================================*/
3396:
3397: PROCEDURE discard_tax_only_lines
3398: (x_return_status OUT NOCOPY VARCHAR2,
3399: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS
3400:
3401: l_row_count NUMBER;
3402: l_error_buffer VARCHAR2(100);
3403:

Line 4039: (p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

4035: | |
4036: *============================================================================*/
4037:
4038: PROCEDURE Update_Exchange_Rate
4039: (p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4040: x_return_status OUT NOCOPY VARCHAR2) IS
4041:
4042: l_error_buffer VARCHAR2(100);
4043:

Line 4139: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

4135: | UPDATE case, if the same summarization criteria exists in |
4136: | zx_lines_summary |
4137: * ===========================================================================*/
4138: PROCEDURE update_exist_summary_line_id(
4139: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4140: x_return_status OUT NOCOPY VARCHAR2) IS
4141:
4142: l_row_count NUMBER;
4143: l_error_buffer VARCHAR2(100);

Line 4274: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

4270: * ===========================================================================*/
4271:
4272: PROCEDURE release_document_tax_hold(
4273: x_return_status OUT NOCOPY VARCHAR2,
4274: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4275: p_tax_hold_released_code IN ZX_API_PUB.VALIDATION_STATUS_TBL_TYPE
4276: ) IS
4277: l_error_buffer VARCHAR2(100);
4278:

Line 4275: p_tax_hold_released_code IN ZX_API_PUB.VALIDATION_STATUS_TBL_TYPE

4271:
4272: PROCEDURE release_document_tax_hold(
4273: x_return_status OUT NOCOPY VARCHAR2,
4274: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4275: p_tax_hold_released_code IN ZX_API_PUB.VALIDATION_STATUS_TBL_TYPE
4276: ) IS
4277: l_error_buffer VARCHAR2(100);
4278:
4279: l_tax_hold_release_value NUMBER;

Line 4397: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

4393: ------------------------------------------------------------------------------
4394: -- Bug 6456915 - associated_child_frozen_flag has been removed from grouping columns for summary tax lines
4395:
4396: PROCEDURE create_summary_lines_crt_evnt(
4397: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4398: x_return_status OUT NOCOPY VARCHAR2
4399: ) IS
4400:
4401: l_error_buffer VARCHAR2(100);

Line 5156: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

5152: -- retain_summ_tax_line_id_flag on event_class_rec of 'Y'
5153: ------------------------------------------------------------------------------
5154: -- Bug 6456915 - associated_child_frozen_flag has been removed from grouping columns for summary tax lines
5155: PROCEDURE create_summary_lines_upd_evnt(
5156: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
5157: x_return_status OUT NOCOPY VARCHAR2
5158: ) IS
5159:
5160: l_error_buffer VARCHAR2(100);