DBA Data[Home] [Help]

APPS.PO_UDA_DEFAULTING_PKG dependencies on EGO_COL_NAME_VALUE_PAIR_OBJ

Line 395: l_context EGO_COL_NAME_VALUE_PAIR_OBJ;

391: l_contract_type VARCHAR2(200);
392: l_doc_type VARCHAR2(200);
393: l_issuing_off VARCHAR2(200);
394:
395: l_context EGO_COL_NAME_VALUE_PAIR_OBJ;
396:
397: d_progress NUMBER := 0;
398: l_err_txt VARCHAR2(2000);
399:

Line 450: l_context := EGO_COL_NAME_VALUE_PAIR_OBJ( 'IDC_TYPE', l_idc_type);

446: FETCH c_get_usage_context1 INTO l_idc_type, l_contract_type;
447: CLOSE c_get_usage_context1;
448:
449: d_progress := 90;
450: l_context := EGO_COL_NAME_VALUE_PAIR_OBJ( 'IDC_TYPE', l_idc_type);
451: l_context_array.EXTEND(1);
452: l_context_array(l_context_array.COUNT) := l_context;
453: l_context := EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type);
454: l_context_array.EXTEND(1);

Line 453: l_context := EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type);

449: d_progress := 90;
450: l_context := EGO_COL_NAME_VALUE_PAIR_OBJ( 'IDC_TYPE', l_idc_type);
451: l_context_array.EXTEND(1);
452: l_context_array(l_context_array.COUNT) := l_context;
453: l_context := EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type);
454: l_context_array.EXTEND(1);
455: l_context_array(l_context_array.COUNT) := l_context;
456:
457: d_progress := 100;

Line 468: l_context := EGO_COL_NAME_VALUE_PAIR_OBJ( 'FORM_TYPE', l_std_form);

464: FETCH c_get_usage_context2 INTO l_std_form;
465: CLOSE c_get_usage_context2;
466:
467: d_progress := 130;
468: l_context := EGO_COL_NAME_VALUE_PAIR_OBJ( 'FORM_TYPE', l_std_form);
469: l_context_array.EXTEND(1);
470: l_context_array(l_context_array.COUNT) := l_context;
471: d_progress := 140;
472: end if;

Line 607: l_pk_column_name_value EGO_COL_NAME_VALUE_PAIR_OBJ;

603: l_attr_name_value_pairs_ind NUMBER;
604: l_attributes_row_table_ind NUMBER;
605: l_attr_group_request_table_ind NUMBER;
606:
607: l_pk_column_name_value EGO_COL_NAME_VALUE_PAIR_OBJ;
608: l_attr_name_value EGO_USER_ATTR_DATA_OBJ;
609: l_attributes_row ego_user_attr_row_obj;
610: l_attr_group_request ego_attr_group_request_obj;
611:

Line 1055: ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

1051: l_vendor_site_id NUMBER;
1052: l_vendor_contact_id NUMBER;
1053:
1054: g_xsc_return_status VARCHAR2(3) := FND_API.G_RET_STS_SUCCESS;
1055: ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
1056:
1057: l_err_txt VARCHAR2(2000);
1058:
1059: BEGIN

Line 1904: ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

1900: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1901:
1902: l_failed_row_id_list VARCHAR2(2000);
1903: l_entity_code VARCHAR2(200);
1904: ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
1905:
1906: l_err_txt VARCHAR2(2000);
1907:
1908: BEGIN

Line 1961: EGO_COL_NAME_VALUE_PAIR_OBJ

1957: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized objects l_attributes_row_table, l_attr_name_value_pairs', d_progress);
1958: d_progress := 80;
1959: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
1960: (
1961: EGO_COL_NAME_VALUE_PAIR_OBJ
1962: (
1963: 'UDA_TEMPLATE_ID'
1964: ,p_template_id || ''
1965: )

Line 2244: l_pk_column_name_value EGO_COL_NAME_VALUE_PAIR_OBJ;

2240: l_attr_name_value_pairs_ind NUMBER;
2241: l_attributes_row_table_ind NUMBER;
2242: l_attr_group_request_table_ind NUMBER;
2243:
2244: l_pk_column_name_value EGO_COL_NAME_VALUE_PAIR_OBJ;
2245: l_attr_name_value EGO_USER_ATTR_DATA_OBJ;
2246: l_attributes_row ego_user_attr_row_obj;
2247: l_attr_group_request ego_attr_group_request_obj;
2248: l_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;

Line 2249: ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

2245: l_attr_name_value EGO_USER_ATTR_DATA_OBJ;
2246: l_attributes_row ego_user_attr_row_obj;
2247: l_attr_group_request ego_attr_group_request_obj;
2248: l_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;
2249: ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
2250:
2251: l_base_object_name VARCHAR2(200);
2252: l_failed_row_id_list VARCHAR2(2000);
2253:

Line 2510: EGO_COL_NAME_VALUE_PAIR_OBJ

2506: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized objects l_attributes_row_table, l_attr_name_value_pairs' , d_progress);
2507:
2508: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
2509: (
2510: EGO_COL_NAME_VALUE_PAIR_OBJ
2511: (
2512: 'UDA_TEMPLATE_ID'
2513: ,p_template_id || ''
2514: )

Line 2866: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ

2862: END;
2863:
2864: IF p_pk1_value IS NOT NULL THEN
2865: x_pk_column_name_value_pairs.EXTEND(1);
2866: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ
2867: (
2868: l_pk1_column_name, p_pk1_value
2869: );
2870: END IF;

Line 2873: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ

2869: );
2870: END IF;
2871: IF p_pk2_value IS NOT NULL THEN
2872: x_pk_column_name_value_pairs.EXTEND(1);
2873: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ
2874: (
2875: l_pk2_column_name, p_pk2_value
2876: );
2877: END IF;

Line 2880: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ

2876: );
2877: END IF;
2878: IF p_pk3_value IS NOT NULL THEN
2879: x_pk_column_name_value_pairs.EXTEND(1);
2880: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ
2881: (
2882: l_pk3_column_name, p_pk3_value
2883: );
2884: END IF;

