DBA Data[Home] [Help]

APPS.OE_SYNC_ORDER_PVT dependencies on OE_ACKNOWLEDGMENT_PUB

Line 1044: ,p_hdr_ack_tbl OUT NOCOPY oe_acknowledgment_pub.header_ack_tbl_type

1040: ,p_lin_req_id IN NUMBER
1041: ,p_hold_source_id IN NUMBER
1042: ,p_order_hold_id IN NUMBER
1043: ,p_change_type IN VARCHAR2
1044: ,p_hdr_ack_tbl OUT NOCOPY oe_acknowledgment_pub.header_ack_tbl_type
1045: ,p_line_ack_tbl OUT NOCOPY oe_acknowledgment_pub.line_ack_tbl_type
1046: ,x_return_status OUT NOCOPY VARCHAR2
1047: ,x_msg_count OUT NOCOPY NUMBER
1048: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1045: ,p_line_ack_tbl OUT NOCOPY oe_acknowledgment_pub.line_ack_tbl_type

1041: ,p_hold_source_id IN NUMBER
1042: ,p_order_hold_id IN NUMBER
1043: ,p_change_type IN VARCHAR2
1044: ,p_hdr_ack_tbl OUT NOCOPY oe_acknowledgment_pub.header_ack_tbl_type
1045: ,p_line_ack_tbl OUT NOCOPY oe_acknowledgment_pub.line_ack_tbl_type
1046: ,x_return_status OUT NOCOPY VARCHAR2
1047: ,x_msg_count OUT NOCOPY NUMBER
1048: ,x_msg_data OUT NOCOPY VARCHAR2
1049: ) IS

Line 1053: l_hdr_ack_rec oe_acknowledgment_pub.header_ack_rec_type;

1049: ) IS
1050:
1051: i NUMBER := 0;
1052: j NUMBER := 0;
1053: l_hdr_ack_rec oe_acknowledgment_pub.header_ack_rec_type;
1054: l_line_ack_rec oe_acknowledgment_pub.line_ack_rec_type;
1055:
1056: -- Cursor modified for Enh. 7244277, 7644412
1057: CURSOR get_hdr_req_cur IS

Line 1054: l_line_ack_rec oe_acknowledgment_pub.line_ack_rec_type;

1050:
1051: i NUMBER := 0;
1052: j NUMBER := 0;
1053: l_hdr_ack_rec oe_acknowledgment_pub.header_ack_rec_type;
1054: l_line_ack_rec oe_acknowledgment_pub.line_ack_rec_type;
1055:
1056: -- Cursor modified for Enh. 7244277, 7644412
1057: CURSOR get_hdr_req_cur IS
1058: SELECT