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_RELATED_LINES_PVT dependencies on OZF_RELATED_DEAL_LINES

Line 62: SELECT OZF_RELATED_DEAL_LINES_s.NEXTVAL

58:
59: l_related_lines_Rec related_lines_rec_type := p_related_lines_rec;
60:
61: CURSOR c_id IS
62: SELECT OZF_RELATED_DEAL_LINES_s.NEXTVAL
63: FROM dual;
64:
65: CURSOR c_id_exists (l_id IN NUMBER) IS
66: SELECT 1

Line 67: FROM OZF_RELATED_DEAL_LINES

63: FROM dual;
64:
65: CURSOR c_id_exists (l_id IN NUMBER) IS
66: SELECT 1
67: FROM OZF_RELATED_DEAL_LINES
68: WHERE RELATED_DEAL_LINES_ID = l_id;
69:
70: BEGIN
71: -- Standard Start of API savepoint

Line 150: -- Invoke table handler(OZF_RELATED_DEAL_LINES_PKG.Insert_Row)

146:
147: -- Debug Message
148: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
149:
150: -- Invoke table handler(OZF_RELATED_DEAL_LINES_PKG.Insert_Row)
151: OZF_RELATED_DEAL_LINES_PKG.Insert_Row(
152: px_related_deal_lines_id => l_related_deal_lines_id,
153: p_modifier_id => p_related_lines_rec.modifier_id,
154: p_related_modifier_id => p_related_lines_rec.related_modifier_id,

Line 151: OZF_RELATED_DEAL_LINES_PKG.Insert_Row(

147: -- Debug Message
148: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
149:
150: -- Invoke table handler(OZF_RELATED_DEAL_LINES_PKG.Insert_Row)
151: OZF_RELATED_DEAL_LINES_PKG.Insert_Row(
152: px_related_deal_lines_id => l_related_deal_lines_id,
153: p_modifier_id => p_related_lines_rec.modifier_id,
154: p_related_modifier_id => p_related_lines_rec.related_modifier_id,
155: p_last_update_date => SYSDATE,

Line 247: FROM OZF_RELATED_DEAL_LINES

243: IS
244: --/*
245: CURSOR c_get_related_lines(p_related_deal_lines_id NUMBER) IS
246: SELECT *
247: FROM OZF_RELATED_DEAL_LINES
248: WHERE related_deal_lines_id = p_related_deal_lines_id;
249:
250:
251: -- Hint: Developer need to provide Where clause

Line 352: -- Invoke table handler(OZF_RELATED_DEAL_LINES_PKG.Update_Row)

348:
349: -- Debug Message
350: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
351:
352: -- Invoke table handler(OZF_RELATED_DEAL_LINES_PKG.Update_Row)
353: OZF_UTILITY_PVT.debug_message('callin update row');
354: OZF_RELATED_DEAL_LINES_PKG.Update_Row(
355: p_related_deal_lines_id => p_related_lines_rec.related_deal_lines_id,
356: p_modifier_id => p_related_lines_rec.modifier_id,

Line 354: OZF_RELATED_DEAL_LINES_PKG.Update_Row(

350: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
351:
352: -- Invoke table handler(OZF_RELATED_DEAL_LINES_PKG.Update_Row)
353: OZF_UTILITY_PVT.debug_message('callin update row');
354: OZF_RELATED_DEAL_LINES_PKG.Update_Row(
355: p_related_deal_lines_id => p_related_lines_rec.related_deal_lines_id,
356: p_modifier_id => p_related_lines_rec.modifier_id,
357: p_related_modifier_id => p_related_lines_rec.related_modifier_id,
358: p_last_update_date => SYSDATE,

Line 479: -- Invoke table handler(OZF_RELATED_DEAL_LINES_PKG.Delete_Row)

475: --
476: -- Debug Message
477: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
478:
479: -- Invoke table handler(OZF_RELATED_DEAL_LINES_PKG.Delete_Row)
480: OZF_RELATED_DEAL_LINES_PKG.Delete_Row(
481: p_RELATED_DEAL_LINES_ID => p_RELATED_DEAL_LINES_ID);
482: --
483: -- End of API body

Line 480: OZF_RELATED_DEAL_LINES_PKG.Delete_Row(

476: -- Debug Message
477: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
478:
479: -- Invoke table handler(OZF_RELATED_DEAL_LINES_PKG.Delete_Row)
480: OZF_RELATED_DEAL_LINES_PKG.Delete_Row(
481: p_RELATED_DEAL_LINES_ID => p_RELATED_DEAL_LINES_ID);
482: --
483: -- End of API body
484: --

Line 565: FROM OZF_RELATED_DEAL_LINES

561: l_RELATED_DEAL_LINES_ID NUMBER;
562:
563: CURSOR c_Related_Lines IS
564: SELECT RELATED_DEAL_LINES_ID
565: FROM OZF_RELATED_DEAL_LINES
566: WHERE RELATED_DEAL_LINES_ID = p_RELATED_DEAL_LINES_ID
567: AND object_version_number = p_object_version
568: FOR UPDATE NOWAIT;
569:

Line 672: 'OZF_RELATED_DEAL_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_RELATED_DEAL_LINES',
673: 'RELATED_DEAL_LINES_ID = ''' || p_related_lines_rec.RELATED_DEAL_LINES_ID ||''''
674: );
675: ELSE
676: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

Line 677: 'OZF_RELATED_DEAL_LINES',

673: 'RELATED_DEAL_LINES_ID = ''' || p_related_lines_rec.RELATED_DEAL_LINES_ID ||''''
674: );
675: ELSE
676: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
677: 'OZF_RELATED_DEAL_LINES',
678: 'RELATED_DEAL_LINES_ID = ''' || p_related_lines_rec.RELATED_DEAL_LINES_ID ||
679: ''' AND RELATED_DEAL_LINES_ID <> ' || p_related_lines_rec.RELATED_DEAL_LINES_ID
680: );
681: END IF;

Line 944: FROM OZF_related_deal_lines

940: l_return_status VARCHAR2(1);
941:
942: CURSOR c_complete IS
943: SELECT *
944: FROM OZF_related_deal_lines
945: WHERE related_deal_lines_id = p_related_lines_rec.related_deal_lines_id;
946: l_related_lines_rec c_complete%ROWTYPE;
947: BEGIN
948: x_complete_rec := p_related_lines_rec;