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.CN_NOTIFY_ORDERS dependencies on OE_ORDER_PUB

Line 499: p_header_rec IN OE_Order_PUB.Header_Rec_Type,

495: x_return_status OUT NOCOPY VARCHAR2,
496: x_msg_count OUT NOCOPY NUMBER,
497: x_msg_data OUT NOCOPY VARCHAR2,
498: p_header_id IN NUMBER,
499: p_header_rec IN OE_Order_PUB.Header_Rec_Type,
500: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type,
501: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
502: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
503: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,

Line 500: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type,

496: x_msg_count OUT NOCOPY NUMBER,
497: x_msg_data OUT NOCOPY VARCHAR2,
498: p_header_id IN NUMBER,
499: p_header_rec IN OE_Order_PUB.Header_Rec_Type,
500: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type,
501: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
502: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
503: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
504: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,

Line 501: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,

497: x_msg_data OUT NOCOPY VARCHAR2,
498: p_header_id IN NUMBER,
499: p_header_rec IN OE_Order_PUB.Header_Rec_Type,
500: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type,
501: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
502: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
503: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
504: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
505: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,

Line 502: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,

498: p_header_id IN NUMBER,
499: p_header_rec IN OE_Order_PUB.Header_Rec_Type,
500: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type,
501: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
502: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
503: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
504: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
505: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
506: p_old_Line_Scredit_tbl IN OE_Order_PUB.line_scredit_tbl_type,

Line 503: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,

499: p_header_rec IN OE_Order_PUB.Header_Rec_Type,
500: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type,
501: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
502: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
503: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
504: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
505: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
506: p_old_Line_Scredit_tbl IN OE_Order_PUB.line_scredit_tbl_type,
507: p_parent_proc_audit_id IN NUMBER,

Line 504: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,

500: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type,
501: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
502: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
503: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
504: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
505: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
506: p_old_Line_Scredit_tbl IN OE_Order_PUB.line_scredit_tbl_type,
507: p_parent_proc_audit_id IN NUMBER,
508: x_org_id IN NUMBER) -- R12 MOAC Change

Line 505: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,

501: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
502: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
503: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
504: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
505: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
506: p_old_Line_Scredit_tbl IN OE_Order_PUB.line_scredit_tbl_type,
507: p_parent_proc_audit_id IN NUMBER,
508: x_org_id IN NUMBER) -- R12 MOAC Change
509: IS

Line 506: p_old_Line_Scredit_tbl IN OE_Order_PUB.line_scredit_tbl_type,

502: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
503: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
504: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
505: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
506: p_old_Line_Scredit_tbl IN OE_Order_PUB.line_scredit_tbl_type,
507: p_parent_proc_audit_id IN NUMBER,
508: x_org_id IN NUMBER) -- R12 MOAC Change
509: IS
510: l_api_name CONSTANT VARCHAR2(30) := 'Adjust_Order';

Line 993: l_header_rec OE_Order_PUB.Header_Rec_Type;

989: l_msg_data VARCHAR2(2000);
990: l_no_more_messages VARCHAR2(2000);
991: l_header_id NUMBER;
992: l_booked_flag VARCHAR2(1);
993: l_header_rec OE_Order_PUB.Header_Rec_Type;
994: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
995: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
996: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
997: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 994: l_old_header_rec OE_Order_PUB.Header_Rec_Type;

990: l_no_more_messages VARCHAR2(2000);
991: l_header_id NUMBER;
992: l_booked_flag VARCHAR2(1);
993: l_header_rec OE_Order_PUB.Header_Rec_Type;
994: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
995: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
996: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
997: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
998: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 995: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

991: l_header_id NUMBER;
992: l_booked_flag VARCHAR2(1);
993: l_header_rec OE_Order_PUB.Header_Rec_Type;
994: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
995: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
996: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
997: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
998: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
999: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 996: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

992: l_booked_flag VARCHAR2(1);
993: l_header_rec OE_Order_PUB.Header_Rec_Type;
994: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
995: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
996: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
997: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
998: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
999: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1000: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 997: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

993: l_header_rec OE_Order_PUB.Header_Rec_Type;
994: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
995: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
996: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
997: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
998: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
999: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1000: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1001: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 998: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

994: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
995: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
996: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
997: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
998: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
999: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1000: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1001: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1002: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 999: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

995: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
996: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
997: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
998: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
999: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1000: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1001: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1002: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1003: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 1000: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

996: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
997: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
998: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
999: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1000: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1001: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1002: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1003: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1004: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 1001: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

997: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
998: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
999: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1000: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1001: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1002: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1003: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1004: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1005: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 1002: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

998: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
999: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1000: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1001: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1002: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1003: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1004: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1005: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1006: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 1003: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

999: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1000: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1001: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1002: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1003: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1004: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1005: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1006: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1007: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 1004: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

1000: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1001: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1002: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1003: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1004: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1005: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1006: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1007: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1008: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 1005: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

1001: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1002: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1003: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1004: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1005: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1006: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1007: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1008: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1009: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 1006: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

1002: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1003: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1004: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1005: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1006: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1007: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1008: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1009: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1010: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 1007: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

1003: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1004: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1005: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1006: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1007: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1008: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1009: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1010: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1011: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 1008: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

1004: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1005: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1006: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1007: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1008: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1009: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1010: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1011: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1012: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 1009: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

1005: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1006: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1007: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1008: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1009: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1010: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1011: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1012: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1013: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 1010: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

1006: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1007: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1008: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1009: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1010: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1011: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1012: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1013: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1014: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 1011: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

1007: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1008: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1009: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1010: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1011: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1012: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1013: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1014: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1015: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 1012: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

1008: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1009: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1010: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1011: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1012: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1013: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1014: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1015: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1016: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 1013: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

1009: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1010: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1011: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1012: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1013: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1014: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1015: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1016: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1017: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 1014: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

1010: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1011: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1012: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1013: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1014: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1015: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1016: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1017: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1018: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 1015: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1011: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1012: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1013: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1014: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1015: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1016: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1017: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1018: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1019: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 1016: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1012: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1013: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1014: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1015: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1016: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1017: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1018: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1019: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1020:

Line 1017: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

1013: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1014: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1015: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1016: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1017: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1018: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1019: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1020:
1021: CURSOR c_booked_flag (cp_hid NUMBER) IS

Line 1018: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

1014: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1015: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1016: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1017: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1018: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1019: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1020:
1021: CURSOR c_booked_flag (cp_hid NUMBER) IS
1022: SELECT booked_flag

Line 1019: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

1015: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1016: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1017: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1018: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1019: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1020:
1021: CURSOR c_booked_flag (cp_hid NUMBER) IS
1022: SELECT booked_flag
1023: FROM aso_i_oe_order_lines_v