6413: x_return_status OUT NOCOPY VARCHAR2
6414: )IS
6415:
6416: i NUMBER;
6417: l_location_type_tbl ZX_TCM_GEO_JUR_PKG.location_type_tbl_type;
6418: l_location_id_tbl ZX_TCM_GEO_JUR_PKG.location_id_tbl_type;
6419: l_return_status VARCHAR2(1);
6420: l_context_info_rec ZX_API_PUB.context_info_rec_type;
6421: l_api_name CONSTANT VARCHAR2(30):= 'PREPARE_FOR_LOC_CACHING';
6414: )IS
6415:
6416: i NUMBER;
6417: l_location_type_tbl ZX_TCM_GEO_JUR_PKG.location_type_tbl_type;
6418: l_location_id_tbl ZX_TCM_GEO_JUR_PKG.location_id_tbl_type;
6419: l_return_status VARCHAR2(1);
6420: l_context_info_rec ZX_API_PUB.context_info_rec_type;
6421: l_api_name CONSTANT VARCHAR2(30):= 'PREPARE_FOR_LOC_CACHING';
6422:
6505: i := i + 1;
6506: END IF;
6507:
6508:
6509: ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info(event_class_mapping_id => p_event_class_rec.event_class_mapping_id,
6510: trx_id => p_event_class_rec.trx_id,
6511: trx_line_id => ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index),
6512: trx_level_type => ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index),
6513: location_type_tbl => l_location_type_tbl,
11779: l_cursor_rows NUMBER;
11780: l_return_status VARCHAR2(30);
11781: l_error_buffer VARCHAR2(2000);
11782: l_context_info_rec ZX_API_PUB.context_info_rec_type;
11783: l_location_type_tbl ZX_TCM_GEO_JUR_PKG.location_type_tbl_type;
11784: l_location_id_tbl ZX_TCM_GEO_JUR_PKG.location_id_tbl_type;
11785: i NUMBER;
11786: l_flag BOOLEAN;
11787: l_tax_calc_flag VARCHAR2(10);
11780: l_return_status VARCHAR2(30);
11781: l_error_buffer VARCHAR2(2000);
11782: l_context_info_rec ZX_API_PUB.context_info_rec_type;
11783: l_location_type_tbl ZX_TCM_GEO_JUR_PKG.location_type_tbl_type;
11784: l_location_id_tbl ZX_TCM_GEO_JUR_PKG.location_id_tbl_type;
11785: i NUMBER;
11786: l_flag BOOLEAN;
11787: l_tax_calc_flag VARCHAR2(10);
11788: -- l_count_line_level_action NUMBER;
14578: ) IS
14579: l_api_name CONSTANT VARCHAR2(30):= 'REVERSE_DOCUMENT';
14580: l_return_status VARCHAR2(30);
14581: l_context_info_rec ZX_API_PUB.context_info_rec_type;
14582: l_location_type_tbl ZX_TCM_GEO_JUR_PKG.location_type_tbl_type;
14583: l_location_id_tbl ZX_TCM_GEO_JUR_PKG.location_id_tbl_type;
14584: l_ptnr_tax_lines_insert NUMBER; -- Bug 5332192
14585: i NUMBER;
14586:
14579: l_api_name CONSTANT VARCHAR2(30):= 'REVERSE_DOCUMENT';
14580: l_return_status VARCHAR2(30);
14581: l_context_info_rec ZX_API_PUB.context_info_rec_type;
14582: l_location_type_tbl ZX_TCM_GEO_JUR_PKG.location_type_tbl_type;
14583: l_location_id_tbl ZX_TCM_GEO_JUR_PKG.location_id_tbl_type;
14584: l_ptnr_tax_lines_insert NUMBER; -- Bug 5332192
14585: i NUMBER;
14586:
14587: CURSOR get_rev_info_csr IS