eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_ACCRUAL_ENGINE dependencies on OE_ORDER_PUB

Line 2787: p_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,

2783: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2784: x_return_status OUT NOCOPY VARCHAR2,
2785: x_msg_count OUT NOCOPY NUMBER,
2786: x_msg_data OUT NOCOPY VARCHAR2,
2787: p_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,
2788: p_old_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,
2789: p_header_rec IN oe_order_pub.header_rec_type := NULL,
2790: p_exception_queue IN VARCHAR2 := fnd_api.g_false
2791:

Line 2788: p_old_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,

2784: x_return_status OUT NOCOPY VARCHAR2,
2785: x_msg_count OUT NOCOPY NUMBER,
2786: x_msg_data OUT NOCOPY VARCHAR2,
2787: p_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,
2788: p_old_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,
2789: p_header_rec IN oe_order_pub.header_rec_type := NULL,
2790: p_exception_queue IN VARCHAR2 := fnd_api.g_false
2791:
2792: ) IS

Line 2789: p_header_rec IN oe_order_pub.header_rec_type := NULL,

2785: x_msg_count OUT NOCOPY NUMBER,
2786: x_msg_data OUT NOCOPY VARCHAR2,
2787: p_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,
2788: p_old_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,
2789: p_header_rec IN oe_order_pub.header_rec_type := NULL,
2790: p_exception_queue IN VARCHAR2 := fnd_api.g_false
2791:
2792: ) IS
2793: l_return_status VARCHAR2 (10) := fnd_api.g_ret_sts_success;

Line 3764: p_header_rec IN oe_order_pub.header_rec_type,

3760: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
3761: x_return_status OUT NOCOPY VARCHAR2,
3762: x_msg_count OUT NOCOPY NUMBER,
3763: x_msg_data OUT NOCOPY VARCHAR2,
3764: p_header_rec IN oe_order_pub.header_rec_type,
3765: p_old_header_rec IN oe_order_pub.header_rec_type,
3766: p_line_tbl IN oe_order_pub.line_tbl_type,
3767: p_old_line_tbl IN oe_order_pub.line_tbl_type
3768: ) IS

Line 3765: p_old_header_rec IN oe_order_pub.header_rec_type,

3761: x_return_status OUT NOCOPY VARCHAR2,
3762: x_msg_count OUT NOCOPY NUMBER,
3763: x_msg_data OUT NOCOPY VARCHAR2,
3764: p_header_rec IN oe_order_pub.header_rec_type,
3765: p_old_header_rec IN oe_order_pub.header_rec_type,
3766: p_line_tbl IN oe_order_pub.line_tbl_type,
3767: p_old_line_tbl IN oe_order_pub.line_tbl_type
3768: ) IS
3769: l_return_status VARCHAR2 (1) ;

Line 3766: p_line_tbl IN oe_order_pub.line_tbl_type,

3762: x_msg_count OUT NOCOPY NUMBER,
3763: x_msg_data OUT NOCOPY VARCHAR2,
3764: p_header_rec IN oe_order_pub.header_rec_type,
3765: p_old_header_rec IN oe_order_pub.header_rec_type,
3766: p_line_tbl IN oe_order_pub.line_tbl_type,
3767: p_old_line_tbl IN oe_order_pub.line_tbl_type
3768: ) IS
3769: l_return_status VARCHAR2 (1) ;
3770: l_api_name CONSTANT VARCHAR2 (30) := 'Adjust_Changed_order';

Line 3767: p_old_line_tbl IN oe_order_pub.line_tbl_type

3763: x_msg_data OUT NOCOPY VARCHAR2,
3764: p_header_rec IN oe_order_pub.header_rec_type,
3765: p_old_header_rec IN oe_order_pub.header_rec_type,
3766: p_line_tbl IN oe_order_pub.line_tbl_type,
3767: p_old_line_tbl IN oe_order_pub.line_tbl_type
3768: ) IS
3769: l_return_status VARCHAR2 (1) ;
3770: l_api_name CONSTANT VARCHAR2 (30) := 'Adjust_Changed_order';
3771: l_api_version CONSTANT NUMBER := 1.0;

