eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_ADJ_NEW_LINE_PVT dependencies on OZF_OFFER_ADJ_NEW_LINES

Line 46: SELECT OZF_OFFER_ADJ_NEW_LINES_s.NEXTVAL

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

Line 51: FROM OZF_OFFER_ADJ_NEW_LINES

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

Line 131: -- Invoke table handler(OZF_OFFER_ADJ_NEW_LINES_PKG.Insert_Row)

127:
128: -- Debug Message
129: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
130:
131: -- Invoke table handler(OZF_OFFER_ADJ_NEW_LINES_PKG.Insert_Row)
132:
133: OZF_OFFER_ADJ_NEW_LINES_PKG.Insert_Row(
134: px_offer_adj_new_line_id => l_offer_adj_new_line_id,
135: p_offer_adjustment_id => p_adj_new_line_rec.offer_adjustment_id,

Line 133: OZF_OFFER_ADJ_NEW_LINES_PKG.Insert_Row(

129: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
130:
131: -- Invoke table handler(OZF_OFFER_ADJ_NEW_LINES_PKG.Insert_Row)
132:
133: OZF_OFFER_ADJ_NEW_LINES_PKG.Insert_Row(
134: px_offer_adj_new_line_id => l_offer_adj_new_line_id,
135: p_offer_adjustment_id => p_adj_new_line_rec.offer_adjustment_id,
136: p_volume_from => p_adj_new_line_rec.volume_from,
137: p_volume_to => p_adj_new_line_rec.volume_to,

Line 233: FROM OZF_OFFER_ADJ_NEW_LINES

229: IS
230:
231: CURSOR c_get_adj_new_line(cp_offerAdjNewLineId NUMBER, cp_objectVersionNumber NUMBER) IS
232: SELECT *
233: FROM OZF_OFFER_ADJ_NEW_LINES
234: WHERE offer_adj_new_line_id = cp_offerAdjNewLineId
235: AND object_version_number = cp_objectVersionNumber;
236: -- Hint: Developer need to provide Where clause
237:

Line 320: -- Invoke table handler(OZF_OFFER_ADJ_NEW_LINES_PKG.Update_Row)

316: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
317: RAISE FND_API.G_EXC_ERROR;
318: END IF;
319: ozf_utility_pvt.debug_message('After validate: return:'||x_return_status);
320: -- Invoke table handler(OZF_OFFER_ADJ_NEW_LINES_PKG.Update_Row)
321: OZF_OFFER_ADJ_NEW_LINES_PKG.Update_Row(
322: p_offer_adj_new_line_id => p_adj_new_line_rec.offer_adj_new_line_id,
323: p_offer_adjustment_id => p_adj_new_line_rec.offer_adjustment_id,
324: p_volume_from => p_adj_new_line_rec.volume_from,

Line 321: OZF_OFFER_ADJ_NEW_LINES_PKG.Update_Row(

317: RAISE FND_API.G_EXC_ERROR;
318: END IF;
319: ozf_utility_pvt.debug_message('After validate: return:'||x_return_status);
320: -- Invoke table handler(OZF_OFFER_ADJ_NEW_LINES_PKG.Update_Row)
321: OZF_OFFER_ADJ_NEW_LINES_PKG.Update_Row(
322: p_offer_adj_new_line_id => p_adj_new_line_rec.offer_adj_new_line_id,
323: p_offer_adjustment_id => p_adj_new_line_rec.offer_adjustment_id,
324: p_volume_from => p_adj_new_line_rec.volume_from,
325: p_volume_to => p_adj_new_line_rec.volume_to,

Line 417: FROM ozf_offer_adj_new_lines

413: WHERE offer_adj_new_line_id = cp_offerAdjNewLineId;
414:
415: CURSOR c_tiers(cp_offerAdjNewLineId NUMBER) IS
416: SELECT offer_adj_new_line_id
417: FROM ozf_offer_adj_new_lines
418: WHERE parent_adj_line_id = cp_offerAdjNewLineId;
419:
420: BEGIN
421: -- Standard Start of API savepoint

Line 473: OZF_OFFER_ADJ_NEW_LINES_PKG.Delete_Row(

469:
470: for l_tiers in c_tiers(p_OFFER_ADJ_NEW_LINE_ID) LOOP
471: ozf_utility_pvt.debug_message('Line id is :'||l_tiers.offer_adj_new_line_id);
472: IF l_tiers.offer_adj_new_line_id IS NOT NULL THEN
473: OZF_OFFER_ADJ_NEW_LINES_PKG.Delete_Row(
474: p_OFFER_ADJ_NEW_LINE_ID => l_tiers.offer_adj_new_line_id);
475: END IF;
476: END LOOP;
477: ozf_utility_pvt.debug_message('Line id is :'||p_OFFER_ADJ_NEW_LINE_ID);

Line 478: -- Invoke table handler(OZF_OFFER_ADJ_NEW_LINES_PKG.Delete_Row)

474: p_OFFER_ADJ_NEW_LINE_ID => l_tiers.offer_adj_new_line_id);
475: END IF;
476: END LOOP;
477: ozf_utility_pvt.debug_message('Line id is :'||p_OFFER_ADJ_NEW_LINE_ID);
478: -- Invoke table handler(OZF_OFFER_ADJ_NEW_LINES_PKG.Delete_Row)
479: OZF_OFFER_ADJ_NEW_LINES_PKG.Delete_Row(
480: p_OFFER_ADJ_NEW_LINE_ID => p_OFFER_ADJ_NEW_LINE_ID);
481: --
482: -- End of API body

Line 479: OZF_OFFER_ADJ_NEW_LINES_PKG.Delete_Row(

475: END IF;
476: END LOOP;
477: ozf_utility_pvt.debug_message('Line id is :'||p_OFFER_ADJ_NEW_LINE_ID);
478: -- Invoke table handler(OZF_OFFER_ADJ_NEW_LINES_PKG.Delete_Row)
479: OZF_OFFER_ADJ_NEW_LINES_PKG.Delete_Row(
480: p_OFFER_ADJ_NEW_LINE_ID => p_OFFER_ADJ_NEW_LINE_ID);
481: --
482: -- End of API body
483: --

Line 565: FROM OZF_OFFER_ADJ_NEW_LINES

561: l_OFFER_ADJ_NEW_LINE_ID NUMBER;
562:
563: CURSOR c_Adj_New_Line IS
564: SELECT OFFER_ADJ_NEW_LINE_ID
565: FROM OZF_OFFER_ADJ_NEW_LINES
566: WHERE OFFER_ADJ_NEW_LINE_ID = p_OFFER_ADJ_NEW_LINE_ID
567: AND object_version_number = p_object_version
568: FOR UPDATE NOWAIT;
569:

Line 672: 'OZF_OFFER_ADJ_NEW_LINES',

668: BEGIN
669: x_return_status := FND_API.g_ret_sts_success;
670: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
671: l_valid_flag := OZF_UTILITY_PVT.check_uniqueness(
672: 'OZF_OFFER_ADJ_NEW_LINES',
673: 'OFFER_ADJ_NEW_LINE_ID = ''' || p_adj_new_line_rec.OFFER_ADJ_NEW_LINE_ID ||''''
674: );
675: ELSE
676: l_valid_flag := OZF_UTILITY_PVT.check_uniqueness(

Line 677: 'OZF_OFFER_ADJ_NEW_LINES',

673: 'OFFER_ADJ_NEW_LINE_ID = ''' || p_adj_new_line_rec.OFFER_ADJ_NEW_LINE_ID ||''''
674: );
675: ELSE
676: l_valid_flag := OZF_UTILITY_PVT.check_uniqueness(
677: 'OZF_OFFER_ADJ_NEW_LINES',
678: 'OFFER_ADJ_NEW_LINE_ID = ''' || p_adj_new_line_rec.OFFER_ADJ_NEW_LINE_ID ||
679: ''' AND OFFER_ADJ_NEW_LINE_ID <> ' || p_adj_new_line_rec.OFFER_ADJ_NEW_LINE_ID
680: );
681: END IF;

Line 881: IF ozf_utility_pvt.check_fk_exists('ozf_offer_adj_new_lines','tier_type = ''PBH'' AND offer_adj_new_line_id ', to_char(p_adj_new_line_rec.parent_adj_line_id)) = FND_API.g_false THEN

877: END IF;
878: END IF;
879:
880: IF p_adj_new_line_rec.parent_adj_line_id IS NOT NULL AND p_adj_new_line_rec.parent_adj_line_id <> FND_API.G_MISS_NUM THEN
881: IF ozf_utility_pvt.check_fk_exists('ozf_offer_adj_new_lines','tier_type = ''PBH'' AND offer_adj_new_line_id ', to_char(p_adj_new_line_rec.parent_adj_line_id)) = FND_API.g_false THEN
882: OZF_Utility_PVT.Error_Message('OZF_INV_PARENT_ID' );
883: x_return_status := FND_API.g_ret_sts_error;
884: return;
885: END IF;

Line 1069: FROM ozf_offer_adj_new_lines

1065: l_return_status VARCHAR2(1);
1066:
1067: CURSOR c_complete IS
1068: SELECT *
1069: FROM ozf_offer_adj_new_lines
1070: WHERE offer_adj_new_line_id = p_adj_new_line_rec.offer_adj_new_line_id;
1071: l_adj_new_line_rec c_complete%ROWTYPE;
1072: BEGIN
1073: x_complete_rec := p_adj_new_line_rec;