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.AZW_PROC dependencies on AZ_PROCESSES

Line 6: item_type az_processes.item_type%TYPE,

2: /* $Header: AZWPROCB.pls 115.46 2003/04/08 08:50:04 sbandi ship $: */
3:
4:
5: TYPE status_rec_t IS RECORD (
6: item_type az_processes.item_type%TYPE,
7: process_name az_processes.process_name%TYPE,
8: context_id az_processes.context_id%TYPE);
9:
10: TYPE status_tbl_t IS TABLE OF status_rec_t INDEX BY BINARY_INTEGER;

Line 7: process_name az_processes.process_name%TYPE,

3:
4:
5: TYPE status_rec_t IS RECORD (
6: item_type az_processes.item_type%TYPE,
7: process_name az_processes.process_name%TYPE,
8: context_id az_processes.context_id%TYPE);
9:
10: TYPE status_tbl_t IS TABLE OF status_rec_t INDEX BY BINARY_INTEGER;
11:

Line 8: context_id az_processes.context_id%TYPE);

4:
5: TYPE status_rec_t IS RECORD (
6: item_type az_processes.item_type%TYPE,
7: process_name az_processes.process_name%TYPE,
8: context_id az_processes.context_id%TYPE);
9:
10: TYPE status_tbl_t IS TABLE OF status_rec_t INDEX BY BINARY_INTEGER;
11:
12: group_status_tbl status_tbl_t;

Line 17: item_type az_processes.item_type%TYPE,

13:
14: group_status_index BINARY_INTEGER DEFAULT 0;
15:
16: TYPE process_rec_t IS RECORD (
17: item_type az_processes.item_type%TYPE,
18: process_name az_processes.process_name%TYPE,
19: parent_id az_processes.parent_id%TYPE,
20: context_type az_processes.context_type%TYPE,
21: display_order az_processes.display_order%TYPE,

Line 18: process_name az_processes.process_name%TYPE,

14: group_status_index BINARY_INTEGER DEFAULT 0;
15:
16: TYPE process_rec_t IS RECORD (
17: item_type az_processes.item_type%TYPE,
18: process_name az_processes.process_name%TYPE,
19: parent_id az_processes.parent_id%TYPE,
20: context_type az_processes.context_type%TYPE,
21: display_order az_processes.display_order%TYPE,
22: process_type az_processes.process_type%TYPE);

Line 19: parent_id az_processes.parent_id%TYPE,

15:
16: TYPE process_rec_t IS RECORD (
17: item_type az_processes.item_type%TYPE,
18: process_name az_processes.process_name%TYPE,
19: parent_id az_processes.parent_id%TYPE,
20: context_type az_processes.context_type%TYPE,
21: display_order az_processes.display_order%TYPE,
22: process_type az_processes.process_type%TYPE);
23:

Line 20: context_type az_processes.context_type%TYPE,

16: TYPE process_rec_t IS RECORD (
17: item_type az_processes.item_type%TYPE,
18: process_name az_processes.process_name%TYPE,
19: parent_id az_processes.parent_id%TYPE,
20: context_type az_processes.context_type%TYPE,
21: display_order az_processes.display_order%TYPE,
22: process_type az_processes.process_type%TYPE);
23:
24: TYPE process_tbl_t IS TABLE OF process_rec_t INDEX BY BINARY_INTEGER;

Line 21: display_order az_processes.display_order%TYPE,

17: item_type az_processes.item_type%TYPE,
18: process_name az_processes.process_name%TYPE,
19: parent_id az_processes.parent_id%TYPE,
20: context_type az_processes.context_type%TYPE,
21: display_order az_processes.display_order%TYPE,
22: process_type az_processes.process_type%TYPE);
23:
24: TYPE process_tbl_t IS TABLE OF process_rec_t INDEX BY BINARY_INTEGER;
25:

Line 22: process_type az_processes.process_type%TYPE);

18: process_name az_processes.process_name%TYPE,
19: parent_id az_processes.parent_id%TYPE,
20: context_type az_processes.context_type%TYPE,
21: display_order az_processes.display_order%TYPE,
22: process_type az_processes.process_type%TYPE);
23:
24: TYPE process_tbl_t IS TABLE OF process_rec_t INDEX BY BINARY_INTEGER;
25:
26: msg_delimiter VARCHAR2(1) := '^';

Line 92: v_ctx_id az_processes.context_id%TYPE;

88: FUNCTION parse_ctxt_id_task(node_id IN VARCHAR2) RETURN NUMBER IS
89:
90: v_first_step PLS_INTEGER;
91: v_second_step PLS_INTEGER;
92: v_ctx_id az_processes.context_id%TYPE;
93:
94: BEGIN
95: -- dbms_output.put_line('parse context id');
96:

Line 120: -- az_processes table. If the process is already in the table,

116: -- process_not_found
117: --
118: -- Private function. Called by set_process.
119: -- Given a process and a context id, check if it already exits in the
120: -- az_processes table. If the process is already in the table,
121: -- return FALSE; otherwise return TRUE.
122: --
123: FUNCTION process_not_found(proc process_rec_t, p_ctx_id NUMBER) RETURN BOOLEAN
124: IS

Line 131: FROM az_processes ap

127: -- dbms_output.put_line('process not found');
128:
129: SELECT count(*)
130: INTO v_cnt
131: FROM az_processes ap
132: WHERE ap.item_type = proc.item_type
133: AND ap.process_name = proc.process_name
134: AND ap.context_id = p_ctx_id;
135:

Line 150: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');

146: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
147: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
148: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
149: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.process_not_found');
150: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
151: APP_EXCEPTION.RAISE_EXCEPTION;
152: END process_not_found;
153:
154:

Line 219: v_type az_processes.item_type%TYPE;

215: --
216: FUNCTION parse_item_type(node_id IN VARCHAR2) RETURN VARCHAR2 IS
217:
218: v_first_sep PLS_INTEGER;
219: v_type az_processes.item_type%TYPE;
220:
221: BEGIN
222:
223: v_first_sep := INSTR(node_id, '.', 1, 1);

Line 251: p_name az_processes.process_name%TYPE;

247: FUNCTION parse_process_name(node_id IN VARCHAR2) RETURN VARCHAR2 IS
248:
249: v_first_sep PLS_INTEGER;
250: v_second_sep PLS_INTEGER;
251: p_name az_processes.process_name%TYPE;
252:
253: BEGIN
254:
255: v_first_sep := INSTR(node_id, '.', 1, 1);

