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.BOMPVALB dependencies on BOM_REF_DESGS_INTERFACE

Line 2519: from bom_ref_desgs_interface

2515:
2516: cursor c1 is
2517: select component_sequence_id CSI, count(*) CNT,
2518: transaction_id TI, component_item_id CII
2519: from bom_ref_desgs_interface
2520: where process_flag = 2
2521: and rownum < 500
2522: group by transaction_id, component_sequence_id, component_item_id;
2523:

Line 2527: from bom_ref_desgs_interface

2523:
2524: BEGIN
2525: select count(distinct component_sequence_id)
2526: into total_recs
2527: from bom_ref_desgs_interface
2528: where process_flag = 2;
2529:
2530: continue_loop := TRUE;
2531: commit_cnt := 0;

Line 2541: from bom_ref_desgs_interface

2537: */
2538: commit_cnt := commit_cnt + 1;
2539: select count(*)
2540: into dummy
2541: from bom_ref_desgs_interface
2542: where transaction_id = c1rec.TI
2543: and component_reference_designator is null;
2544:
2545: if (dummy = 0) then

Line 2557: tbl_name => 'BOM_REF_DESGS_INTERFACE',

2553: prog_id => prog_id,
2554: req_id => request_id,
2555: trans_id => c1rec.TI,
2556: error_text => err_text,
2557: tbl_name => 'BOM_REF_DESGS_INTERFACE',
2558: msg_name => 'BOM_NULL_REF_DESGS',
2559: err_text => err_text);
2560: update bom_ref_desgs_interface set
2561: process_flag = 3

Line 2560: update bom_ref_desgs_interface set

2556: error_text => err_text,
2557: tbl_name => 'BOM_REF_DESGS_INTERFACE',
2558: msg_name => 'BOM_NULL_REF_DESGS',
2559: err_text => err_text);
2560: update bom_ref_desgs_interface set
2561: process_flag = 3
2562: where transaction_id = c1rec.TI;
2563:
2564: if (ret_code <> 0) then

Line 2588: tbl_name => 'BOM_REF_DESGS_INTERFACE',

2584: prog_id => prog_id,
2585: req_id => request_id,
2586: trans_id => c1rec.TI,
2587: error_text => err_text,
2588: tbl_name => 'BOM_REF_DESGS_INTERFACE',
2589: msg_name => 'BOM_COMP_SEQ_ID_INVALID',
2590: err_text => err_text);
2591: update bom_ref_desgs_interface set
2592: process_flag = 3

Line 2591: update bom_ref_desgs_interface set

2587: error_text => err_text,
2588: tbl_name => 'BOM_REF_DESGS_INTERFACE',
2589: msg_name => 'BOM_COMP_SEQ_ID_INVALID',
2590: err_text => err_text);
2591: update bom_ref_desgs_interface set
2592: process_flag = 3
2593: where transaction_id = c1rec.TI;
2594:
2595: if (ret_code <> 0) then

Line 2617: tbl_name => 'BOM_REF_DESGS_INTERFACE',

2613: prog_id => prog_id,
2614: req_id => request_id,
2615: trans_id => c1rec.TI,
2616: error_text => err_text,
2617: tbl_name => 'BOM_REF_DESGS_INTERFACE',
2618: msg_name => 'BOM_DUP_REF_DESG',
2619: err_text => err_text);
2620: update bom_ref_desgs_interface set
2621: process_flag = 3

Line 2620: update bom_ref_desgs_interface set

2616: error_text => err_text,
2617: tbl_name => 'BOM_REF_DESGS_INTERFACE',
2618: msg_name => 'BOM_DUP_REF_DESG',
2619: err_text => err_text);
2620: update bom_ref_desgs_interface set
2621: process_flag = 3
2622: where transaction_id = c1rec.TI;
2623:
2624: if (ret_code <> 0) then

Line 2647: tbl_name => 'BOM_REF_DESGS_INTERFACE',

2643: prog_id => prog_id,
2644: req_id => request_id,
2645: trans_id => c1rec.TI,
2646: error_text => err_text,
2647: tbl_name => 'BOM_REF_DESGS_INTERFACE',
2648: msg_name => 'BOM_REF_DESG_COUNT_INVALID',
2649: err_text => err_text);
2650: update bom_ref_desgs_interface set
2651: process_flag = 3

