DBA Data[Home] [Help]

APPS.POS_VENDOR_PUB_PKG dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 3141: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY,

3137: PROCEDURE Process_User_Attrs_Data (
3138: p_api_version IN NUMBER,
3139: p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE,
3140: p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE,
3141: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY,
3142: p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY,
3143: p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL,
3144: p_entity_id IN NUMBER DEFAULT NULL,
3145: p_entity_index IN NUMBER DEFAULT NULL,

Line 3142: p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY,

3138: p_api_version IN NUMBER,
3139: p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE,
3140: p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE,
3141: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY,
3142: p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY,
3143: p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL,
3144: p_entity_id IN NUMBER DEFAULT NULL,
3145: p_entity_index IN NUMBER DEFAULT NULL,
3146: p_entity_code IN VARCHAR2 DEFAULT NULL,

Line 3194: l_data_level_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY := NULL;

3190: --l_object_id NUMBER := NULL;
3191: l_object_name VARCHAR2(430) := NULL;
3192:
3193: l_row_attrs_table EGO_USER_ATTR_DATA_TABLE := NULL;
3194: l_data_level_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY := NULL;
3195:
3196: l_entity_id VARCHAR2(1000) := NULL;
3197: l_message_type VARCHAR2(1000) := NULL;
3198:

Line 3206: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

3202: x_return_status := 'S';
3203:
3204: FOR i IN 1 .. p_attributes_row_table.count LOOP
3205: IF (p_attributes_row_table(i).data_level = 'SUPP_LEVEL') THEN
3206: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3207: EGO_COL_NAME_VALUE_PAIR_OBJ('IS_PROSPECT', p_attributes_row_table(i).data_level_1));
3208: ELSIF (p_attributes_row_table(i).data_level = 'SUPP_ADDR_LEVEL') THEN
3209: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3210: EGO_COL_NAME_VALUE_PAIR_OBJ('IS_PROSPECT', p_attributes_row_table(i).data_level_1)

Line 3209: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

3205: IF (p_attributes_row_table(i).data_level = 'SUPP_LEVEL') THEN
3206: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3207: EGO_COL_NAME_VALUE_PAIR_OBJ('IS_PROSPECT', p_attributes_row_table(i).data_level_1));
3208: ELSIF (p_attributes_row_table(i).data_level = 'SUPP_ADDR_LEVEL') THEN
3209: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3210: EGO_COL_NAME_VALUE_PAIR_OBJ('IS_PROSPECT', p_attributes_row_table(i).data_level_1)
3211: , EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', p_attributes_row_table(i).data_level_2));
3212: ELSIF (p_attributes_row_table(i).data_level = 'SUPP_ADDR_SITE_LEVEL') THEN
3213: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

Line 3213: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

3209: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3210: EGO_COL_NAME_VALUE_PAIR_OBJ('IS_PROSPECT', p_attributes_row_table(i).data_level_1)
3211: , EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', p_attributes_row_table(i).data_level_2));
3212: ELSIF (p_attributes_row_table(i).data_level = 'SUPP_ADDR_SITE_LEVEL') THEN
3213: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3214: EGO_COL_NAME_VALUE_PAIR_OBJ('IS_PROSPECT', p_attributes_row_table(i).data_level_1)
3215: , EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', p_attributes_row_table(i).data_level_2)
3216: , EGO_COL_NAME_VALUE_PAIR_OBJ('PK2_VALUE', p_attributes_row_table(i).data_level_3));
3217: END IF;

Line 3282: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY,

3278:
3279:
3280: PROCEDURE Get_User_Attrs_Data (
3281: p_api_version IN NUMBER,
3282: p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY,
3283: p_attr_group_request_table IN EGO_ATTR_GROUP_REQUEST_TABLE,
3284: p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL,
3285: p_entity_id IN VARCHAR2 DEFAULT NULL,
3286: p_entity_index IN NUMBER DEFAULT NULL,