DBA Data[Home] [Help]

APPS.PO_OM_INTEGRATION_GRP dependencies on PO_TBL_NUMBER

Line 8: p_req_header_id IN PO_TBL_NUMBER,

4: -- Detailed comments maintained in the Package Body PO_OM_INTEGRATION_GRP.update_req_po
5: PROCEDURE update_req_po
6: (
7: p_api_version IN NUMBER,
8: p_req_header_id IN PO_TBL_NUMBER,
9: p_req_line_id IN PO_TBL_NUMBER,
10: p_po_header_id IN PO_TBL_NUMBER := NULL,
11: p_po_release_id IN PO_TBL_NUMBER := NULL,
12: p_po_line_id IN PO_TBL_NUMBER := NULL,

Line 9: p_req_line_id IN PO_TBL_NUMBER,

5: PROCEDURE update_req_po
6: (
7: p_api_version IN NUMBER,
8: p_req_header_id IN PO_TBL_NUMBER,
9: p_req_line_id IN PO_TBL_NUMBER,
10: p_po_header_id IN PO_TBL_NUMBER := NULL,
11: p_po_release_id IN PO_TBL_NUMBER := NULL,
12: p_po_line_id IN PO_TBL_NUMBER := NULL,
13: p_po_line_location_id IN PO_TBL_NUMBER := NULL,

Line 10: p_po_header_id IN PO_TBL_NUMBER := NULL,

6: (
7: p_api_version IN NUMBER,
8: p_req_header_id IN PO_TBL_NUMBER,
9: p_req_line_id IN PO_TBL_NUMBER,
10: p_po_header_id IN PO_TBL_NUMBER := NULL,
11: p_po_release_id IN PO_TBL_NUMBER := NULL,
12: p_po_line_id IN PO_TBL_NUMBER := NULL,
13: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
14: p_quantity IN PO_TBL_NUMBER := NULL,

Line 11: p_po_release_id IN PO_TBL_NUMBER := NULL,

7: p_api_version IN NUMBER,
8: p_req_header_id IN PO_TBL_NUMBER,
9: p_req_line_id IN PO_TBL_NUMBER,
10: p_po_header_id IN PO_TBL_NUMBER := NULL,
11: p_po_release_id IN PO_TBL_NUMBER := NULL,
12: p_po_line_id IN PO_TBL_NUMBER := NULL,
13: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
14: p_quantity IN PO_TBL_NUMBER := NULL,
15: p_secondary_quantity IN PO_TBL_NUMBER := NULL,

Line 12: p_po_line_id IN PO_TBL_NUMBER := NULL,

8: p_req_header_id IN PO_TBL_NUMBER,
9: p_req_line_id IN PO_TBL_NUMBER,
10: p_po_header_id IN PO_TBL_NUMBER := NULL,
11: p_po_release_id IN PO_TBL_NUMBER := NULL,
12: p_po_line_id IN PO_TBL_NUMBER := NULL,
13: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
14: p_quantity IN PO_TBL_NUMBER := NULL,
15: p_secondary_quantity IN PO_TBL_NUMBER := NULL,
16: p_need_by_date IN PO_TBL_DATE := NULL,

Line 13: p_po_line_location_id IN PO_TBL_NUMBER := NULL,

9: p_req_line_id IN PO_TBL_NUMBER,
10: p_po_header_id IN PO_TBL_NUMBER := NULL,
11: p_po_release_id IN PO_TBL_NUMBER := NULL,
12: p_po_line_id IN PO_TBL_NUMBER := NULL,
13: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
14: p_quantity IN PO_TBL_NUMBER := NULL,
15: p_secondary_quantity IN PO_TBL_NUMBER := NULL,
16: p_need_by_date IN PO_TBL_DATE := NULL,
17: p_ship_to_location_id IN PO_TBL_NUMBER := NULL,

Line 14: p_quantity IN PO_TBL_NUMBER := NULL,

10: p_po_header_id IN PO_TBL_NUMBER := NULL,
11: p_po_release_id IN PO_TBL_NUMBER := NULL,
12: p_po_line_id IN PO_TBL_NUMBER := NULL,
13: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
14: p_quantity IN PO_TBL_NUMBER := NULL,
15: p_secondary_quantity IN PO_TBL_NUMBER := NULL,
16: p_need_by_date IN PO_TBL_DATE := NULL,
17: p_ship_to_location_id IN PO_TBL_NUMBER := NULL,
18: p_sales_order_update_date IN PO_TBL_DATE := NULL,

Line 15: p_secondary_quantity IN PO_TBL_NUMBER := NULL,

11: p_po_release_id IN PO_TBL_NUMBER := NULL,
12: p_po_line_id IN PO_TBL_NUMBER := NULL,
13: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
14: p_quantity IN PO_TBL_NUMBER := NULL,
15: p_secondary_quantity IN PO_TBL_NUMBER := NULL,
16: p_need_by_date IN PO_TBL_DATE := NULL,
17: p_ship_to_location_id IN PO_TBL_NUMBER := NULL,
18: p_sales_order_update_date IN PO_TBL_DATE := NULL,
19: p_preferred_grade IN PO_TBL_VARCHAR240 := NULL, /* INVCONV SSCHINCH 09/07/04*/

Line 17: p_ship_to_location_id IN PO_TBL_NUMBER := NULL,

13: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
14: p_quantity IN PO_TBL_NUMBER := NULL,
15: p_secondary_quantity IN PO_TBL_NUMBER := NULL,
16: p_need_by_date IN PO_TBL_DATE := NULL,
17: p_ship_to_location_id IN PO_TBL_NUMBER := NULL,
18: p_sales_order_update_date IN PO_TBL_DATE := NULL,
19: p_preferred_grade IN PO_TBL_VARCHAR240 := NULL, /* INVCONV SSCHINCH 09/07/04*/
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,

Line 31: p_req_header_id IN PO_TBL_NUMBER,

27: -- Detailed comments maintained in the Package Body PO_OM_INTEGRATION_GRP.cancel_req_po
28: PROCEDURE cancel_req_po
29: (
30: p_api_version IN NUMBER,
31: p_req_header_id IN PO_TBL_NUMBER,
32: p_req_line_id IN PO_TBL_NUMBER,
33: p_po_header_id IN PO_TBL_NUMBER := NULL,
34: p_po_release_id IN PO_TBL_NUMBER := NULL,
35: p_po_line_id IN PO_TBL_NUMBER := NULL,

Line 32: p_req_line_id IN PO_TBL_NUMBER,

28: PROCEDURE cancel_req_po
29: (
30: p_api_version IN NUMBER,
31: p_req_header_id IN PO_TBL_NUMBER,
32: p_req_line_id IN PO_TBL_NUMBER,
33: p_po_header_id IN PO_TBL_NUMBER := NULL,
34: p_po_release_id IN PO_TBL_NUMBER := NULL,
35: p_po_line_id IN PO_TBL_NUMBER := NULL,
36: p_po_line_location_id IN PO_TBL_NUMBER := NULL,

Line 33: p_po_header_id IN PO_TBL_NUMBER := NULL,

29: (
30: p_api_version IN NUMBER,
31: p_req_header_id IN PO_TBL_NUMBER,
32: p_req_line_id IN PO_TBL_NUMBER,
33: p_po_header_id IN PO_TBL_NUMBER := NULL,
34: p_po_release_id IN PO_TBL_NUMBER := NULL,
35: p_po_line_id IN PO_TBL_NUMBER := NULL,
36: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
37: x_return_status OUT NOCOPY VARCHAR2,

Line 34: p_po_release_id IN PO_TBL_NUMBER := NULL,

30: p_api_version IN NUMBER,
31: p_req_header_id IN PO_TBL_NUMBER,
32: p_req_line_id IN PO_TBL_NUMBER,
33: p_po_header_id IN PO_TBL_NUMBER := NULL,
34: p_po_release_id IN PO_TBL_NUMBER := NULL,
35: p_po_line_id IN PO_TBL_NUMBER := NULL,
36: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,

Line 35: p_po_line_id IN PO_TBL_NUMBER := NULL,

31: p_req_header_id IN PO_TBL_NUMBER,
32: p_req_line_id IN PO_TBL_NUMBER,
33: p_po_header_id IN PO_TBL_NUMBER := NULL,
34: p_po_release_id IN PO_TBL_NUMBER := NULL,
35: p_po_line_id IN PO_TBL_NUMBER := NULL,
36: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2

Line 36: p_po_line_location_id IN PO_TBL_NUMBER := NULL,

32: p_req_line_id IN PO_TBL_NUMBER,
33: p_po_header_id IN PO_TBL_NUMBER := NULL,
34: p_po_release_id IN PO_TBL_NUMBER := NULL,
35: p_po_line_id IN PO_TBL_NUMBER := NULL,
36: p_po_line_location_id IN PO_TBL_NUMBER := NULL,
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2
40: )

Line 53: ,p_entity_id_tbl IN PO_TBL_NUMBER

49: ,x_return_status OUT NOCOPY VARCHAR2
50: ,x_msg_count OUT NOCOPY NUMBER
51: ,x_msg_data OUT NOCOPY VARCHAR2
52: ,p_entity IN VARCHAR2
53: ,p_entity_id_tbl IN PO_TBL_NUMBER
54: );
55:
56: PROCEDURE Validate_Purge
57: ( p_api_version IN NUMBER

Line 64: ,p_entity_id_tbl IN PO_TBL_NUMBER

60: ,x_return_status OUT NOCOPY VARCHAR2
61: ,x_msg_count OUT NOCOPY NUMBER
62: ,x_msg_data OUT NOCOPY VARCHAR2
63: ,p_entity IN VARCHAR2
64: ,p_entity_id_tbl IN PO_TBL_NUMBER
65: ,x_purge_allowed_tbl OUT NOCOPY PO_TBL_VARCHAR1
66: );
67:
68: --