DBA Data[Home] [Help]

APPS.OE_SALES_CAN_UTIL dependencies on OE_ORDER_PUB

Line 21: G_LINE_REC OE_ORDER_PUB.Line_Rec_Type;

17: --
18: -- End of Comments
19:
20: G_PKG_NAME VARCHAR2(30) := 'OE_SALES_CAN_UTIL';
21: G_LINE_REC OE_ORDER_PUB.Line_Rec_Type;
22: G_REQUIRE_REASON BOOLEAN := FALSE;
23: G_ORDER_CANCEL BOOLEAN := FALSE;
24:
25: /* 7576948: IR ISO Change Management project Start */

Line 60: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

56:
57: /* IR ISO Change Management project End */
58:
59: PROCEDURE check_constraints
60: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
61: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
62: OE_Order_PUB.G_MISS_LINE_REC
63: , x_return_status OUT NOCOPY VARCHAR2
64:

Line 61: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

57: /* IR ISO Change Management project End */
58:
59: PROCEDURE check_constraints
60: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
61: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
62: OE_Order_PUB.G_MISS_LINE_REC
63: , x_return_status OUT NOCOPY VARCHAR2
64:
65: );

Line 62: OE_Order_PUB.G_MISS_LINE_REC

58:
59: PROCEDURE check_constraints
60: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
61: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
62: OE_Order_PUB.G_MISS_LINE_REC
63: , x_return_status OUT NOCOPY VARCHAR2
64:
65: );
66:

Line 68: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

64:
65: );
66:
67: PROCEDURE check_constraints
68: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
69: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type:=
70: OE_Order_PUB.G_MISS_header_REC
71: , x_return_status OUT NOCOPY VARCHAR2
72:

Line 69: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type:=

65: );
66:
67: PROCEDURE check_constraints
68: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
69: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type:=
70: OE_Order_PUB.G_MISS_header_REC
71: , x_return_status OUT NOCOPY VARCHAR2
72:
73: );

Line 70: OE_Order_PUB.G_MISS_header_REC

66:
67: PROCEDURE check_constraints
68: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
69: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type:=
70: OE_Order_PUB.G_MISS_header_REC
71: , x_return_status OUT NOCOPY VARCHAR2
72:
73: );
74:

Line 76: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

72:
73: );
74:
75: PROCEDURE update_service
76: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
77: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
78: OE_Order_PUB.G_MISS_LINE_REC
79: , x_return_status OUT NOCOPY VARCHAR2
80:

Line 77: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

73: );
74:
75: PROCEDURE update_service
76: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
77: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
78: OE_Order_PUB.G_MISS_LINE_REC
79: , x_return_status OUT NOCOPY VARCHAR2
80:
81: );

Line 78: OE_Order_PUB.G_MISS_LINE_REC

74:
75: PROCEDURE update_service
76: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
77: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
78: OE_Order_PUB.G_MISS_LINE_REC
79: , x_return_status OUT NOCOPY VARCHAR2
80:
81: );
82:

Line 85: p_line_rec IN OE_Order_PUB.Line_Rec_Type

81: );
82:
83:
84: FUNCTION Cal_Cancelled_Qty (
85: p_line_rec IN OE_Order_PUB.Line_Rec_Type
86: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
87: OE_Order_PUB.G_MISS_LINE_REC
88: )Return Number;
89:

Line 86: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

82:
83:
84: FUNCTION Cal_Cancelled_Qty (
85: p_line_rec IN OE_Order_PUB.Line_Rec_Type
86: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
87: OE_Order_PUB.G_MISS_LINE_REC
88: )Return Number;
89:
90: FUNCTION Cal_Cancelled_Qty2 ( -- INVCONV

Line 87: OE_Order_PUB.G_MISS_LINE_REC

83:
84: FUNCTION Cal_Cancelled_Qty (
85: p_line_rec IN OE_Order_PUB.Line_Rec_Type
86: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
87: OE_Order_PUB.G_MISS_LINE_REC
88: )Return Number;
89:
90: FUNCTION Cal_Cancelled_Qty2 ( -- INVCONV
91: p_line_rec IN OE_Order_PUB.Line_Rec_Type

Line 91: p_line_rec IN OE_Order_PUB.Line_Rec_Type

87: OE_Order_PUB.G_MISS_LINE_REC
88: )Return Number;
89:
90: FUNCTION Cal_Cancelled_Qty2 ( -- INVCONV
91: p_line_rec IN OE_Order_PUB.Line_Rec_Type
92: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
93: OE_Order_PUB.G_MISS_LINE_REC
94: )Return Number;
95:

Line 92: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

88: )Return Number;
89:
90: FUNCTION Cal_Cancelled_Qty2 ( -- INVCONV
91: p_line_rec IN OE_Order_PUB.Line_Rec_Type
92: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
93: OE_Order_PUB.G_MISS_LINE_REC
94: )Return Number;
95:
96:

Line 93: OE_Order_PUB.G_MISS_LINE_REC

89:
90: FUNCTION Cal_Cancelled_Qty2 ( -- INVCONV
91: p_line_rec IN OE_Order_PUB.Line_Rec_Type
92: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
93: OE_Order_PUB.G_MISS_LINE_REC
94: )Return Number;
95:
96:
97: PROCEDURE perform_line_change

Line 98: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

94: )Return Number;
95:
96:
97: PROCEDURE perform_line_change
98: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
99: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
100: OE_Order_PUB.G_MISS_LINE_REC
101: , x_return_status OUT NOCOPY varchar2
102:

Line 99: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

95:
96:
97: PROCEDURE perform_line_change
98: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
99: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
100: OE_Order_PUB.G_MISS_LINE_REC
101: , x_return_status OUT NOCOPY varchar2
102:
103: );

Line 100: OE_Order_PUB.G_MISS_LINE_REC

96:
97: PROCEDURE perform_line_change
98: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
99: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
100: OE_Order_PUB.G_MISS_LINE_REC
101: , x_return_status OUT NOCOPY varchar2
102:
103: );
104:

Line 106: ( p_header_rec IN OE_Order_PUB.header_Rec_Type

102:
103: );
104:
105: PROCEDURE perform_cancel_order
106: ( p_header_rec IN OE_Order_PUB.header_Rec_Type
107: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type :=
108: OE_Order_PUB.G_MISS_header_REC
109: , x_return_status OUT NOCOPY varchar2
110:

Line 107: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type :=

103: );
104:
105: PROCEDURE perform_cancel_order
106: ( p_header_rec IN OE_Order_PUB.header_Rec_Type
107: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type :=
108: OE_Order_PUB.G_MISS_header_REC
109: , x_return_status OUT NOCOPY varchar2
110:
111: );

Line 108: OE_Order_PUB.G_MISS_header_REC

104:
105: PROCEDURE perform_cancel_order
106: ( p_header_rec IN OE_Order_PUB.header_Rec_Type
107: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type :=
108: OE_Order_PUB.G_MISS_header_REC
109: , x_return_status OUT NOCOPY varchar2
110:
111: );
112:

Line 114: ( p_Header_Rec IN OE_Order_PUB.Header_Rec_Type

110:
111: );
112:
113: PROCEDURE Cancel_Remaining_Order
114: ( p_Header_Rec IN OE_Order_PUB.Header_Rec_Type
115: := OE_Order_PUB.G_MISS_header_REC,
116: p_header_id IN NUMBER := FND_API.G_MISS_NUM
117: , x_return_status OUT NOCOPY varchar2
118:

Line 115: := OE_Order_PUB.G_MISS_header_REC,

111: );
112:
113: PROCEDURE Cancel_Remaining_Order
114: ( p_Header_Rec IN OE_Order_PUB.Header_Rec_Type
115: := OE_Order_PUB.G_MISS_header_REC,
116: p_header_id IN NUMBER := FND_API.G_MISS_NUM
117: , x_return_status OUT NOCOPY varchar2
118:
119: );

Line 127: ) RETURN OE_Order_PUB.Line_Tbl_Type;

123: ( p_line_id IN NUMBER :=
124: FND_API.G_MISS_NUM
125: , p_header_id IN NUMBER :=
126: FND_API.G_MISS_NUM
127: ) RETURN OE_Order_PUB.Line_Tbl_Type;
128:
129: PROCEDURE Cancel_Wf
130: (
131: x_return_status OUT NOCOPY varchar2

Line 132: , x_request_rec IN OUT NOCOPY OE_Order_PUB.Request_Rec_Type

128:
129: PROCEDURE Cancel_Wf
130: (
131: x_return_status OUT NOCOPY varchar2
132: , x_request_rec IN OUT NOCOPY OE_Order_PUB.Request_Rec_Type
133: );
134:
135: END OE_SALES_CAN_UTIL;