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: G_CANCELLATION_ACTION VARCHAR2(2) := 'N'; -- 12695580
25:

Line 61: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

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

Line 62: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

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

Line 63: OE_Order_PUB.G_MISS_LINE_REC

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

Line 69: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

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

Line 70: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type:=

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

Line 71: OE_Order_PUB.G_MISS_header_REC

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

Line 77: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

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

Line 78: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

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

Line 79: OE_Order_PUB.G_MISS_LINE_REC

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

Line 86: p_line_rec IN OE_Order_PUB.Line_Rec_Type

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

Line 87: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

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

Line 88: OE_Order_PUB.G_MISS_LINE_REC

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

Line 92: p_line_rec IN OE_Order_PUB.Line_Rec_Type

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

Line 93: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

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

Line 94: OE_Order_PUB.G_MISS_LINE_REC

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

Line 99: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

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

Line 100: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

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

Line 101: OE_Order_PUB.G_MISS_LINE_REC

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

Line 107: ( p_header_rec IN OE_Order_PUB.header_Rec_Type

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

Line 108: , p_old_header_rec IN OE_Order_PUB.header_Rec_Type :=

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

Line 109: OE_Order_PUB.G_MISS_header_REC

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

Line 115: ( p_Header_Rec IN OE_Order_PUB.Header_Rec_Type

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

Line 116: := OE_Order_PUB.G_MISS_header_REC,

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

Line 128: ) RETURN OE_Order_PUB.Line_Tbl_Type;

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

Line 133: , x_request_rec IN OUT NOCOPY OE_Order_PUB.Request_Rec_Type

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