8: PROCEDURE make_common_query_inbound(p_flag VARCHAR2);
9:
10: PROCEDURE root_node_event (
11: x_node_value IN OUT NOCOPY NUMBER
12: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
13: , x_tbl_index IN OUT NOCOPY NUMBER
14: ) IS
15: i NUMBER;
16: j NUMBER;
115:
116:
117: PROCEDURE org_node_event(
118: x_node_value IN OUT NOCOPY NUMBER
119: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
120: , x_tbl_index IN OUT NOCOPY NUMBER
121: )
122: IS
123: i NUMBER := 1;
241:
242:
243: PROCEDURE sub_node_event(
244: x_node_value IN OUT NOCOPY NUMBER
245: ,x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
246: ,x_tbl_index IN OUT NOCOPY NUMBER
247: )
248: IS
249:
407:
408:
409: PROCEDURE loc_node_event(
410: x_node_value IN OUT NOCOPY NUMBER
411: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
412: , x_tbl_index IN OUT NOCOPY NUMBER
413: )
414: IS
415: i NUMBER := 1;
552: END loc_node_event;
553:
554: PROCEDURE lpn_node_event(
555: x_node_value IN OUT NOCOPY NUMBER
556: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
557: , x_tbl_index IN OUT NOCOPY NUMBER
558: )
559: IS
560: str_query varchar2(4000);
981:
982:
983: PROCEDURE item_node_event(
984: x_node_value IN OUT NOCOPY NUMBER
985: ,x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
986: ,x_tbl_index IN OUT NOCOPY NUMBER
987: ) IS
988:
989: from_receiving NUMBER;
1607:
1608:
1609: PROCEDURE rev_node_event(
1610: x_node_value IN OUT NOCOPY NUMBER
1611: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
1612: , x_tbl_index IN OUT NOCOPY NUMBER
1613: )
1614: IS
1615: loc_control NUMBER;
2069: END rev_node_event;
2070:
2071: PROCEDURE lot_node_event(
2072: x_node_value IN OUT NOCOPY NUMBER
2073: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
2074: , x_tbl_index IN OUT NOCOPY NUMBER
2075: )
2076: IS
2077: loc_control NUMBER;
2573: END lot_node_event;
2574:
2575: PROCEDURE serial_node_event(
2576: x_node_value IN OUT NOCOPY NUMBER
2577: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
2578: , x_tbl_index IN OUT NOCOPY NUMBER
2579: )
2580: IS
2581: serial mtl_serial_numbers.serial_number%TYPE;
2786:
2787:
2788: PROCEDURE matloc_node_event(
2789: x_node_value IN OUT NOCOPY NUMBER
2790: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
2791: , x_tbl_index IN OUT NOCOPY NUMBER
2792: )
2793: IS
2794: i NUMBER := 1;
2980:
2981:
2982: PROCEDURE doc_type_node_event(
2983: x_node_value IN OUT NOCOPY NUMBER
2984: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
2985: , x_tbl_index IN OUT NOCOPY NUMBER
2986: )
2987: IS
2988: i NUMBER := 1;
3065: END doc_type_node_event;
3066:
3067: PROCEDURE doc_num_node_event(
3068: x_node_value IN OUT NOCOPY NUMBER
3069: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
3070: , x_tbl_index IN OUT NOCOPY NUMBER
3071: )
3072: IS
3073: l_procedure_name VARCHAR2(30);
3515: END make_common_query_receiving;
3516:
3517: PROCEDURE event (
3518: x_node_value IN OUT NOCOPY NUMBER
3519: ,x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
3520: ,x_tbl_index IN OUT NOCOPY NUMBER
3521: ) IS
3522:
3523: l_procedure_name VARCHAR2(30);