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 2302: p_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,

2298: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2299: x_return_status OUT NOCOPY VARCHAR2,
2300: x_msg_count OUT NOCOPY NUMBER,
2301: x_msg_data OUT NOCOPY VARCHAR2,
2302: p_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,
2303: p_old_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,
2304: p_header_rec IN oe_order_pub.header_rec_type := NULL,
2305: p_exception_queue IN VARCHAR2 := fnd_api.g_false
2306:

Line 2303: p_old_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,

2299: x_return_status OUT NOCOPY VARCHAR2,
2300: x_msg_count OUT NOCOPY NUMBER,
2301: x_msg_data OUT NOCOPY VARCHAR2,
2302: p_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,
2303: p_old_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,
2304: p_header_rec IN oe_order_pub.header_rec_type := NULL,
2305: p_exception_queue IN VARCHAR2 := fnd_api.g_false
2306:
2307: ) IS

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

2300: x_msg_count OUT NOCOPY NUMBER,
2301: x_msg_data OUT NOCOPY VARCHAR2,
2302: p_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,
2303: p_old_line_adj_tbl IN oe_order_pub.line_adj_tbl_type,
2304: p_header_rec IN oe_order_pub.header_rec_type := NULL,
2305: p_exception_queue IN VARCHAR2 := fnd_api.g_false
2306:
2307: ) IS
2308: l_return_status VARCHAR2 (10) := fnd_api.g_ret_sts_success;

Line 2907: p_header_rec IN oe_order_pub.header_rec_type,

2903: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2904: x_return_status OUT NOCOPY VARCHAR2,
2905: x_msg_count OUT NOCOPY NUMBER,
2906: x_msg_data OUT NOCOPY VARCHAR2,
2907: p_header_rec IN oe_order_pub.header_rec_type,
2908: p_old_header_rec IN oe_order_pub.header_rec_type,
2909: p_line_tbl IN oe_order_pub.line_tbl_type,
2910: p_old_line_tbl IN oe_order_pub.line_tbl_type
2911: ) IS

Line 2908: p_old_header_rec IN oe_order_pub.header_rec_type,

2904: x_return_status OUT NOCOPY VARCHAR2,
2905: x_msg_count OUT NOCOPY NUMBER,
2906: x_msg_data OUT NOCOPY VARCHAR2,
2907: p_header_rec IN oe_order_pub.header_rec_type,
2908: p_old_header_rec IN oe_order_pub.header_rec_type,
2909: p_line_tbl IN oe_order_pub.line_tbl_type,
2910: p_old_line_tbl IN oe_order_pub.line_tbl_type
2911: ) IS
2912: l_return_status VARCHAR2 (1) ;

Line 2909: p_line_tbl IN oe_order_pub.line_tbl_type,

2905: x_msg_count OUT NOCOPY NUMBER,
2906: x_msg_data OUT NOCOPY VARCHAR2,
2907: p_header_rec IN oe_order_pub.header_rec_type,
2908: p_old_header_rec IN oe_order_pub.header_rec_type,
2909: p_line_tbl IN oe_order_pub.line_tbl_type,
2910: p_old_line_tbl IN oe_order_pub.line_tbl_type
2911: ) IS
2912: l_return_status VARCHAR2 (1) ;
2913: l_api_name CONSTANT VARCHAR2 (30) := 'Adjust_Changed_order';

Line 2910: p_old_line_tbl IN oe_order_pub.line_tbl_type

2906: x_msg_data OUT NOCOPY VARCHAR2,
2907: p_header_rec IN oe_order_pub.header_rec_type,
2908: p_old_header_rec IN oe_order_pub.header_rec_type,
2909: p_line_tbl IN oe_order_pub.line_tbl_type,
2910: p_old_line_tbl IN oe_order_pub.line_tbl_type
2911: ) IS
2912: l_return_status VARCHAR2 (1) ;
2913: l_api_name CONSTANT VARCHAR2 (30) := 'Adjust_Changed_order';
2914: l_api_version CONSTANT NUMBER := 1.0;

Line 3919: l_header_rec oe_order_pub.header_rec_type;