Line 5046: l_header_rec oe_order_pub.header_rec_type;

5042: l_msg_data VARCHAR2 (2000);
5043: l_no_more_messages VARCHAR2 (1);
5044: l_header_id NUMBER;
5045: l_booked_flag VARCHAR2 (1);
5046: l_header_rec oe_order_pub.header_rec_type;
5047: l_old_header_rec oe_order_pub.header_rec_type;
5048: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5049: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5050: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

Line 5047: l_old_header_rec oe_order_pub.header_rec_type;

5043: l_no_more_messages VARCHAR2 (1);
5044: l_header_id NUMBER;
5045: l_booked_flag VARCHAR2 (1);
5046: l_header_rec oe_order_pub.header_rec_type;
5047: l_old_header_rec oe_order_pub.header_rec_type;
5048: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5049: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5050: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5051: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

Line 5048: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;

5044: l_header_id NUMBER;
5045: l_booked_flag VARCHAR2 (1);
5046: l_header_rec oe_order_pub.header_rec_type;
5047: l_old_header_rec oe_order_pub.header_rec_type;
5048: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5049: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5050: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5051: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5052: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

Line 5049: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;

5045: l_booked_flag VARCHAR2 (1);
5046: l_header_rec oe_order_pub.header_rec_type;
5047: l_old_header_rec oe_order_pub.header_rec_type;
5048: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5049: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5050: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5051: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5052: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5053: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

Line 5050: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

5046: l_header_rec oe_order_pub.header_rec_type;
5047: l_old_header_rec oe_order_pub.header_rec_type;
5048: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5049: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5050: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5051: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5052: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5053: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5054: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

Line 5051: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

5047: l_old_header_rec oe_order_pub.header_rec_type;
5048: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5049: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5050: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5051: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5052: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5053: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5054: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5055: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

Line 5052: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

5048: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5049: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5050: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5051: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5052: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5053: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5054: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5055: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5056: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

Line 5053: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

5049: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5050: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5051: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5052: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5053: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5054: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5055: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5056: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5057: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

Line 5054: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

5050: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5051: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5052: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5053: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5054: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5055: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5056: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5057: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5058: l_line_tbl oe_order_pub.line_tbl_type;

Line 5055: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

5051: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5052: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5053: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5054: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5055: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5056: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5057: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5058: l_line_tbl oe_order_pub.line_tbl_type;
5059: l_old_line_tbl oe_order_pub.line_tbl_type;

Line 5056: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

5052: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5053: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5054: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5055: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5056: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5057: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5058: l_line_tbl oe_order_pub.line_tbl_type;
5059: l_old_line_tbl oe_order_pub.line_tbl_type;
5060: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;

Line 5057: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

5053: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5054: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5055: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5056: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5057: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5058: l_line_tbl oe_order_pub.line_tbl_type;
5059: l_old_line_tbl oe_order_pub.line_tbl_type;
5060: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5061: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;

Line 5058: l_line_tbl oe_order_pub.line_tbl_type;

5054: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5055: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5056: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5057: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5058: l_line_tbl oe_order_pub.line_tbl_type;
5059: l_old_line_tbl oe_order_pub.line_tbl_type;
5060: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5061: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5062: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

Line 5059: l_old_line_tbl oe_order_pub.line_tbl_type;

5055: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5056: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5057: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5058: l_line_tbl oe_order_pub.line_tbl_type;
5059: l_old_line_tbl oe_order_pub.line_tbl_type;
5060: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5061: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5062: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5063: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

Line 5060: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;

5056: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5057: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5058: l_line_tbl oe_order_pub.line_tbl_type;
5059: l_old_line_tbl oe_order_pub.line_tbl_type;
5060: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5061: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5062: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5063: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5064: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

Line 5061: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;

5057: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5058: l_line_tbl oe_order_pub.line_tbl_type;
5059: l_old_line_tbl oe_order_pub.line_tbl_type;
5060: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5061: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5062: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5063: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5064: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5065: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

Line 5062: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

5058: l_line_tbl oe_order_pub.line_tbl_type;
5059: l_old_line_tbl oe_order_pub.line_tbl_type;
5060: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5061: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5062: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5063: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5064: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5065: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5066: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

