DBA Data[Home] [Help]

APPS.AZW_HIER dependencies on AZW_PROC

Line 25: ctx_table AZW_PROC.context_tbl_t;

21: t_index BINARY_INTEGER DEFAULT 0;
22:
23: -- Start: added by swarup for context sort
24:
25: ctx_table AZW_PROC.context_tbl_t;
26:
27: PROCEDURE insert_context( ctx_type IN VARCHAR2,
28: meaning IN VARCHAR2,
29: msg IN OUT message_tbl_t,

Line 41: ctx_table OUT AZW_PROC.context_tbl_t);

37: PROCEDURE insert_proc_task_for_context( msg IN OUT message_tbl_t,
38: i IN OUT INTEGER );
39:
40: PROCEDURE get_context( ctx_type IN VARCHAR2,
41: ctx_table OUT AZW_PROC.context_tbl_t);
42:
43: -- End: added by swarup for context sort
44:
45: g_current_mode az_processes.process_type%TYPE ;

Line 490: AZW_PROC.get_application_name(v_application_id);

486:
487: t_index := t_index + 1;
488: IF (v_application_id is not null) THEN
489: hierarchy_table(t_index).display_name :=
490: AZW_PROC.get_application_name(v_application_id);
491: ELSE
492: hierarchy_table(t_index).display_name :=
493: AZW_PROC.get_lookup_meaning(v_lookup_code);
494: END IF; /* v_application_id is not null */

Line 493: AZW_PROC.get_lookup_meaning(v_lookup_code);

489: hierarchy_table(t_index).display_name :=
490: AZW_PROC.get_application_name(v_application_id);
491: ELSE
492: hierarchy_table(t_index).display_name :=
493: AZW_PROC.get_lookup_meaning(v_lookup_code);
494: END IF; /* v_application_id is not null */
495:
496: hierarchy_table(t_index).node_id := v_node_id;
497: hierarchy_table(t_index).parent_node_id := v_hierarchy_parent_id;

Line 525: AZW_PROC.get_application_name(v_application_id);

521: IF p_sort_by = 'PH' OR p_sort_by = 'C'THEN
522: t_index := t_index + 1;
523: IF (v_application_id is not null) THEN
524: hierarchy_table(t_index).display_name :=
525: AZW_PROC.get_application_name(v_application_id);
526: ELSE
527: hierarchy_table(t_index).display_name :=
528: AZW_PROC.get_lookup_meaning(v_lookup_code);
529: END IF; /* v_application_id is not null */

Line 528: AZW_PROC.get_lookup_meaning(v_lookup_code);

524: hierarchy_table(t_index).display_name :=
525: AZW_PROC.get_application_name(v_application_id);
526: ELSE
527: hierarchy_table(t_index).display_name :=
528: AZW_PROC.get_lookup_meaning(v_lookup_code);
529: END IF; /* v_application_id is not null */
530:
531: hierarchy_table(t_index).node_id := v_node_id;
532: hierarchy_table(t_index).parent_node_id := v_hierarchy_parent_id;

Line 661: AZW_PROC.get_application_name(v_application_id);

657: t_index := t_index + 1;
658:
659: IF (v_application_id is not null) THEN
660: hierarchy_table(t_index).display_name :=
661: AZW_PROC.get_application_name(v_application_id);
662: ELSE
663: hierarchy_table(t_index).display_name :=
664: AZW_PROC.get_lookup_meaning(v_lookup_code);
665: END IF; /* v_application_id is not null */

Line 664: AZW_PROC.get_lookup_meaning(v_lookup_code);

660: hierarchy_table(t_index).display_name :=
661: AZW_PROC.get_application_name(v_application_id);
662: ELSE
663: hierarchy_table(t_index).display_name :=
664: AZW_PROC.get_lookup_meaning(v_lookup_code);
665: END IF; /* v_application_id is not null */
666:
667: hierarchy_table(t_index).node_id := v_node_id;
668: hierarchy_table(t_index).parent_node_id := 'root';

Line 713: AZW_PROC.get_application_name(v_application_id);

709: t_index := t_index + 1;
710:
711: IF (v_application_id is not null) THEN
712: hierarchy_table(t_index).display_name :=
713: AZW_PROC.get_application_name(v_application_id);
714: ELSE
715: hierarchy_table(t_index).display_name :=
716: AZW_PROC.get_lookup_meaning(v_lookup_code);
717: END IF; /* v_application_id is not null */

