APPS.FLM_KANBAN dependencies on STANDARD

Line 12: i_standard_operation_id NUMBER,

8: i_template_sub VARCHAR2,
9: i_default_locator_id NUMBER DEFAULT NULL,
10: i_org_id NUMBER,
11: i_line_id NUMBER,
12: i_standard_operation_id NUMBER,
13: i_operation_type NUMBER,
14: i_assembly IN assembly_t,
15: i_item_attributes IN VARCHAR2,
16: i_item_from IN VARCHAR2,

Line 203: p_standard_operation_id IN number,

199: ----------------------------------------------------------------------------
200: procedure restrict_items_by_line(p_restrict IN number,
201: p_org_id IN number,
202: p_line_id IN number,
203: p_standard_operation_id IN number,
204: p_operation_type IN number,
205: p_items IN OUT NOCOPY l_item_with_type_t) is
206:
207: p_line_items l_item_with_type_t;

Line 307: bos2.standard_operation_id

303: bic.component_item_id;
304:
305: Cursor get_std_lineop_id(p_org_id number, p_assembly_item_id number, p_alt varchar2, p_op_seq_num number) Is
306: Select
307: bos2.standard_operation_id
308: From
309: bom_operational_routings bor,
310: bom_operation_sequences bos1,
311: bom_operation_sequences bos2

Line 326: bos2.standard_operation_id

322: (bos1.disable_date > sysdate - 1 or bos1.disable_date is null);
323:
324: Cursor get_std_process_id(p_org_id number, p_assembly_item_id number, p_alt varchar2, p_op_seq_num number) Is
325: Select
326: bos2.standard_operation_id
327: From
328: bom_operational_routings bor,
329: bom_operation_sequences bos1,
330: bom_operation_sequences bos2

Line 446: if (p_standard_operation_id is null OR

442: i := G_COMPONENTS.FIRST;
443: j := G_COMPONENTS.LAST;
444:
445: LOOP
446: if (p_standard_operation_id is null OR
447: (G_COMPONENTS(i).std_lineop_id = p_standard_operation_id and p_operation_type = 3) OR
448: (G_COMPONENTS(i).std_process_id = p_standard_operation_id and p_operation_type = 2)) then
449:
450: pou_exists := false;

Line 447: (G_COMPONENTS(i).std_lineop_id = p_standard_operation_id and p_operation_type = 3) OR

443: j := G_COMPONENTS.LAST;
444:
445: LOOP
446: if (p_standard_operation_id is null OR
447: (G_COMPONENTS(i).std_lineop_id = p_standard_operation_id and p_operation_type = 3) OR
448: (G_COMPONENTS(i).std_process_id = p_standard_operation_id and p_operation_type = 2)) then
449:
450: pou_exists := false;
451: for k in 0..l_cnt-1 loop

Line 448: (G_COMPONENTS(i).std_process_id = p_standard_operation_id and p_operation_type = 2)) then

444:
445: LOOP
446: if (p_standard_operation_id is null OR
447: (G_COMPONENTS(i).std_lineop_id = p_standard_operation_id and p_operation_type = 3) OR
448: (G_COMPONENTS(i).std_process_id = p_standard_operation_id and p_operation_type = 2)) then
449:
450: pou_exists := false;
451: for k in 0..l_cnt-1 loop
452: if (p_line_items(k).item_id = G_COMPONENTS(i).component_item_id) and

Line 608: i_standard_operation_id,

604: -- retrieve components by a line and/or a lineop(process) into l_items
605: restrict_items_by_line(0,
606: i_org_id,
607: i_line_id,
608: i_standard_operation_id,
609: i_operation_type,
610: l_items);
611: else
612: -- restrict components in l_items by a line and/or a lineop(process)

Line 616: i_standard_operation_id,

612: -- restrict components in l_items by a line and/or a lineop(process)
613: restrict_items_by_line(1,
614: i_org_id,
615: i_line_id,
616: i_standard_operation_id,
617: i_operation_type,
618: l_items);
619: end if;
620: end if;