APPS.FLM_EXECUTION_UTIL dependencies on FLM_EXE_PREFERENCES

Line 25: FROM FLM_EXE_PREFERENCES

21: l_data_entry_mode VARCHAR2(1);
22:
23: CURSOR c_dem_lineop IS
24: SELECT data_entry_mode
25: FROM FLM_EXE_PREFERENCES
26: WHERE ORGANIZATION_ID = l_org_id
27: AND LINE_ID = l_line_id
28: AND STANDARD_OPERATION_ID = l_operation_id;
29:

Line 32: FROM FLM_EXE_PREFERENCES

28: AND STANDARD_OPERATION_ID = l_operation_id;
29:
30: CURSOR c_dem_line IS
31: SELECT data_entry_mode
32: FROM FLM_EXE_PREFERENCES
33: WHERE ORGANIZATION_ID = l_org_id
34: AND LINE_ID = l_line_id
35: AND STANDARD_OPERATION_ID IS NULL;
36:

Line 39: FROM FLM_EXE_PREFERENCES

35: AND STANDARD_OPERATION_ID IS NULL;
36:
37: CURSOR c_dem_org IS
38: SELECT data_entry_mode
39: FROM FLM_EXE_PREFERENCES
40: WHERE ORGANIZATION_ID = l_org_id
41: AND LINE_ID IS NULL
42: AND STANDARD_OPERATION_ID IS NULL;
43:

Line 94: FROM FLM_EXE_PREFERENCES

90: l_view_all_sch VARCHAR2(1);
91:
92: CURSOR c_view_all_lineop IS
93: SELECT VIEW_ALL_SCHEDULES
94: FROM FLM_EXE_PREFERENCES
95: WHERE ORGANIZATION_ID = l_org_id
96: AND LINE_ID = l_line_id
97: AND STANDARD_OPERATION_ID = l_operation_id;
98:

Line 101: FROM FLM_EXE_PREFERENCES

97: AND STANDARD_OPERATION_ID = l_operation_id;
98:
99: CURSOR c_view_all_line IS
100: SELECT VIEW_ALL_SCHEDULES
101: FROM FLM_EXE_PREFERENCES
102: WHERE ORGANIZATION_ID = l_org_id
103: AND LINE_ID = l_line_id
104: AND STANDARD_OPERATION_ID IS NULL;
105:

Line 108: FROM FLM_EXE_PREFERENCES

104: AND STANDARD_OPERATION_ID IS NULL;
105:
106: CURSOR c_view_all_org IS
107: SELECT VIEW_ALL_SCHEDULES
108: FROM FLM_EXE_PREFERENCES
109: WHERE ORGANIZATION_ID = l_org_id
110: AND LINE_ID IS NULL
111: AND STANDARD_OPERATION_ID IS NULL;
112:

Line 222: FLM_EXE_PREFERENCES

218: CURSOR c_wkstn_enabled IS
219: SELECT
220: WORKSTATION_ENABLED
221: FROM
222: FLM_EXE_PREFERENCES
223: WHERE
224: ORGANIZATION_ID = l_org_id AND
225: NVL(LINE_ID,-1) = NVL(l_line_id,-1) AND
226: NVL(STANDARD_OPERATION_ID,-1) = nvl(l_operation_id,-1);

Line 1298: from flm_exe_preferences

1294: --2 = ALL
1295:
1296: CURSOR line_bf_option(p_org_id IN NUMBER, p_line_id IN NUMBER) IS
1297: select nvl(backflush_option, G_BFLUSH_OPTION_ALL) backflush_option
1298: from flm_exe_preferences
1299: where organization_id = p_org_id
1300: and line_id = p_line_id;
1301:
1302: CURSOR org_bf_option(p_org_id IN NUMBER) IS

Line 1304: from flm_exe_preferences

1300: and line_id = p_line_id;
1301:
1302: CURSOR org_bf_option(p_org_id IN NUMBER) IS
1303: select nvl(backflush_option,G_BFLUSH_OPTION_ALL) backflush_option
1304: from flm_exe_preferences
1305: where organization_id = p_org_id;
1306: l_bf_option NUMBER;
1307:
1308: BEGIN