Line 716: AZW_PROC.get_lookup_meaning(v_lookup_code);

712: hierarchy_table(t_index).display_name :=
713: AZW_PROC.get_application_name(v_application_id);
714: ELSE
715: hierarchy_table(t_index).display_name :=
716: AZW_PROC.get_lookup_meaning(v_lookup_code);
717: END IF; /* v_application_id is not null */
718:
719: hierarchy_table(t_index).node_id := v_node_id;
720: hierarchy_table(t_index).parent_node_id := 'root';

Line 922: AZW_PROC.get_application_name(v_application_id);

918: t_index := t_index + 1;
919:
920: IF (v_application_id is not null) THEN
921: hierarchy_table(t_index).display_name :=
922: AZW_PROC.get_application_name(v_application_id);
923: ELSE
924: hierarchy_table(t_index).display_name :=
925: AZW_PROC.get_lookup_meaning(v_lookup_code);
926: END IF;

Line 925: AZW_PROC.get_lookup_meaning(v_lookup_code);

921: hierarchy_table(t_index).display_name :=
922: AZW_PROC.get_application_name(v_application_id);
923: ELSE
924: hierarchy_table(t_index).display_name :=
925: AZW_PROC.get_lookup_meaning(v_lookup_code);
926: END IF;
927:
928: hierarchy_table(t_index).node_id := v_node_id;
929: hierarchy_table(t_index).parent_node_id := 'root';

Line 962: AZW_PROC.get_application_name(v_application_id);

958: t_index := t_index + 1;
959:
960: IF (v_application_id is not null) THEN
961: hierarchy_table(t_index).display_name :=
962: AZW_PROC.get_application_name(v_application_id);
963: ELSE
964: hierarchy_table(t_index).display_name :=
965: AZW_PROC.get_lookup_meaning(v_lookup_code);
966: END IF;

Line 965: AZW_PROC.get_lookup_meaning(v_lookup_code);

961: hierarchy_table(t_index).display_name :=
962: AZW_PROC.get_application_name(v_application_id);
963: ELSE
964: hierarchy_table(t_index).display_name :=
965: AZW_PROC.get_lookup_meaning(v_lookup_code);
966: END IF;
967:
968: hierarchy_table(t_index).node_id := v_node_id;
969: hierarchy_table(t_index).parent_node_id := v_hierarchy_parent_id;

Line 1555: -- AZW_PROC.populate_az_processes is now called from AZWIZARD.fmb within the

1551: hierarchy_table.delete;
1552: msg.delete;
1553: t_index := 0;
1554:
1555: -- AZW_PROC.populate_az_processes is now called from AZWIZARD.fmb within the
1556: -- WHEN_NEW_FORM_INSTANCE trigger instead.
1557: -- AZW_PROC.populate_az_processes; -- DONT REMOVE THIS !!!
1558:
1559: -- get groups, then get processes and then tasks

Line 1557: -- AZW_PROC.populate_az_processes; -- DONT REMOVE THIS !!!

1553: t_index := 0;
1554:
1555: -- AZW_PROC.populate_az_processes is now called from AZWIZARD.fmb within the
1556: -- WHEN_NEW_FORM_INSTANCE trigger instead.
1557: -- AZW_PROC.populate_az_processes; -- DONT REMOVE THIS !!!
1558:
1559: -- get groups, then get processes and then tasks
1560: IF (p_process_group = 'ALL') THEN
1561: IF (p_sort_by = 'PH' OR p_sort_by = 'C') THEN

Line 1896: * AZW_PROC.get_context fetches all the context_id, context_name

1892: /*---------------------------------------------------------------
1893: * get_context : private procedure
1894: * retrieves all distinct context_id, context_name
1895: * from az_processes table.
1896: * AZW_PROC.get_context fetches all the context_id, context_name
1897: * but this one fetches only those for which some processes exists.
1898: *--------------------------------------------------------------*/
1899:
1900: PROCEDURE get_context( ctx_type IN VARCHAR2,

Line 1901: ctx_table OUT AZW_PROC.context_tbl_t) IS

1897: * but this one fetches only those for which some processes exists.
1898: *--------------------------------------------------------------*/
1899:
1900: PROCEDURE get_context( ctx_type IN VARCHAR2,
1901: ctx_table OUT AZW_PROC.context_tbl_t) IS
1902:
1903: CURSOR ctx_cursor IS
1904: SELECT DISTINCT context_id, context_name
1905: FROM az_processes