APPS.OZF_OFFER_BACK_CREATE_PVT dependencies on OZF_OFFER_ADJUSTMENT_LINES

Line 45: SELECT OZF_OFFER_ADJUSTMENT_LINES_s.NEXTVAL

41: l_OFFER_ADJUSTMENT_LINE_ID NUMBER;
42: l_dummy NUMBER;
43:
44: CURSOR c_id IS
45: SELECT OZF_OFFER_ADJUSTMENT_LINES_s.NEXTVAL
46: FROM dual;
47:
48: CURSOR c_id_exists (l_id IN NUMBER) IS
49: SELECT 1

Line 50: FROM OZF_OFFER_ADJUSTMENT_LINES

46: FROM dual;
47:
48: CURSOR c_id_exists (l_id IN NUMBER) IS
49: SELECT 1
50: FROM OZF_OFFER_ADJUSTMENT_LINES
51: WHERE OFFER_ADJUSTMENT_LINE_ID = l_id;
52:
53: BEGIN
54: -- Standard Start of API savepoint

Line 132: -- Invoke table handler(OZF_OFFER_ADJUSTMENT_LINES_PKG.Insert_Row)

128:
129: -- Debug Message
130: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
131:
132: -- Invoke table handler(OZF_OFFER_ADJUSTMENT_LINES_PKG.Insert_Row)
133: OZF_OFFER_ADJUSTMENT_LINES_PKG.Insert_Row(
134: px_offer_adjustment_line_id => l_offer_adjustment_line_id,
135: p_offer_adjustment_id => p_offer_back_create_rec.offer_adjustment_id,
136: p_list_line_id => p_offer_back_create_rec.list_line_id,

Line 133: OZF_OFFER_ADJUSTMENT_LINES_PKG.Insert_Row(

129: -- Debug Message
130: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
131:
132: -- Invoke table handler(OZF_OFFER_ADJUSTMENT_LINES_PKG.Insert_Row)
133: OZF_OFFER_ADJUSTMENT_LINES_PKG.Insert_Row(
134: px_offer_adjustment_line_id => l_offer_adjustment_line_id,
135: p_offer_adjustment_id => p_offer_back_create_rec.offer_adjustment_id,
136: p_list_line_id => p_offer_back_create_rec.list_line_id,
137: p_arithmetic_operator => p_offer_back_create_rec.arithmetic_operator,

Line 231: FROM OZF_OFFER_ADJUSTMENT_LINES

227: IS
228:
229: CURSOR c_get_offer_back_create(offer_adjustment_line_id NUMBER) IS
230: SELECT *
231: FROM OZF_OFFER_ADJUSTMENT_LINES
232: WHERE offer_adjustment_line_id = p_offer_back_create_rec.offer_adjustment_line_id;
233: -- Hint: Developer need to provide Where clause
234:
235: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Offer_Back';

Line 334: -- Invoke table handler(OZF_OFFER_ADJUSTMENT_LINES_PKG.Update_Row)

330: OZF_UTILITY_PVT.debug_message('p_list_line_id: '|| p_offer_back_create_rec.list_line_id);
331: OZF_UTILITY_PVT.debug_message('p_arithmetic_operator '|| p_offer_back_create_rec.arithmetic_operator);
332: OZF_UTILITY_PVT.debug_message('p_original_discount '|| p_offer_back_create_rec.original_discount);
333: OZF_UTILITY_PVT.debug_message('p_modified_discount '|| p_offer_back_create_rec.modified_discount);
334: -- Invoke table handler(OZF_OFFER_ADJUSTMENT_LINES_PKG.Update_Row)
335:
336: OZF_OFFER_ADJUSTMENT_LINES_PKG.Update_Row(
337: p_offer_adjustment_line_id => p_offer_back_create_rec.offer_adjustment_line_id,
338: p_offer_adjustment_id => p_offer_back_create_rec.offer_adjustment_id,

Line 336: OZF_OFFER_ADJUSTMENT_LINES_PKG.Update_Row(

332: OZF_UTILITY_PVT.debug_message('p_original_discount '|| p_offer_back_create_rec.original_discount);
333: OZF_UTILITY_PVT.debug_message('p_modified_discount '|| p_offer_back_create_rec.modified_discount);
334: -- Invoke table handler(OZF_OFFER_ADJUSTMENT_LINES_PKG.Update_Row)
335:
336: OZF_OFFER_ADJUSTMENT_LINES_PKG.Update_Row(
337: p_offer_adjustment_line_id => p_offer_back_create_rec.offer_adjustment_line_id,
338: p_offer_adjustment_id => p_offer_back_create_rec.offer_adjustment_id,
339: p_list_line_id => p_offer_back_create_rec.list_line_id,
340: p_arithmetic_operator => p_offer_back_create_rec.arithmetic_operator,

Line 462: -- Invoke table handler(OZF_OFFER_ADJUSTMENT_LINES_PKG.Delete_Row)

458: --
459: -- Debug Message
460: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
461:
462: -- Invoke table handler(OZF_OFFER_ADJUSTMENT_LINES_PKG.Delete_Row)
463: OZF_OFFER_ADJUSTMENT_LINES_PKG.Delete_Row(
464: p_OFFER_ADJUSTMENT_LINE_ID => p_OFFER_ADJUSTMENT_LINE_ID);
465: --
466: -- End of API body

Line 463: OZF_OFFER_ADJUSTMENT_LINES_PKG.Delete_Row(

459: -- Debug Message
460: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
461:
462: -- Invoke table handler(OZF_OFFER_ADJUSTMENT_LINES_PKG.Delete_Row)
463: OZF_OFFER_ADJUSTMENT_LINES_PKG.Delete_Row(
464: p_OFFER_ADJUSTMENT_LINE_ID => p_OFFER_ADJUSTMENT_LINE_ID);
465: --
466: -- End of API body
467: --

Line 548: FROM OZF_OFFER_ADJUSTMENT_LINES

544: l_OFFER_ADJUSTMENT_LINE_ID NUMBER;
545:
546: CURSOR c_Offer_Back_Create IS
547: SELECT OFFER_ADJUSTMENT_LINE_ID
548: FROM OZF_OFFER_ADJUSTMENT_LINES
549: WHERE OFFER_ADJUSTMENT_LINE_ID = p_OFFER_ADJUSTMENT_LINE_ID
550: AND object_version_number = p_object_version
551: FOR UPDATE NOWAIT;
552:

Line 655: 'OZF_OFFER_ADJUSTMENT_LINES',

651: BEGIN
652: x_return_status := FND_API.g_ret_sts_success;
653: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
654: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
655: 'OZF_OFFER_ADJUSTMENT_LINES',
656: 'OFFER_ADJUSTMENT_LINE_ID = ''' || p_offer_back_create_rec.OFFER_ADJUSTMENT_LINE_ID ||''''
657: );
658: ELSE
659: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

Line 660: 'OZF_OFFER_ADJUSTMENT_LINES',

656: 'OFFER_ADJUSTMENT_LINE_ID = ''' || p_offer_back_create_rec.OFFER_ADJUSTMENT_LINE_ID ||''''
657: );
658: ELSE
659: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
660: 'OZF_OFFER_ADJUSTMENT_LINES',
661: 'OFFER_ADJUSTMENT_LINE_ID = ''' || p_offer_back_create_rec.OFFER_ADJUSTMENT_LINE_ID ||
662: ''' AND OFFER_ADJUSTMENT_LINE_ID <> ' || p_offer_back_create_rec.OFFER_ADJUSTMENT_LINE_ID
663: );
664: END IF;

Line 769: FROM ozf_offer_adjustment_lines

765: l_return_status VARCHAR2(1);
766:
767: CURSOR c_complete IS
768: SELECT *
769: FROM ozf_offer_adjustment_lines
770: WHERE offer_adjustment_line_id = p_offer_back_create_rec.offer_adjustment_line_id;
771: l_offer_back_create_rec c_complete%ROWTYPE;
772: BEGIN
773: x_complete_rec := p_offer_back_create_rec;