12: -- PROCEDURE make_common_query_lpn(p_flag VARCHAR2);
13:
14: PROCEDURE root_node_event (
15: x_node_value IN OUT NOCOPY NUMBER
16: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
17: , x_tbl_index IN OUT NOCOPY NUMBER
18: ) IS
19: l_procedure_name VARCHAR2(30);
20: BEGIN
72: END root_node_event;
73:
74: PROCEDURE org_node_event (
75: x_node_value IN OUT NOCOPY NUMBER
76: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
77: , x_tbl_index IN OUT NOCOPY NUMBER
78: ) IS
79: l_procedure_name VARCHAR(30);
80: TYPE tab IS TABLE OF varchar2(100) index by binary_integer;
234:
235:
236: PROCEDURE mat_loc_node_event (
237: x_node_value IN OUT NOCOPY NUMBER
238: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
239: , x_tbl_index IN OUT NOCOPY NUMBER
240: ) IS
241: l_procedure_name VARCHAR(30);
242: BEGIN
353: END mat_loc_node_event;
354:
355: PROCEDURE lpn_node_event (
356: x_node_value IN OUT NOCOPY NUMBER
357: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
358: , x_tbl_index IN OUT NOCOPY NUMBER
359: ) IS
360: l_procedure_name VARCHAR2(30);
361: BEGIN
512: END lpn_node_event;
513:
514: PROCEDURE item_node_event (
515: x_node_value IN OUT NOCOPY NUMBER
516: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
517: , x_tbl_index IN OUT NOCOPY NUMBER
518: ) IS
519:
520: l_rev_control NUMBER;
849: END item_node_event;
850:
851: PROCEDURE rev_node_event (
852: x_node_value IN OUT NOCOPY NUMBER
853: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
854: , x_tbl_index IN OUT NOCOPY NUMBER
855: ) IS
856: l_lot_control NUMBER;
857: l_serial_control NUMBER;
1159: END rev_node_event;
1160:
1161: PROCEDURE lot_node_event (
1162: x_node_value IN OUT NOCOPY NUMBER
1163: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
1164: , x_tbl_index IN OUT NOCOPY NUMBER
1165: ) IS
1166:
1167: l_serial_control NUMBER;
1465: END lot_node_event;
1466:
1467: PROCEDURE serial_node_event (
1468: x_node_value IN OUT NOCOPY NUMBER
1469: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
1470: , x_tbl_index IN OUT NOCOPY NUMBER
1471: ) IS
1472: l_procedure_name VARCHAR2(30);
1473: BEGIN
1843: END;
1844:
1845: PROCEDURE event (
1846: x_node_value IN OUT NOCOPY NUMBER
1847: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
1848: , x_tbl_index IN OUT NOCOPY NUMBER
1849: ) IS
1850: l_procedure_name VARCHAR2(30);
1851: BEGIN