Line 5063: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

5059: l_old_line_tbl oe_order_pub.line_tbl_type;
5060: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5061: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5062: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5063: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5064: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5065: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5066: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5067: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

Line 5064: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

5060: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5061: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5062: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5063: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5064: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5065: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5066: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5067: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5068: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

Line 5065: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

5061: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5062: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5063: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5064: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5065: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5066: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5067: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5068: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5069: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

Line 5066: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

5062: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5063: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5064: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5065: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5066: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5067: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5068: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5069: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5070: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

Line 5067: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

5063: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5064: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5065: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5066: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5067: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5068: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5069: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5070: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5071: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

Line 5068: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

5064: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5065: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5066: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5067: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5068: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5069: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5070: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5071: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5072: l_action_request_tbl oe_order_pub.request_tbl_type;

Line 5069: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

5065: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5066: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5067: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5068: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5069: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5070: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5071: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5072: l_action_request_tbl oe_order_pub.request_tbl_type;
5073: l_que_msg_count NUMBER := 0 ;

Line 5070: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

5066: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5067: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5068: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5069: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5070: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5071: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5072: l_action_request_tbl oe_order_pub.request_tbl_type;
5073: l_que_msg_count NUMBER := 0 ;
5074: BEGIN

Line 5071: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

5067: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5068: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5069: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5070: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5071: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5072: l_action_request_tbl oe_order_pub.request_tbl_type;
5073: l_que_msg_count NUMBER := 0 ;
5074: BEGIN
5075: -- Standard Start of process savepoint

Line 5072: l_action_request_tbl oe_order_pub.request_tbl_type;

5068: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5069: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5070: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5071: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5072: l_action_request_tbl oe_order_pub.request_tbl_type;
5073: l_que_msg_count NUMBER := 0 ;
5074: BEGIN
5075: -- Standard Start of process savepoint
5076: -- Start looping to check for messages in the queue

Line 5338: l_header_rec oe_order_pub.header_rec_type;

5334: l_msg_data VARCHAR2 (2000);
5335: l_no_more_messages VARCHAR2 (1);
5336: l_header_id NUMBER;
5337: l_booked_flag VARCHAR2 (1);
5338: l_header_rec oe_order_pub.header_rec_type;
5339: l_old_header_rec oe_order_pub.header_rec_type;
5340: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5341: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5342: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

Line 5339: l_old_header_rec oe_order_pub.header_rec_type;

5335: l_no_more_messages VARCHAR2 (1);
5336: l_header_id NUMBER;
5337: l_booked_flag VARCHAR2 (1);
5338: l_header_rec oe_order_pub.header_rec_type;
5339: l_old_header_rec oe_order_pub.header_rec_type;
5340: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5341: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5342: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5343: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

Line 5340: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;

5336: l_header_id NUMBER;
5337: l_booked_flag VARCHAR2 (1);
5338: l_header_rec oe_order_pub.header_rec_type;
5339: l_old_header_rec oe_order_pub.header_rec_type;
5340: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5341: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5342: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5343: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5344: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

Line 5341: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;

5337: l_booked_flag VARCHAR2 (1);
5338: l_header_rec oe_order_pub.header_rec_type;
5339: l_old_header_rec oe_order_pub.header_rec_type;
5340: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5341: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5342: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5343: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5344: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5345: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

Line 5342: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

5338: l_header_rec oe_order_pub.header_rec_type;
5339: l_old_header_rec oe_order_pub.header_rec_type;
5340: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5341: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5342: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5343: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5344: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5345: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5346: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

Line 5343: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

5339: l_old_header_rec oe_order_pub.header_rec_type;
5340: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5341: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5342: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5343: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5344: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5345: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5346: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5347: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

Line 5344: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

5340: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5341: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5342: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5343: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5344: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5345: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5346: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5347: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5348: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

Line 5345: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

5341: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
5342: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5343: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5344: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5345: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5346: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5347: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5348: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5349: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

Line 5346: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

5342: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5343: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5344: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5345: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5346: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5347: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5348: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5349: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5350: l_line_tbl oe_order_pub.line_tbl_type;

