DBA Data[Home] [Help]

APPS.OE_ACKNOWLEDGMENT_PUB dependencies on OE_ORDER_PUB

Line 42: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=

38: PROCEDURE Process_Acknowledgment
39: (p_api_version_number IN NUMBER
40: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
41:
42: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
43: OE_Order_Pub.G_MISS_HEADER_REC
44: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
45: OE_Order_Pub.G_MISS_HEADER_VAL_REC
46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=

Line 43: OE_Order_Pub.G_MISS_HEADER_REC

39: (p_api_version_number IN NUMBER
40: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
41:
42: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
43: OE_Order_Pub.G_MISS_HEADER_REC
44: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
45: OE_Order_Pub.G_MISS_HEADER_VAL_REC
46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL

Line 44: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=

40: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
41:
42: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
43: OE_Order_Pub.G_MISS_HEADER_REC
44: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
45: OE_Order_Pub.G_MISS_HEADER_VAL_REC
46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

Line 45: OE_Order_Pub.G_MISS_HEADER_VAL_REC

41:
42: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
43: OE_Order_Pub.G_MISS_HEADER_REC
44: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
45: OE_Order_Pub.G_MISS_HEADER_VAL_REC
46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL

Line 46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=

42: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
43: OE_Order_Pub.G_MISS_HEADER_REC
44: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
45: OE_Order_Pub.G_MISS_HEADER_VAL_REC
46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=

Line 47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL

43: OE_Order_Pub.G_MISS_HEADER_REC
44: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
45: OE_Order_Pub.G_MISS_HEADER_VAL_REC
46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL

Line 48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

44: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
45: OE_Order_Pub.G_MISS_HEADER_VAL_REC
46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

Line 49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL

45: OE_Order_Pub.G_MISS_HEADER_VAL_REC
46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL

Line 50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=

46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=

Line 51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL

47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
55: OE_Order_Pub.G_MISS_LINE_TBL

Line 52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
55: OE_Order_Pub.G_MISS_LINE_TBL
56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=

Line 53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL

49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
55: OE_Order_Pub.G_MISS_LINE_TBL
56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
57: OE_Order_Pub.G_MISS_LINE_VAL_TBL

Line 54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=

50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
55: OE_Order_Pub.G_MISS_LINE_TBL
56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
57: OE_Order_Pub.G_MISS_LINE_VAL_TBL
58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=

Line 55: OE_Order_Pub.G_MISS_LINE_TBL

51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
55: OE_Order_Pub.G_MISS_LINE_TBL
56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
57: OE_Order_Pub.G_MISS_LINE_VAL_TBL
58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL

Line 56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=

52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
55: OE_Order_Pub.G_MISS_LINE_TBL
56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
57: OE_Order_Pub.G_MISS_LINE_VAL_TBL
58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

Line 57: OE_Order_Pub.G_MISS_LINE_VAL_TBL

53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
55: OE_Order_Pub.G_MISS_LINE_TBL
56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
57: OE_Order_Pub.G_MISS_LINE_VAL_TBL
58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL

Line 58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=

54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
55: OE_Order_Pub.G_MISS_LINE_TBL
56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
57: OE_Order_Pub.G_MISS_LINE_VAL_TBL
58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=

Line 59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL

55: OE_Order_Pub.G_MISS_LINE_TBL
56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
57: OE_Order_Pub.G_MISS_LINE_VAL_TBL
58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL

Line 60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
57: OE_Order_Pub.G_MISS_LINE_VAL_TBL
58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

Line 61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL

57: OE_Order_Pub.G_MISS_LINE_VAL_TBL
58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL

Line 62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=

58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=

Line 63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL

59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL

Line 64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
68: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

Line 65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL

61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
68: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
69: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL

Line 66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=

62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
68: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
69: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
70: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=

Line 67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL

63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
68: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
69: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
70: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
71: OE_Order_Pub.G_MISS_REQUEST_TBL

Line 68: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
68: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
69: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
70: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
71: OE_Order_Pub.G_MISS_REQUEST_TBL
72:

Line 69: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL

65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
68: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
69: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
70: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
71: OE_Order_Pub.G_MISS_REQUEST_TBL
72:
73: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=

Line 70: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=

66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
68: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
69: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
70: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
71: OE_Order_Pub.G_MISS_REQUEST_TBL
72:
73: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
74: OE_Order_Pub.G_MISS_HEADER_REC

Line 71: OE_Order_Pub.G_MISS_REQUEST_TBL

67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
68: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
69: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
70: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
71: OE_Order_Pub.G_MISS_REQUEST_TBL
72:
73: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
74: OE_Order_Pub.G_MISS_HEADER_REC
75: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=

Line 73: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=

69: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
70: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
71: OE_Order_Pub.G_MISS_REQUEST_TBL
72:
73: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
74: OE_Order_Pub.G_MISS_HEADER_REC
75: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
76: OE_Order_Pub.G_MISS_HEADER_VAL_REC
77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=

Line 74: OE_Order_Pub.G_MISS_HEADER_REC

70: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
71: OE_Order_Pub.G_MISS_REQUEST_TBL
72:
73: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
74: OE_Order_Pub.G_MISS_HEADER_REC
75: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
76: OE_Order_Pub.G_MISS_HEADER_VAL_REC
77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL

Line 75: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=

71: OE_Order_Pub.G_MISS_REQUEST_TBL
72:
73: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
74: OE_Order_Pub.G_MISS_HEADER_REC
75: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
76: OE_Order_Pub.G_MISS_HEADER_VAL_REC
77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

Line 76: OE_Order_Pub.G_MISS_HEADER_VAL_REC

72:
73: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
74: OE_Order_Pub.G_MISS_HEADER_REC
75: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
76: OE_Order_Pub.G_MISS_HEADER_VAL_REC
77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL

Line 77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=

73: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
74: OE_Order_Pub.G_MISS_HEADER_REC
75: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
76: OE_Order_Pub.G_MISS_HEADER_VAL_REC
77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=

Line 78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL

74: OE_Order_Pub.G_MISS_HEADER_REC
75: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
76: OE_Order_Pub.G_MISS_HEADER_VAL_REC
77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL

Line 79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=

75: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
76: OE_Order_Pub.G_MISS_HEADER_VAL_REC
77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

Line 80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL

76: OE_Order_Pub.G_MISS_HEADER_VAL_REC
77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL

Line 81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=

77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=

Line 82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL

78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
86: OE_Order_Pub.G_MISS_LINE_TBL

Line 83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=

79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
86: OE_Order_Pub.G_MISS_LINE_TBL
87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=

Line 84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL

80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
86: OE_Order_Pub.G_MISS_LINE_TBL
87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
88: OE_Order_Pub.G_MISS_LINE_VAL_TBL

Line 85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=

81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
86: OE_Order_Pub.G_MISS_LINE_TBL
87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
88: OE_Order_Pub.G_MISS_LINE_VAL_TBL
89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=

Line 86: OE_Order_Pub.G_MISS_LINE_TBL

82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
86: OE_Order_Pub.G_MISS_LINE_TBL
87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
88: OE_Order_Pub.G_MISS_LINE_VAL_TBL
89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL

Line 87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=

83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
86: OE_Order_Pub.G_MISS_LINE_TBL
87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
88: OE_Order_Pub.G_MISS_LINE_VAL_TBL
89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

Line 88: OE_Order_Pub.G_MISS_LINE_VAL_TBL

84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
86: OE_Order_Pub.G_MISS_LINE_TBL
87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
88: OE_Order_Pub.G_MISS_LINE_VAL_TBL
89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL

Line 89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=

85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
86: OE_Order_Pub.G_MISS_LINE_TBL
87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
88: OE_Order_Pub.G_MISS_LINE_VAL_TBL
89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=

Line 90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL

86: OE_Order_Pub.G_MISS_LINE_TBL
87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
88: OE_Order_Pub.G_MISS_LINE_VAL_TBL
89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL

Line 91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=

87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
88: OE_Order_Pub.G_MISS_LINE_VAL_TBL
89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

Line 92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL

88: OE_Order_Pub.G_MISS_LINE_VAL_TBL
89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL

Line 93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=

89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
97: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=

Line 94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL

90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
97: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
98: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL

Line 95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=

91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
97: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
98: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
99: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

Line 96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL

92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
97: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
98: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
99: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
100: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL

Line 97: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=

93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
97: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
98: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
99: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
100: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
101:

Line 98: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL

94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
97: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
98: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
99: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
100: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
101:
102: ,p_buyer_seller_flag IN VARCHAR2 DEFAULT 'B'

Line 99: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=

95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
97: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
98: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
99: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
100: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
101:
102: ,p_buyer_seller_flag IN VARCHAR2 DEFAULT 'B'
103: ,p_reject_order IN VARCHAR2 DEFAULT 'N'

Line 100: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL

96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
97: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
98: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
99: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
100: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
101:
102: ,p_buyer_seller_flag IN VARCHAR2 DEFAULT 'B'
103: ,p_reject_order IN VARCHAR2 DEFAULT 'N'
104:

Line 116: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,

112: p_change_sequence IN Varchar2 := NULL,
113: p_msg_id IN Number := NULL,
114: p_request_id IN Number := Null,
115: p_xml_transaction_type_code IN Varchar2 := NULL,
116: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,
117: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
118: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
119: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type
120: );

Line 117: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,

113: p_msg_id IN Number := NULL,
114: p_request_id IN Number := Null,
115: p_xml_transaction_type_code IN Varchar2 := NULL,
116: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,
117: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
118: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
119: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type
120: );
121:

Line 118: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,

114: p_request_id IN Number := Null,
115: p_xml_transaction_type_code IN Varchar2 := NULL,
116: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,
117: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
118: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
119: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type
120: );
121:
122: PROCEDURE Process_Xml_Acknowledgment

Line 119: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type

115: p_xml_transaction_type_code IN Varchar2 := NULL,
116: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,
117: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
118: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
119: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type
120: );
121:
122: PROCEDURE Process_Xml_Acknowledgment
123: ( p_api_version_number IN NUMBER := 1,

Line 142: p_header_rec IN OE_Order_Pub.Header_Rec_Type,

138:
139: PROCEDURE Process_SSO
140: ( p_api_version_number IN NUMBER := 1,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
143: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
144: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
145: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
146: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 143: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,

139: PROCEDURE Process_SSO
140: ( p_api_version_number IN NUMBER := 1,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
143: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
144: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
145: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
146: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
147: );

Line 144: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,

140: ( p_api_version_number IN NUMBER := 1,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
143: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
144: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
145: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
146: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
147: );
148:

Line 145: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,

141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
143: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
144: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
145: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
146: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
147: );
148:
149: Procedure Raise_Event_Showso

Line 266: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

262: , x_return_status OUT NOCOPY VARCHAR2
263: );
264:
265: Procedure Process_3A8
266: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
267: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
268: , x_return_status OUT NOCOPY VARCHAR2
269: );
270:

Line 267: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

263: );
264:
265: Procedure Process_3A8
266: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
267: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
268: , x_return_status OUT NOCOPY VARCHAR2
269: );
270:
271: Function EM_Transaction_Type

Line 277: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,

273: ) RETURN VARCHAR2;
274:
275: --SUN OIP ER
276: FUNCTION Get_Line_Index
277: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
278: p_line_id IN Number
279: )
280: RETURN NUMBER;
281: --End of SUN OIP ER