579: -- the structure below so that this information is available to partner
580: -- API which will be called in the end in bulk.
581:
582: TYPE ptnr_tax_regime_rec_type is RECORD (
583: application_id zx_lines_det_factors.application_id%TYPE,
584: event_class_code zx_lines_det_factors.event_class_code%TYPE,
585: entity_code zx_lines_det_factors.entity_code%TYPE,
586: trx_id zx_lines_det_factors.trx_id%TYPE,
587: event_id zx_lines_det_factors.event_id%TYPE,
580: -- API which will be called in the end in bulk.
581:
582: TYPE ptnr_tax_regime_rec_type is RECORD (
583: application_id zx_lines_det_factors.application_id%TYPE,
584: event_class_code zx_lines_det_factors.event_class_code%TYPE,
585: entity_code zx_lines_det_factors.entity_code%TYPE,
586: trx_id zx_lines_det_factors.trx_id%TYPE,
587: event_id zx_lines_det_factors.event_id%TYPE,
588: event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
581:
582: TYPE ptnr_tax_regime_rec_type is RECORD (
583: application_id zx_lines_det_factors.application_id%TYPE,
584: event_class_code zx_lines_det_factors.event_class_code%TYPE,
585: entity_code zx_lines_det_factors.entity_code%TYPE,
586: trx_id zx_lines_det_factors.trx_id%TYPE,
587: event_id zx_lines_det_factors.event_id%TYPE,
588: event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
589: event_type_code zx_lines_det_factors.event_type_code%TYPE,
582: TYPE ptnr_tax_regime_rec_type is RECORD (
583: application_id zx_lines_det_factors.application_id%TYPE,
584: event_class_code zx_lines_det_factors.event_class_code%TYPE,
585: entity_code zx_lines_det_factors.entity_code%TYPE,
586: trx_id zx_lines_det_factors.trx_id%TYPE,
587: event_id zx_lines_det_factors.event_id%TYPE,
588: event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
589: event_type_code zx_lines_det_factors.event_type_code%TYPE,
590: tax_event_class_code zx_lines_det_factors.tax_event_class_code%TYPE,
583: application_id zx_lines_det_factors.application_id%TYPE,
584: event_class_code zx_lines_det_factors.event_class_code%TYPE,
585: entity_code zx_lines_det_factors.entity_code%TYPE,
586: trx_id zx_lines_det_factors.trx_id%TYPE,
587: event_id zx_lines_det_factors.event_id%TYPE,
588: event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
589: event_type_code zx_lines_det_factors.event_type_code%TYPE,
590: tax_event_class_code zx_lines_det_factors.tax_event_class_code%TYPE,
591: tax_event_type_code zx_lines_det_factors.tax_event_type_code%TYPE,
584: event_class_code zx_lines_det_factors.event_class_code%TYPE,
585: entity_code zx_lines_det_factors.entity_code%TYPE,
586: trx_id zx_lines_det_factors.trx_id%TYPE,
587: event_id zx_lines_det_factors.event_id%TYPE,
588: event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
589: event_type_code zx_lines_det_factors.event_type_code%TYPE,
590: tax_event_class_code zx_lines_det_factors.tax_event_class_code%TYPE,
591: tax_event_type_code zx_lines_det_factors.tax_event_type_code%TYPE,
592: doc_status_code VARCHAR2(30),
585: entity_code zx_lines_det_factors.entity_code%TYPE,
586: trx_id zx_lines_det_factors.trx_id%TYPE,
587: event_id zx_lines_det_factors.event_id%TYPE,
588: event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
589: event_type_code zx_lines_det_factors.event_type_code%TYPE,
590: tax_event_class_code zx_lines_det_factors.tax_event_class_code%TYPE,
591: tax_event_type_code zx_lines_det_factors.tax_event_type_code%TYPE,
592: doc_status_code VARCHAR2(30),
593: record_flag zx_evnt_cls_mappings.record_flag%TYPE,
586: trx_id zx_lines_det_factors.trx_id%TYPE,
587: event_id zx_lines_det_factors.event_id%TYPE,
588: event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
589: event_type_code zx_lines_det_factors.event_type_code%TYPE,
590: tax_event_class_code zx_lines_det_factors.tax_event_class_code%TYPE,
591: tax_event_type_code zx_lines_det_factors.tax_event_type_code%TYPE,
592: doc_status_code VARCHAR2(30),
593: record_flag zx_evnt_cls_mappings.record_flag%TYPE,
594: quote_flag zx_trx_headers_gt.quote_flag%TYPE,
587: event_id zx_lines_det_factors.event_id%TYPE,
588: event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
589: event_type_code zx_lines_det_factors.event_type_code%TYPE,
590: tax_event_class_code zx_lines_det_factors.tax_event_class_code%TYPE,
591: tax_event_type_code zx_lines_det_factors.tax_event_type_code%TYPE,
592: doc_status_code VARCHAR2(30),
593: record_flag zx_evnt_cls_mappings.record_flag%TYPE,
594: quote_flag zx_trx_headers_gt.quote_flag%TYPE,
595: record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%TYPE,
593: record_flag zx_evnt_cls_mappings.record_flag%TYPE,
594: quote_flag zx_trx_headers_gt.quote_flag%TYPE,
595: record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%TYPE,
596: prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%TYPE,
597: first_pty_org_id zx_lines_det_factors.first_pty_org_id%TYPE,
598: internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE,
599: legal_entity_id zx_lines_det_factors.legal_entity_id%TYPE,
600: ledger_id zx_lines_det_factors.ledger_id%TYPE,
601: establishment_id zx_lines_det_factors.establishment_id%TYPE,
594: quote_flag zx_trx_headers_gt.quote_flag%TYPE,
595: record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%TYPE,
596: prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%TYPE,
597: first_pty_org_id zx_lines_det_factors.first_pty_org_id%TYPE,
598: internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE,
599: legal_entity_id zx_lines_det_factors.legal_entity_id%TYPE,
600: ledger_id zx_lines_det_factors.ledger_id%TYPE,
601: establishment_id zx_lines_det_factors.establishment_id%TYPE,
602: currency_conversion_type zx_lines_det_factors.currency_conversion_type%TYPE,
595: record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%TYPE,
596: prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%TYPE,
597: first_pty_org_id zx_lines_det_factors.first_pty_org_id%TYPE,
598: internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE,
599: legal_entity_id zx_lines_det_factors.legal_entity_id%TYPE,
600: ledger_id zx_lines_det_factors.ledger_id%TYPE,
601: establishment_id zx_lines_det_factors.establishment_id%TYPE,
602: currency_conversion_type zx_lines_det_factors.currency_conversion_type%TYPE,
603: process_for_applicability_flag VARCHAR2(1),
596: prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%TYPE,
597: first_pty_org_id zx_lines_det_factors.first_pty_org_id%TYPE,
598: internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE,
599: legal_entity_id zx_lines_det_factors.legal_entity_id%TYPE,
600: ledger_id zx_lines_det_factors.ledger_id%TYPE,
601: establishment_id zx_lines_det_factors.establishment_id%TYPE,
602: currency_conversion_type zx_lines_det_factors.currency_conversion_type%TYPE,
603: process_for_applicability_flag VARCHAR2(1),
604: perf_addnl_appl_for_imprt_flag VARCHAR2(1),
597: first_pty_org_id zx_lines_det_factors.first_pty_org_id%TYPE,
598: internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE,
599: legal_entity_id zx_lines_det_factors.legal_entity_id%TYPE,
600: ledger_id zx_lines_det_factors.ledger_id%TYPE,
601: establishment_id zx_lines_det_factors.establishment_id%TYPE,
602: currency_conversion_type zx_lines_det_factors.currency_conversion_type%TYPE,
603: process_for_applicability_flag VARCHAR2(1),
604: perf_addnl_appl_for_imprt_flag VARCHAR2(1),
605: ptnr_srvc_subscr_flag VARCHAR2(1),
598: internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE,
599: legal_entity_id zx_lines_det_factors.legal_entity_id%TYPE,
600: ledger_id zx_lines_det_factors.ledger_id%TYPE,
601: establishment_id zx_lines_det_factors.establishment_id%TYPE,
602: currency_conversion_type zx_lines_det_factors.currency_conversion_type%TYPE,
603: process_for_applicability_flag VARCHAR2(1),
604: perf_addnl_appl_for_imprt_flag VARCHAR2(1),
605: ptnr_srvc_subscr_flag VARCHAR2(1),
606: effective_date DATE,
1154: -- Latin Tax specific global structure ----------
1155: -- The following structure is introduced for Latin Tax Processing
1156:
1157: TYPE lte_trx_rec_type is RECORD (
1158: application_id zx_lines_det_factors.application_id%TYPE,
1159: event_class_code zx_lines_det_factors.event_class_code%TYPE,
1160: entity_code zx_lines_det_factors.entity_code%TYPE,
1161: trx_id zx_lines_det_factors.trx_id%TYPE,
1162: event_id zx_lines_det_factors.event_id%TYPE,
1155: -- The following structure is introduced for Latin Tax Processing
1156:
1157: TYPE lte_trx_rec_type is RECORD (
1158: application_id zx_lines_det_factors.application_id%TYPE,
1159: event_class_code zx_lines_det_factors.event_class_code%TYPE,
1160: entity_code zx_lines_det_factors.entity_code%TYPE,
1161: trx_id zx_lines_det_factors.trx_id%TYPE,
1162: event_id zx_lines_det_factors.event_id%TYPE,
1163: event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
1156:
1157: TYPE lte_trx_rec_type is RECORD (
1158: application_id zx_lines_det_factors.application_id%TYPE,
1159: event_class_code zx_lines_det_factors.event_class_code%TYPE,
1160: entity_code zx_lines_det_factors.entity_code%TYPE,
1161: trx_id zx_lines_det_factors.trx_id%TYPE,
1162: event_id zx_lines_det_factors.event_id%TYPE,
1163: event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
1164: event_type_code zx_lines_det_factors.event_type_code%TYPE,
1157: TYPE lte_trx_rec_type is RECORD (
1158: application_id zx_lines_det_factors.application_id%TYPE,
1159: event_class_code zx_lines_det_factors.event_class_code%TYPE,
1160: entity_code zx_lines_det_factors.entity_code%TYPE,
1161: trx_id zx_lines_det_factors.trx_id%TYPE,
1162: event_id zx_lines_det_factors.event_id%TYPE,
1163: event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
1164: event_type_code zx_lines_det_factors.event_type_code%TYPE,
1165: tax_event_class_code zx_lines_det_factors.tax_event_class_code%TYPE,
1158: application_id zx_lines_det_factors.application_id%TYPE,
1159: event_class_code zx_lines_det_factors.event_class_code%TYPE,
1160: entity_code zx_lines_det_factors.entity_code%TYPE,
1161: trx_id zx_lines_det_factors.trx_id%TYPE,
1162: event_id zx_lines_det_factors.event_id%TYPE,
1163: event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
1164: event_type_code zx_lines_det_factors.event_type_code%TYPE,
1165: tax_event_class_code zx_lines_det_factors.tax_event_class_code%TYPE,
1166: tax_event_type_code zx_lines_det_factors.tax_event_type_code%TYPE,
1159: event_class_code zx_lines_det_factors.event_class_code%TYPE,
1160: entity_code zx_lines_det_factors.entity_code%TYPE,
1161: trx_id zx_lines_det_factors.trx_id%TYPE,
1162: event_id zx_lines_det_factors.event_id%TYPE,
1163: event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
1164: event_type_code zx_lines_det_factors.event_type_code%TYPE,
1165: tax_event_class_code zx_lines_det_factors.tax_event_class_code%TYPE,
1166: tax_event_type_code zx_lines_det_factors.tax_event_type_code%TYPE,
1167: doc_status_code VARCHAR2(30),
1160: entity_code zx_lines_det_factors.entity_code%TYPE,
1161: trx_id zx_lines_det_factors.trx_id%TYPE,
1162: event_id zx_lines_det_factors.event_id%TYPE,
1163: event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
1164: event_type_code zx_lines_det_factors.event_type_code%TYPE,
1165: tax_event_class_code zx_lines_det_factors.tax_event_class_code%TYPE,
1166: tax_event_type_code zx_lines_det_factors.tax_event_type_code%TYPE,
1167: doc_status_code VARCHAR2(30),
1168: record_flag zx_evnt_cls_mappings.record_flag%TYPE,
1161: trx_id zx_lines_det_factors.trx_id%TYPE,
1162: event_id zx_lines_det_factors.event_id%TYPE,
1163: event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
1164: event_type_code zx_lines_det_factors.event_type_code%TYPE,
1165: tax_event_class_code zx_lines_det_factors.tax_event_class_code%TYPE,
1166: tax_event_type_code zx_lines_det_factors.tax_event_type_code%TYPE,
1167: doc_status_code VARCHAR2(30),
1168: record_flag zx_evnt_cls_mappings.record_flag%TYPE,
1169: quote_flag zx_trx_headers_gt.quote_flag%TYPE,
1162: event_id zx_lines_det_factors.event_id%TYPE,
1163: event_class_mapping_id zx_lines_det_factors.event_class_mapping_id%TYPE,
1164: event_type_code zx_lines_det_factors.event_type_code%TYPE,
1165: tax_event_class_code zx_lines_det_factors.tax_event_class_code%TYPE,
1166: tax_event_type_code zx_lines_det_factors.tax_event_type_code%TYPE,
1167: doc_status_code VARCHAR2(30),
1168: record_flag zx_evnt_cls_mappings.record_flag%TYPE,
1169: quote_flag zx_trx_headers_gt.quote_flag%TYPE,
1170: record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%TYPE,
1168: record_flag zx_evnt_cls_mappings.record_flag%TYPE,
1169: quote_flag zx_trx_headers_gt.quote_flag%TYPE,
1170: record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%TYPE,
1171: prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%TYPE,
1172: first_pty_org_id zx_lines_det_factors.first_pty_org_id%TYPE,
1173: internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE,
1174: legal_entity_id zx_lines_det_factors.legal_entity_id%TYPE,
1175: ledger_id zx_lines_det_factors.ledger_id%TYPE,
1176: establishment_id zx_lines_det_factors.establishment_id%TYPE,
1169: quote_flag zx_trx_headers_gt.quote_flag%TYPE,
1170: record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%TYPE,
1171: prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%TYPE,
1172: first_pty_org_id zx_lines_det_factors.first_pty_org_id%TYPE,
1173: internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE,
1174: legal_entity_id zx_lines_det_factors.legal_entity_id%TYPE,
1175: ledger_id zx_lines_det_factors.ledger_id%TYPE,
1176: establishment_id zx_lines_det_factors.establishment_id%TYPE,
1177: currency_conversion_type zx_lines_det_factors.currency_conversion_type%TYPE,
1170: record_for_partners_flag zx_evnt_cls_mappings.record_for_partners_flag%TYPE,
1171: prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%TYPE,
1172: first_pty_org_id zx_lines_det_factors.first_pty_org_id%TYPE,
1173: internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE,
1174: legal_entity_id zx_lines_det_factors.legal_entity_id%TYPE,
1175: ledger_id zx_lines_det_factors.ledger_id%TYPE,
1176: establishment_id zx_lines_det_factors.establishment_id%TYPE,
1177: currency_conversion_type zx_lines_det_factors.currency_conversion_type%TYPE,
1178: process_for_applicability_flag VARCHAR2(1),
1171: prod_family_grp_code zx_evnt_cls_mappings.prod_family_grp_code%TYPE,
1172: first_pty_org_id zx_lines_det_factors.first_pty_org_id%TYPE,
1173: internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE,
1174: legal_entity_id zx_lines_det_factors.legal_entity_id%TYPE,
1175: ledger_id zx_lines_det_factors.ledger_id%TYPE,
1176: establishment_id zx_lines_det_factors.establishment_id%TYPE,
1177: currency_conversion_type zx_lines_det_factors.currency_conversion_type%TYPE,
1178: process_for_applicability_flag VARCHAR2(1),
1179: perf_addnl_appl_for_imprt_flag VARCHAR2(1),
1172: first_pty_org_id zx_lines_det_factors.first_pty_org_id%TYPE,
1173: internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE,
1174: legal_entity_id zx_lines_det_factors.legal_entity_id%TYPE,
1175: ledger_id zx_lines_det_factors.ledger_id%TYPE,
1176: establishment_id zx_lines_det_factors.establishment_id%TYPE,
1177: currency_conversion_type zx_lines_det_factors.currency_conversion_type%TYPE,
1178: process_for_applicability_flag VARCHAR2(1),
1179: perf_addnl_appl_for_imprt_flag VARCHAR2(1),
1180: effective_date DATE
1173: internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE,
1174: legal_entity_id zx_lines_det_factors.legal_entity_id%TYPE,
1175: ledger_id zx_lines_det_factors.ledger_id%TYPE,
1176: establishment_id zx_lines_det_factors.establishment_id%TYPE,
1177: currency_conversion_type zx_lines_det_factors.currency_conversion_type%TYPE,
1178: process_for_applicability_flag VARCHAR2(1),
1179: perf_addnl_appl_for_imprt_flag VARCHAR2(1),
1180: effective_date DATE
1181: );
1256: --
1257: PROCEDURE get_product_options_info(
1258: p_application_id IN NUMBER,
1259: p_org_id IN NUMBER,
1260: p_event_class_mapping_id IN zx_lines_det_factors.EVENT_CLASS_MAPPING_ID%TYPE,
1261: x_product_options_rec OUT NOCOPY zx_product_options_rec_type,
1262: x_return_status OUT NOCOPY VARCHAR2);
1263:
1264: END ZX_GLOBAL_STRUCTURES_PKG;