Line 5347: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

5343: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
5344: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5345: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5346: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5347: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5348: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5349: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5350: l_line_tbl oe_order_pub.line_tbl_type;
5351: l_old_line_tbl oe_order_pub.line_tbl_type;

Line 5348: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

5344: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5345: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5346: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5347: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5348: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5349: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5350: l_line_tbl oe_order_pub.line_tbl_type;
5351: l_old_line_tbl oe_order_pub.line_tbl_type;
5352: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;

Line 5349: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

5345: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
5346: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5347: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5348: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5349: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5350: l_line_tbl oe_order_pub.line_tbl_type;
5351: l_old_line_tbl oe_order_pub.line_tbl_type;
5352: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5353: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;

Line 5350: l_line_tbl oe_order_pub.line_tbl_type;

5346: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5347: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5348: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5349: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5350: l_line_tbl oe_order_pub.line_tbl_type;
5351: l_old_line_tbl oe_order_pub.line_tbl_type;
5352: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5353: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5354: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

Line 5351: l_old_line_tbl oe_order_pub.line_tbl_type;

5347: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
5348: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5349: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5350: l_line_tbl oe_order_pub.line_tbl_type;
5351: l_old_line_tbl oe_order_pub.line_tbl_type;
5352: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5353: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5354: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5355: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

Line 5352: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;

5348: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5349: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5350: l_line_tbl oe_order_pub.line_tbl_type;
5351: l_old_line_tbl oe_order_pub.line_tbl_type;
5352: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5353: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5354: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5355: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5356: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

Line 5353: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;

5349: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
5350: l_line_tbl oe_order_pub.line_tbl_type;
5351: l_old_line_tbl oe_order_pub.line_tbl_type;
5352: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5353: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5354: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5355: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5356: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5357: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

Line 5354: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

5350: l_line_tbl oe_order_pub.line_tbl_type;
5351: l_old_line_tbl oe_order_pub.line_tbl_type;
5352: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5353: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5354: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5355: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5356: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5357: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5358: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

Line 5355: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

5351: l_old_line_tbl oe_order_pub.line_tbl_type;
5352: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5353: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5354: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5355: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5356: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5357: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5358: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5359: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

Line 5356: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

5352: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5353: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5354: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5355: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5356: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5357: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5358: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5359: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5360: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

Line 5357: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

5353: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
5354: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5355: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5356: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5357: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5358: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5359: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5360: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5361: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

Line 5358: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

5354: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5355: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5356: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5357: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5358: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5359: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5360: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5361: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5362: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

Line 5359: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

5355: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
5356: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5357: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5358: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5359: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5360: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5361: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5362: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5363: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

Line 5360: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

5356: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5357: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5358: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5359: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5360: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5361: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5362: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5363: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5364: l_action_request_tbl oe_order_pub.request_tbl_type;

Line 5361: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

5357: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
5358: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5359: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5360: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5361: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5362: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5363: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5364: l_action_request_tbl oe_order_pub.request_tbl_type;
5365: l_index NUMBER;

Line 5362: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

5358: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5359: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5360: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5361: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5362: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5363: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5364: l_action_request_tbl oe_order_pub.request_tbl_type;
5365: l_index NUMBER;
5366: l_mode VARCHAR2(30):= DBMS_AQ.BROWSE;

Line 5363: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

5359: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
5360: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5361: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5362: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5363: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5364: l_action_request_tbl oe_order_pub.request_tbl_type;
5365: l_index NUMBER;
5366: l_mode VARCHAR2(30):= DBMS_AQ.BROWSE;
5367: l_navigation VARCHAR2 (30) := DBMS_AQ.FIRST_MESSAGE;

Line 5364: l_action_request_tbl oe_order_pub.request_tbl_type;

5360: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5361: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
5362: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5363: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5364: l_action_request_tbl oe_order_pub.request_tbl_type;
5365: l_index NUMBER;
5366: l_mode VARCHAR2(30):= DBMS_AQ.BROWSE;
5367: l_navigation VARCHAR2 (30) := DBMS_AQ.FIRST_MESSAGE;
5368: