9: PROCEDURE make_common_queries(p_flag VARCHAR2);
10:
11: PROCEDURE root_node_event (
12: x_node_value IN OUT NOCOPY NUMBER
13: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
14: , x_tbl_index IN OUT NOCOPY NUMBER
15: ) IS
16:
17: l_procedure_name VARCHAR2(30);
41: END root_node_event;
42:
43: PROCEDURE org_node_event (
44: x_node_value IN OUT NOCOPY NUMBER
45: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
46: , x_tbl_index IN OUT NOCOPY NUMBER
47: ) IS
48:
49: l_procedure_name VARCHAR2(30);
83: END org_node_event;
84:
85: PROCEDURE serial_node_event (
86: x_node_value IN OUT NOCOPY NUMBER
87: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
88: , x_tbl_index IN OUT NOCOPY NUMBER
89: ) IS
90:
91: l_procedure_name VARCHAR2(30);
139: END serial_node_event;
140:
141: PROCEDURE item_node_event (
142: x_node_value IN OUT NOCOPY NUMBER
143: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
144: , x_tbl_index IN OUT NOCOPY NUMBER
145: ) IS
146: l_rev_control NUMBER;
147: l_lot_control NUMBER;
229: END item_node_event;
230:
231: PROCEDURE rev_node_event (
232: x_node_value IN OUT NOCOPY NUMBER
233: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
234: , x_tbl_index IN OUT NOCOPY NUMBER
235: ) IS
236:
237: l_lot_control NUMBER;
315: END rev_node_event;
316:
317: PROCEDURE lot_node_event (
318: x_node_value IN OUT NOCOPY NUMBER
319: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
320: , x_tbl_index IN OUT NOCOPY NUMBER
321: ) IS
322:
323: l_rev_control NUMBER;
431: -- General APPTREE event handler for the EMPLOYEE tab.
432: --
433: PROCEDURE event (
434: x_node_value IN OUT NOCOPY NUMBER
435: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
436: , x_tbl_index IN OUT NOCOPY NUMBER
437: ) IS
438:
439: l_procedure_name VARCHAR2(30);