Line 2887: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ

2883: );
2884: END IF;
2885: IF p_pk4_value IS NOT NULL THEN
2886: x_pk_column_name_value_pairs.EXTEND(1);
2887: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ
2888: (
2889: l_pk4_column_name, p_pk4_value
2890: );
2891: END IF;

Line 2894: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ

2890: );
2891: END IF;
2892: IF p_pk5_value IS NOT NULL THEN
2893: x_pk_column_name_value_pairs.EXTEND(1);
2894: x_pk_column_name_value_pairs(x_pk_column_name_value_pairs.COUNT) := EGO_COL_NAME_VALUE_PAIR_OBJ
2895: (
2896: l_pk5_column_name, p_pk5_value
2897: );
2898: END IF;

Line 2941: EGO_COL_NAME_VALUE_PAIR_OBJ

2937: PO_UDA_DEFAULTING_PKG.DEBUG(' p_ext_attr_value ' || p_ext_attr_value, 0);
2938:
2939: IF x_external_attr_value_pairs IS NULL THEN
2940: x_external_attr_value_pairs := EGO_COL_NAME_VALUE_PAIR_TABLE(
2941: EGO_COL_NAME_VALUE_PAIR_OBJ
2942: (
2943: 'x_msg_data'
2944: ,NULL
2945: ),

Line 2946: EGO_COL_NAME_VALUE_PAIR_OBJ

2942: (
2943: 'x_msg_data'
2944: ,NULL
2945: ),
2946: EGO_COL_NAME_VALUE_PAIR_OBJ
2947: (
2948: 'x_msg_count'
2949: ,NULL
2950: ),

Line 2951: EGO_COL_NAME_VALUE_PAIR_OBJ

2947: (
2948: 'x_msg_count'
2949: ,NULL
2950: ),
2951: EGO_COL_NAME_VALUE_PAIR_OBJ
2952: (
2953: 'x_errorcode'
2954: ,NULL
2955: ),

Line 2956: EGO_COL_NAME_VALUE_PAIR_OBJ

2952: (
2953: 'x_errorcode'
2954: ,NULL
2955: ),
2956: EGO_COL_NAME_VALUE_PAIR_OBJ
2957: (
2958: 'x_return_status'
2959: ,NULL
2960: ),

Line 2961: EGO_COL_NAME_VALUE_PAIR_OBJ

2957: (
2958: 'x_return_status'
2959: ,NULL
2960: ),
2961: EGO_COL_NAME_VALUE_PAIR_OBJ
2962: (
2963: 'VENDOR_CONTACT_ID'
2964: ,NULL
2965: ),

Line 2966: EGO_COL_NAME_VALUE_PAIR_OBJ

2962: (
2963: 'VENDOR_CONTACT_ID'
2964: ,NULL
2965: ),
2966: EGO_COL_NAME_VALUE_PAIR_OBJ
2967: (
2968: 'VENDOR_SITE_ID'
2969: ,NULL
2970: ),

Line 2971: EGO_COL_NAME_VALUE_PAIR_OBJ

2967: (
2968: 'VENDOR_SITE_ID'
2969: ,NULL
2970: ),
2971: EGO_COL_NAME_VALUE_PAIR_OBJ
2972: (
2973: 'VENDOR_ID'
2974: ,NULL
2975: ),

Line 2976: EGO_COL_NAME_VALUE_PAIR_OBJ

2972: (
2973: 'VENDOR_ID'
2974: ,NULL
2975: ),
2976: EGO_COL_NAME_VALUE_PAIR_OBJ
2977: (
2978: 'ITEM_ID'
2979: ,NULL
2980: ),

Line 2981: EGO_COL_NAME_VALUE_PAIR_OBJ

2977: (
2978: 'ITEM_ID'
2979: ,NULL
2980: ),
2981: EGO_COL_NAME_VALUE_PAIR_OBJ
2982: (
2983: 'LINE_TYPE_ID'
2984: ,NULL
2985: ),

Line 2986: EGO_COL_NAME_VALUE_PAIR_OBJ

2982: (
2983: 'LINE_TYPE_ID'
2984: ,NULL
2985: ),
2986: EGO_COL_NAME_VALUE_PAIR_OBJ
2987: (
2988: 'SHIP_TO_LOC_ID'
2989: ,NULL
2990: ),

Line 2991: EGO_COL_NAME_VALUE_PAIR_OBJ

2987: (
2988: 'SHIP_TO_LOC_ID'
2989: ,NULL
2990: ),
2991: EGO_COL_NAME_VALUE_PAIR_OBJ
2992: (
2993: 'ORG_ID'
2994: ,NULL
2995: ),

Line 2996: EGO_COL_NAME_VALUE_PAIR_OBJ

2992: (
2993: 'ORG_ID'
2994: ,NULL
2995: ),
2996: EGO_COL_NAME_VALUE_PAIR_OBJ
2997: (
2998: 'AGENT_ID'
2999: ,NULL
3000: ),

Line 3001: EGO_COL_NAME_VALUE_PAIR_OBJ

2997: (
2998: 'AGENT_ID'
2999: ,NULL
3000: ),
3001: EGO_COL_NAME_VALUE_PAIR_OBJ
3002: (
3003: 'CONTRACT_TYPE'
3004: ,NULL
3005: ),

Line 3006: EGO_COL_NAME_VALUE_PAIR_OBJ

3002: (
3003: 'CONTRACT_TYPE'
3004: ,NULL
3005: ),
3006: EGO_COL_NAME_VALUE_PAIR_OBJ
3007: (
3008: 'CATEGORY_ID'
3009: ,NULL
3010: ),

Line 3011: EGO_COL_NAME_VALUE_PAIR_OBJ

3007: (
3008: 'CATEGORY_ID'
3009: ,NULL
3010: ),
3011: EGO_COL_NAME_VALUE_PAIR_OBJ
3012: (
3013: 'PREPARER_ID'
3014: ,NULL
3015: ),

Line 3016: EGO_COL_NAME_VALUE_PAIR_OBJ

3012: (
3013: 'PREPARER_ID'
3014: ,NULL
3015: ),
3016: EGO_COL_NAME_VALUE_PAIR_OBJ
3017: (
3018: 'BASE_AUCTION_HEADER_ID'
3019: ,NULL
3020: ),

Line 3021: EGO_COL_NAME_VALUE_PAIR_OBJ

3017: (
3018: 'BASE_AUCTION_HEADER_ID'
3019: ,NULL
3020: ),
3021: EGO_COL_NAME_VALUE_PAIR_OBJ
3022: (
3023: 'DELIMITER'
3024: ,NULL
3025: ),

Line 3026: EGO_COL_NAME_VALUE_PAIR_OBJ

3022: (
3023: 'DELIMITER'
3024: ,NULL
3025: ),
3026: EGO_COL_NAME_VALUE_PAIR_OBJ
3027: (
3028: 'p_source_doc_number'
3029: ,NULL
3030: )

Line 3075: x_external_attr_value_pairs(l_index) := EGO_COL_NAME_VALUE_PAIR_OBJ(p_ext_attr_name, p_ext_attr_value);

3071: PO_UDA_DEFAULTING_PKG.DEBUG('The Name Value Pair does not have an index defined (Check PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR)', 0);
3072: RETURN;
3073: END IF;
3074:
3075: x_external_attr_value_pairs(l_index) := EGO_COL_NAME_VALUE_PAIR_OBJ(p_ext_attr_name, p_ext_attr_value);
3076: EXCEPTION
3077: WHEN OTHERS THEN
3078: PO_UDA_DEFAULTING_PKG.DEBUG(SQLERRM, 0);
3079: RAISE;

Line 3086: ,x_ext_name_val_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ

3082: PROCEDURE GET_EXT_ATTR_NAME_VALUE_PAIR
3083: (
3084: p_ext_attr_name IN VARCHAR2
3085: ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
3086: ,x_ext_name_val_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
3087: )
3088: IS
3089: MSG_DATA_IND NUMBER := 1;
3090: MSG_COUNT_IND NUMBER := 2;

Line 3169: l_structure EGO_COL_NAME_VALUE_PAIR_OBJ;

3165: ,p_progress IN NUMBER
3166: )
3167: IS
3168: l_structure_ind NUMBER;
3169: l_structure EGO_COL_NAME_VALUE_PAIR_OBJ;
3170: BEGIN
3171: IF PO_LOG.d_stmt then --bug 12611018
3172: IF p_structure_array IS NOT NULL THEN
3173: l_structure_ind := p_structure_array.FIRST;

Line 3198: l_structure EGO_COL_NAME_VALUE_PAIR_OBJ;

3194: ,p_progress IN NUMBER
3195: )
3196: IS
3197: l_structure_ind NUMBER;
3198: l_structure EGO_COL_NAME_VALUE_PAIR_OBJ;
3199: BEGIN
3200: IF PO_LOG.d_stmt THEN --bug 12611018
3201:
3202: IF p_structure_array IS NOT NULL THEN