3915: l_msg_data VARCHAR2 (2000);
3916: l_no_more_messages VARCHAR2 (1);
3917: l_header_id NUMBER;
3918: l_booked_flag VARCHAR2 (1);
3919: l_header_rec oe_order_pub.header_rec_type;
3920: l_old_header_rec oe_order_pub.header_rec_type;
3921: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3922: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3923: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

Line 3920: l_old_header_rec oe_order_pub.header_rec_type;

3916: l_no_more_messages VARCHAR2 (1);
3917: l_header_id NUMBER;
3918: l_booked_flag VARCHAR2 (1);
3919: l_header_rec oe_order_pub.header_rec_type;
3920: l_old_header_rec oe_order_pub.header_rec_type;
3921: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3922: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3923: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3924: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

Line 3921: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;

3917: l_header_id NUMBER;
3918: l_booked_flag VARCHAR2 (1);
3919: l_header_rec oe_order_pub.header_rec_type;
3920: l_old_header_rec oe_order_pub.header_rec_type;
3921: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3922: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3923: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3924: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3925: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

Line 3922: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;

3918: l_booked_flag VARCHAR2 (1);
3919: l_header_rec oe_order_pub.header_rec_type;
3920: l_old_header_rec oe_order_pub.header_rec_type;
3921: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3922: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3923: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3924: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3925: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3926: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

Line 3923: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

3919: l_header_rec oe_order_pub.header_rec_type;
3920: l_old_header_rec oe_order_pub.header_rec_type;
3921: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3922: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3923: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3924: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3925: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3926: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3927: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

Line 3924: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

3920: l_old_header_rec oe_order_pub.header_rec_type;
3921: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3922: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3923: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3924: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3925: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3926: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3927: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3928: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

Line 3925: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

3921: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3922: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3923: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3924: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3925: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3926: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3927: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3928: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3929: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

Line 3926: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

3922: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
3923: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3924: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3925: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3926: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3927: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3928: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3929: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3930: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

Line 3927: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

3923: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3924: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3925: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3926: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3927: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3928: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3929: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3930: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3931: l_line_tbl oe_order_pub.line_tbl_type;

Line 3928: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

3924: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
3925: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3926: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3927: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3928: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3929: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3930: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3931: l_line_tbl oe_order_pub.line_tbl_type;
3932: l_old_line_tbl oe_order_pub.line_tbl_type;

Line 3929: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

3925: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3926: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3927: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3928: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3929: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3930: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3931: l_line_tbl oe_order_pub.line_tbl_type;
3932: l_old_line_tbl oe_order_pub.line_tbl_type;
3933: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;

Line 3930: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

3926: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
3927: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3928: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3929: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3930: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3931: l_line_tbl oe_order_pub.line_tbl_type;
3932: l_old_line_tbl oe_order_pub.line_tbl_type;
3933: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3934: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;

Line 3931: l_line_tbl oe_order_pub.line_tbl_type;

3927: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3928: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3929: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3930: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3931: l_line_tbl oe_order_pub.line_tbl_type;
3932: l_old_line_tbl oe_order_pub.line_tbl_type;
3933: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3934: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3935: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

Line 3932: l_old_line_tbl oe_order_pub.line_tbl_type;

3928: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
3929: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3930: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3931: l_line_tbl oe_order_pub.line_tbl_type;
3932: l_old_line_tbl oe_order_pub.line_tbl_type;
3933: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3934: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3935: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3936: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

Line 3933: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;

3929: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3930: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3931: l_line_tbl oe_order_pub.line_tbl_type;
3932: l_old_line_tbl oe_order_pub.line_tbl_type;
3933: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3934: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3935: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3936: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3937: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

Line 3934: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;

3930: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
3931: l_line_tbl oe_order_pub.line_tbl_type;
3932: l_old_line_tbl oe_order_pub.line_tbl_type;
3933: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3934: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3935: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3936: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3937: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3938: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

Line 3935: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

3931: l_line_tbl oe_order_pub.line_tbl_type;
3932: l_old_line_tbl oe_order_pub.line_tbl_type;
3933: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3934: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3935: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3936: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3937: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3938: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3939: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

Line 3936: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

3932: l_old_line_tbl oe_order_pub.line_tbl_type;
3933: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3934: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3935: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3936: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3937: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3938: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3939: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3940: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

Line 3937: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

3933: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3934: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3935: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3936: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3937: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3938: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3939: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3940: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3941: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

Line 3938: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

3934: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
3935: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3936: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3937: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3938: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3939: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3940: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3941: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3942: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

Line 3939: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

3935: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3936: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3937: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3938: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3939: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3940: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3941: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3942: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3943: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

Line 3940: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

3936: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
3937: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3938: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3939: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3940: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3941: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3942: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3943: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
3944: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

Line 3941: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

3937: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3938: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3939: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3940: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3941: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3942: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3943: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
3944: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
3945: l_action_request_tbl oe_order_pub.request_tbl_type;

Line 3942: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

3938: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
3939: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3940: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3941: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3942: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3943: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
3944: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
3945: l_action_request_tbl oe_order_pub.request_tbl_type;
3946: l_que_msg_count NUMBER := 0 ;

Line 3943: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

3939: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3940: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3941: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3942: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3943: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
3944: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
3945: l_action_request_tbl oe_order_pub.request_tbl_type;
3946: l_que_msg_count NUMBER := 0 ;
3947: BEGIN

Line 3944: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

3940: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
3941: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3942: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3943: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
3944: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
3945: l_action_request_tbl oe_order_pub.request_tbl_type;
3946: l_que_msg_count NUMBER := 0 ;
3947: BEGIN
3948: -- Standard Start of process savepoint

Line 3945: l_action_request_tbl oe_order_pub.request_tbl_type;

3941: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3942: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
3943: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
3944: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
3945: l_action_request_tbl oe_order_pub.request_tbl_type;
3946: l_que_msg_count NUMBER := 0 ;
3947: BEGIN
3948: -- Standard Start of process savepoint
3949: -- Start looping to check for messages in the queue

Line 4210: l_header_rec oe_order_pub.header_rec_type;

4206: l_msg_data VARCHAR2 (2000);
4207: l_no_more_messages VARCHAR2 (1);
4208: l_header_id NUMBER;
4209: l_booked_flag VARCHAR2 (1);
4210: l_header_rec oe_order_pub.header_rec_type;
4211: l_old_header_rec oe_order_pub.header_rec_type;
4212: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4213: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4214: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

Line 4211: l_old_header_rec oe_order_pub.header_rec_type;

4207: l_no_more_messages VARCHAR2 (1);
4208: l_header_id NUMBER;
4209: l_booked_flag VARCHAR2 (1);
4210: l_header_rec oe_order_pub.header_rec_type;
4211: l_old_header_rec oe_order_pub.header_rec_type;
4212: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4213: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4214: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4215: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

Line 4212: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;

4208: l_header_id NUMBER;
4209: l_booked_flag VARCHAR2 (1);
4210: l_header_rec oe_order_pub.header_rec_type;
4211: l_old_header_rec oe_order_pub.header_rec_type;
4212: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4213: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4214: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4215: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4216: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

Line 4213: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;

4209: l_booked_flag VARCHAR2 (1);
4210: l_header_rec oe_order_pub.header_rec_type;
4211: l_old_header_rec oe_order_pub.header_rec_type;
4212: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4213: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4214: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4215: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4216: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4217: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

Line 4214: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

4210: l_header_rec oe_order_pub.header_rec_type;
4211: l_old_header_rec oe_order_pub.header_rec_type;
4212: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4213: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4214: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4215: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4216: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4217: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4218: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

Line 4215: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;

4211: l_old_header_rec oe_order_pub.header_rec_type;
4212: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4213: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4214: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4215: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4216: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4217: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4218: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4219: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

Line 4216: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

4212: l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4213: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4214: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4215: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4216: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4217: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4218: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4219: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4220: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

Line 4217: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;

4213: l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
4214: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4215: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4216: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4217: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4218: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4219: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4220: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4221: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

Line 4218: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

4214: l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4215: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4216: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4217: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4218: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4219: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4220: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4221: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4222: l_line_tbl oe_order_pub.line_tbl_type;

Line 4219: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;

4215: l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
4216: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4217: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4218: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4219: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4220: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4221: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4222: l_line_tbl oe_order_pub.line_tbl_type;
4223: l_old_line_tbl oe_order_pub.line_tbl_type;

Line 4220: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

4216: l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4217: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4218: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4219: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4220: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4221: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4222: l_line_tbl oe_order_pub.line_tbl_type;
4223: l_old_line_tbl oe_order_pub.line_tbl_type;
4224: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;

Line 4221: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;

4217: l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
4218: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4219: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4220: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4221: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4222: l_line_tbl oe_order_pub.line_tbl_type;
4223: l_old_line_tbl oe_order_pub.line_tbl_type;
4224: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4225: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;

Line 4222: l_line_tbl oe_order_pub.line_tbl_type;

4218: l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4219: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4220: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4221: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4222: l_line_tbl oe_order_pub.line_tbl_type;
4223: l_old_line_tbl oe_order_pub.line_tbl_type;
4224: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4225: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4226: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

Line 4223: l_old_line_tbl oe_order_pub.line_tbl_type;

4219: l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
4220: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4221: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4222: l_line_tbl oe_order_pub.line_tbl_type;
4223: l_old_line_tbl oe_order_pub.line_tbl_type;
4224: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4225: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4226: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4227: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

Line 4224: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;

4220: l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4221: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4222: l_line_tbl oe_order_pub.line_tbl_type;
4223: l_old_line_tbl oe_order_pub.line_tbl_type;
4224: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4225: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4226: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4227: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4228: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

Line 4225: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;

4221: l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
4222: l_line_tbl oe_order_pub.line_tbl_type;
4223: l_old_line_tbl oe_order_pub.line_tbl_type;
4224: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4225: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4226: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4227: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4228: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4229: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

Line 4226: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

4222: l_line_tbl oe_order_pub.line_tbl_type;
4223: l_old_line_tbl oe_order_pub.line_tbl_type;
4224: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4225: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4226: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4227: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4228: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4229: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4230: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

Line 4227: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;

4223: l_old_line_tbl oe_order_pub.line_tbl_type;
4224: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4225: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4226: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4227: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4228: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4229: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4230: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4231: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

Line 4228: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

4224: l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4225: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4226: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4227: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4228: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4229: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4230: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4231: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4232: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

Line 4229: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;

4225: l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
4226: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4227: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4228: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4229: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4230: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4231: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4232: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4233: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

Line 4230: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

4226: l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4227: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4228: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4229: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4230: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4231: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4232: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4233: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4234: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

Line 4231: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;

4227: l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
4228: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4229: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4230: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4231: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4232: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4233: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4234: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
4235: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

Line 4232: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

4228: l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4229: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4230: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4231: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4232: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4233: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4234: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
4235: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
4236: l_action_request_tbl oe_order_pub.request_tbl_type;

Line 4233: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;

4229: l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
4230: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4231: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4232: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4233: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4234: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
4235: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
4236: l_action_request_tbl oe_order_pub.request_tbl_type;
4237: l_index NUMBER;

Line 4234: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

4230: l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4231: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4232: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4233: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4234: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
4235: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
4236: l_action_request_tbl oe_order_pub.request_tbl_type;
4237: l_index NUMBER;
4238: l_mode VARCHAR2(30):= DBMS_AQ.BROWSE;

Line 4235: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;

4231: l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
4232: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4233: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4234: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
4235: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
4236: l_action_request_tbl oe_order_pub.request_tbl_type;
4237: l_index NUMBER;
4238: l_mode VARCHAR2(30):= DBMS_AQ.BROWSE;
4239: l_navigation VARCHAR2 (30) := DBMS_AQ.FIRST_MESSAGE;

Line 4236: l_action_request_tbl oe_order_pub.request_tbl_type;

4232: l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4233: l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
4234: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
4235: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
4236: l_action_request_tbl oe_order_pub.request_tbl_type;
4237: l_index NUMBER;
4238: l_mode VARCHAR2(30):= DBMS_AQ.BROWSE;
4239: l_navigation VARCHAR2 (30) := DBMS_AQ.FIRST_MESSAGE;
4240: