DBA Data[Home] [Help]

APPS.WSH_OE_CONSTRAINTS dependencies on OE_LINE_SECURITY

Line 88: IF OE_LINE_SECURITY.g_record.ordered_quantity = 0 THEN

84: END IF;
85:
86:
87: -- Full cancellation?
88: IF OE_LINE_SECURITY.g_record.ordered_quantity = 0 THEN
89: -- allow full cancellation
90: x_result_out := lc_allowed;
91: --
92: -- Debug Statements

Line 104: OPEN c_details(OE_LINE_SECURITY.g_record.line_id);

100: END IF;
101:
102:
103:
104: OPEN c_details(OE_LINE_SECURITY.g_record.line_id);
105: FETCH c_details INTO l_details;
106:
107: IF c_details%NOTFOUND THEN
108: -- OK to do the changes if nothing is found

Line 126: OPEN c_reservations(OE_LINE_SECURITY.g_record.line_id);

122: CLOSE c_details;
123:
124:
125:
126: OPEN c_reservations(OE_LINE_SECURITY.g_record.line_id);
127: FETCH c_reservations INTO l_reservations;
128:
129: IF c_reservations%NOTFOUND THEN
130: -- OK to do the changes because there are no reservations

Line 277: OPEN c_details(OE_LINE_SECURITY.g_record.line_id);

273: RETURN;
274: END IF;
275:
276:
277: OPEN c_details(OE_LINE_SECURITY.g_record.line_id);
278: FETCH c_details INTO l_details;
279:
280: IF c_details%NOTFOUND THEN
281: -- OK to do the changes if nothing is found