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.BOM_IMPORT_PUB dependencies on BOM_CMP_USR_ATTR_INTERFACE

Line 1690: UPDATE bom_cmp_usr_attr_interface

1686: AND*/(comp_source_system_reference = l_comp_table(j).comp_source_system_reference OR component_item_number = l_comp_table(j).component_item_number)
1687: AND (parent_source_system_reference = l_comp_table(j).parent_source_system_reference OR assembly_item_number = l_comp_table(j).assembly_item_number)));
1688:
1689: -- IF l_comp_table(j).transaction_id IS NOT NULL THEN
1690: UPDATE bom_cmp_usr_attr_interface
1691: SET item_number = l_comp_table(j).component_item_number,
1692: assembly_item_number = l_comp_table(j).assembly_item_number,
1693: comp_source_system_reference = l_comp_table(j).comp_source_system_reference,
1694: parent_source_system_reference = l_comp_table(j).parent_source_system_reference,

Line 2341: FROM bom_cmp_usr_attr_interface BCUA

2337:
2338: CURSOR Get_Src_Attr(p_str_type_id IN NUMBER,p_attr_grp_id IN NUMBER,p_attr_grp_name IN VARCHAR2)
2339: IS
2340: SELECT BCUA.attr_group_int_name
2341: FROM bom_cmp_usr_attr_interface BCUA
2342: WHERE BCUA.batch_id = p_batch_id
2343: AND BCUA.structure_type_id = p_str_type_id
2344: AND (BCUA.attr_group_id = p_attr_grp_id OR BCUA.attr_group_int_name = p_attr_grp_name);
2345:

Line 2499: FROM bom_cmp_usr_attr_interface BCUI

2495:
2496: BEGIN
2497: SELECT 'Exist'
2498: INTO l_dummy
2499: FROM bom_cmp_usr_attr_interface BCUI
2500: WHERE (BCUI.comp_source_system_reference = p_ss_record_id OR BCUI.component_sequence_id = p_comp_seq_id)
2501: AND ( BCUI.attr_group_id = attr.attr_group_id OR BCUI.attr_group_int_name = attr.attr_group_name)
2502: AND BCUI.attr_int_name = attr.attr_name
2503: AND BCUI.batch_id = p_batch_id;

Line 2521: /* l_attr_sql := l_attr_sql || ') from bom_cmp_usr_attr_interface where process_status <> -1 AND comp_source_system_reference = ' || ''''||

2517: IF SUBSTR(attr.database_column,1,LENGTH(attr.database_column)-10) = 'D' OR SUBSTR(attr.database_column,1,LENGTH(attr.database_column)-11) = 'D'
2518: THEN
2519: l_attr_sql := l_attr_sql || 'attr_value_date,null,attr_disp_value,attr_value_date)';
2520: END IF;*/
2521: /* l_attr_sql := l_attr_sql || ') from bom_cmp_usr_attr_interface where process_status <> -1 AND comp_source_system_reference = ' || ''''||
2522: p_ss_record_id ||''' and ( attr_group_id = ' ||
2523: attr.attr_group_id || ' or attr_group_int_name = '|| ''''||attr.attr_group_name || ''' ) and attr_int_name = ' || '''' || attr.attr_name || ''' ),';*/
2524: END IF;
2525:

Line 2659: l_attr_sql := l_attr_sql || ' FROM bom_attrs_v attr, bom_components_ext_b BCEB,bom_cmp_usr_attr_interface BCUA '||l_where_clause ;

2655: || ' BCUA.structure_type_id = '|| p_str_type_id || ' AND BCUA.attr_disp_value IS NOT NULL AND attr.attr_group_type = ' || ''''|| 'BOM_COMPONENTMGMT_GROUP' || ''' AND (BCUA.ATTR_GROUP_ID = '
2656: || ' attr.attr_group_id OR BCUA.attr_group_int_name = attr.attr_group_name )))';*/
2657:
2658: --dinu_log_message(l_attr_sql);
2659: l_attr_sql := l_attr_sql || ' FROM bom_attrs_v attr, bom_components_ext_b BCEB,bom_cmp_usr_attr_interface BCUA '||l_where_clause ;
2660: --dinu_log_message(' FROM bom_attrs_v attr, bom_components_ext_b BCEB '||l_where_clause);
2661:
2662: l_attr_sql := l_attr_sql || ' UNION ALL ' || l_attr_sql1
2663: || ' FROM (SELECT attr_group_name,attr_group_disp_name FROM ego_attr_groups_v WHERE attr_group_type = '||''''|| 'BOM_COMPONENT_BASE' || ''' AND application_id = 702 ORDER BY attr_group_name) grps,'

Line 3061: TYPE bom_cmp_usr_type IS TABLE OF bom_cmp_usr_attr_interface%ROWTYPE;

3057: l_comp_id NUMBER;
3058: l_org_id NUMBER;
3059: l_txn_type VARCHAR2(1000);
3060:
3061: TYPE bom_cmp_usr_type IS TABLE OF bom_cmp_usr_attr_interface%ROWTYPE;
3062:
3063: l_attr_table bom_cmp_usr_type;
3064: l_debug BOOLEAN := false;
3065: l_return_status VARCHAR2(1);

Line 3088: bom_cmp_usr_attr_interface bcua

3084: efd.descriptive_flex_context_code attr_group_name,
3085: efd.descriptive_flexfield_name attr_group_type,
3086: bcua.structure_type_id
3087: from ego_fnd_dsc_flx_ctx_ext efd,
3088: bom_cmp_usr_attr_interface bcua
3089: where efd.application_id = 702
3090: and efd.descriptive_flexfield_name = 'BOM_COMPONENTMGMT_GROUP'
3091: and efd.descriptive_flex_context_code = bcua.attr_group_int_name
3092: and bcua.data_set_id = p_data_set_id;

Line 3103: bom_cmp_usr_attr_interface bcu,

3099: 'D',bcu.attr_value_date,null) attr_value,
3100: bcu.attr_disp_value,
3101: efc.data_type data_type
3102: from
3103: bom_cmp_usr_attr_interface bcu,
3104: fnd_descr_flex_column_usages fd,
3105: ego_fnd_df_col_usgs_ext efc
3106: where
3107: bcu.data_set_id = p_data_set_id

Line 3121: from bom_cmp_usr_attr_interface

3117: and fd.end_user_column_name = bcu.attr_int_name;
3118:
3119: Cursor c_get_row_identifier(p_data_set_id number,p_attr_grp_int_name in varchar2)is
3120: Select distinct row_identifier
3121: from bom_cmp_usr_attr_interface
3122: where
3123: data_set_id = p_data_set_id
3124: and attr_group_int_name = p_attr_grp_int_name;
3125: */

Line 3184: UPDATE bom_cmp_usr_attr_interface BCUA

3180: * api will once again insert the default rows.Also we need to update the attr group id.
3181: */
3182:
3183:
3184: UPDATE bom_cmp_usr_attr_interface BCUA
3185: SET component_sequence_id = l_comp_seq_id,
3186: bill_sequence_id = l_bill_seq_id,
3187: process_status = 2,
3188: attr_group_id = (select attr_group_id from EGO_FND_DSC_FLX_CTX_EXT where application_id = 702 and DESCRIPTIVE_FLEXFIELD_NAME = 'BOM_COMPONENTMGMT_GROUP' and DESCRIPTIVE_FLEX_CONTEXT_CODE = BCUA.attr_group_int_name),

Line 3221: ,p_interface_table_name => 'BOM_CMP_USR_ATTR_INTERFACE'

3217: p_api_version => 1.0
3218: ,p_application_id => 702
3219: ,p_attr_group_type => 'BOM_COMPONENTMGMT_GROUP'
3220: ,p_object_name => 'BOM_COMPONENTS'
3221: ,p_interface_table_name => 'BOM_CMP_USR_ATTR_INTERFACE'
3222: ,p_data_set_id => p_batch_id
3223: ,p_target_entity_sql => l_target_sql
3224: ,p_additional_class_Code_query => l_add_class
3225: ,p_commit => 'T'

Line 3243: UPDATE bom_cmp_usr_attr_interface

3239: * Update comp_item_id and org_id.Otherwise ext bulkload will fail for privilege check.We check for
3240: * Edit item and View Item privileges.For this we need the comp ids and org ids.
3241: */
3242:
3243: UPDATE bom_cmp_usr_attr_interface
3244: SET component_item_id = l_comp_id,
3245: organization_id = l_org_id,
3246: attr_group_type = 'BOM_COMPONENTMGMT_GROUP'
3247: WHERE (data_set_id = p_batch_id or batch_id = p_batch_id )

Line 3266: UPDATE bom_cmp_usr_attr_interface

3262: END IF;
3263:
3264:
3265: /* IF l_bill_seq_id IS NOT NULL THEN
3266: UPDATE bom_cmp_usr_attr_interface
3267: SET process_status = 2
3268: WHERE data_set_id = p_batch_id
3269: AND bill_sequence_id = l_bill_seq_id
3270: AND process_status = 0;

Line 3414: -- 'UPDATE bom_cmp_usr_attr_interface '||

3410:
3411: -- l_error_attr_name := ' ('||l_error_attr_name||')';
3412:
3413: -- l_dynamic_sql :=
3414: -- 'UPDATE bom_cmp_usr_attr_interface '||
3415: -- ' SET PROCESS_STATUS = '||G_COM_VALDN_FAIL||
3416: -- ' WHERE DATA_SET_ID = '||p_batch_id||
3417: -- ' AND ATTR_INT_NAME in '||l_error_attr_name||
3418: -- ' AND row_identifier = '||c_curr_row_identfier.row_identifier;

Line 3434: -- ,p_table_name => 'BOM_CMP_USR_ATTR_INTERFACE'

3430: -- ,p_message_type => 'E'
3431: -- ,p_row_identifier => NULL
3432: -- ,p_entity_id => NULL
3433: -- ,p_entity_index => NULL
3434: -- ,p_table_name => 'BOM_CMP_USR_ATTR_INTERFACE'
3435: -- ,p_entity_code => NULL
3436: -- );
3437:
3438:

Line 3467: , p_interface_table_name => 'BOM_CMP_USR_ATTR_INTERFACE'

3463: , p_application_id => 702
3464: , p_attr_group_type => 'BOM_COMPONENTMGMT_GROUP'
3465: , p_object_name => 'BOM_COMPONENTS'
3466: , p_hz_party_id => l_gz_party_id
3467: , p_interface_table_name => 'BOM_CMP_USR_ATTR_INTERFACE'
3468: , p_data_set_id => p_batch_id
3469: , p_related_class_codes_query => 'SELECT bst.structure_type_id FROM BOM_STRUCTURE_TYPES_B bst START WITH bst.structure_type_id = UAI2.STRUCTURE_TYPE_ID CONNECT BY PRIOR bst.parent_structure_type_id = bst.structure_type_id '
3470: , p_init_fnd_msg_list => 'F'
3471: , p_log_errors => 'T'

Line 3490: UPDATE bom_cmp_usr_attr_interface

3486: -- interface rows to 4 , so that if again uploaded these rows are not processed.
3487: -- our processing cycle is for each header, so updating the process_status for processed headers
3488:
3489: IF l_return_status = 'S' THEN
3490: UPDATE bom_cmp_usr_attr_interface
3491: SET process_status = 4
3492: WHERE ( data_set_id = p_batch_id or batch_id = p_batch_id)
3493: AND process_status = 2
3494: AND bill_sequence_id = l_bill_seq_id;

Line 5162: DELETE bom_cmp_usr_attr_interface

5158:
5159: stmt_num := 5;
5160: Write_Debug('Deleting the component attr rows');
5161:
5162: DELETE bom_cmp_usr_attr_interface
5163: WHERE (batch_id = p_batch_id or data_set_id = p_batch_id);
5164:
5165: stmt_num := 6;
5166: Write_Debug('Deleting the Comp Operation Rows');

Line 5609: TYPE bom_comp_attr_type IS TABLE OF bom_cmp_usr_attr_interface%ROWTYPE;

5605: x_Error_Mesg IN OUT NOCOPY VARCHAR2
5606: )
5607: IS
5608:
5609: TYPE bom_comp_attr_type IS TABLE OF bom_cmp_usr_attr_interface%ROWTYPE;
5610: l_attr_table bom_comp_attr_type;
5611: l_merge_table bom_comp_attr_type;
5612: l_count NUMBER;
5613: l_merge_count NUMBER;

Line 5620: FROM bom_cmp_usr_attr_interface

5616:
5617: CURSOR Get_User_Attrs
5618: IS
5619: SELECT *
5620: FROM bom_cmp_usr_attr_interface
5621: WHERE (data_set_id = p_batch_id OR batch_id = p_batch_id)
5622: AND ( component_sequence_id = p_comp_seq
5623: OR( (item_number = p_comp_name or comp_source_system_reference = p_comp_ref)
5624: AND (assembly_item_number = p_par_name OR parent_source_system_reference = p_par_ref)

Line 5639: FROM bom_cmp_usr_attr_interface

5635: l_str_type_id IN NUMBER
5636: )
5637: IS
5638: SELECT *
5639: FROM bom_cmp_usr_attr_interface
5640: WHERE (data_set_id = p_batch_id OR batch_id = p_batch_id)
5641: AND ( component_sequence_id = p_comp_seq
5642: OR ( (item_number = p_comp_name or comp_source_system_reference = p_comp_ref)
5643: AND (assembly_item_number = p_par_name OR parent_source_system_reference = p_par_ref)

Line 5721: UPDATE bom_cmp_usr_attr_interface

5717:
5718: l_merge_table(j).process_status := -1;
5719: END LOOP; --same attrs loop
5720:
5721: UPDATE bom_cmp_usr_attr_interface
5722: SET attr_value_str = l_merge_table(1).attr_value_str,
5723: attr_value_num = l_merge_table(1).attr_value_num,
5724: attr_value_date = l_merge_table(1).attr_value_date,
5725: attr_disp_value = l_merge_table(1).attr_disp_value

Line 5729: UPDATE bom_cmp_usr_attr_interface

5725: attr_disp_value = l_merge_table(1).attr_disp_value
5726: WHERE (data_set_id = p_batch_id OR batch_id = p_batch_id)
5727: AND interface_table_unique_id = l_merge_table(1).interface_table_unique_id;
5728:
5729: UPDATE bom_cmp_usr_attr_interface
5730: SET process_status = -1
5731: WHERE (batch_id = p_batch_id or data_set_id = p_batch_id)
5732: AND ( component_sequence_id = l_merge_table(1).component_sequence_id
5733: OR ( (item_number = l_merge_table(1).item_number or comp_source_system_reference = l_merge_table(1).comp_source_system_reference)

Line 5901: UPDATE bom_cmp_usr_attr_interface

5897: AND nvl(alternate_bom_designator,'Primary') = nvl(l_header_table(i).alternate_bom_designator,'Primary')
5898: )
5899: );
5900:
5901: UPDATE bom_cmp_usr_attr_interface
5902: SET process_status = 5
5903: WHERE batch_id = p_batch_id
5904: AND process_status= 1
5905: AND ( bill_sequence_id = l_header_table(i).bill_sequence_id