DBA Data[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 3411: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3407: l_attr_metadata_table EGO_ATTR_METADATA_TABLE;
3408: l_curr_attr_index NUMBER;
3409: l_curr_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
3410: l_to_char_db_col_expression VARCHAR2(90);
3411: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3412: l_aliased_attr_names VARCHAR2(32000);
3413: l_user_attrs_view_ddl VARCHAR2(32757);
3414: l_ddl_error_message VARCHAR2(1000);
3415: l_token_table ERROR_HANDLER.Token_Tbl_Type;

Line 3573: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

3569:
3570: IF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 5 AND
3571: l_ext_table_metadata_obj.pk_column_metadata(5) IS NOT NULL AND
3572: l_ext_table_metadata_obj.pk_column_metadata(5).COL_NAME IS NOT NULL) THEN
3573: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3574: EGO_COL_NAME_VALUE_PAIR_OBJ(l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME)
3575: ,EGO_COL_NAME_VALUE_PAIR_OBJ(l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME)
3576: ,EGO_COL_NAME_VALUE_PAIR_OBJ(l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME)
3577: ,EGO_COL_NAME_VALUE_PAIR_OBJ(l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME)

Line 3583: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

3579: );
3580: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 4 AND
3581: l_ext_table_metadata_obj.pk_column_metadata(4) IS NOT NULL AND
3582: l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME IS NOT NULL) THEN
3583: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3584: EGO_COL_NAME_VALUE_PAIR_OBJ(l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME)
3585: ,EGO_COL_NAME_VALUE_PAIR_OBJ(l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME)
3586: ,EGO_COL_NAME_VALUE_PAIR_OBJ(l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME)
3587: ,EGO_COL_NAME_VALUE_PAIR_OBJ(l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME, l_ext_table_metadata_obj.pk_column_metadata(4).COL_NAME)

Line 3592: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

3588: );
3589: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 3 AND
3590: l_ext_table_metadata_obj.pk_column_metadata(3) IS NOT NULL AND
3591: l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME IS NOT NULL) THEN
3592: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3593: EGO_COL_NAME_VALUE_PAIR_OBJ(l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME)
3594: ,EGO_COL_NAME_VALUE_PAIR_OBJ(l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME)
3595: ,EGO_COL_NAME_VALUE_PAIR_OBJ(l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME, l_ext_table_metadata_obj.pk_column_metadata(3).COL_NAME)
3596: );

Line 3600: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

3596: );
3597: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 2 AND
3598: l_ext_table_metadata_obj.pk_column_metadata(2) IS NOT NULL AND
3599: l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME IS NOT NULL) THEN
3600: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3601: EGO_COL_NAME_VALUE_PAIR_OBJ(l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME)
3602: ,EGO_COL_NAME_VALUE_PAIR_OBJ(l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME, l_ext_table_metadata_obj.pk_column_metadata(2).COL_NAME)
3603: );
3604: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 1 AND

Line 3607: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

3603: );
3604: ELSIF (l_ext_table_metadata_obj.pk_column_metadata.COUNT = 1 AND
3605: l_ext_table_metadata_obj.pk_column_metadata(1) IS NOT NULL AND
3606: l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME IS NOT NULL) THEN
3607: p_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3608: EGO_COL_NAME_VALUE_PAIR_OBJ(l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME, l_ext_table_metadata_obj.pk_column_metadata(1).COL_NAME)
3609: );
3610: END IF;
3611: END IF;

Line 15579: ,p_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

15575: -- Execute_Function
15576: --------------------------------------------------------------------------------------------
15577: PROCEDURE Execute_Function(
15578: p_Action_Id IN Number
15579: ,p_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15580: ,p_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
15581: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
15582: ,x_attributes_data_table IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
15583: ,x_external_attrs_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE

Line 15580: ,p_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

15576: --------------------------------------------------------------------------------------------
15577: PROCEDURE Execute_Function(
15578: p_Action_Id IN Number
15579: ,p_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15580: ,p_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
15581: ,x_attributes_row_table IN OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
15582: ,x_attributes_data_table IN OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
15583: ,x_external_attrs_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
15584: ,x_return_status OUT NOCOPY VARCHAR2