7: PROCEDURE make_common_queries(p_flag VARCHAR2);
8:
9: PROCEDURE root_node_event (
10: x_node_value IN OUT NOCOPY NUMBER
11: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
12: , x_tbl_index IN OUT NOCOPY NUMBER
13: ) IS
14:
15: l_procedure_name VARCHAR2(30);
49:
50:
51: PROCEDURE grade_node_event (
52: x_node_value IN OUT NOCOPY NUMBER
53: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
54: , x_tbl_index IN OUT NOCOPY NUMBER
55: ) IS
56:
57: l_procedure_name VARCHAR2(30);
94:
95:
96: PROCEDURE org_node_event (
97: x_node_value IN OUT NOCOPY NUMBER
98: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
99: , x_tbl_index IN OUT NOCOPY NUMBER
100: ) IS
101:
102: l_procedure_name VARCHAR2(30);
195:
196:
197: PROCEDURE item_node_event (
198: x_node_value IN OUT NOCOPY NUMBER
199: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
200: , x_tbl_index IN OUT NOCOPY NUMBER
201: ) IS
202:
203: l_procedure_name VARCHAR2(30);
317: END item_node_event;
318:
319: PROCEDURE lot_node_event (
320: x_node_value IN OUT NOCOPY NUMBER
321: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
322: , x_tbl_index IN OUT NOCOPY NUMBER
323: ) IS
324:
325: l_procedure_name VARCHAR2(30);
483:
484:
485: PROCEDURE serial_node_event (
486: x_node_value IN OUT NOCOPY NUMBER
487: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
488: , x_tbl_index IN OUT NOCOPY NUMBER
489: ) IS
490:
491: l_procedure_name VARCHAR2(30);
735: END make_common_queries;
736:
737: PROCEDURE event (
738: x_node_value IN OUT NOCOPY NUMBER
739: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
740: , x_tbl_index IN OUT NOCOPY NUMBER
741: ) IS
742:
743: l_procedure_name VARCHAR2(30);