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

Line 2181: p_transaction_rec IN OUT NOCOPY zx_api_pub.transaction_rec_type

2177: | PROCEDURE insert_transaction_rec : Populate the row in transaction_rec |
2178: * ============================================================================*/
2179:
2180: PROCEDURE insert_transaction_rec (
2181: p_transaction_rec IN OUT NOCOPY zx_api_pub.transaction_rec_type
2182: )
2183: IS
2184: BEGIN
2185:

Line 2201: p_transaction_rec IN OUT NOCOPY zx_api_pub.transaction_rec_type,

2197: | PROCEDURE insert_row_transaction_rec : Populate the row in transaction_rec |
2198: * ============================================================================*/
2199:
2200: PROCEDURE insert_row_transaction_rec (
2201: p_transaction_rec IN OUT NOCOPY zx_api_pub.transaction_rec_type,
2202: p_initial_row IN NUMBER
2203: )
2204: IS
2205: BEGIN

Line 2574: x_sync_trx_rec OUT NOCOPY zx_api_pub.sync_trx_rec_type

2570: * =========================================================================*/
2571: PROCEDURE insert_sync_trx_rec
2572: (
2573: p_header_row IN NUMBER,
2574: x_sync_trx_rec OUT NOCOPY zx_api_pub.sync_trx_rec_type
2575: )
2576: IS
2577: BEGIN
2578: x_sync_trx_rec.APPLICATION_ID := g_suite_rec_tbl.APPLICATION_ID(p_header_row);

Line 2608: x_sync_trx_lines_tbl OUT NOCOPY zx_api_pub.sync_trx_lines_tbl_type%type)

2604: PROCEDURE insert_sync_trx_lines_tbl(
2605: p_header_row IN NUMBER,
2606: p_starting_row_sync_trx_lines IN NUMBER,
2607: p_ending_row_sync_trx_lines IN NUMBER,
2608: x_sync_trx_lines_tbl OUT NOCOPY zx_api_pub.sync_trx_lines_tbl_type%type)
2609: IS
2610: i NUMBER;
2611: l_counter NUMBER;
2612: BEGIN

Line 2643: p_transaction_line_rec IN OUT NOCOPY zx_api_pub.transaction_line_rec_type,

2639: /* ============================================================================*
2640: | PROCEDURE insert_transaction_line_rec: Populate the transaction_line_rec |
2641: * ============================================================================*/
2642: PROCEDURE insert_transaction_line_rec (
2643: p_transaction_line_rec IN OUT NOCOPY zx_api_pub.transaction_line_rec_type,
2644: p_row_trx_line IN NUMBER
2645: )
2646: IS
2647: BEGIN

Line 4522: l_hold_codes_tbl zx_api_pub.hold_codes_tbl_type;

4518: l_error_flag VARCHAR2(1);
4519: l_mesg VARCHAR2(2000);
4520: l_return_status VARCHAR2(2000);
4521: l_override_level VARCHAR2(2000);
4522: l_hold_codes_tbl zx_api_pub.hold_codes_tbl_type;
4523: l_validation_status VARCHAR2(4000);
4524: l_start_row NUMBER;
4525: l_end_row NUMBER;
4526: l_flag VARCHAR2(1);

Line 4531: l_sync_trx_rec zx_api_pub.sync_trx_rec_type;

4527: l_tax_hold_code VARCHAR2(100);
4528: l_initial_row NUMBER;
4529: l_ending_row NUMBER;
4530: l_first BOOLEAN;
4531: l_sync_trx_rec zx_api_pub.sync_trx_rec_type;
4532: l_sync_trx_lines_tbl zx_api_pub.sync_trx_lines_tbl_type%type;
4533: l_zx_errors_gt VARCHAR2(4000);
4534:
4535:

Line 4532: l_sync_trx_lines_tbl zx_api_pub.sync_trx_lines_tbl_type%type;

