DBA Data[Home] [Help]

APPS.POS_MERGE_SUPPLIER_PKG dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 2787: l_pk_column_values ego_col_name_value_pair_array;

2783: x_msg_count OUT NOCOPY NUMBER,
2784: x_msg_data OUT NOCOPY VARCHAR2
2785: ) IS
2786: l_request_table ego_attr_group_request_table := ego_attr_group_request_table(NULL);
2787: l_pk_column_values ego_col_name_value_pair_array;
2788: l_class_code_name_value_pairs ego_col_name_value_pair_array := ego_col_name_value_pair_array(NULL);
2789: l_party_id NUMBER;
2790: l_party_site_id NUMBER;
2791:

Line 2788: l_class_code_name_value_pairs ego_col_name_value_pair_array := ego_col_name_value_pair_array(NULL);

2784: x_msg_data OUT NOCOPY VARCHAR2
2785: ) IS
2786: l_request_table ego_attr_group_request_table := ego_attr_group_request_table(NULL);
2787: l_pk_column_values ego_col_name_value_pair_array;
2788: l_class_code_name_value_pairs ego_col_name_value_pair_array := ego_col_name_value_pair_array(NULL);
2789: l_party_id NUMBER;
2790: l_party_site_id NUMBER;
2791:
2792: l_attributes_row_table ego_user_attr_row_table := ego_user_attr_row_table(NULL);

Line 2845: l_pk_column_values := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('PARTY_ID',

2841:
2842: /* Build the Primary key Name value pairs */
2843: IF (p_data_level_id = 17701) THEN
2844:
2845: l_pk_column_values := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('PARTY_ID',
2846: to_char(p_to_party_id)));
2847: ELSIF (p_data_level_id = 17702) THEN
2848: BEGIN
2849: SELECT party_id

Line 2862: l_pk_column_values := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('PARTY_ID',

2858: p_to_party_id);
2859: x_return_status := fnd_api.g_ret_sts_error;
2860: RETURN;
2861: END;
2862: l_pk_column_values := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('PARTY_ID',
2863: to_char(l_party_id)));
2864:
2865: ELSIF (p_data_level_id = 17703) THEN
2866: BEGIN

Line 2895: l_pk_column_values := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('PARTY_ID',

2891: p_to_party_id);
2892: x_return_status := fnd_api.g_ret_sts_error;
2893: RETURN;
2894: END;
2895: l_pk_column_values := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('PARTY_ID',
2896: to_char(l_party_id)));
2897: END IF;
2898:
2899: /* Build the Attribute group Object */

Line 3436: l_class_code_name_value_pairs := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('CLASSIFICATION_CODE',

3432: l_attributes_data_table2(i)
3433: .user_row_identifier);
3434: END LOOP;
3435:
3436: l_class_code_name_value_pairs := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('CLASSIFICATION_CODE',
3437: p_class_code));
3438:
3439: ego_user_attrs_data_pub.process_user_attrs_data(p_api_version => 1.0,
3440: p_object_name => 'HZ_PARTIES',

Line 3483: l_class_code_name_value_pairs := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('CLASSIFICATION_CODE',

3479: END LOOP;
3480:
3481: l_attributes_row_table.trim;
3482:
3483: l_class_code_name_value_pairs := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('CLASSIFICATION_CODE',
3484: p_class_code));
3485:
3486: /* Call the EGO API to process the attributes based on the mode */
3487:

Line 3543: l_pk_column_values ego_col_name_value_pair_array;

3539: x_msg_count OUT NOCOPY NUMBER,
3540: x_msg_data OUT NOCOPY VARCHAR2
3541: ) IS
3542: l_request_table ego_attr_group_request_table := ego_attr_group_request_table(NULL);
3543: l_pk_column_values ego_col_name_value_pair_array;
3544:
3545: l_attributes_row_table ego_user_attr_row_table := ego_user_attr_row_table(NULL);
3546: l_attributes_data_table ego_user_attr_data_table := ego_user_attr_data_table(NULL);
3547: l_row_identifier NUMBER;

Line 3556: l_class_code_name_value_pairs ego_col_name_value_pair_array := ego_col_name_value_pair_array(NULL);

3552: l_msg_data VARCHAR2(100);
3553: l_errorcode NUMBER;
3554: l_error_msg_tbl error_handler.error_tbl_type;
3555:
3556: l_class_code_name_value_pairs ego_col_name_value_pair_array := ego_col_name_value_pair_array(NULL);
3557: l_party_id NUMBER;
3558: l_party_site_id NUMBER;
3559: BEGIN
3560: x_return_status := fnd_api.g_ret_sts_success;

Line 3569: l_pk_column_values := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('PARTY_ID',

3565:
3566: /* Build the Primary key Name value pairs */
3567: IF (p_data_level_id = 17701) THEN
3568:
3569: l_pk_column_values := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('PARTY_ID',
3570: to_char(p_to_party_id)));
3571: ELSIF (p_data_level_id = 17702) THEN
3572:
3573: BEGIN

Line 3587: l_pk_column_values := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('PARTY_ID',

3583: p_to_party_id);
3584: x_return_status := fnd_api.g_ret_sts_error;
3585: RETURN;
3586: END;
3587: l_pk_column_values := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('PARTY_ID',
3588: to_char(l_party_id)));
3589:
3590: ELSIF (p_data_level_id = 17703) THEN
3591: BEGIN

Line 3621: l_pk_column_values := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('PARTY_ID',

3617: x_return_status := fnd_api.g_ret_sts_error;
3618: RETURN;
3619: END;
3620:
3621: l_pk_column_values := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('PARTY_ID',
3622: to_char(l_party_id)));
3623: END IF;
3624:
3625: /* Build the Attribute group Object */

Line 3751: l_class_code_name_value_pairs := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('CLASSIFICATION_CODE',

3747: p_uda_data_rec => p_uda_rec,
3748: x_attributes_data_table => l_attributes_data_table);
3749: END IF;
3750:
3751: l_class_code_name_value_pairs := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('CLASSIFICATION_CODE',
3752: p_class_code));
3753:
3754: /* Call the EGO API to process the attributes based on the mode */
3755: