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 1547: UPDATE bom_cmp_usr_attr_interface

1543: AND*/(comp_source_system_reference = l_comp_table(j).comp_source_system_reference OR component_item_number = l_comp_table(j).component_item_number)
1544: AND (parent_source_system_reference = l_comp_table(j).parent_source_system_reference OR assembly_item_number = l_comp_table(j).assembly_item_number)));
1545:
1546: -- IF l_comp_table(j).transaction_id IS NOT NULL THEN
1547: UPDATE bom_cmp_usr_attr_interface
1548: SET item_number = l_comp_table(j).component_item_number,
1549: assembly_item_number = l_comp_table(j).assembly_item_number,
1550: comp_source_system_reference = l_comp_table(j).comp_source_system_reference,
1551: parent_source_system_reference = l_comp_table(j).parent_source_system_reference,

Line 2198: FROM bom_cmp_usr_attr_interface BCUA

2194:
2195: CURSOR Get_Src_Attr(p_str_type_id IN NUMBER,p_attr_grp_id IN NUMBER,p_attr_grp_name IN VARCHAR2)
2196: IS
2197: SELECT BCUA.attr_group_int_name
2198: FROM bom_cmp_usr_attr_interface BCUA
2199: WHERE BCUA.batch_id = p_batch_id
2200: AND BCUA.structure_type_id = p_str_type_id
2201: AND (BCUA.attr_group_id = p_attr_grp_id OR BCUA.attr_group_int_name = p_attr_grp_name);
2202:

Line 2354: FROM bom_cmp_usr_attr_interface BCUI

2350:
2351: BEGIN
2352: SELECT 'Exist'
2353: INTO l_dummy
2354: FROM bom_cmp_usr_attr_interface BCUI
2355: WHERE (BCUI.comp_source_system_reference = p_ss_record_id OR BCUI.component_sequence_id = p_comp_seq_id)
2356: AND ( BCUI.attr_group_id = attr.attr_group_id OR BCUI.attr_group_int_name = attr.attr_group_name)
2357: AND BCUI.attr_int_name = attr.attr_name
2358: AND BCUI.batch_id = p_batch_id;

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

2372: IF SUBSTR(attr.database_column,1,LENGTH(attr.database_column)-10) = 'D' OR SUBSTR(attr.database_column,1,LENGTH(attr.database_column)-11) = 'D'
2373: THEN
2374: l_attr_sql := l_attr_sql || 'attr_value_date,null,attr_disp_value,attr_value_date)';
2375: END IF;*/
2376: /* l_attr_sql := l_attr_sql || ') from bom_cmp_usr_attr_interface where process_status <> -1 AND comp_source_system_reference = ' || ''''||
2377: p_ss_record_id ||''' and ( attr_group_id = ' ||
2378: attr.attr_group_id || ' or attr_group_int_name = '|| ''''||attr.attr_group_name || ''' ) and attr_int_name = ' || '''' || attr.attr_name || ''' ),';*/
2379: END IF;
2380:

Line 2514: 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 ;

2510: || ' 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 = '
2511: || ' attr.attr_group_id OR BCUA.attr_group_int_name = attr.attr_group_name )))';*/
2512:
2513: --dinu_log_message(l_attr_sql);
2514: 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 ;
2515: --dinu_log_message(' FROM bom_attrs_v attr, bom_components_ext_b BCEB '||l_where_clause);
2516:
2517: l_attr_sql := l_attr_sql || ' UNION ALL ' || l_attr_sql1
2518: || ' 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 2908: TYPE bom_cmp_usr_type IS TABLE OF bom_cmp_usr_attr_interface%ROWTYPE;

2904: l_comp_id NUMBER;
2905: l_org_id NUMBER;
2906: l_txn_type VARCHAR2(1000);
2907:
2908: TYPE bom_cmp_usr_type IS TABLE OF bom_cmp_usr_attr_interface%ROWTYPE;
2909:
2910: l_attr_table bom_cmp_usr_type;
2911: l_debug BOOLEAN := false;
2912: l_return_status VARCHAR2(1);

Line 2976: UPDATE bom_cmp_usr_attr_interface BCUA

2972: * api will once again insert the default rows.Also we need to update the attr group id.
2973: */
2974:
2975:
2976: UPDATE bom_cmp_usr_attr_interface BCUA
2977: SET component_sequence_id = l_comp_seq_id,
2978: bill_sequence_id = l_bill_seq_id,
2979: process_status = 2,
2980: 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 3011: ,p_interface_table_name => 'BOM_CMP_USR_ATTR_INTERFACE'

3007: p_api_version => 1.0
3008: ,p_application_id => 702
3009: ,p_attr_group_type => 'BOM_COMPONENTMGMT_GROUP'
3010: ,p_object_name => 'BOM_COMPONENTS'
3011: ,p_interface_table_name => 'BOM_CMP_USR_ATTR_INTERFACE'
3012: ,p_data_set_id => p_batch_id
3013: ,p_target_entity_sql => l_target_sql
3014: ,p_additional_class_Code_query => l_add_class
3015: ,p_commit => 'T'

Line 3026: UPDATE bom_cmp_usr_attr_interface

3022: * Update comp_item_id and org_id.Otherwise ext bulkload will fail for privilege check.We check for
3023: * Edit item and View Item privileges.For this we need the comp ids and org ids.
3024: */
3025:
3026: UPDATE bom_cmp_usr_attr_interface
3027: SET component_item_id = l_comp_id,
3028: organization_id = l_org_id,
3029: attr_group_type = 'BOM_COMPONENTMGMT_GROUP'
3030: WHERE (data_set_id = p_batch_id or batch_id = p_batch_id )

Line 3049: UPDATE bom_cmp_usr_attr_interface

3045: END IF;
3046:
3047:
3048: /* IF l_bill_seq_id IS NOT NULL THEN
3049: UPDATE bom_cmp_usr_attr_interface
3050: SET process_status = 2
3051: WHERE data_set_id = p_batch_id
3052: AND bill_sequence_id = l_bill_seq_id
3053: AND process_status = 0;

Line 3084: , p_interface_table_name => 'BOM_CMP_USR_ATTR_INTERFACE'

3080: , p_application_id => 702
3081: , p_attr_group_type => 'BOM_COMPONENTMGMT_GROUP'
3082: , p_object_name => 'BOM_COMPONENTS'
3083: , p_hz_party_id => l_gz_party_id
3084: , p_interface_table_name => 'BOM_CMP_USR_ATTR_INTERFACE'
3085: , p_data_set_id => p_batch_id
3086: , 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 '
3087: , p_init_fnd_msg_list => 'F'
3088: , p_log_errors => 'T'

Line 3107: UPDATE bom_cmp_usr_attr_interface

3103: -- interface rows to 4 , so that if again uploaded these rows are not processed.
3104: -- our processing cycle is for each header, so updating the process_status for processed headers
3105:
3106: IF l_return_status = 'S' THEN
3107: UPDATE bom_cmp_usr_attr_interface
3108: SET process_status = 4
3109: WHERE ( data_set_id = p_batch_id or batch_id = p_batch_id)
3110: AND process_status = 2
3111: AND bill_sequence_id = l_bill_seq_id;

Line 4770: DELETE bom_cmp_usr_attr_interface

4766:
4767: stmt_num := 5;
4768: Write_Debug('Deleting the component attr rows');
4769:
4770: DELETE bom_cmp_usr_attr_interface
4771: WHERE (batch_id = p_batch_id or data_set_id = p_batch_id);
4772:
4773: stmt_num := 6;
4774: Write_Debug('Deleting the Comp Operation Rows');

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

5213: x_Error_Mesg IN OUT NOCOPY VARCHAR2
5214: )
5215: IS
5216:
5217: TYPE bom_comp_attr_type IS TABLE OF bom_cmp_usr_attr_interface%ROWTYPE;
5218: l_attr_table bom_comp_attr_type;
5219: l_merge_table bom_comp_attr_type;
5220: l_count NUMBER;
5221: l_merge_count NUMBER;

Line 5228: FROM bom_cmp_usr_attr_interface

5224:
5225: CURSOR Get_User_Attrs
5226: IS
5227: SELECT *
5228: FROM bom_cmp_usr_attr_interface
5229: WHERE (data_set_id = p_batch_id OR batch_id = p_batch_id)
5230: AND ( component_sequence_id = p_comp_seq
5231: OR( (item_number = p_comp_name or comp_source_system_reference = p_comp_ref)
5232: AND (assembly_item_number = p_par_name OR parent_source_system_reference = p_par_ref)

Line 5247: FROM bom_cmp_usr_attr_interface

5243: l_str_type_id IN NUMBER
5244: )
5245: IS
5246: SELECT *
5247: FROM bom_cmp_usr_attr_interface
5248: WHERE (data_set_id = p_batch_id OR batch_id = p_batch_id)
5249: AND ( component_sequence_id = p_comp_seq
5250: OR ( (item_number = p_comp_name or comp_source_system_reference = p_comp_ref)
5251: AND (assembly_item_number = p_par_name OR parent_source_system_reference = p_par_ref)

Line 5329: UPDATE bom_cmp_usr_attr_interface

5325:
5326: l_merge_table(j).process_status := -1;
5327: END LOOP; --same attrs loop
5328:
5329: UPDATE bom_cmp_usr_attr_interface
5330: SET attr_value_str = l_merge_table(1).attr_value_str,
5331: attr_value_num = l_merge_table(1).attr_value_num,
5332: attr_value_date = l_merge_table(1).attr_value_date,
5333: attr_disp_value = l_merge_table(1).attr_disp_value

Line 5337: UPDATE bom_cmp_usr_attr_interface

5333: attr_disp_value = l_merge_table(1).attr_disp_value
5334: WHERE (data_set_id = p_batch_id OR batch_id = p_batch_id)
5335: AND interface_table_unique_id = l_merge_table(1).interface_table_unique_id;
5336:
5337: UPDATE bom_cmp_usr_attr_interface
5338: SET process_status = -1
5339: WHERE (batch_id = p_batch_id or data_set_id = p_batch_id)
5340: AND ( component_sequence_id = l_merge_table(1).component_sequence_id
5341: OR ( (item_number = l_merge_table(1).item_number or comp_source_system_reference = l_merge_table(1).comp_source_system_reference)

Line 5509: UPDATE bom_cmp_usr_attr_interface

5505: AND nvl(alternate_bom_designator,'Primary') = nvl(l_header_table(i).alternate_bom_designator,'Primary')
5506: )
5507: );
5508:
5509: UPDATE bom_cmp_usr_attr_interface
5510: SET process_status = 5
5511: WHERE batch_id = p_batch_id
5512: AND process_status= 1
5513: AND ( bill_sequence_id = l_header_table(i).bill_sequence_id