[Home] [Help]
2: /* $Header: zxditaxlndetpkgb.pls 120.114.12020000.3 2012/07/30 08:34:28 smuthusa noship $ */
3:
4: -- private procedures
5: PROCEDURE create_offset_tax_lines(
6: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
7: p_return_status OUT NOCOPY VARCHAR2,
8: p_error_buffer OUT NOCOPY VARCHAR2 );
9:
10: PROCEDURE populate_tax_line_numbers(
13: x_error_buffer OUT NOCOPY VARCHAR2
14: );
15:
16: PROCEDURE process_reference_tax_lines(
17: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_error_buffer OUT NOCOPY VARCHAR2
20: );
21:
19: x_error_buffer OUT NOCOPY VARCHAR2
20: );
21:
22: PROCEDURE process_copy_and_create (
23: p_event_class_rec IN zx_api_pub.event_class_rec_type,
24: x_return_status OUT NOCOPY VARCHAR2,
25: x_error_buffer OUT NOCOPY VARCHAR2);
26:
27: PROCEDURE adjust_overapplication(
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_error_buffer OUT NOCOPY VARCHAR2);
31:
32: PROCEDURE process_unchanged_trx_lines(
33: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_error_buffer OUT NOCOPY VARCHAR2);
36:
37: PROCEDURE set_acct_source_tax_rate_id(
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_error_buffer OUT NOCOPY VARCHAR2);
36:
37: PROCEDURE set_acct_source_tax_rate_id(
38: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
39: x_return_status OUT NOCOPY VARCHAR2,
40: x_error_buffer OUT NOCOPY VARCHAR2);
41:
42: g_current_runtime_level NUMBER;
54: -- This procedure is the tail end wrap service for tax rounding, tax
55: -- columns population and offset tax lines determination
56:
57: PROCEDURE determine_tax_lines(
58: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
59: p_return_status OUT NOCOPY VARCHAR2,
60: p_error_buffer OUT NOCOPY VARCHAR2
61: )
62: IS
402: -- DESCRIPTION
403: -- This procedure creates offset tax lines after rounding has been done
404: --
405: PROCEDURE create_offset_tax_lines(
406: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
407: p_return_status OUT NOCOPY VARCHAR2,
408: p_error_buffer OUT NOCOPY VARCHAR2 )
409: IS
410: l_tax_line_rec ZX_DETAIL_TAX_LINES_GT%ROWTYPE;
1207: -- Ling Zhang 26-Jul-04 Created for bug fix 3391299
1208: -- Ling Zhang 17-Aug-06 Rewritten for bug fix 5417887
1209:
1210: PROCEDURE populate_tax_line_numbers(
1211: -- p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1212: x_return_status OUT NOCOPY VARCHAR2,
1213: x_error_buffer OUT NOCOPY VARCHAR2
1214: ) IS
1215:
1384: -- Ling Zhang Aug-06-2004 Created for bug fix 3391186
1385: --
1386:
1387: PROCEDURE process_reference_tax_lines(
1388: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
1389: x_return_status OUT NOCOPY VARCHAR2,
1390: x_error_buffer OUT NOCOPY VARCHAR2)
1391: IS
1392: l_user_id NUMBER;
2878: -- Ling Zhang Aug-08-2005 Bug Fix 4542315
2879: --
2880:
2881: PROCEDURE process_copy_and_create(
2882: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2883: x_return_status OUT NOCOPY VARCHAR2,
2884: x_error_buffer OUT NOCOPY VARCHAR2) IS
2885:
2886: l_user_id NUMBER;
4179: -- Ling Zhang Feb-23-2005 Created for Bug Fix 4151574
4180: --
4181:
4182: PROCEDURE adjust_overapplication(
4183: -- p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4184: x_return_status OUT NOCOPY VARCHAR2,
4185: x_error_buffer OUT NOCOPY VARCHAR2)
4186: IS
4187: -- bug 14102214 using forceful hint ZX_LINES_N1 on cm_tax table
4414: -- Ling Zhang Apr-20-2005 Created for Bug Fix 4313177
4415: --
4416:
4417: PROCEDURE process_unchanged_trx_lines(
4418: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4419: x_return_status OUT NOCOPY VARCHAR2,
4420: x_error_buffer OUT NOCOPY VARCHAR2)
4421: IS
4422:
4513: -- to the same transaction line
4514: --
4515:
4516: PROCEDURE set_acct_source_tax_rate_id(
4517: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
4518: x_return_status OUT NOCOPY VARCHAR2,
4519: x_error_buffer OUT NOCOPY VARCHAR2) IS
4520:
4521: l_row_count NUMBER;