eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_UDA_AUTOCREATE_PKG dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 11: g_tar_head_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

7:
8: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
9: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
10:
11: g_tar_head_col_name_val_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
12:
13: g_src_func_area VARCHAR2(100);
14: g_src_doc_type VARCHAR2(100);
15: g_src_doc_style NUMBER;

Line 46: ,p_src_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

42:
43: PROCEDURE auto_default_sys_addresses (p_address_type IN VARCHAR2,x_return_status OUT NOCOPY VARCHAR2);
44:
45: PROCEDURE process_addresses(p_ag_type IN VARCHAR2
46: ,p_src_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
47: ,p_src_uda_template_id IN NUMBER
48: ,p_attr_group_id IN NUMBER
49: ,p_address_type IN VARCHAR2
50: ,p_extension_id IN NUMBER

Line 1350: from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1346: x_return_status VARCHAR2(1);
1347: x_msg_count NUMBER;
1348: x_msg_data VARCHAR2(2000);
1349:
1350: from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1351: to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1352:
1353: from_template_id NUMBER;
1354: to_template_id NUMBER;

Line 1351: to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1347: x_msg_count NUMBER;
1348: x_msg_data VARCHAR2(2000);
1349:
1350: from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1351: to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1352:
1353: from_template_id NUMBER;
1354: to_template_id NUMBER;
1355:

Line 1440: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

1436:
1437: IF x_pk2_col_name IS NOT NULL AND x_pk2_value IS NOT NULL
1438: THEN
1439:
1440: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1441: EGO_COL_NAME_VALUE_PAIR_OBJ(
1442: x_pk1_col_name, x_pk1_value
1443: ),
1444: EGO_COL_NAME_VALUE_PAIR_OBJ(

Line 1449: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

1445: x_pk2_col_name, x_pk2_value
1446: ));
1447:
1448: ELSE
1449: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1450: EGO_COL_NAME_VALUE_PAIR_OBJ(
1451: x_pk1_col_name, x_pk1_value
1452: ));
1453: END IF;

Line 1455: to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

1451: x_pk1_col_name, x_pk1_value
1452: ));
1453: END IF;
1454:
1455: to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1456: EGO_COL_NAME_VALUE_PAIR_OBJ(
1457: p_to_pk1_col_name,p_to_pk1_value
1458: ),
1459: EGO_COL_NAME_VALUE_PAIR_OBJ(

Line 1831: from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1827: AND pla.draft_id = po_autocreate_params.g_draft_id;
1828:
1829: l_src_template_id NUMBER;
1830: l_target_template_id NUMBER;
1831: from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1832: to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1833:
1834: l_to_pk1_value NUMBER;
1835: l_attr_group_tbl PO_TBL_VARCHAR30;

Line 1832: to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

1828:
1829: l_src_template_id NUMBER;
1830: l_target_template_id NUMBER;
1831: from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1832: to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1833:
1834: l_to_pk1_value NUMBER;
1835: l_attr_group_tbl PO_TBL_VARCHAR30;
1836:

Line 1881: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(

1877: ,p_message => 'l_src_template_id' || l_src_template_id
1878: );
1879: END IF;
1880:
1881: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ(
1882: 'BID_NUMBER', l_src_rec.bid_number
1883: ),
1884: EGO_COL_NAME_VALUE_PAIR_OBJ(
1885: 'LINE_NUMBER', l_src_rec.bid_line_number

Line 1931: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

1927: ,p_message => 'l_src_template_id' || l_src_template_id
1928: );
1929: END IF;
1930:
1931: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1932: EGO_COL_NAME_VALUE_PAIR_OBJ(
1933: 'REQUISITION_LINE_ID',
1934: l_src_rec.requisition_line_id
1935: )

Line 1981: to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

1977: END IF;
1978:
1979:
1980:
1981: to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
1982: EGO_COL_NAME_VALUE_PAIR_OBJ(
1983: 'PO_LINE_ID',l_to_pk1_value
1984: ),
1985: EGO_COL_NAME_VALUE_PAIR_OBJ(

Line 2048: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

2044:
2045: l_api_name VARCHAR2(30) := 'auto_default_sys_addresses';
2046: l_progress VARCHAR2(3) := '000';
2047:
2048: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2049:
2050:
2051:
2052: x_errorcode NUMBER;

Line 2066: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;

2062: x_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;
2063:
2064: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
2065: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;
2066: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
2067:
2068: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2069:
2070: l_address_lookup_type varchar2(100);

Line 2068: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

2064: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
2065: l_po_uda_usage_object PO_UDA_USAGE_OBJECT;
2066: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
2067:
2068: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2069:
2070: l_address_lookup_type varchar2(100);
2071:
2072: l_attr_grp_ids_list po_tbl_NUMBER;

Line 2130: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

2126:
2127: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
2128: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
2129:
2130: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
2131: (
2132: EGO_COL_NAME_VALUE_PAIR_OBJ
2133: (
2134: 'UDA_TEMPLATE_ID'

Line 2149: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY();

2145:
2146:
2147: l_po_uda_usage_object := PO_UDA_USAGE_OBJECT();
2148: l_po_uda_usage_object_array := PO_UDA_USAGE_OBJECT_ARRAY();
2149: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2150:
2151: l_po_uda_usage_object := po_uda_usage_object.new_instance(g_tar_header_uda_template_id,'ADDRESS',l_context );
2152: l_attr_grp_ids_list := l_po_uda_usage_object.Attr_group_Id;
2153: l_attr_group_id := l_attr_grp_ids_list(1);

Line 2346: ,p_src_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY

2342:
2343:
2344: /* For address the level is alaways the Header */
2345: PROCEDURE process_addresses(p_ag_type IN VARCHAR2
2346: ,p_src_pk_col_name_val_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2347: ,p_src_uda_template_id IN NUMBER
2348: ,p_attr_group_id IN NUMBER
2349: ,p_address_type IN VARCHAR2
2350: ,p_extension_id IN NUMBER

Line 2376: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

2372: l_attr_list VARCHAR2(2000);
2373:
2374: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
2375:
2376: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2377:
2378: l_tar_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
2379:
2380: l_src_data_level VARCHAR2(100);

Line 2503: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(ego_col_name_value_pair_obj('UDA_TEMPLATE_ID',g_tar_header_uda_template_id ||'' ));

2499: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL
2500: INTO l_new_extension_id
2501: FROM dual;
2502:
2503: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(ego_col_name_value_pair_obj('UDA_TEMPLATE_ID',g_tar_header_uda_template_id ||'' ));
2504:
2505: l_process_attr_row_tbl(1).ATTR_GROUP_ID := get_ag_id('PO_HEADER_EXT_ATTRS','addresses');
2506: l_process_attr_row_tbl(1).ATTR_GROUP_APP_ID := 201;
2507: l_process_attr_row_tbl(1).DATA_LEVEL :='PO_HEADER';

Line 2847: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

2843: l_api_name VARCHAR2(30) := 'exec_uda_function';
2844: l_progress VARCHAR2(3) := '000';
2845:
2846: l_entity_code VARCHAR2(200);
2847: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2848: l_data_level VARCHAR2(200);
2849:
2850: l_attr_list VARCHAR2(2000);
2851:

Line 2856: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

2852: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
2853:
2854: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
2855: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
2856: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2857:
2858: l_ext_attr_value_pairs_ind NUMBER;
2859: l_ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
2860:

Line 2906: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

2902: END IF;
2903:
2904: l_progress := '020';
2905:
2906: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2907: EGO_COL_NAME_VALUE_PAIR_OBJ(
2908: p_pk1_col_name, p_pk1_col_value
2909: ),
2910: EGO_COL_NAME_VALUE_PAIR_OBJ(

Line 3131: g_tar_head_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

3127:
3128: g_target_func_area := 'PURCHASING';
3129: g_target_doc_style := l_document_style_id;
3130:
3131: g_tar_head_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3132: EGO_COL_NAME_VALUE_PAIR_OBJ(
3133: 'PO_HEADER_ID', po_autocreate_params.g_po_header_id
3134: ),
3135: EGO_COL_NAME_VALUE_PAIR_OBJ(

Line 3383: l_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3379:
3380: l_object_id FND_OBJECTS.object_id%TYPE;
3381: l_attr_group_Type VARCHAR2(300);
3382: l_object_dff_cr PO_UDA_DATA_UTIL.g_object_dff_cr;
3383: l_dtlevel_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3384: l_main_data_level_id EGO_DATA_LEVEL_B.data_level_id%TYPE;
3385: x_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;
3386: x_errorcode NUMBER;
3387:

Line 3389: from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3385: x_external_attr_value_pairs EGO_COL_NAME_VALUE_PAIR_TABLE;
3386: x_errorcode NUMBER;
3387:
3388:
3389: from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3390: to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3391:
3392: x_pk1_col_name VARCHAR2(100);
3393: x_pk1_value NUMBER;

Line 3390: to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3386: x_errorcode NUMBER;
3387:
3388:
3389: from_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3390: to_pk_col_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3391:
3392: x_pk1_col_name VARCHAR2(100);
3393: x_pk1_value NUMBER;
3394: x_pk2_col_name VARCHAR2(100);

Line 3423: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

3419: , p_message => 'x_src_template_id :'||x_src_template_id
3420: );
3421: END IF;
3422:
3423: from_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3424: EGO_COL_NAME_VALUE_PAIR_OBJ(
3425: 'PO_HEADER_ID', po_autocreate_params.g_po_header_id
3426: ),
3427: EGO_COL_NAME_VALUE_PAIR_OBJ(

Line 3430: to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

3426: ),
3427: EGO_COL_NAME_VALUE_PAIR_OBJ(
3428: 'DRAFT_ID', -1
3429: ));
3430: to_pk_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3431: EGO_COL_NAME_VALUE_PAIR_OBJ(
3432: 'PO_HEADER_ID', po_autocreate_params.g_po_header_id
3433: ),
3434: EGO_COL_NAME_VALUE_PAIR_OBJ(

Line 3474: l_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

3470: END IF;
3471:
3472: END;
3473:
3474: l_dtlevel_col_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
3475: EGO_COL_NAME_VALUE_PAIR_OBJ(
3476: 'PK1_VALUE', null
3477: )
3478: );