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 63: SELECT OZF_RELATED_DEAL_LINES_s.NEXTVAL

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

Line 68: FROM OZF_RELATED_DEAL_LINES

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

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

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

Line 152: OZF_RELATED_DEAL_LINES_PKG.Insert_Row(

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

Line 248: FROM OZF_RELATED_DEAL_LINES

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

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

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

Line 355: OZF_RELATED_DEAL_LINES_PKG.Update_Row(

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

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

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

Line 481: OZF_RELATED_DEAL_LINES_PKG.Delete_Row(

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

Line 566: FROM OZF_RELATED_DEAL_LINES

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

Line 673: 'OZF_RELATED_DEAL_LINES',

669: BEGIN
670: x_return_status := FND_API.g_ret_sts_success;
671: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
672: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
673: 'OZF_RELATED_DEAL_LINES',
674: 'RELATED_DEAL_LINES_ID = ''' || p_related_lines_rec.RELATED_DEAL_LINES_ID ||''''
675: );
676: ELSE
677: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

Line 678: 'OZF_RELATED_DEAL_LINES',

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

Line 945: FROM OZF_related_deal_lines

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