[Home] [Help]
147: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
148: END IF;
149: l_progress := '010';
150:
151: l_template_id := po_uda_data_util.get_template_id(
152: p_functional_area => p_functional_area,
153: p_document_type => p_doc_type,
154: p_document_style_id => p_doc_style_id,
155: p_document_level => p_doc_level,
1497: -- Not usre whether we need to update po_headers_all with the new template id
1498: -- In case of add mode/new mode
1499: l_progress := '070';
1500:
1501: PO_UDA_DATA_UTIL.AutoCreate_User_Attrs
1502: (
1503: from_template_id => x_src_template_id
1504: ,to_template_id => g_target_uda_template_id
1505: ,from_pk_col_value_pairs => from_pk_col_value_pairs
1514:
1515: IF g_debug_stmt THEN
1516: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
1517: , p_token => l_progress
1518: , p_message => ' After Calling PO_UDA_DATA_UTIL.AutoCreate_User_Attrs
1519: Return Status ' || x_return_status || ' Message Count :' || x_msg_count
1520: ||' Message Data: '|| x_msg_data
1521: );
1522: END IF;
1988:
1989: IF l_attr_group_tbl.Count > 0 THEN
1990:
1991: l_progress := '140';
1992: po_uda_data_util.autocreate_user_attrs
1993: (
1994: from_template_id => l_src_template_id
1995: ,to_template_id => l_target_template_id
1996: ,from_pk_col_value_pairs => from_pk_col_value_pairs
2004: );
2005: IF g_debug_stmt THEN
2006: po_debug.debug_stmt(p_log_head => g_log_head||l_api_name
2007: , p_token => l_progress
2008: , p_message => ' After Calling PO_UDA_DATA_UTIL.AutoCreate_User_Attrs
2009: Return Status ' || x_return_status || ' Message Count :' || x_msg_count
2010: ||' Message Data: '|| x_msg_data
2011: );
2012: END IF;
2279: THEN
2280: l_progress := '150';
2281: ego_user_attrs_data_pvt.process_user_attrs_data (
2282: p_api_version => 1.0
2283: ,p_object_name => PO_UDA_DATA_UTIL.g_object_dff_tl('PO_HEADER_EXT_ATTRS').l_object_name
2284: ,p_attributes_row_table => l_attributes_row_table--from Previous STEP but change the ATTR_GROUP_ID here as for the target
2285: ,p_attributes_data_table => l_attr_name_value_pairs --can be same object got from previous step
2286: ,p_pk_column_name_value_pairs => g_tar_head_col_name_val_pairs
2287: ,p_class_code_name_value_pairs => l_class_code_name_value_pairs -- pass { "UDA_TEMPLATE_ID", 343 }
2454: ,l_attr_list
2455: );
2456:
2457: l_progress := '060';
2458: l_src_object_name := PO_UDA_DATA_UTIL.g_object_dff_tl(p_ag_type).l_object_name;
2459:
2460: l_progress := '080';
2461: ego_user_attrs_data_pvt.get_user_attrs_data(
2462: p_api_version => 1.0
2513: LOOP
2514: l_process_attr_data_tbl(i).ROW_IDENTIFIER := l_new_extension_id;
2515: END LOOP;
2516:
2517: l_target_object_name := PO_UDA_DATA_UTIL.g_object_dff_tl('PO_HEADER_EXT_ATTRS').l_object_name;
2518:
2519: l_progress := '160';
2520: ego_user_attrs_data_pvt.process_user_attrs_data (
2521: p_api_version => 1.0
3002:
3003: ego_user_attrs_data_pub.Get_User_Attrs_Data
3004: (
3005: p_api_version => 1.0
3006: ,p_object_name => PO_UDA_DATA_UTIL.g_object_dff_tl(l_entity_code).l_object_name
3007: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs
3008: ,p_attr_group_request_table => l_attr_group_request_table
3009: ,x_attributes_row_table => l_attributes_row_table
3010: ,x_attributes_data_table => l_attr_name_value_pairs
3378: l_progress VARCHAR2(3) := '000';
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;
3449: );
3450: END IF;
3451:
3452:
3453: l_object_dff_cr := PO_UDA_DATA_UTIL.g_object_dff_tl(l_attr_group_Type);
3454:
3455: SELECT object_id
3456: INTO l_object_id
3457: FROM FND_OBJECTS