DBA Data[Home] [Help]

APPS.PO_DELREC_PVT dependencies on OE_WSH_BULK_GRP

Line 17: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

13: x_return_status IN OUT NOCOPY VARCHAR2,
14: p_header_id IN NUMBER,
15: p_line_id IN NUMBER,
16: p_line_location_id IN NUMBER,
17: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
18: );
19:
20: PROCEDURE get_cancelled_po
21: (

Line 27: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

23: x_return_status IN OUT NOCOPY VARCHAR2,
24: p_header_id IN NUMBER,
25: p_line_id IN NUMBER,
26: p_line_location_id IN NUMBER,
27: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
28: );
29:
30: PROCEDURE get_opened_po
31: (

Line 37: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

33: x_return_status IN OUT NOCOPY VARCHAR2,
34: p_header_id IN NUMBER,
35: p_line_id IN NUMBER,
36: p_line_location_id IN NUMBER,
37: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
38: );
39:
40: PROCEDURE get_closed_po
41: (

Line 47: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

43: x_return_status IN OUT NOCOPY VARCHAR2,
44: p_header_id IN NUMBER,
45: p_line_id IN NUMBER,
46: p_line_location_id IN NUMBER,
47: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
48: );
49:
50: PROCEDURE get_finally_closed_po
51: (

Line 57: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

53: x_return_status IN OUT NOCOPY VARCHAR2,
54: p_header_id IN NUMBER,
55: p_line_id IN NUMBER,
56: p_line_location_id IN NUMBER,
57: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
58: );
59:
60: PROCEDURE get_approved_release
61: (

Line 66: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

62: p_api_version IN NUMBER,
63: x_return_status IN OUT NOCOPY VARCHAR2,
64: p_header_id IN NUMBER,
65: p_line_location_id IN NUMBER,
66: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
67: );
68:
69: PROCEDURE get_cancelled_release
70: (

Line 75: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

71: p_api_version IN NUMBER,
72: x_return_status IN OUT NOCOPY VARCHAR2,
73: p_header_id IN NUMBER,
74: p_line_location_id IN NUMBER,
75: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
76: );
77:
78:
79: PROCEDURE get_opened_release

Line 85: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

81: p_api_version IN NUMBER,
82: x_return_status IN OUT NOCOPY VARCHAR2,
83: p_header_id IN NUMBER,
84: p_line_location_id IN NUMBER,
85: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
86: );
87:
88: PROCEDURE get_closed_release
89: (

Line 94: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

90: p_api_version IN NUMBER,
91: x_return_status IN OUT NOCOPY VARCHAR2,
92: p_header_id IN NUMBER,
93: p_line_location_id IN NUMBER,
94: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
95: );
96:
97: PROCEDURE get_finally_closed_release
98: (

Line 103: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

99: p_api_version IN NUMBER,
100: x_return_status IN OUT NOCOPY VARCHAR2,
101: p_header_id IN NUMBER,
102: p_line_location_id IN NUMBER,
103: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
104: );
105:
106: PROCEDURE make_rcv_call
107: (

Line 115: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type );

111: p_action IN VARCHAR2,
112: p_header_id IN NUMBER,
113: p_line_id IN NUMBER,
114: p_line_location_id IN NUMBER,
115: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type );
116:
117: -- Bug 3581992 START
118: PROCEDURE debug_fte_rec
119: (

Line 120: p_fte_rec IN OE_WSH_BULK_GRP.Line_Rec_Type

116:
117: -- Bug 3581992 START
118: PROCEDURE debug_fte_rec
119: (
120: p_fte_rec IN OE_WSH_BULK_GRP.Line_Rec_Type
121: );
122: -- Bug 3581992 END
123:
124: -------------------------------------------------------------------------------

Line 185: l_fte_rec OE_WSH_BULK_GRP.Line_Rec_Type;

181: l_shipping_control PO_HEADERS_ALL.shipping_control%TYPE;
182:
183: -- define record of tables for bulk processing
184: l_action_rec WSH_BULK_TYPES_GRP.action_parameters_rectype;
185: l_fte_rec OE_WSH_BULK_GRP.Line_Rec_Type;
186: l_fte_out_rec WSH_BULK_TYPES_GRP.Bulk_process_out_rec_type;
187:
188: BEGIN
189: -- Standard Start of API savepoint

Line 576: l_fte_rec OE_WSH_BULK_GRP.Line_Rec_Type;

572: PROCEDURE test_rcv_call
573: IS
574: l_action_rec WSH_BULK_TYPES_GRP.action_parameters_rectype;
575: l_return_status VARCHAR2(255);
576: l_fte_rec OE_WSH_BULK_GRP.Line_Rec_Type;
577: BEGIN
578: l_action_rec.action_code := 'RECEIPT';
579: l_action_rec.Caller := 'PO';
580: l_action_rec.Phase := '';

Line 605: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

601: p_action IN VARCHAR2,
602: p_header_id IN NUMBER,
603: p_line_id IN NUMBER,
604: p_line_location_id IN NUMBER,
605: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
606: )
607: IS
608: l_api_name VARCHAR2(25) := 'make_rcv_call';
609: l_fte_out_rec WSH_BULK_TYPES_GRP.Bulk_process_out_rec_type;

Line 1289: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

1285: x_return_status IN OUT NOCOPY VARCHAR2,
1286: p_header_id IN NUMBER,
1287: p_line_id IN NUMBER,
1288: p_line_location_id IN NUMBER,
1289: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
1290: )
1291: IS
1292: l_api_name CONSTANT VARCHAR2(100) := 'get_approved_po';
1293: l_api_version CONSTANT NUMBER := 1.0;

Line 1511: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

1507: x_return_status IN OUT NOCOPY VARCHAR2,
1508: p_header_id IN NUMBER,
1509: p_line_id IN NUMBER,
1510: p_line_location_id IN NUMBER,
1511: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
1512: )
1513: IS
1514: l_api_name CONSTANT VARCHAR2(100) := 'get_cancelled_po';
1515: l_api_version CONSTANT NUMBER := 1.0;

Line 1732: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

1728: x_return_status IN OUT NOCOPY VARCHAR2,
1729: p_header_id IN NUMBER,
1730: p_line_id IN NUMBER,
1731: p_line_location_id IN NUMBER,
1732: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
1733: )
1734: IS
1735: l_api_name CONSTANT VARCHAR2(100) := 'get_opened_po';
1736: l_api_version CONSTANT NUMBER := 1.0;

Line 1954: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

1950: x_return_status IN OUT NOCOPY VARCHAR2,
1951: p_header_id IN NUMBER,
1952: p_line_id IN NUMBER,
1953: p_line_location_id IN NUMBER,
1954: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
1955: )
1956: IS
1957: l_api_name CONSTANT VARCHAR2(100) := 'get_closed_po';
1958: l_api_version CONSTANT NUMBER := 1.0;

Line 2176: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

2172: x_return_status IN OUT NOCOPY VARCHAR2,
2173: p_header_id IN NUMBER,
2174: p_line_id IN NUMBER,
2175: p_line_location_id IN NUMBER,
2176: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
2177: )
2178: IS
2179: l_api_name CONSTANT VARCHAR2(100) := 'get_finally_closed_po';
2180: l_api_version CONSTANT NUMBER := 1.0;

Line 2394: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

2390: p_api_version IN NUMBER,
2391: x_return_status IN OUT NOCOPY VARCHAR2,
2392: p_header_id IN NUMBER,
2393: p_line_location_id IN NUMBER,
2394: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
2395: )
2396: IS
2397: l_api_name CONSTANT VARCHAR2(100) := 'get_approved_release';
2398: l_api_version CONSTANT NUMBER := 1.0;

Line 2622: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

2618: p_api_version IN NUMBER,
2619: x_return_status IN OUT NOCOPY VARCHAR2,
2620: p_header_id IN NUMBER,
2621: p_line_location_id IN NUMBER,
2622: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
2623: )
2624: IS
2625: l_api_name CONSTANT VARCHAR2(100) := 'get_cancelled_release';
2626: l_api_version CONSTANT NUMBER := 1.0;

Line 2848: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

2844: p_api_version IN NUMBER,
2845: x_return_status IN OUT NOCOPY VARCHAR2,
2846: p_header_id IN NUMBER,
2847: p_line_location_id IN NUMBER,
2848: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
2849: )
2850: IS
2851: l_api_name CONSTANT VARCHAR2(100) := 'get_opened_release';
2852: l_api_version CONSTANT NUMBER := 1.0;

Line 3075: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

3071: p_api_version IN NUMBER,
3072: x_return_status IN OUT NOCOPY VARCHAR2,
3073: p_header_id IN NUMBER,
3074: p_line_location_id IN NUMBER,
3075: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
3076: )
3077: IS
3078: l_api_name CONSTANT VARCHAR2(100) := 'get_closed_release';
3079: l_api_version CONSTANT NUMBER := 1.0;

Line 3304: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type

3300: p_api_version IN NUMBER,
3301: x_return_status IN OUT NOCOPY VARCHAR2,
3302: p_header_id IN NUMBER,
3303: p_line_location_id IN NUMBER,
3304: x_fte_rec IN OUT NOCOPY OE_WSH_BULK_GRP.Line_Rec_Type
3305: )
3306: IS
3307: l_api_name CONSTANT VARCHAR2(100) := 'get_finally_closed_release';
3308: l_api_version CONSTANT NUMBER := 1.0;

Line 3514: p_fte_rec IN OE_WSH_BULK_GRP.Line_Rec_Type

3510: --End of Comments
3511: -------------------------------------------------------------------------------
3512: PROCEDURE debug_fte_rec
3513: (
3514: p_fte_rec IN OE_WSH_BULK_GRP.Line_Rec_Type
3515: ) IS
3516: l_api_name CONSTANT VARCHAR2(30) := 'debug_fte_rec';
3517: BEGIN
3518: IF (g_debug_stmt) AND (p_fte_rec.po_shipment_line_id IS NOT NULL) THEN