Line 284: p_name az_processes.process_name%TYPE;

280: FUNCTION parse_process_name_task(node_id IN VARCHAR2) RETURN VARCHAR2 IS
281:
282: v_first_sep PLS_INTEGER;
283: v_second_sep PLS_INTEGER;
284: p_name az_processes.process_name%TYPE;
285:
286: BEGIN
287:
288: v_first_sep := INSTR(node_id, '.', 1, 1);

Line 316: v_ctx_id az_processes.context_id%TYPE;

312: FUNCTION parse_context_id(node_id IN VARCHAR2) RETURN VARCHAR2 IS
313:
314: v_last_sep PLS_INTEGER;
315: v_len PLS_INTEGER;
316: v_ctx_id az_processes.context_id%TYPE;
317:
318: BEGIN
319:
320: v_last_sep := INSTR(node_id, '.', -1, 1);

Line 382: v_process_parent_id az_processes.parent_id%TYPE;

378: --
379: FUNCTION get_group_color(node_id IN VARCHAR2) RETURN VARCHAR2
380: IS
381:
382: v_process_parent_id az_processes.parent_id%TYPE;
383: v_process_item_type az_processes.item_type%TYPE;
384: v_process_name az_processes.process_name%TYPE;
385: v_process_ctxt_id az_processes.context_id%TYPE;
386: p_group_id az_groups.group_id%TYPE;

Line 383: v_process_item_type az_processes.item_type%TYPE;

379: FUNCTION get_group_color(node_id IN VARCHAR2) RETURN VARCHAR2
380: IS
381:
382: v_process_parent_id az_processes.parent_id%TYPE;
383: v_process_item_type az_processes.item_type%TYPE;
384: v_process_name az_processes.process_name%TYPE;
385: v_process_ctxt_id az_processes.context_id%TYPE;
386: p_group_id az_groups.group_id%TYPE;
387: v_group_color az_groups.color_code%TYPE;

Line 384: v_process_name az_processes.process_name%TYPE;

380: IS
381:
382: v_process_parent_id az_processes.parent_id%TYPE;
383: v_process_item_type az_processes.item_type%TYPE;
384: v_process_name az_processes.process_name%TYPE;
385: v_process_ctxt_id az_processes.context_id%TYPE;
386: p_group_id az_groups.group_id%TYPE;
387: v_group_color az_groups.color_code%TYPE;
388: p_node_id VARCHAR2(300);

Line 385: v_process_ctxt_id az_processes.context_id%TYPE;

381:
382: v_process_parent_id az_processes.parent_id%TYPE;
383: v_process_item_type az_processes.item_type%TYPE;
384: v_process_name az_processes.process_name%TYPE;
385: v_process_ctxt_id az_processes.context_id%TYPE;
386: p_group_id az_groups.group_id%TYPE;
387: v_group_color az_groups.color_code%TYPE;
388: p_node_id VARCHAR2(300);
389:

Line 399: FROM az_processes

395:
396: BEGIN
397: SELECT parent_id
398: INTO v_process_parent_id
399: FROM az_processes
400: WHERE item_type = v_process_item_type
401: AND process_name = v_process_name
402: AND context_id = v_process_ctxt_id;
403: EXCEPTION

Line 409: fnd_message.set_token('AZW_ERROR_STMT','select parent_id from az_processes');

405: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
406: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
407: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
408: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');
409: fnd_message.set_token('AZW_ERROR_STMT','select parent_id from az_processes');
410: APP_EXCEPTION.RAISE_EXCEPTION;
411: END;
412:
413: p_group_id := v_process_parent_id;

Line 490: v_ctxt_type az_processes.context_type%TYPE;

486: p_process_name IN VARCHAR2,
487: p_context_id IN NUMBER)
488: RETURN VARCHAR2 IS
489:
490: v_ctxt_type az_processes.context_type%TYPE;
491:
492: BEGIN
493:
494: IF (p_context_id > -1) THEN

Line 532: v_ctxt_name az_processes.context_name%TYPE;

528:
529: curs integer;
530: rows integer;
531: sqlstatement az_contexts_sql.SQL_STATEMENT%TYPE;
532: v_ctxt_name az_processes.context_name%TYPE;
533:
534: BEGIN
535:
536: v_ctxt_name := NULL;

Line 582: v_ctxt_name az_processes.context_name%TYPE;

578: --
579: FUNCTION get_context_name(ctx_type IN VARCHAR2, ctx_id IN NUMBER)
580: RETURN VARCHAR2 IS
581:
582: v_ctxt_name az_processes.context_name%TYPE;
583:
584: BEGIN
585:
586: IF (ctx_type = 'BG') THEN

Line 1050: -- Private procedure. Called by populate_az_processes.

1046:
1047: --
1048: -- get_processes
1049: --
1050: -- Private procedure. Called by populate_az_processes.
1051: -- Retrieve all workflow runnable processes for installed products
1052: -- and store them in the given PL/SQL table.
1053: --
1054: PROCEDURE get_processes(proc_table OUT NOCOPY process_tbl_t) IS

Line 1089: -- insert_az_processes

1085: END get_processes;
1086:
1087:
1088: --
1089: -- insert_az_processes
1090: --
1091: -- Private procedure. Called by populate_processes.
1092: -- Insert the process into az_processes for each context.
1093: -- (Cartesian product)

Line 1092: -- Insert the process into az_processes for each context.

1088: --
1089: -- insert_az_processes
1090: --
1091: -- Private procedure. Called by populate_processes.
1092: -- Insert the process into az_processes for each context.
1093: -- (Cartesian product)
1094: -- Check if the process with the context is already in the table; insert
1095: -- the one not already in the table.
1096: --

Line 1097: PROCEDURE insert_az_processes(proc IN process_rec_t,ctxts IN context_tbl_t) IS

1093: -- (Cartesian product)
1094: -- Check if the process with the context is already in the table; insert
1095: -- the one not already in the table.
1096: --
1097: PROCEDURE insert_az_processes(proc IN process_rec_t,ctxts IN context_tbl_t) IS
1098:
1099: BEGIN
1100:
1101: FOR j IN 1..ctxts.COUNT LOOP

Line 1105: INSERT INTO az_processes(item_type, process_name, context_id,

1101: FOR j IN 1..ctxts.COUNT LOOP
1102:
1103: IF process_not_found(proc, ctxts(j).context_id) THEN
1104: BEGIN
1105: INSERT INTO az_processes(item_type, process_name, context_id,
1106: display_order, complete_flag,
1107: context_type, context_name, comments,parent_id,
1108: status_code, process_type)
1109: VALUES (proc.item_type, proc.process_name,

Line 1123: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');

1119: WHEN OTHERS THEN
1120: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1121: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1122: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1123: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1124: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');
1125: APP_EXCEPTION.RAISE_EXCEPTION;
1126: END;
1127:

Line 1124: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');

1120: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1121: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1122: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1123: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1124: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');
1125: APP_EXCEPTION.RAISE_EXCEPTION;
1126: END;
1127:
1128: ELSE

Line 1130: UPDATE az_processes

1126: END;
1127:
1128: ELSE
1129: BEGIN
1130: UPDATE az_processes
1131: SET context_name = ctxts(j).context_name
1132: WHERE item_type = proc.item_type
1133: AND process_name = proc.process_name
1134: AND context_id = ctxts(j).context_id

Line 1141: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');

1137: WHEN OTHERS THEN
1138: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1139: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1140: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1141: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1142: fnd_message.set_token('AZW_ERROR_STMT','update az_processes');
1143: APP_EXCEPTION.RAISE_EXCEPTION;
1144: END;
1145: END IF;

Line 1142: fnd_message.set_token('AZW_ERROR_STMT','update az_processes');

1138: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1139: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1140: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1141: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1142: fnd_message.set_token('AZW_ERROR_STMT','update az_processes');
1143: APP_EXCEPTION.RAISE_EXCEPTION;
1144: END;
1145: END IF;
1146: END LOOP;

Line 1152: -- DBMS_OUTPUT.PUT_LINE('error: insert_az_processes(context): ' || SQLERRM);

1148: EXCEPTION
1149: WHEN app_exception.application_exception THEN
1150: RAISE;
1151: WHEN OTHERS THEN
1152: -- DBMS_OUTPUT.PUT_LINE('error: insert_az_processes(context): ' || SQLERRM);
1153: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1154: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1155: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1156: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');

Line 1156: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');

1152: -- DBMS_OUTPUT.PUT_LINE('error: insert_az_processes(context): ' || SQLERRM);
1153: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1154: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1155: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1156: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1157: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1158: APP_EXCEPTION.RAISE_EXCEPTION;
1159:
1160: END insert_az_processes;

Line 1160: END insert_az_processes;

1156: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1157: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1158: APP_EXCEPTION.RAISE_EXCEPTION;
1159:
1160: END insert_az_processes;
1161:
1162:
1163: --
1164: -- insert_az_processes

Line 1164: -- insert_az_processes

1160: END insert_az_processes;
1161:
1162:
1163: --
1164: -- insert_az_processes
1165: --
1166: -- Private procedure. Called by populate_processes.
1167: -- Insert the process without context into az_processes.
1168: -- Check if the process with the context is already in the table; insert

Line 1167: -- Insert the process without context into az_processes.

1163: --
1164: -- insert_az_processes
1165: --
1166: -- Private procedure. Called by populate_processes.
1167: -- Insert the process without context into az_processes.
1168: -- Check if the process with the context is already in the table; insert
1169: -- the one not already in the table.
1170: -- The context_id in az_processes is defaulted to -1.
1171: --

Line 1170: -- The context_id in az_processes is defaulted to -1.

1166: -- Private procedure. Called by populate_processes.
1167: -- Insert the process without context into az_processes.
1168: -- Check if the process with the context is already in the table; insert
1169: -- the one not already in the table.
1170: -- The context_id in az_processes is defaulted to -1.
1171: --
1172: PROCEDURE insert_az_processes(proc IN process_rec_t) IS
1173:
1174: BEGIN

Line 1172: PROCEDURE insert_az_processes(proc IN process_rec_t) IS

1168: -- Check if the process with the context is already in the table; insert
1169: -- the one not already in the table.
1170: -- The context_id in az_processes is defaulted to -1.
1171: --
1172: PROCEDURE insert_az_processes(proc IN process_rec_t) IS
1173:
1174: BEGIN
1175:
1176: IF process_not_found(proc, -1) THEN

Line 1178: INSERT INTO az_processes (item_type, process_name, context_id,

1174: BEGIN
1175:
1176: IF process_not_found(proc, -1) THEN
1177: BEGIN
1178: INSERT INTO az_processes (item_type, process_name, context_id,
1179: display_order, complete_flag,
1180: context_type, context_name, comments, parent_id,
1181: status_code, process_type)
1182: VALUES (proc.item_type, proc.process_name, -1, proc.display_order, 'N',

Line 1190: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');

1186: WHEN OTHERS THEN
1187: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1188: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1189: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1190: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');
1191: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');
1192: APP_EXCEPTION.RAISE_EXCEPTION;
1193: END;
1194:

Line 1191: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');

1187: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1188: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1189: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1190: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');
1191: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');
1192: APP_EXCEPTION.RAISE_EXCEPTION;
1193: END;
1194:
1195: group_status_index := group_status_index + 1;

Line 1206: -- DBMS_OUTPUT.PUT_LINE('error: insert_az_processes: ' || SQLERRM);

1202: EXCEPTION
1203: WHEN app_exception.application_exception THEN
1204: RAISE;
1205: WHEN OTHERS THEN
1206: -- DBMS_OUTPUT.PUT_LINE('error: insert_az_processes: ' || SQLERRM);
1207: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1208: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1209: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1210: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');

Line 1210: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');

1206: -- DBMS_OUTPUT.PUT_LINE('error: insert_az_processes: ' || SQLERRM);
1207: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1208: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1209: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1210: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');
1211: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1212: APP_EXCEPTION.RAISE_EXCEPTION;
1213:
1214: END insert_az_processes;

Line 1214: END insert_az_processes;

1210: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');
1211: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1212: APP_EXCEPTION.RAISE_EXCEPTION;
1213:
1214: END insert_az_processes;
1215:
1216:
1217: --
1218: -- populate_processes

Line 1220: -- Private procedure. Called by populate_az_processes.

1216:
1217: --
1218: -- populate_processes
1219: --
1220: -- Private procedure. Called by populate_az_processes.
1221: --
1222: PROCEDURE populate_processes(bg_ctx IN context_tbl_t,
1223: io_ctx IN context_tbl_t,
1224: ou_ctx IN context_tbl_t,

Line 1235: insert_az_processes(processes(i), bg_ctx);

1231: -- dbms_output.put_line('populate processes');
1232:
1233: FOR i IN 1..processes.COUNT LOOP
1234: IF (UPPER(processes(i).context_type) LIKE '%BG%') THEN
1235: insert_az_processes(processes(i), bg_ctx);
1236: ELSIF (UPPER(processes(i).context_type) LIKE '%IO%') THEN
1237: insert_az_processes(processes(i), io_ctx);
1238: ELSIF (UPPER(processes(i).context_type) LIKE '%OU%') THEN
1239: insert_az_processes(processes(i), ou_ctx);

Line 1237: insert_az_processes(processes(i), io_ctx);

1233: FOR i IN 1..processes.COUNT LOOP
1234: IF (UPPER(processes(i).context_type) LIKE '%BG%') THEN
1235: insert_az_processes(processes(i), bg_ctx);
1236: ELSIF (UPPER(processes(i).context_type) LIKE '%IO%') THEN
1237: insert_az_processes(processes(i), io_ctx);
1238: ELSIF (UPPER(processes(i).context_type) LIKE '%OU%') THEN
1239: insert_az_processes(processes(i), ou_ctx);
1240: ELSIF (UPPER(processes(i).context_type) LIKE '%SOB%') THEN
1241: insert_az_processes(processes(i), sob_ctx);

Line 1239: insert_az_processes(processes(i), ou_ctx);

1235: insert_az_processes(processes(i), bg_ctx);
1236: ELSIF (UPPER(processes(i).context_type) LIKE '%IO%') THEN
1237: insert_az_processes(processes(i), io_ctx);
1238: ELSIF (UPPER(processes(i).context_type) LIKE '%OU%') THEN
1239: insert_az_processes(processes(i), ou_ctx);
1240: ELSIF (UPPER(processes(i).context_type) LIKE '%SOB%') THEN
1241: insert_az_processes(processes(i), sob_ctx);
1242: ELSIF (UPPER(processes(i).context_type) LIKE '%OPMCOM%') THEN
1243: insert_az_processes(processes(i), opmcom_ctx);

Line 1241: insert_az_processes(processes(i), sob_ctx);

1237: insert_az_processes(processes(i), io_ctx);
1238: ELSIF (UPPER(processes(i).context_type) LIKE '%OU%') THEN
1239: insert_az_processes(processes(i), ou_ctx);
1240: ELSIF (UPPER(processes(i).context_type) LIKE '%SOB%') THEN
1241: insert_az_processes(processes(i), sob_ctx);
1242: ELSIF (UPPER(processes(i).context_type) LIKE '%OPMCOM%') THEN
1243: insert_az_processes(processes(i), opmcom_ctx);
1244: ELSIF (UPPER(processes(i).context_type) LIKE '%OPMORG%') THEN
1245: insert_az_processes(processes(i), opmorg_ctx);

Line 1243: insert_az_processes(processes(i), opmcom_ctx);

1239: insert_az_processes(processes(i), ou_ctx);
1240: ELSIF (UPPER(processes(i).context_type) LIKE '%SOB%') THEN
1241: insert_az_processes(processes(i), sob_ctx);
1242: ELSIF (UPPER(processes(i).context_type) LIKE '%OPMCOM%') THEN
1243: insert_az_processes(processes(i), opmcom_ctx);
1244: ELSIF (UPPER(processes(i).context_type) LIKE '%OPMORG%') THEN
1245: insert_az_processes(processes(i), opmorg_ctx);
1246: ELSE
1247: insert_az_processes(processes(i));

Line 1245: insert_az_processes(processes(i), opmorg_ctx);

1241: insert_az_processes(processes(i), sob_ctx);
1242: ELSIF (UPPER(processes(i).context_type) LIKE '%OPMCOM%') THEN
1243: insert_az_processes(processes(i), opmcom_ctx);
1244: ELSIF (UPPER(processes(i).context_type) LIKE '%OPMORG%') THEN
1245: insert_az_processes(processes(i), opmorg_ctx);
1246: ELSE
1247: insert_az_processes(processes(i));
1248: END IF;
1249: END LOOP;

Line 1247: insert_az_processes(processes(i));

1243: insert_az_processes(processes(i), opmcom_ctx);
1244: ELSIF (UPPER(processes(i).context_type) LIKE '%OPMORG%') THEN
1245: insert_az_processes(processes(i), opmorg_ctx);
1246: ELSE
1247: insert_az_processes(processes(i));
1248: END IF;
1249: END LOOP;
1250: COMMIT;
1251:

Line 1310: -- Private procedure. Called by populate_az_processes.

1306:
1307: --
1308: -- disable_invalid_processes
1309: --
1310: -- Private procedure. Called by populate_az_processes.
1311: -- Delete processes that are not valid as of the date this procedure is
1312: -- executed. These processes include those in BG, IO, OU types. SOB type
1313: -- doesn't define from/to dates.
1314: --

Line 1319: v_item_type az_processes.item_type%TYPE;

1315: PROCEDURE disable_invalid_processes IS
1316:
1317: cnt PLS_INTEGER DEFAULT 0;
1318: v_installed_prods PLS_INTEGER DEFAULT 0;
1319: v_item_type az_processes.item_type%TYPE;
1320: v_process_name az_processes.process_name%TYPE;
1321:
1322: CURSOR invalid_bg_processes_cursor IS
1323: SELECT ap.item_type, ap.process_name, ap.context_id

Line 1320: v_process_name az_processes.process_name%TYPE;

1316:
1317: cnt PLS_INTEGER DEFAULT 0;
1318: v_installed_prods PLS_INTEGER DEFAULT 0;
1319: v_item_type az_processes.item_type%TYPE;
1320: v_process_name az_processes.process_name%TYPE;
1321:
1322: CURSOR invalid_bg_processes_cursor IS
1323: SELECT ap.item_type, ap.process_name, ap.context_id
1324: FROM az_processes ap,

Line 1324: FROM az_processes ap,

1320: v_process_name az_processes.process_name%TYPE;
1321:
1322: CURSOR invalid_bg_processes_cursor IS
1323: SELECT ap.item_type, ap.process_name, ap.context_id
1324: FROM az_processes ap,
1325: per_business_groups pbg
1326: WHERE ap.context_type = 'BG'
1327: AND ap.process_type = g_current_mode
1328: AND ap.context_id > -1

Line 1337: FROM az_processes ap,

1333: OR pbg.date_to < SYSDATE));
1334:
1335: CURSOR invalid_io_processes_cursor IS
1336: SELECT ap.item_type, ap.process_name, ap.context_id
1337: FROM az_processes ap,
1338: org_organization_definitions ood
1339: WHERE ap.context_type = 'IO'
1340: AND ap.process_type = g_current_mode
1341: AND ap.context_id > -1

Line 1350: FROM az_processes ap,

1346: OR ood.disable_date < SYSDATE));
1347:
1348: CURSOR invalid_ou_processes_cursor IS
1349: SELECT ap.item_type, ap.process_name, ap.context_id
1350: FROM az_processes ap,
1351: hr_operating_units hou
1352: WHERE ap.context_type = 'OU'
1353: AND ap.process_type = g_current_mode
1354: AND ap.context_id > -1

Line 1363: -- get rid of non-existent BG processes from az_processes

1359: OR hou.date_to < SYSDATE));
1360:
1361: BEGIN
1362: -- dbms_output.put_line('disable invalid process');
1363: -- get rid of non-existent BG processes from az_processes
1364: DELETE from az_processes
1365: WHERE context_type = 'BG'
1366: AND context_id not in
1367: ( select distinct organization_id

Line 1364: DELETE from az_processes

1360:
1361: BEGIN
1362: -- dbms_output.put_line('disable invalid process');
1363: -- get rid of non-existent BG processes from az_processes
1364: DELETE from az_processes
1365: WHERE context_type = 'BG'
1366: AND context_id not in
1367: ( select distinct organization_id
1368: from per_business_groups);

Line 1369: -- get rid of non-existent IO processes from az_processes

1365: WHERE context_type = 'BG'
1366: AND context_id not in
1367: ( select distinct organization_id
1368: from per_business_groups);
1369: -- get rid of non-existent IO processes from az_processes
1370: DELETE from az_processes
1371: WHERE context_type = 'IO'
1372: AND context_id not in
1373: ( select distinct organization_id

Line 1370: DELETE from az_processes

1366: AND context_id not in
1367: ( select distinct organization_id
1368: from per_business_groups);
1369: -- get rid of non-existent IO processes from az_processes
1370: DELETE from az_processes
1371: WHERE context_type = 'IO'
1372: AND context_id not in
1373: ( select distinct organization_id
1374: from org_organization_definitions);

Line 1375: -- get rid of non-existent OU processes from az_processes

1371: WHERE context_type = 'IO'
1372: AND context_id not in
1373: ( select distinct organization_id
1374: from org_organization_definitions);
1375: -- get rid of non-existent OU processes from az_processes
1376: DELETE from az_processes
1377: WHERE context_type = 'OU'
1378: AND context_id not in
1379: ( select distinct organization_id

Line 1376: DELETE from az_processes

1372: AND context_id not in
1373: ( select distinct organization_id
1374: from org_organization_definitions);
1375: -- get rid of non-existent OU processes from az_processes
1376: DELETE from az_processes
1377: WHERE context_type = 'OU'
1378: AND context_id not in
1379: ( select distinct organization_id
1380: from hr_operating_units);

Line 1389: FROM az_processes;

1385:
1386: BEGIN
1387: SELECT COUNT(*)
1388: INTO cnt
1389: FROM az_processes;
1390: EXCEPTION
1391: WHEN OTHERS THEN
1392: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1393: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 1396: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');

1392: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1393: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1394: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1395: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1396: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
1397: APP_EXCEPTION.RAISE_EXCEPTION;
1398: END ;
1399:
1400: IF (cnt <> 0) THEN

Line 1403: DELETE from az_processes ap

1399:
1400: IF (cnt <> 0) THEN
1401: BEGIN
1402: FOR invalid_process IN invalid_bg_processes_cursor LOOP
1403: DELETE from az_processes ap
1404: WHERE ap.item_type = invalid_process.item_type
1405: AND ap.process_name = invalid_process.process_name
1406: AND ap.context_id = invalid_process.context_id;
1407:

Line 1428: DELETE from az_processes ap

1424: END ;
1425:
1426: BEGIN
1427: FOR invalid_process IN invalid_io_processes_cursor LOOP
1428: DELETE from az_processes ap
1429: WHERE ap.item_type = invalid_process.item_type
1430: AND ap.process_name = invalid_process.process_name
1431: AND ap.context_id = invalid_process.context_id;
1432:

Line 1453: DELETE from az_processes ap

1449: END ;
1450:
1451: BEGIN
1452: FOR invalid_process IN invalid_ou_processes_cursor LOOP
1453: DELETE from az_processes ap
1454: WHERE ap.item_type = invalid_process.item_type
1455: AND ap.process_name = invalid_process.process_name
1456: AND ap.context_id = invalid_process.context_id;
1457:

Line 1496: -- POPULATE_AZ_PROCESSES

1492: END disable_invalid_processes;
1493:
1494:
1495: --
1496: -- POPULATE_AZ_PROCESSES
1497: --
1498: -- Public procedure. Called by AZW_HIER.get_hierarchy each time
1499: -- hierarchy is shown.
1500: --

Line 1501: PROCEDURE populate_az_processes IS

1497: --
1498: -- Public procedure. Called by AZW_HIER.get_hierarchy each time
1499: -- hierarchy is shown.
1500: --
1501: PROCEDURE populate_az_processes IS
1502:
1503: bg_ctx context_tbl_t;
1504: io_ctx context_tbl_t;
1505: ou_ctx context_tbl_t;

Line 1514: -- dbms_output.put_line('populate az_processes table');

1510: opmorg_ctx context_tbl_t;
1511:
1512:
1513: BEGIN
1514: -- dbms_output.put_line('populate az_processes table');
1515:
1516: g_current_mode := fnd_profile.value('AZ_CURRENT_MODE');
1517:
1518: -- get the current session language for task_init

Line 1530: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_az_processes');

1526: WHEN OTHERS THEN
1527: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1528: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1529: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1530: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_az_processes');
1531: fnd_message.set_token('AZW_ERROR_STMT','select language_code .. from fnd_languages');
1532: APP_EXCEPTION.RAISE_EXCEPTION;
1533: END;
1534: get_context('BG', bg_ctx);

Line 1579: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_az_processes');

1575: WHEN OTHERS THEN
1576: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1577: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1578: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1579: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_az_processes');
1580: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1581: APP_EXCEPTION.RAISE_EXCEPTION;
1582:
1583: END populate_az_processes;

Line 1583: END populate_az_processes;

1579: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_az_processes');
1580: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1581: APP_EXCEPTION.RAISE_EXCEPTION;
1582:
1583: END populate_az_processes;
1584:
1585:
1586: --
1587: -- UPDATE_PROCESS_PHASE

Line 1595: p_type az_processes.item_type%TYPE;

1591: -- Updates phase information for a given process
1592: --
1593: PROCEDURE update_process_phase(node_id IN VARCHAR2, value IN NUMBER) IS
1594:
1595: p_type az_processes.item_type%TYPE;
1596: p_name az_processes.process_name%TYPE;
1597: ctx_id az_processes.context_id%TYPE;
1598:
1599: BEGIN

Line 1596: p_name az_processes.process_name%TYPE;

1592: --
1593: PROCEDURE update_process_phase(node_id IN VARCHAR2, value IN NUMBER) IS
1594:
1595: p_type az_processes.item_type%TYPE;
1596: p_name az_processes.process_name%TYPE;
1597: ctx_id az_processes.context_id%TYPE;
1598:
1599: BEGIN
1600: p_type := parse_item_type(node_id);

Line 1597: ctx_id az_processes.context_id%TYPE;

1593: PROCEDURE update_process_phase(node_id IN VARCHAR2, value IN NUMBER) IS
1594:
1595: p_type az_processes.item_type%TYPE;
1596: p_name az_processes.process_name%TYPE;
1597: ctx_id az_processes.context_id%TYPE;
1598:
1599: BEGIN
1600: p_type := parse_item_type(node_id);
1601: p_name := parse_process_name(node_id);

Line 1605: UPDATE az_processes ap

1601: p_name := parse_process_name(node_id);
1602: ctx_id := parse_context_id(node_id);
1603:
1604: /*
1605: UPDATE az_processes ap
1606: SET ap.phase = value
1607: WHERE ap.item_type = p_type
1608: AND ap.process_name = p_name
1609: AND ap.context_id = TO_NUMBER(ctx_id);

Line 1629: p_type az_processes.item_type%TYPE;

1625: -- Updates phase information for a given process
1626: --
1627: PROCEDURE update_process_comments(node_id IN VARCHAR2, value IN VARCHAR2) IS
1628:
1629: p_type az_processes.item_type%TYPE;
1630: p_name az_processes.process_name%TYPE;
1631: ctx_id az_processes.context_id%TYPE;
1632:
1633: BEGIN

Line 1630: p_name az_processes.process_name%TYPE;

1626: --
1627: PROCEDURE update_process_comments(node_id IN VARCHAR2, value IN VARCHAR2) IS
1628:
1629: p_type az_processes.item_type%TYPE;
1630: p_name az_processes.process_name%TYPE;
1631: ctx_id az_processes.context_id%TYPE;
1632:
1633: BEGIN
1634: p_type := parse_item_type(node_id);

Line 1631: ctx_id az_processes.context_id%TYPE;

1627: PROCEDURE update_process_comments(node_id IN VARCHAR2, value IN VARCHAR2) IS
1628:
1629: p_type az_processes.item_type%TYPE;
1630: p_name az_processes.process_name%TYPE;
1631: ctx_id az_processes.context_id%TYPE;
1632:
1633: BEGIN
1634: p_type := parse_item_type(node_id);
1635: p_name := parse_process_name(node_id);

Line 1639: UPDATE az_processes ap

1635: p_name := parse_process_name(node_id);
1636: ctx_id := parse_context_id(node_id);
1637:
1638: BEGIN
1639: UPDATE az_processes ap
1640: SET ap.comments = value
1641: WHERE ap.item_type = p_type
1642: AND ap.process_name = p_name
1643: AND ap.context_id = TO_NUMBER(ctx_id);

Line 1846: FROM az_processes ap

1842: BEGIN
1843: BEGIN
1844: SELECT ap.parent_id
1845: INTO v_group_id
1846: FROM az_processes ap
1847: WHERE ap.item_type = p_item_type
1848: AND ap.process_name = p_process_name
1849: AND ap.process_type = g_current_mode
1850: AND ap.context_id = p_context_id;

Line 1859: fnd_message.set_token('AZW_ERROR_STMT','select parent_id from az_processes');

1855: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1856: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1857: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1858: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1859: fnd_message.set_token('AZW_ERROR_STMT','select parent_id from az_processes');
1860: APP_EXCEPTION.RAISE_EXCEPTION;
1861: END;
1862:
1863: IF v_group_id is null THEN

Line 1869: FROM az_processes ap

1865: ELSE
1866: BEGIN
1867: SELECT COUNT(*)
1868: INTO v_cnt
1869: FROM az_processes ap
1870: WHERE ap.status_code <> 'C'
1871: AND ap.process_type = g_current_mode
1872: AND ap.parent_id = v_group_id;
1873: EXCEPTION

Line 1879: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');

1875: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1876: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1877: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1878: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1879: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
1880: APP_EXCEPTION.RAISE_EXCEPTION;
1881: END;
1882:
1883: IF (v_cnt = 0) THEN

Line 1932: p_type az_processes.item_type%TYPE;

1928: -- Updates phase information for a given process
1929: --
1930: PROCEDURE update_process_status(node_id IN VARCHAR2, value IN VARCHAR2) IS
1931:
1932: p_type az_processes.item_type%TYPE;
1933: p_name az_processes.process_name%TYPE;
1934: ctx_id az_processes.context_id%TYPE;
1935: v_count NUMBER(30);
1936: BEGIN

Line 1933: p_name az_processes.process_name%TYPE;

1929: --
1930: PROCEDURE update_process_status(node_id IN VARCHAR2, value IN VARCHAR2) IS
1931:
1932: p_type az_processes.item_type%TYPE;
1933: p_name az_processes.process_name%TYPE;
1934: ctx_id az_processes.context_id%TYPE;
1935: v_count NUMBER(30);
1936: BEGIN
1937: p_type := parse_item_type(node_id);

Line 1934: ctx_id az_processes.context_id%TYPE;

1930: PROCEDURE update_process_status(node_id IN VARCHAR2, value IN VARCHAR2) IS
1931:
1932: p_type az_processes.item_type%TYPE;
1933: p_name az_processes.process_name%TYPE;
1934: ctx_id az_processes.context_id%TYPE;
1935: v_count NUMBER(30);
1936: BEGIN
1937: p_type := parse_item_type(node_id);
1938: p_name := parse_process_name(node_id);

Line 1963: UPDATE az_processes ap

1959: END;
1960:
1961: IF (value <> 'N') THEN
1962: BEGIN
1963: UPDATE az_processes ap
1964: SET ap.status_code = value
1965: WHERE ap.item_type = p_type
1966: AND ap.process_name = p_name
1967: AND ap.context_id = TO_NUMBER(ctx_id);

Line 1975: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = value');

1971: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1972: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1973: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1974: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1975: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = value');
1976: APP_EXCEPTION.RAISE_EXCEPTION;
1977: END;
1978: ELSE
1979: IF (v_count <> 0) THEN

Line 1981: UPDATE az_processes ap

1977: END;
1978: ELSE
1979: IF (v_count <> 0) THEN
1980: BEGIN
1981: UPDATE az_processes ap
1982: SET ap.status_code = 'A'
1983: WHERE ap.item_type = p_type
1984: AND ap.process_name = p_name
1985: AND ap.context_id = TO_NUMBER(ctx_id);

Line 1993: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = A');

1989: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1990: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1991: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1992: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1993: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = A');
1994: APP_EXCEPTION.RAISE_EXCEPTION;
1995: END;
1996: ELSE
1997: BEGIN

Line 1998: UPDATE az_processes ap

1994: APP_EXCEPTION.RAISE_EXCEPTION;
1995: END;
1996: ELSE
1997: BEGIN
1998: UPDATE az_processes ap
1999: SET ap.status_code = 'N'
2000: WHERE ap.item_type = p_type
2001: AND ap.process_name = p_name
2002: AND ap.context_id = TO_NUMBER(ctx_id);

Line 2009: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = N');

2005: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2006: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2007: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2008: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
2009: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = N');
2010: APP_EXCEPTION.RAISE_EXCEPTION;
2011: END;
2012: END IF; /* for process complete unchecked */
2013: END IF;

Line 2337: p_type az_processes.item_type%TYPE;

2333: --
2334: FUNCTION az_start_task(node_id IN VARCHAR2, role IN VARCHAR2) RETURN VARCHAR2
2335: IS
2336:
2337: p_type az_processes.item_type%TYPE;
2338: p_name az_processes.process_name%TYPE;
2339: ctx_id az_processes.context_id%TYPE;
2340: ctx_type az_processes.context_type%TYPE;
2341: ctx_name az_processes.context_name%TYPE;

Line 2338: p_name az_processes.process_name%TYPE;

2334: FUNCTION az_start_task(node_id IN VARCHAR2, role IN VARCHAR2) RETURN VARCHAR2
2335: IS
2336:
2337: p_type az_processes.item_type%TYPE;
2338: p_name az_processes.process_name%TYPE;
2339: ctx_id az_processes.context_id%TYPE;
2340: ctx_type az_processes.context_type%TYPE;
2341: ctx_name az_processes.context_name%TYPE;
2342: org_code org_access_view.organization_code%TYPE DEFAULT NULL;

Line 2339: ctx_id az_processes.context_id%TYPE;

2335: IS
2336:
2337: p_type az_processes.item_type%TYPE;
2338: p_name az_processes.process_name%TYPE;
2339: ctx_id az_processes.context_id%TYPE;
2340: ctx_type az_processes.context_type%TYPE;
2341: ctx_name az_processes.context_name%TYPE;
2342: org_code org_access_view.organization_code%TYPE DEFAULT NULL;
2343: coa_id org_access_view.chart_of_accounts_id%TYPE DEFAULT NULL;

Line 2340: ctx_type az_processes.context_type%TYPE;

2336:
2337: p_type az_processes.item_type%TYPE;
2338: p_name az_processes.process_name%TYPE;
2339: ctx_id az_processes.context_id%TYPE;
2340: ctx_type az_processes.context_type%TYPE;
2341: ctx_name az_processes.context_name%TYPE;
2342: org_code org_access_view.organization_code%TYPE DEFAULT NULL;
2343: coa_id org_access_view.chart_of_accounts_id%TYPE DEFAULT NULL;
2344: p_role wf_roles.name%TYPE;

Line 2341: ctx_name az_processes.context_name%TYPE;

2337: p_type az_processes.item_type%TYPE;
2338: p_name az_processes.process_name%TYPE;
2339: ctx_id az_processes.context_id%TYPE;
2340: ctx_type az_processes.context_type%TYPE;
2341: ctx_name az_processes.context_name%TYPE;
2342: org_code org_access_view.organization_code%TYPE DEFAULT NULL;
2343: coa_id org_access_view.chart_of_accounts_id%TYPE DEFAULT NULL;
2344: p_role wf_roles.name%TYPE;
2345: msg az_webform_messages.mesg%TYPE;

Line 2403: v_type az_processes.item_type%TYPE;

2399: --
2400: FUNCTION az_reassign_task(node_id IN VARCHAR2, p_role IN VARCHAR2)
2401: RETURN VARCHAR2
2402: IS
2403: v_type az_processes.item_type%TYPE;
2404: v_key wf_items.item_key%TYPE;
2405: p_name az_processes.process_name%TYPE;
2406: label az_webform_messages.mesg%TYPE;
2407:

Line 2405: p_name az_processes.process_name%TYPE;

2401: RETURN VARCHAR2
2402: IS
2403: v_type az_processes.item_type%TYPE;
2404: v_key wf_items.item_key%TYPE;
2405: p_name az_processes.process_name%TYPE;
2406: label az_webform_messages.mesg%TYPE;
2407:
2408: BEGIN
2409:

Line 2438: v_type az_processes.item_type%TYPE;

2434: -- Public function. Aborts a task and returns its label
2435: --
2436: FUNCTION az_abort_task(node_id IN VARCHAR2) RETURN VARCHAR2
2437: IS
2438: v_type az_processes.item_type%TYPE;
2439: v_key wf_items.item_key%TYPE;
2440: p_name az_processes.process_name%TYPE;
2441: label az_webform_messages.mesg%TYPE;
2442: p_role wf_roles.name%TYPE;

Line 2440: p_name az_processes.process_name%TYPE;

2436: FUNCTION az_abort_task(node_id IN VARCHAR2) RETURN VARCHAR2
2437: IS
2438: v_type az_processes.item_type%TYPE;
2439: v_key wf_items.item_key%TYPE;
2440: p_name az_processes.process_name%TYPE;
2441: label az_webform_messages.mesg%TYPE;
2442: p_role wf_roles.name%TYPE;
2443:
2444: BEGIN

Line 2479: v_type az_processes.item_type%TYPE;

2475: -- Given a task node id for a task return it's display label
2476: --
2477: FUNCTION get_task_label(node_id IN VARCHAR2) RETURN VARCHAR2
2478: IS
2479: v_type az_processes.item_type%TYPE;
2480: v_key wf_items.item_key%TYPE;
2481: p_name az_processes.process_name%TYPE;
2482: label az_webform_messages.mesg%TYPE;
2483: p_role wf_roles.name%TYPE;

Line 2481: p_name az_processes.process_name%TYPE;

2477: FUNCTION get_task_label(node_id IN VARCHAR2) RETURN VARCHAR2
2478: IS
2479: v_type az_processes.item_type%TYPE;
2480: v_key wf_items.item_key%TYPE;
2481: p_name az_processes.process_name%TYPE;
2482: label az_webform_messages.mesg%TYPE;
2483: p_role wf_roles.name%TYPE;
2484:
2485: BEGIN

Line 2515: v_type az_processes.item_type%TYPE;

2511: -- Given a task node id for a task return it's current status
2512: --
2513: FUNCTION get_task_status(node_id IN VARCHAR2) RETURN VARCHAR2
2514: IS
2515: v_type az_processes.item_type%TYPE;
2516: v_key wf_items.item_key%TYPE;
2517: p_name az_processes.process_name%TYPE;
2518: label az_webform_messages.mesg%TYPE;
2519: v_task_status wf_item_activity_statuses.activity_status%TYPE;

Line 2517: p_name az_processes.process_name%TYPE;

2513: FUNCTION get_task_status(node_id IN VARCHAR2) RETURN VARCHAR2
2514: IS
2515: v_type az_processes.item_type%TYPE;
2516: v_key wf_items.item_key%TYPE;
2517: p_name az_processes.process_name%TYPE;
2518: label az_webform_messages.mesg%TYPE;
2519: v_task_status wf_item_activity_statuses.activity_status%TYPE;
2520:
2521: CURSOR az_task_status_cursor IS

Line 2568: -- Populates the STATUS_CODE column in AZ_PROCESSES to be either

2564: --
2565: -- POPULATE_PROCESS_STATUS
2566: --
2567: -- Public procedure. Called during upgrade from 11.0 to 11.5 only.
2568: -- Populates the STATUS_CODE column in AZ_PROCESSES to be either
2569: -- 'A', 'C', or 'N'.
2570: --
2571:
2572: PROCEDURE populate_process_status IS

Line 2576: FROM az_processes ap,wf_items wfi, wf_item_attribute_values wiav

2572: PROCEDURE populate_process_status IS
2573:
2574: CURSOR az_process_active_cursor IS
2575: SELECT ap.item_type, ap.process_name, ap.context_id
2576: FROM az_processes ap,wf_items wfi, wf_item_attribute_values wiav
2577: WHERE wfi.item_type = ap.item_type
2578: AND wfi.root_activity = ap.process_name
2579: AND wiav.item_type = wfi.item_type
2580: AND wiav.item_key = wfi.item_key

Line 2584: p_item_type az_processes.item_type%TYPE;

2580: AND wiav.item_key = wfi.item_key
2581: AND wiav.name = 'AZW_IA_CTXT_ID'
2582: AND wiav.text_value = ap.context_id
2583: AND ap.complete_flag = 'N';
2584: p_item_type az_processes.item_type%TYPE;
2585: p_process_name az_processes.process_name%TYPE;
2586: p_context_id az_processes.context_id%TYPE;
2587:
2588: BEGIN

Line 2585: p_process_name az_processes.process_name%TYPE;

2581: AND wiav.name = 'AZW_IA_CTXT_ID'
2582: AND wiav.text_value = ap.context_id
2583: AND ap.complete_flag = 'N';
2584: p_item_type az_processes.item_type%TYPE;
2585: p_process_name az_processes.process_name%TYPE;
2586: p_context_id az_processes.context_id%TYPE;
2587:
2588: BEGIN
2589: -- dbms_output.put_line('populate process status');

Line 2586: p_context_id az_processes.context_id%TYPE;

2582: AND wiav.text_value = ap.context_id
2583: AND ap.complete_flag = 'N';
2584: p_item_type az_processes.item_type%TYPE;
2585: p_process_name az_processes.process_name%TYPE;
2586: p_context_id az_processes.context_id%TYPE;
2587:
2588: BEGIN
2589: -- dbms_output.put_line('populate process status');
2590:

Line 2599: UPDATE az_processes

2595: FETCH az_process_active_cursor
2596: INTO p_item_type, p_process_name, p_context_id;
2597:
2598: WHILE az_process_active_cursor%FOUND LOOP
2599: UPDATE az_processes
2600: SET status_code = 'A'
2601: WHERE item_type = p_item_type
2602: AND process_name = p_process_name
2603: AND context_id = p_context_id;

Line 2622: UPDATE az_processes

2618:
2619: BEGIN
2620: -- Update all 'Complete' processes
2621:
2622: UPDATE az_processes
2623: SET status_code = 'C'
2624: WHERE complete_flag = 'Y';
2625: EXCEPTION
2626: WHEN OTHERS THEN

Line 2631: fnd_message.set_token('AZW_ERROR_STMT','update az_processes status code C');

2627: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2628: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2629: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2630: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');
2631: fnd_message.set_token('AZW_ERROR_STMT','update az_processes status code C');
2632: APP_EXCEPTION.RAISE_EXCEPTION;
2633: END;
2634:
2635: BEGIN

Line 2638: UPDATE az_processes

2634:
2635: BEGIN
2636: -- Update all 'Not Started' Processes
2637:
2638: UPDATE az_processes
2639: SET status_code = 'N'
2640: WHERE status_code NOT IN ('A', 'C');
2641: EXCEPTION
2642: WHEN OTHERS THEN

Line 2647: fnd_message.set_token('AZW_ERROR_STMT','update az_processes status code N');

2643: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2644: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2645: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2646: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');
2647: fnd_message.set_token('AZW_ERROR_STMT','update az_processes status code N');
2648: APP_EXCEPTION.RAISE_EXCEPTION;
2649: END;
2650:
2651: COMMIT;