Line 2650: update bom_ref_desgs_interface set

2646: error_text => err_text,
2647: tbl_name => 'BOM_REF_DESGS_INTERFACE',
2648: msg_name => 'BOM_REF_DESG_COUNT_INVALID',
2649: err_text => err_text);
2650: update bom_ref_desgs_interface set
2651: process_flag = 3
2652: where transaction_id = c1rec.TI;
2653:
2654: if (ret_code <> 0) then

Line 2729: tbl_name => 'BOM_REF_DESGS_INTERFACE',

2725: prog_id => prog_id,
2726: req_id => request_id,
2727: trans_id => c1rec.TI,
2728: error_text => err_text,
2729: tbl_name => 'BOM_REF_DESGS_INTERFACE',
2730: msg_name => 'BOM_NO_REF_DESGS_ALLOWED',
2731: err_text => err_text);
2732: update bom_ref_desgs_interface set
2733: process_flag = 3

Line 2732: update bom_ref_desgs_interface set

2728: error_text => err_text,
2729: tbl_name => 'BOM_REF_DESGS_INTERFACE',
2730: msg_name => 'BOM_NO_REF_DESGS_ALLOWED',
2731: err_text => err_text);
2732: update bom_ref_desgs_interface set
2733: process_flag = 3
2734: where transaction_id = c1rec.TI;
2735:
2736: if (ret_code <> 0) then

Line 2753: tbl_name => 'BOM_REF_DESGS_INTERFACE',

2749: prog_id => prog_id,
2750: req_id => request_id,
2751: trans_id => c1rec.TI,
2752: error_text => err_text,
2753: tbl_name => 'BOM_REF_DESGS_INTERFACE',
2754: msg_name => 'BOM_NO_REF_DESGS_COMP',
2755: err_text => err_text);
2756: update bom_ref_desgs_interface set
2757: process_flag = 3

Line 2756: update bom_ref_desgs_interface set

2752: error_text => err_text,
2753: tbl_name => 'BOM_REF_DESGS_INTERFACE',
2754: msg_name => 'BOM_NO_REF_DESGS_COMP',
2755: err_text => err_text);
2756: update bom_ref_desgs_interface set
2757: process_flag = 3
2758: where transaction_id = c1rec.TI;
2759:
2760: if (ret_code <> 0) then

Line 2766: update bom_ref_desgs_interface

2762: end if;
2763: goto continue_loop;
2764: end if;
2765:
2766: update bom_ref_desgs_interface
2767: set process_flag = 4
2768: where transaction_id = c1rec.TI;
2769:
2770: <>

Line 2824: from bom_reference_designators a, bom_ref_desgs_interface b

2820: */
2821: begin
2822: select 1
2823: into dummy
2824: from bom_reference_designators a, bom_ref_desgs_interface b
2825: where b.transaction_id = trans_id
2826: and a.component_sequence_id = b.component_sequence_id
2827: and a.COMPONENT_REFERENCE_DESIGNATOR =
2828: b.COMPONENT_REFERENCE_DESIGNATOR

Line 2846: from bom_ref_desgs_interface a

2842: ** check in interface table
2843: */
2844: select count(*)
2845: into dummy
2846: from bom_ref_desgs_interface a
2847: where transaction_id = trans_id
2848: and exists (select 'same designator'
2849: from bom_ref_desgs_interface b
2850: where b.transaction_id = trans_id

Line 2849: from bom_ref_desgs_interface b

2845: into dummy
2846: from bom_ref_desgs_interface a
2847: where transaction_id = trans_id
2848: and exists (select 'same designator'
2849: from bom_ref_desgs_interface b
2850: where b.transaction_id = trans_id
2851: and b.rowid <> a.rowid
2852: and b.COMPONENT_REFERENCE_DESIGNATOR =
2853: a.COMPONENT_REFERENCE_DESIGNATOR

Line 2941: from bom_ref_desgs_interface

2937: where component_sequencE_id = cmp_seq_id;
2938:
2939: select count(*)
2940: into int_ref_qty
2941: from bom_ref_desgs_interface
2942: where transaction_id = trans_id
2943: and process_flag <> 3
2944: and process_flag <> 7;
2945: if (ref_qty + int_ref_qty <> cmp_qty) then