2568: l_multi_mod_request_record po_multi_mod_requests%ROWTYPE;
2569: l_fpds_reporting VARCHAR2(25);
2570:
2571: l_entity_names_tbl PO_TBL_VARCHAR30;
2572: l_entity_pk1 PO_TBL_VARCHAR240;
2573: l_entity_pk2 PO_TBL_VARCHAR240;
2574: l_edited_entity_pk2 PO_TBL_VARCHAR240;
2575: l_entity_pk3 PO_TBL_VARCHAR240;
2576: l_entity_pk4 PO_TBL_VARCHAR240;
2569: l_fpds_reporting VARCHAR2(25);
2570:
2571: l_entity_names_tbl PO_TBL_VARCHAR30;
2572: l_entity_pk1 PO_TBL_VARCHAR240;
2573: l_entity_pk2 PO_TBL_VARCHAR240;
2574: l_edited_entity_pk2 PO_TBL_VARCHAR240;
2575: l_entity_pk3 PO_TBL_VARCHAR240;
2576: l_entity_pk4 PO_TBL_VARCHAR240;
2577: l_sum_check_tbl PO_TBL_NUMBER;
2570:
2571: l_entity_names_tbl PO_TBL_VARCHAR30;
2572: l_entity_pk1 PO_TBL_VARCHAR240;
2573: l_entity_pk2 PO_TBL_VARCHAR240;
2574: l_edited_entity_pk2 PO_TBL_VARCHAR240;
2575: l_entity_pk3 PO_TBL_VARCHAR240;
2576: l_entity_pk4 PO_TBL_VARCHAR240;
2577: l_sum_check_tbl PO_TBL_NUMBER;
2578: l_conc_mods_enabled_flag VARCHAR2(1);
2571: l_entity_names_tbl PO_TBL_VARCHAR30;
2572: l_entity_pk1 PO_TBL_VARCHAR240;
2573: l_entity_pk2 PO_TBL_VARCHAR240;
2574: l_edited_entity_pk2 PO_TBL_VARCHAR240;
2575: l_entity_pk3 PO_TBL_VARCHAR240;
2576: l_entity_pk4 PO_TBL_VARCHAR240;
2577: l_sum_check_tbl PO_TBL_NUMBER;
2578: l_conc_mods_enabled_flag VARCHAR2(1);
2579: l_cntr NUMBER;
2572: l_entity_pk1 PO_TBL_VARCHAR240;
2573: l_entity_pk2 PO_TBL_VARCHAR240;
2574: l_edited_entity_pk2 PO_TBL_VARCHAR240;
2575: l_entity_pk3 PO_TBL_VARCHAR240;
2576: l_entity_pk4 PO_TBL_VARCHAR240;
2577: l_sum_check_tbl PO_TBL_NUMBER;
2578: l_conc_mods_enabled_flag VARCHAR2(1);
2579: l_cntr NUMBER;
2580: x_results PO_VALIDATION_RESULTS_TYPE;
2720: END IF;
2721:
2722: --check if locked
2723: l_entity_names_tbl := PO_TBL_VARCHAR30('PO_HEADER');
2724: l_entity_pk1 := PO_TBL_VARCHAR240(p_po_header_id);
2725: l_edited_entity_pk2 := PO_TBL_VARCHAR240(null);
2726: l_entity_pk3 := PO_TBL_VARCHAR240(null);
2727: l_entity_pk4 := PO_TBL_VARCHAR240(null);
2728:
2721:
2722: --check if locked
2723: l_entity_names_tbl := PO_TBL_VARCHAR30('PO_HEADER');
2724: l_entity_pk1 := PO_TBL_VARCHAR240(p_po_header_id);
2725: l_edited_entity_pk2 := PO_TBL_VARCHAR240(null);
2726: l_entity_pk3 := PO_TBL_VARCHAR240(null);
2727: l_entity_pk4 := PO_TBL_VARCHAR240(null);
2728:
2729: SELECT attr_group_id
2722: --check if locked
2723: l_entity_names_tbl := PO_TBL_VARCHAR30('PO_HEADER');
2724: l_entity_pk1 := PO_TBL_VARCHAR240(p_po_header_id);
2725: l_edited_entity_pk2 := PO_TBL_VARCHAR240(null);
2726: l_entity_pk3 := PO_TBL_VARCHAR240(null);
2727: l_entity_pk4 := PO_TBL_VARCHAR240(null);
2728:
2729: SELECT attr_group_id
2730: INTO l_addr_attr_group_id
2723: l_entity_names_tbl := PO_TBL_VARCHAR30('PO_HEADER');
2724: l_entity_pk1 := PO_TBL_VARCHAR240(p_po_header_id);
2725: l_edited_entity_pk2 := PO_TBL_VARCHAR240(null);
2726: l_entity_pk3 := PO_TBL_VARCHAR240(null);
2727: l_entity_pk4 := PO_TBL_VARCHAR240(null);
2728:
2729: SELECT attr_group_id
2730: INTO l_addr_attr_group_id
2731: FROM ego_attr_groups_v