APPS.FLM_EXECUTION_UTIL dependencies on FLM_EXECUTION_UTIL

Line 1: PACKAGE BODY flm_execution_util AS

1: PACKAGE BODY flm_execution_util AS
2: /* $Header: FLMEXUTB.pls 120.20 2006/11/08 01:44:53 ksuleman ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FLM_EXECUTION_UTIL';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FLM_EXECUTION_UTIL';

1: PACKAGE BODY flm_execution_util AS
2: /* $Header: FLMEXUTB.pls 120.20 2006/11/08 01:44:53 ksuleman ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FLM_EXECUTION_UTIL';
5:
6: FUNCTION get_view_all_schedules(
7: p_organization_id IN NUMBER,
8: p_line_id IN NUMBER,

Line 290: and flm_execution_util.workstation_enabled(next_op_seq_id) = 'N'

286: CURSOR sch_cur_op_csr IS
287: select next_op_seq_id seq_id
288: from flm_exe_operations
289: where wip_entity_id = i_wip_entity_id
290: and flm_execution_util.workstation_enabled(next_op_seq_id) = 'N'
291: order by next_op_seq_id;
292: l_view_all_sch VARCHAR2(1);
293:
294: BEGIN

Line 366: and flm_execution_util.workstation_enabled(from_op_seq_id) = 'N'

362: select count(*)
363: into l_cnt
364: from bom_operation_networks
365: where to_op_seq_id = l_op_seq_id
366: and flm_execution_util.workstation_enabled(from_op_seq_id) = 'N'
367: and flm_execution_util.workstation_enabled(op_rec.seq_id) = 'N'
368: start with from_op_seq_id = op_rec.seq_id
369: connect by prior to_op_seq_id = from_op_seq_id
370: and transition_type in (1, 2)

Line 367: and flm_execution_util.workstation_enabled(op_rec.seq_id) = 'N'

363: into l_cnt
364: from bom_operation_networks
365: where to_op_seq_id = l_op_seq_id
366: and flm_execution_util.workstation_enabled(from_op_seq_id) = 'N'
367: and flm_execution_util.workstation_enabled(op_rec.seq_id) = 'N'
368: start with from_op_seq_id = op_rec.seq_id
369: connect by prior to_op_seq_id = from_op_seq_id
370: and transition_type in (1, 2)
371: and flm_execution_util.workstation_enabled(from_op_seq_id) = 'N';

Line 371: and flm_execution_util.workstation_enabled(from_op_seq_id) = 'N';

367: and flm_execution_util.workstation_enabled(op_rec.seq_id) = 'N'
368: start with from_op_seq_id = op_rec.seq_id
369: connect by prior to_op_seq_id = from_op_seq_id
370: and transition_type in (1, 2)
371: and flm_execution_util.workstation_enabled(from_op_seq_id) = 'N';
372: IF l_cnt > 0 THEN
373: RETURN 'Y';
374: END IF;
375: END LOOP;

Line 383: and flm_execution_util.workstation_enabled(from_op_seq_id) = 'N'

379: select count(*)
380: into l_cnt
381: from bom_operation_networks
382: where to_op_seq_id = l_op_seq_id
383: and flm_execution_util.workstation_enabled(from_op_seq_id) = 'N'
384: start with from_op_seq_id = op_rec.seq_id
385: connect by prior to_op_seq_id = from_op_seq_id
386: and transition_type in (1, 2)
387: and flm_execution_util.workstation_enabled(from_op_seq_id) = 'N';

Line 387: and flm_execution_util.workstation_enabled(from_op_seq_id) = 'N';

383: and flm_execution_util.workstation_enabled(from_op_seq_id) = 'N'
384: start with from_op_seq_id = op_rec.seq_id
385: connect by prior to_op_seq_id = from_op_seq_id
386: and transition_type in (1, 2)
387: and flm_execution_util.workstation_enabled(from_op_seq_id) = 'N';
388: IF l_cnt > 0 THEN
389: RETURN 'Y';
390: END IF;
391: END LOOP;

Line 1169: flm_execution_util.merge_backflush_comps(

1165: if(l_rtg_seq_id is null) then
1166: return;
1167: end if;
1168:
1169: flm_execution_util.merge_backflush_comps(
1170: p_wip_ent_id => p_wip_ent_id,
1171: p_line_id => p_line_id,
1172: p_assyID => p_assyID,
1173: p_orgID => p_orgID,

Line 1986: END flm_execution_util;

1982:
1983: END non_txncomp_exist;
1984:
1985:
1986: END flm_execution_util;