DBA Data[Home] [Help]

APPS.PO_MULTI_MOD_PVT dependencies on PO_TBL_VARCHAR240

Line 2572: l_entity_pk1 PO_TBL_VARCHAR240;

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;

Line 2573: l_entity_pk2 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;

Line 2574: l_edited_entity_pk2 PO_TBL_VARCHAR240;

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);

Line 2575: l_entity_pk3 PO_TBL_VARCHAR240;

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;

Line 2576: l_entity_pk4 PO_TBL_VARCHAR240;

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;

Line 2724: l_entity_pk1 := PO_TBL_VARCHAR240(p_po_header_id);

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:

Line 2725: l_edited_entity_pk2 := PO_TBL_VARCHAR240(null);

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

Line 2726: l_entity_pk3 := PO_TBL_VARCHAR240(null);

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

Line 2727: l_entity_pk4 := PO_TBL_VARCHAR240(null);

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