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.BOMPASGR dependencies on BOM_OP_ROUTINGS_INTERFACE

Line 35: BOM_OP_ROUTINGS_INTERFACE

31:
32: REQUIRES
33: err_text out buffer to return error message
34: MODIFIES
35: BOM_OP_ROUTINGS_INTERFACE
36: BOM_OP_SEQUENCES_INTERFACE
37: BOM_OP_RESOURCES_INTERFACE
38: MTL_RTG_ITEM_REVS_INTERFACE
39: MTL_INTERFACE_ERRORS

Line 55: update bom_op_routings_interface ori

51: stmt_num NUMBER;
52: BEGIN
53: stmt_num := 1;
54: loop
55: update bom_op_routings_interface ori
56: set organization_id = (select organization_id from
57: mtl_parameters a
58: where a.organization_code = ori.organization_code)
59: where process_flag = 1

Line 304: BOM_OP_ROUTINGS_INTERFACE. If any application error occurs, it

300: /* NAME
301: bmprtgh_assign_rtg_header - assign routing data
302: DESCRIPTION
303: assign defaults and various ids in the interface table,
304: BOM_OP_ROUTINGS_INTERFACE. If any application error occurs, it
305: inserts record into MTL_INTERFACE_ERRORS.
306:
307: REQUIRES
308: err_text out buffer to return error message

Line 310: BOM_OP_ROUTINGS_INTERFACE

306:
307: REQUIRES
308: err_text out buffer to return error message
309: MODIFIES
310: BOM_OP_ROUTINGS_INTERFACE
311: MTL_INTERFACE_ERRORS
312: RETURNS
313: 0 if successful
314: SQLCODE if unsuccessful

Line 353: from bom_op_routings_interface

349: alternate_routing_designator ARD, transaction_id TI,
350: routing_sequence_id RSI, process_revision PR,
351: creation_date CD, created_by CB, last_update_login LUL,
352: last_update_date LUD, last_updated_by LUB
353: from bom_op_routings_interface
354: where process_flag = 1
355: and (all_org = 1
356: or
357: (all_org = 2 and organization_id = org_id)

Line 366: from bom_op_routings_interface

362: transaction_id TI, common_routing_sequence_id CRSI,
363: assembly_item_id AII, routing_sequence_id RSI,
364: common_assembly_item_id CAID, organization_id OI,
365: alternate_routing_designator ARD
366: from bom_op_routings_interface
367: where process_flag = 99
368: and (all_org = 1
369: or
370: (all_org = 2 and organization_id = org_id)

Line 380: update bom_op_routings_interface ori

376: ** assign transaction ids for every row first
377: */
378: stmt_num := 1;
379: loop
380: update bom_op_routings_interface ori
381: set transaction_id = mtl_system_items_interface_s.nextval,
382: routing_sequence_id = nvl(routing_sequence_id,
383: bom_operational_routings_s.nextval)
384: where transaction_id is null

Line 407: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',

403: prog_id => prog_id,
404: req_id => req_id,
405: trans_id => c1rec.TI,
406: error_text => err_text,
407: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',
408: msg_name => 'BOM_ORG_ID_MISSING',
409: err_text => err_text);
410: update bom_op_routings_interface set
411: process_flag = 3

Line 410: update bom_op_routings_interface set

406: error_text => err_text,
407: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',
408: msg_name => 'BOM_ORG_ID_MISSING',
409: err_text => err_text);
410: update bom_op_routings_interface set
411: process_flag = 3
412: where transaction_id = c1rec.TI;
413:
414: goto continue_loop;

Line 439: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',

435: prog_id => prog_id,
436: req_id => req_id,
437: trans_id => c1rec.TI,
438: error_text => err_text,
439: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',
440: msg_name => 'BOM_ASSY_ITEM_MISSING',
441: err_text => err_text);
442: update bom_op_routings_interface set
443: process_flag = 3

Line 442: update bom_op_routings_interface set

438: error_text => err_text,
439: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',
440: msg_name => 'BOM_ASSY_ITEM_MISSING',
441: err_text => err_text);
442: update bom_op_routings_interface set
443: process_flag = 3
444: where transaction_id = c1rec.TI;
445:
446: if (ret_code <> 0) then

Line 475: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',

471: prog_id => prog_id,
472: req_id => req_id,
473: trans_id => c1rec.TI,
474: error_text => err_text,
475: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',
476: msg_name => 'BOM_LOCATION_NAME_INVALID',
477: err_text => err_text);
478: update bom_op_routings_interface set
479: process_flag = 3

