APPS.WSH_PO_INTEGRATION_GRP dependencies on WSH_PO_INTG_TYPES_GRP

Line 21: -- p_in_rec IN WSH_PO_INTG_TYPES_GRP.purge_in_rectype

17: -- IN:
18: -- p_api_version_number IN NUMBER
19: -- p_init_msg_list IN VARCHAR2
20: -- p_commit IN VARCHAR2
21: -- p_in_rec IN WSH_PO_INTG_TYPES_GRP.purge_in_rectype
22: -- A table of records which conatins Header Ids of lines as one of its field.
23: -- IN OUT:
24: --
25: -- OUT:

Line 28: -- x_out_rec OUT NOCOPY WSH_PO_INTG_TYPES_GRP.purge_out_rectype

24: --
25: -- OUT:
26: -- x_msg_count OUT NOCOPY NUMBER
27: -- x_msg_data OUT NOCOPY VARCHAR2
28: -- x_out_rec OUT NOCOPY WSH_PO_INTG_TYPES_GRP.purge_out_rectype
29: -- A table of records which contains the flag field. For each record of the i/p
30: -- p_in_rec there is a corresponding entry in this table of records.
31: -- This field is set to 'Y' if there are no pending transactions against the
32: -- header ID and set to 'N' if there are pending transactions against this

Line 50: p_in_rec IN WSH_PO_INTG_TYPES_GRP.purge_in_rectype,

46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: -- procedure specific parameters
50: p_in_rec IN WSH_PO_INTG_TYPES_GRP.purge_in_rectype,
51: x_out_rec OUT NOCOPY WSH_PO_INTG_TYPES_GRP.purge_out_rectype
52: ) AS
53:
54: l_purge NUMBER := 0;

Line 51: x_out_rec OUT NOCOPY WSH_PO_INTG_TYPES_GRP.purge_out_rectype

47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: -- procedure specific parameters
50: p_in_rec IN WSH_PO_INTG_TYPES_GRP.purge_in_rectype,
51: x_out_rec OUT NOCOPY WSH_PO_INTG_TYPES_GRP.purge_out_rectype
52: ) AS
53:
54: l_purge NUMBER := 0;
55: l_api_version_number NUMBER := 1.0;

Line 171: -- p_in_rec IN WSH_PO_INTG_TYPES_GRP.purge_in_rectype

167: -- IN:
168: -- p_api_version_number IN NUMBER
169: -- p_init_msg_list IN VARCHAR2
170: -- p_commit IN VARCHAR2
171: -- p_in_rec IN WSH_PO_INTG_TYPES_GRP.purge_in_rectype
172: -- A table of records which contains the header ID to be purged.
173: -- IN OUT:
174: --
175: -- OUT:

Line 194: p_in_rec IN WSH_PO_INTG_TYPES_GRP.purge_in_rectype

190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: -- procedure specific parameters
194: p_in_rec IN WSH_PO_INTG_TYPES_GRP.purge_in_rectype
195: ) IS
196:
197: l_api_version_number NUMBER := 1.0;
198: l_api_name CONSTANT VARCHAR2(30) := 'purge';

Line 334: P_in_rec IN WSH_PO_INTG_TYPES_GRP.merge_in_rectype,

330: P_commit IN VARCHAR2,
331: X_return_status OUT NOCOPY VARCHAR2,
332: X_msg_count OUT NOCOPY NUMBER,
333: X_msg_data OUT NOCOPY VARCHAR2,
334: P_in_rec IN WSH_PO_INTG_TYPES_GRP.merge_in_rectype,
335: X_out_rec OUT NOCOPY WSH_PO_INTG_TYPES_GRP.merge_out_rectype) IS
336:
337: l_api_version_number NUMBER := 1.0;
338: l_api_name CONSTANT VARCHAR2(30) := 'vendor_merge';

Line 335: X_out_rec OUT NOCOPY WSH_PO_INTG_TYPES_GRP.merge_out_rectype) IS

331: X_return_status OUT NOCOPY VARCHAR2,
332: X_msg_count OUT NOCOPY NUMBER,
333: X_msg_data OUT NOCOPY VARCHAR2,
334: P_in_rec IN WSH_PO_INTG_TYPES_GRP.merge_in_rectype,
335: X_out_rec OUT NOCOPY WSH_PO_INTG_TYPES_GRP.merge_out_rectype) IS
336:
337: l_api_version_number NUMBER := 1.0;
338: l_api_name CONSTANT VARCHAR2(30) := 'vendor_merge';
339: l_return_status VARCHAR2(1);

Line 434: P_in_rec IN WSH_PO_INTG_TYPES_GRP.delInfo_in_rectype,

430: P_commit IN VARCHAR2,
431: x_return_status OUT NOCOPY VARCHAR2,
432: x_msg_count OUT NOCOPY NUMBER,
433: x_msg_data OUT NOCOPY VARCHAR2,
434: P_in_rec IN WSH_PO_INTG_TYPES_GRP.delInfo_in_rectype,
435: x_out_rec OUT NOCOPY WSH_PO_INTG_TYPES_GRP.delInfo_out_rectype)
436: IS
437: --
438: CURSOR c_GetDelId(p_respNum VARCHAR2) IS

Line 435: x_out_rec OUT NOCOPY WSH_PO_INTG_TYPES_GRP.delInfo_out_rectype)

431: x_return_status OUT NOCOPY VARCHAR2,
432: x_msg_count OUT NOCOPY NUMBER,
433: x_msg_data OUT NOCOPY VARCHAR2,
434: P_in_rec IN WSH_PO_INTG_TYPES_GRP.delInfo_in_rectype,
435: x_out_rec OUT NOCOPY WSH_PO_INTG_TYPES_GRP.delInfo_out_rectype)
436: IS
437: --
438: CURSOR c_GetDelId(p_respNum VARCHAR2) IS
439: SELECT wth.shipment_header_id, wth.last_update_date, wnd.last_update_date