APPS.FLM_EXECUTION_UTIL dependencies on FLM_EXE_PREFERENCES

Line 20: FROM FLM_EXE_PREFERENCES

16: l_view_all_sch VARCHAR2(1);
17:
18: CURSOR c_view_all_lineop IS
19: SELECT VIEW_ALL_SCHEDULES
20: FROM FLM_EXE_PREFERENCES
21: WHERE ORGANIZATION_ID = l_org_id
22: AND LINE_ID = l_line_id
23: AND STANDARD_OPERATION_ID = l_operation_id;
24:

Line 27: FROM FLM_EXE_PREFERENCES

23: AND STANDARD_OPERATION_ID = l_operation_id;
24:
25: CURSOR c_view_all_line IS
26: SELECT VIEW_ALL_SCHEDULES
27: FROM FLM_EXE_PREFERENCES
28: WHERE ORGANIZATION_ID = l_org_id
29: AND LINE_ID = l_line_id
30: AND STANDARD_OPERATION_ID IS NULL;
31:

Line 34: FROM FLM_EXE_PREFERENCES

30: AND STANDARD_OPERATION_ID IS NULL;
31:
32: CURSOR c_view_all_org IS
33: SELECT VIEW_ALL_SCHEDULES
34: FROM FLM_EXE_PREFERENCES
35: WHERE ORGANIZATION_ID = l_org_id
36: AND LINE_ID IS NULL
37: AND STANDARD_OPERATION_ID IS NULL;
38:

Line 140: FLM_EXE_PREFERENCES

136: CURSOR c_wkstn_enabled IS
137: SELECT
138: WORKSTATION_ENABLED
139: FROM
140: FLM_EXE_PREFERENCES
141: WHERE
142: NVL(ORGANIZATION_ID,-1) = NVL(l_org_id,-1) AND
143: NVL(LINE_ID,-1) = NVL(l_line_id,-1) AND
144: NVL(STANDARD_OPERATION_ID,-1) = nvl(l_operation_id,-1);

Line 1078: from flm_exe_preferences

1074: --2 = ALL
1075:
1076: CURSOR line_bf_option(p_org_id IN NUMBER, p_line_id IN NUMBER) IS
1077: select nvl(backflush_option, G_BFLUSH_OPTION_ALL) backflush_option
1078: from flm_exe_preferences
1079: where organization_id = p_org_id
1080: and line_id = p_line_id;
1081:
1082: CURSOR org_bf_option(p_org_id IN NUMBER) IS

Line 1084: from flm_exe_preferences

1080: and line_id = p_line_id;
1081:
1082: CURSOR org_bf_option(p_org_id IN NUMBER) IS
1083: select nvl(backflush_option,G_BFLUSH_OPTION_ALL) backflush_option
1084: from flm_exe_preferences
1085: where organization_id = p_org_id;
1086: l_bf_option NUMBER;
1087:
1088: BEGIN