Line 478: update bom_op_routings_interface set

474: error_text => err_text,
475: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',
476: msg_name => 'BOM_LOCATION_NAME_INVALID',
477: err_text => err_text);
478: update bom_op_routings_interface set
479: process_flag = 3
480: where transaction_id = c1rec.TI;
481:
482: if (ret_code <> 0) then

Line 512: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',

508: prog_id => prog_id,
509: req_id => req_id,
510: trans_id => c1rec.TI,
511: error_text => err_text,
512: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',
513: msg_name => 'BOM_CMN_ASSY_ITEM_INVALID',
514: err_text => err_text);
515: update bom_op_routings_interface set
516: process_flag = 3

Line 515: update bom_op_routings_interface set

511: error_text => err_text,
512: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',
513: msg_name => 'BOM_CMN_ASSY_ITEM_INVALID',
514: err_text => err_text);
515: update bom_op_routings_interface set
516: process_flag = 3
517: where transaction_id = c1rec.TI;
518:
519: if (ret_code <> 0) then

Line 628: ** update bom_op_routings_interface with the modified column values

624: mtl_system_items_interface_s.nextval);
625: end if;
626:
627: /*
628: ** update bom_op_routings_interface with the modified column values
629: */
630: <>
631: stmt_num := 6;
632: update bom_op_routings_interface

Line 632: update bom_op_routings_interface

628: ** update bom_op_routings_interface with the modified column values
629: */
630: <>
631: stmt_num := 6;
632: update bom_op_routings_interface
633: set organization_id = nvl(organization_id, c1rec.OI),
634: assembly_item_id = nvl(assembly_item_id, c1rec.AII),
635: completion_locator_id = nvl(completion_locator_id, c1rec.CLI),
636: common_assembly_item_id = nvl(common_assembly_item_id, c1rec.CAII),

Line 721: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',

717: prog_id => prog_id,
718: req_id => req_id,
719: trans_id => c2rec.TI,
720: error_text => err_text,
721: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',
722: msg_name => 'BOM_CMN_RTG_SEQ_INVALID',
723: err_text => err_text);
724: proc_flag := 3;
725: end if;

Line 744: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',

740: prog_id => prog_id,
741: req_id => req_id,
742: trans_id => c2rec.TI,
743: error_text => err_text,
744: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',
745: msg_name => 'BOM_CMN_RTG_SEQ_INVALID',
746: err_text => err_text);
747: proc_flag := 3;
748: end if;

Line 755: update bom_op_routings_interface set

751: assy_id := NULL;
752: end if;
753:
754: stmt_num := 8;
755: update bom_op_routings_interface set
756: process_flag = proc_flag,
757: common_routing_sequence_id = c2rec.CRSI,
758: common_assembly_item_id = assy_id
759: where transaction_id = c2rec.TI;

Line 1767: bom_op_routings_interface bori

1763: begin
1764: select bori.organization_id
1765: into dummy_org_id
1766: from bom_op_sequences_interface bosi,
1767: bom_op_routings_interface bori
1768: where operation_sequence_id = c2rec.OSI
1769: and bosi.process_flag <>3 and bosi.process_flag <>7
1770: and bori.process_flag <>3 and bori.process_flag <>7
1771: and bosi.routing_sequence_id = bori.routing_sequence_id

Line 2143: from bom_op_routings_interface

2139: END;
2140:
2141: select routing_sequence_id
2142: into rtg_seq_id
2143: from bom_op_routings_interface
2144: where organization_id = org_id
2145: and assembly_item_id = item_id
2146: and nvl(alternate_routing_designator, 'NONE') =
2147: nvl(alt_desg, 'NONE')

Line 2408: from bom_op_routings_interface

2404: END;
2405:
2406: select assembly_item_id, organization_id, alternate_routing_designator
2407: into item_id, org_id, alt_desg
2408: from bom_op_routings_interface
2409: where routing_sequence_id = rtg_seq_id
2410: and process_flag <> 3 and process_flag <> 7
2411: and rownum = 1;
2412:

Line 2513: BOM_OP_ROUTINGS_INTERFACE

2509:
2510: REQUIRES
2511: err_text out buffer to return error message
2512: MODIFIES
2513: BOM_OP_ROUTINGS_INTERFACE
2514: BOM_OP_SEQUENCES_INTERFACE
2515: BOM_OP_RESOURCES_INTERFACE
2516: MTL_INTERFACE_ERRORS
2517: RETURNS