[Home] [Help]
61: ------------------------------------------------*/
62: C_LINES_PER_COMMIT CONSTANT NUMBER := 1000;
63: I Number;
64: l_line_level_action varchar2(20);
65: l_document_type zx_lines_det_factors.event_class_code%type;
66: l_trx_line_context_changed BOOLEAN;
67: l_state_tax_cnt NUMBER;
68: l_county_tax_cnt NUMBER;
69: l_city_tax_cnt NUMBER;
724: l_cnt_of_loc_info_gt NUMBER;
725: l_cnt_of_ptnr_neg_line_gt NUMBER;
726: l_partner_processing_flag VARCHAR2(80);
727: l_record_for_partners_flag VARCHAR2(80);
728: l_line_action zx_lines_det_factors.line_level_action%type;
729: -- l_inclusive_tax_override_flag VARCHAR2(80);
730: l_application_id NUMBER;
731: l_entity_code VARCHAR2(80);
732: l_event_class_code VARCHAR2(100);
822: BEGIN
823: SELECT count(*)
824: INTO l_cnt_of_options_gt
825: FROM ZX_TRX_PRE_PROC_OPTIONS_GT ztppo
826: , ZX_LINES_DET_FACTORS zldf
827: WHERE ztppo.application_id = zldf.application_id
828: AND ztppo.entity_code = zldf.entity_code
829: AND ztppo.event_class_code = zldf.event_class_code
830: AND ztppo.trx_id = zldf.trx_id;
895:
896: SELECT output_tax_classification_code,receivables_trx_type_id,internal_organization_id, ship_to_location_id,
897: bill_to_location_id
898: INTO l_tax_code, l_trx_type_id, l_org_id, l_ship_to_location_id, l_bill_to_location_id
899: FROM zx_lines_det_factors
900: WHERE application_id = l_application_id
901: and entity_code = l_entity_code
902: and event_class_code = l_event_class_code
903: and trx_id = l_trx_id
978: --BEGIN
979: -- select zldf.line_level_action,zldf.inclusive_tax_override_flag
980: -- into l_line_level_action, l_inclusive_tax_override_flag
981: -- FROM ZX_TRX_PRE_PROC_OPTIONS_GT ztppo
982: -- ,ZX_LINES_DET_FACTORS zldf
983: -- WHERE ztppo.application_id = zldf.application_id
984: -- AND ztppo.entity_code = zldf.entity_code
985: -- AND ztppo.event_class_code = zldf.event_class_code
986: -- AND ztppo.trx_id = zldf.trx_id;
1402: ELSE
1403: IF l_document_type = 'APPLIED_CREDIT_MEMO' and pg_line_amount_tab(I) = 0 THEN
1404: BEGIN
1405: select line_level_action into l_line_action
1406: from zx_lines_det_factors
1407: where application_id = l_application_id
1408: and entity_code = l_entity_code
1409: and event_class_code = l_event_class_code
1410: and trx_id = pg_trx_id_tab(I)
2736: --bug#6831713
2737: BEGIN
2738: SELECT nvl(zd.partner_migrated_flag, 'N') -- Bug 5007293
2739: INTO pg_ugraded_inv_flag_tab(I)
2740: FROM ZX_LINES_DET_FACTORS zd
2741: WHERE zd.event_class_mapping_id = pg_adj_doc_doc_type_id_tab(i)
2742: AND zd.trx_id = pg_adj_doc_trx_id_tab(i)
2743: AND zd.trx_line_id = pg_adj_doc_line_id_tab(i)
2744: AND zd.trx_level_type = pg_adj_doc_trx_lev_type_tab(i)
3384: IF l_situs = 'SHIP_TO' THEN
3385: /* Bug 5090593: Making use of the location ids passed thru view.
3386: select nvl(ship_to_location_id, bill_to_location_id)
3387: INTO p_location_id
3388: From zx_lines_det_factors
3389: WHERE event_class_mapping_id = pg_doc_type_id_tab(I) and
3390: trx_id = pg_trx_id_tab(I) and
3391: trx_line_id = pg_trx_line_id_tab(I) and
3392: trx_level_type = pg_trx_level_type_tab(I);
3396: ELSIF l_situs = 'SHIP_FROM' THEN
3397: /* Bug 5090593: Making use of the location ids passed thru view.
3398: select nvl(ship_from_location_id, bill_from_location_id)
3399: INTO p_location_id
3400: From zx_lines_det_factors
3401: WHERE event_class_mapping_id = pg_doc_type_id_tab(I) and
3402: trx_id = pg_trx_id_tab(I) and
3403: trx_line_id = pg_trx_line_id_tab(I) and
3404: trx_level_type = pg_trx_level_type_tab(I);
4166: l_EVENT_CLASS_CODE,
4167: l_TRX_ID ,
4168: l_TRX_LINE_ID,
4169: l_TRX_LEVEL_TYPE
4170: FROM zx_lines_det_factors
4171: WHERE event_class_mapping_id = p_evnt_cls_mapping_id
4172: AND trx_id = p_transaction_id
4173: AND trx_line_id = p_transaction_line_id
4174: AND trx_level_type = p_trx_level_type;
4177: IF (g_level_exception >= g_current_runtime_level ) THEN
4178: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4179: END IF;
4180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4181: g_string :='No data found in zx_lines_det_factors ';
4182: error_exception_handle(g_string);
4183: RETURN;
4184: END;
4185:
4464: l_neg_tax_line_count NUMBER; -- Added for Bug#12544630
4465: l_neg_trx_line_count NUMBER; -- Added for Bug#12544630
4466: l_update_mode BOOLEAN; -- Added for Bug#12544630
4467:
4468: l_line_action zx_lines_det_factors.line_level_action%type;
4469: l_adj_trx_id ZX_SYNC_HDR_INPUT_V.transaction_id%type;
4470: BEGIN
4471: x_return_status := FND_API.G_RET_STS_SUCCESS;
4472: err_count := 0;
4555:
4556: -- SELECT output_tax_classification_code , receivables_trx_type_id,
4557: -- internal_organization_id
4558: -- INTO l_tax_code, l_trx_type_id, l_org_id
4559: -- FROM zx_lines_det_factors
4560: -- WHERE application_id = l_application_id
4561: -- AND entity_code = l_entity_code
4562: -- AND event_class_code = l_event_class_code
4563: -- AND trx_id = SYNC_TAX_LINES.transaction_id(1)
5228: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5229: BEGIN
5230: SELECT count(*)
5231: INTO l_cnt_of_det_factors
5232: FROM ZX_LINES_DET_FACTORS
5233: WHERE event_class_mapping_id = x_transaction_rec.document_type_id
5234: AND trx_id = x_transaction_rec.transaction_id;
5235: EXCEPTION WHEN OTHERS THEN
5236: l_cnt_of_det_factors := 0;
5320:
5321: SELECT output_tax_classification_code,receivables_trx_type_id,
5322: internal_organization_id into
5323: l_tax_code,l_trx_type_id, l_org_id
5324: FROM zx_lines_det_factors where
5325: application_id = l_application_id
5326: and entity_code = l_entity_code
5327: and event_class_code = l_event_class_code
5328: and trx_id = l_trx_id