4528: l_initial_row NUMBER;
4529: l_ending_row NUMBER;
4530: l_first BOOLEAN;
4531: l_sync_trx_rec zx_api_pub.sync_trx_rec_type;
4532: l_sync_trx_lines_tbl zx_api_pub.sync_trx_lines_tbl_type%type;
4533: l_zx_errors_gt VARCHAR2(4000);
4534:
4535:
4536: -------------------------------------

Line 4563: zx_api_pub.calculate_tax (

4559: IF p_api_service = 'CALCULATE_TAX' THEN
4560: select count(*) into l_dummy from zx_trx_headers_gt;
4561: write_message('zx_transaction_headers_gt contains rows:'||to_char(l_dummy));
4562:
4563: zx_api_pub.calculate_tax (
4564: l_api_version ,
4565: l_init_msg_list ,
4566: l_commit ,
4567: l_validation_level ,

Line 4573: write_message('Service ZX_API_PUB.CALCULATE_TAX has been called! For ');

4569: l_msg_count ,
4570: l_msg_data
4571: );
4572: write_message('----------------------------------------------------');
4573: write_message('Service ZX_API_PUB.CALCULATE_TAX has been called! For ');
4574: write_message('Suite: '||p_suite_number||' and Case: '||p_case_number);
4575: write_message('x_return_status : '||l_return_status);
4576: write_message('x_msg_count : '||to_char(l_msg_count) );
4577:

Line 7133: zx_api_pub.synchronize_tax_repository (

7129:
7130: -----------------------------------------------------------
7131: -- Proceeds to Call the API Synchronize Tax Repository
7132: -----------------------------------------------------------
7133: zx_api_pub.synchronize_tax_repository (
7134: P_API_VERSION => l_api_version ,
7135: P_INIT_MSG_LIST => l_init_msg_list ,
7136: P_COMMIT => l_commit ,
7137: P_VALIDATION_LEVEL => l_validation_level ,

Line 7145: write_message('Service ZX_API_PUB.SYNCHRONIZE_TAX_REPOSITORY has been called!.');

7141: P_SYNC_TRX_REC => l_sync_trx_rec ,
7142: P_SYNC_TRX_LINES_TBL => l_sync_trx_lines_tbl);
7143:
7144:
7145: write_message('Service ZX_API_PUB.SYNCHRONIZE_TAX_REPOSITORY has been called!.');
7146: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
7147: write_message('x_return_status : '||l_return_status);
7148: write_message('x_msg_count : '||l_msg_count );
7149: write_message('x_msg_data : '||l_msg_data );

Line 7157: zx_api_pub.override_tax(

7153:
7154: -----------------------------------------------------------
7155: -- Proceeds to Call the API Override Tax
7156: -----------------------------------------------------------
7157: zx_api_pub.override_tax(
7158: P_API_VERSION => l_api_version ,
7159: P_INIT_MSG_LIST => l_init_msg_list ,
7160: P_COMMIT => l_commit ,
7161: P_VALIDATION_LEVEL => l_validation_level ,

Line 7170: write_message('Service ZX_API_PUB.OVERRIDE_TAX has been called!. ');

7166: P_OVERRIDE_LEVEL => l_override_level ,
7167: P_EVENT_ID => null -- v7 change. From where to obtain l_event_id?
7168: );
7169:
7170: write_message('Service ZX_API_PUB.OVERRIDE_TAX has been called!. ');
7171: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
7172: write_message('x_return_status : '||l_return_status);
7173: write_message('x_msg_count : '||l_msg_count );
7174: write_message('x_msg_data : '||l_msg_data );

Line 7180: zx_api_pub.global_document_update (

7176: ELSIF p_api_service = 'GLOBAL_DOCUMENT_UPDATE' THEN
7177: -----------------------------------------------------------
7178: -- Proceeds to Call the API Synchronize Tax Repository
7179: -----------------------------------------------------------
7180: zx_api_pub.global_document_update (
7181: l_api_version ,
7182: l_init_msg_list ,
7183: l_commit ,
7184: l_validation_level ,

Line 7189: write_message('Service ZX_API_PUB.GLOBAL_DOCUMENT_UPDATE has been called!. ');

7185: l_return_status ,
7186: l_msg_count ,
7187: l_msg_data ,
7188: g_transaction_rec );
7189: write_message('Service ZX_API_PUB.GLOBAL_DOCUMENT_UPDATE has been called!. ');
7190: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
7191: write_message('x_return_status : '||l_return_status);
7192: write_message('x_msg_count : '||l_msg_count );
7193: write_message('x_msg_data : '||l_msg_data );

Line 7199: zx_api_pub.mark_tax_lines_deleted (

7195: ELSIF p_api_service = 'MARK_TAX_LINES_DELETED' THEN
7196: -----------------------------------------------------------
7197: -- Proceeds to Call the API Synchronize Tax Repository
7198: -----------------------------------------------------------
7199: zx_api_pub.mark_tax_lines_deleted (
7200: l_api_version ,
7201: l_init_msg_list ,
7202: l_commit ,
7203: l_validation_level ,

Line 7209: write_message('Service ZX_API_PUB.MARK_TAX_LINES_DELETED has been called!. ');

7205: l_msg_count ,
7206: l_msg_data ,
7207: g_transaction_line_rec);
7208:
7209: write_message('Service ZX_API_PUB.MARK_TAX_LINES_DELETED has been called!. ');
7210: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
7211: write_message('x_return_status : '||l_return_status);
7212: write_message('x_msg_count : '||l_msg_count );
7213: write_message('x_msg_data : '||l_msg_data );

Line 7219: zx_api_pub.import_document_with_tax (

7215: ELSIF p_api_service = 'IMPORT_DOCUMENT_WITH_TAX' THEN
7216: -----------------------------------------------------------
7217: -- Proceeds to Call the API Synchronize Tax Repository
7218: -----------------------------------------------------------
7219: zx_api_pub.import_document_with_tax (
7220: l_api_version ,
7221: l_init_msg_list ,
7222: l_commit ,
7223: l_validation_level ,

Line 7229: write_message('Service ZX_API_PUB.IMPORT_DOCUMENT_WITH_TAX has been called!. ');

7225: l_msg_count ,
7226: l_msg_data
7227: );
7228:
7229: write_message('Service ZX_API_PUB.IMPORT_DOCUMENT_WITH_TAX has been called!. ');
7230: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
7231: write_message('x_return_status : '||l_return_status);
7232: write_message('x_msg_count : '||l_msg_count );
7233: write_message('x_msg_data : '||l_msg_data );

Line 7239: zx_api_pub.validate_document_for_tax (

7235: ELSIF p_api_service = 'VALIDATE_DOCUMENT_WITH_TAX' THEN
7236: -----------------------------------------------------------
7237: -- Proceeds to Call the API Synchronize Tax Repository
7238: -----------------------------------------------------------
7239: zx_api_pub.validate_document_for_tax (
7240: P_API_VERSION => l_api_version ,
7241: P_INIT_MSG_LIST => l_init_msg_list ,
7242: P_COMMIT => l_commit ,
7243: P_VALIDATION_LEVEL => l_validation_level ,

Line 7251: write_message('Service ZX_API_PUB.VALIDATE_DOCUMENT_WITH_TAX has been called!. ');

7247: P_TRANSACTION_REC => g_transaction_rec ,
7248: X_VALIDATION_STATUS => l_validation_status,
7249: X_HOLD_CODES_TBL => l_hold_codes_tbl);
7250:
7251: write_message('Service ZX_API_PUB.VALIDATE_DOCUMENT_WITH_TAX has been called!. ');
7252: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
7253: write_message('x_return_status : '||l_return_status);
7254: write_message('x_msg_count : '||l_msg_count );
7255: write_message('x_msg_data : '||l_msg_data );

Line 7261: zx_api_pub.reverse_document_distribution (

7257: ELSIF p_api_service = 'REVERSE_DOCUMENT_DISTRIBUTIONS' THEN
7258: -----------------------------------------------------------
7259: -- Proceeds to Call the API Reverse Document Distribution
7260: -----------------------------------------------------------
7261: zx_api_pub.reverse_document_distribution (
7262: l_api_version ,
7263: l_init_msg_list ,
7264: l_commit ,
7265: l_validation_level ,

Line 7270: write_message('Service ZX_API_PUB.REVERSE_DOCUMENT_DISTRIBUTION has been called!. ');

7266: l_return_status ,
7267: l_msg_count ,
7268: l_msg_data );
7269:
7270: write_message('Service ZX_API_PUB.REVERSE_DOCUMENT_DISTRIBUTION has been called!. ');
7271: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
7272: write_message('x_return_status : '||l_return_status);
7273: write_message('x_msg_count : '||l_msg_count );
7274: write_message('x_msg_data : '||l_msg_data );

Line 7280: zx_api_pub.reverse_document (

7276: ELSIF p_api_service = 'REVERSE_DOCUMENT' THEN
7277: -----------------------------------------------------------
7278: -- Proceeds to Call the API Synchronize Tax Repository
7279: -----------------------------------------------------------
7280: zx_api_pub.reverse_document (
7281: l_api_version ,
7282: l_init_msg_list ,
7283: l_commit ,
7284: l_validation_level ,

Line 7289: write_message('Service ZX_API_PUB.REVERSE_DOCUMENT has been called!. ');

7285: l_return_status ,
7286: l_msg_count ,
7287: l_msg_data );
7288:
7289: write_message('Service ZX_API_PUB.REVERSE_DOCUMENT has been called!. ');
7290: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
7291: write_message('x_return_status : '||l_return_status);
7292: write_message('x_msg_count : '||l_msg_count );
7293: write_message('x_msg_data : '||l_msg_data );

Line 7299: zx_api_pub.reverse_distributions (

7295: ELSIF p_api_service = 'REVERSE_DISTRIBUTIONS' THEN
7296: -----------------------------------------------------------
7297: -- Proceeds to Call the API REVERSE DISTRIBUTIONS
7298: -----------------------------------------------------------
7299: zx_api_pub.reverse_distributions (
7300: l_api_version ,
7301: l_init_msg_list ,
7302: l_commit ,
7303: l_validation_level ,

Line 7308: write_message('Service ZX_API_PUB.REVERSE_DISTRIBUTIONS has been called!. ');

7304: l_return_status ,
7305: l_msg_count ,
7306: l_msg_data );
7307:
7308: write_message('Service ZX_API_PUB.REVERSE_DISTRIBUTIONS has been called!. ');
7309: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
7310: write_message('x_return_status : '||l_return_status);
7311: write_message('x_msg_count : '||l_msg_count );
7312: write_message('x_msg_data : '||l_msg_data );

Line 7318: zx_api_pub.determine_recovery (

7314: ELSIF p_api_service = 'DETERMINE_RECOVERY' THEN
7315: -----------------------------------------------------------
7316: -- Proceeds to Call the API Synchronize Tax Repository
7317: -----------------------------------------------------------
7318: zx_api_pub.determine_recovery (
7319: l_api_version ,
7320: l_init_msg_list ,
7321: l_commit ,
7322: l_validation_level ,

Line 7328: write_message('Service ZX_API_PUB.DETERMINE_RECOVERY has been called!. ');

7324: l_msg_count ,
7325: l_msg_data
7326: );
7327:
7328: write_message('Service ZX_API_PUB.DETERMINE_RECOVERY has been called!. ');
7329: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
7330: write_message('x_return_status : '||l_return_status);
7331: write_message('x_msg_count : '||l_msg_count );
7332: write_message('x_msg_data : '||l_msg_data );

Line 7338: zx_api_pub.override_recovery (

7334: ELSIF p_api_service = 'OVERRIDE_RECOVERY' THEN
7335: -----------------------------------------------------------
7336: -- Proceeds to Call the API Synchronize Tax Repository
7337: -----------------------------------------------------------
7338: zx_api_pub.override_recovery (
7339: l_api_version ,
7340: l_init_msg_list ,
7341: l_commit ,
7342: l_validation_level ,

Line 7348: write_message('Service ZX_API_PUB.OVERRIDE_RECOVERY has been called!. ');

7344: l_msg_count ,
7345: l_msg_data ,
7346: g_transaction_rec );
7347:
7348: write_message('Service ZX_API_PUB.OVERRIDE_RECOVERY has been called!. ');
7349: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
7350: write_message('x_return_status : '||l_return_status);
7351: write_message('x_msg_count : '||l_msg_count );
7352: write_message('x_msg_data : '||l_msg_data );

Line 7358: zx_api_pub.freeze_tax_distributions (

7354: ELSIF p_api_service = 'FREEZE_DISTRIBUTION_LINES' THEN
7355: -----------------------------------------------------------
7356: -- Proceeds to Call the API Synchronize Tax Repository
7357: -----------------------------------------------------------
7358: zx_api_pub.freeze_tax_distributions (
7359: l_api_version ,
7360: l_init_msg_list ,
7361: l_commit ,
7362: l_validation_level ,

Line 7368: write_message('Service ZX_API_PUB.FREEZE_DISTRIBUTION_LINES has been called!. ');

7364: l_msg_count ,
7365: l_msg_data ,
7366: g_transaction_rec );
7367:
7368: write_message('Service ZX_API_PUB.FREEZE_DISTRIBUTION_LINES has been called!. ');
7369: write_message('For Suite: '||p_suite_number||' and Case: '||p_case_number);
7370: write_message('x_return_status : '||l_return_status);
7371: write_message('x_msg_count : '||l_msg_count );
7372: write_message('x_msg_data : '||l_msg_data );

Line 7501: zx_api_pub.calculate_tax (

7497:
7498: -----------------------------------------------------------
7499: -- Proceeds to Call the APIs Calculate Tax
7500: -----------------------------------------------------------
7501: zx_api_pub.calculate_tax (
7502: p_api_version => l_api_version ,
7503: p_init_msg_list => l_init_msg_list ,
7504: p_commit => l_commit ,
7505: p_validation_level => l_validation_level ,

Line 7511: write_message('Service ZX_API_PUB.CALCULATE_TAX has been called! For '||

7507: x_msg_count => l_msg_count ,
7508: x_msg_data => l_msg_data
7509: );
7510: write_message('----------------------------------------------------------');
7511: write_message('Service ZX_API_PUB.CALCULATE_TAX has been called! For '||
7512: 'Suite: '||p_suite_number||' and Case: '||p_case_number);
7513: write_message('x_return_status : '||l_return_status);
7514: write_message('x_msg_count : '||l_msg_count );
7515: write_message('x_msg_data : '||l_msg_data );

Line 7546: zx_api_pub.Discard_tax_only_lines

7542: -----------------------------------------------------------
7543: -- Calling Discard tax only Lines
7544: -----------------------------------------------------------
7545:
7546: zx_api_pub.Discard_tax_only_lines
7547: (
7548: p_api_version => l_api_version ,
7549: p_init_msg_list => l_init_msg_list ,
7550: p_commit => l_commit ,

Line 7558: write_message('Service ZX_API_PUB.Discard_Tax_only_lines has been called ');

7554: x_msg_data => l_msg_data ,
7555: p_transaction_rec => g_transaction_rec );
7556:
7557: write_message('----------------------------------------------------------');
7558: write_message('Service ZX_API_PUB.Discard_Tax_only_lines has been called ');
7559: write_message('x_return_status : '||l_return_status);
7560:
7561: END IF;
7562:

Line 7572: zx_api_pub.Reverse_distributions (

7568:
7569: -----------------------------------------------------------
7570: -- Proceeds to Call Reverse Distributions
7571: -----------------------------------------------------------
7572: zx_api_pub.Reverse_distributions (
7573: p_api_version => l_api_version ,
7574: p_init_msg_list => l_init_msg_list ,
7575: p_commit => l_commit ,
7576: p_validation_level => l_validation_level ,

Line 7591: zx_api_pub.validate_document_for_tax (

7587: ----------------------------------------------------------------------
7588: -- Call validate_document_for_tax
7589: ----------------------------------------------------------------------
7590:
7591: zx_api_pub.validate_document_for_tax (
7592: p_api_version => l_api_version,
7593: p_init_msg_list => l_init_msg_list,
7594: p_commit => l_commit,
7595: p_validation_level => l_validation_level,

Line 7604: write_message('Service ZX_API_PUB.VALIDATE_DOCUMENT_FOR_TAX ');

7600: x_validation_status => l_validation_status,
7601: x_hold_codes_tbl => l_hold_codes_tbl);
7602:
7603: write_message('----------------------------------------------------------');
7604: write_message('Service ZX_API_PUB.VALIDATE_DOCUMENT_FOR_TAX ');
7605: write_message('x_return_status : '||l_return_status);
7606: write_message('x_msg_count : '||l_msg_count );
7607: write_message('x_msg_data : '||l_msg_data );
7608:

Line 7653: zx_api_pub.global_document_update (

7649: ----------------------------------------------------------------------
7650: -- Call global_document_update
7651: ----------------------------------------------------------------------
7652:
7653: zx_api_pub.global_document_update (
7654: p_api_version => l_api_version,
7655: p_init_msg_list => l_init_msg_list,
7656: p_commit => l_commit,
7657: p_validation_level => l_validation_level ,

Line 7664: write_message('Service ZX_API_PUB.GLOBAL_DOCUMENT_FOR_UPDATE has been called');

7660: x_msg_data => l_msg_data ,
7661: p_transaction_rec => g_transaction_rec );
7662:
7663: write_message('----------------------------------------------------------');
7664: write_message('Service ZX_API_PUB.GLOBAL_DOCUMENT_FOR_UPDATE has been called');
7665: write_message('x_return_status : '||l_return_status);
7666: write_message('x_msg_count : '||l_msg_count );
7667: write_message('x_msg_data : '||l_msg_data );
7668:

Line 7697: zx_api_pub.global_document_update (

7693: ----------------------------------------------------------------------
7694: -- Call global_document_update
7695: ----------------------------------------------------------------------
7696:
7697: zx_api_pub.global_document_update (
7698: p_api_version => l_api_version ,
7699: p_init_msg_list => l_init_msg_list ,
7700: p_commit => l_commit,
7701: p_validation_level => l_validation_level ,

Line 7708: write_message('Service ZX_API_PUB.GLOBAL_DOCUMENT_UPDATE has been called ');

7704: x_msg_data => l_msg_data ,
7705: p_transaction_rec => g_transaction_rec );
7706:
7707: write_message('----------------------------------------------------------');
7708: write_message('Service ZX_API_PUB.GLOBAL_DOCUMENT_UPDATE has been called ');
7709: write_message('x_return_status : '||l_return_status);
7710: write_message('x_msg_count : '||l_msg_count );
7711: write_message('x_msg_data : '||l_msg_data );
7712:

Line 9229: g_suite_rec_tbl.ROW_API(l_row) := 'ZX_API_PUB';

9225: initialize_row(p_record_counter => l_row);
9226:
9227: g_suite_rec_tbl.ROW_SUITE(l_row) := p_Suite ;
9228: g_suite_rec_tbl.ROW_CASE(l_row) := p_Case;
9229: g_suite_rec_tbl.ROW_API(l_row) := 'ZX_API_PUB';
9230: g_suite_rec_tbl.ROW_SERVICE(l_row) := 'DETERMINE_RECOVERY';
9231: g_suite_rec_tbl.APPLICATION_ID(l_row) := g_dist_lines_cache_rec_tbl.APPLICATION_ID(i);
9232: g_suite_rec_tbl.ENTITY_CODE(l_row) := g_dist_lines_cache_rec_tbl.ENTITY_CODE(i);
9233: g_suite_rec_tbl.EVENT_CLASS_CODE(l_row) := g_dist_lines_cache_rec_tbl.EVENT_CLASS_CODE(i);