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_OFFER_PERFORMANCE_PVT dependencies on OZF_OFFER_PERFORMANCES

Line 45: SELECT OZF_OFFER_PERFORMANCES_S.NEXTVAL

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

Line 50: FROM OZF_OFFER_PERFORMANCES

46: FROM dual;
47:
48: CURSOR c_id_exists (l_id IN NUMBER) IS
49: SELECT 1
50: FROM OZF_OFFER_PERFORMANCES
51: WHERE OFFER_PERFORMANCE_ID = l_id;
52:
53: BEGIN
54: --dbms_output.put_line('First message');

Line 135: -- Invoke table handler(OZF_OFFER_PERFORMANCES_PKG.Insert_Row)

131:
132: -- Debug Message
133: ozf_utility_pvt.debug_message( 'Private API: Calling create table handler');
134:
135: -- Invoke table handler(OZF_OFFER_PERFORMANCES_PKG.Insert_Row)
136: OZF_OFFER_PERFORMANCES_PKG.Insert_Row(
137: px_offer_performance_id => l_offer_performance_id,
138: p_list_header_id => p_offer_perf_rec.list_header_id,
139: p_last_update_date => SYSDATE,

Line 136: OZF_OFFER_PERFORMANCES_PKG.Insert_Row(

132: -- Debug Message
133: ozf_utility_pvt.debug_message( 'Private API: Calling create table handler');
134:
135: -- Invoke table handler(OZF_OFFER_PERFORMANCES_PKG.Insert_Row)
136: OZF_OFFER_PERFORMANCES_PKG.Insert_Row(
137: px_offer_performance_id => l_offer_performance_id,
138: p_list_header_id => p_offer_perf_rec.list_header_id,
139: p_last_update_date => SYSDATE,
140: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 257: FROM OZF_OFFER_PERFORMANCES

253: IS
254:
255: CURSOR c_get_offer_performance(l_offer_performance_id NUMBER) IS
256: SELECT *
257: FROM OZF_OFFER_PERFORMANCES
258: where offer_performance_id = l_offer_performance_id;
259: -- Hint: Developer need to provide Where clause
260:
261: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Offer_Performance';

Line 359: -- Invoke table handler(OZF_OFFER_PERFORMANCES_PKG.Update_Row)

355: ozf_utility_pvt.debug_message('out OUT NOCOPY out of validate');
356: -- Debug Message
357: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW||'Private API: Calling update table handler');
358: l_object_version_number := l_tar_offer_perf_rec.object_version_number + 1;
359: -- Invoke table handler(OZF_OFFER_PERFORMANCES_PKG.Update_Row)
360: OZF_OFFER_PERFORMANCES_PKG.Update_Row(
361: p_offer_performance_id => p_offer_perf_rec.offer_performance_id,
362: p_list_header_id => p_offer_perf_rec.list_header_id,
363: p_last_update_date => SYSDATE,

Line 360: OZF_OFFER_PERFORMANCES_PKG.Update_Row(

356: -- Debug Message
357: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW||'Private API: Calling update table handler');
358: l_object_version_number := l_tar_offer_perf_rec.object_version_number + 1;
359: -- Invoke table handler(OZF_OFFER_PERFORMANCES_PKG.Update_Row)
360: OZF_OFFER_PERFORMANCES_PKG.Update_Row(
361: p_offer_performance_id => p_offer_perf_rec.offer_performance_id,
362: p_list_header_id => p_offer_perf_rec.list_header_id,
363: p_last_update_date => SYSDATE,
364: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 511: -- Invoke table handler(OZF_OFFER_PERFORMANCES_PKG.Delete_Row)

507: --
508: -- Debug Message
509: ozf_utility_pvt.debug_message( 'Private API: Calling delete table handler');
510:
511: -- Invoke table handler(OZF_OFFER_PERFORMANCES_PKG.Delete_Row)
512: OZF_OFFER_PERFORMANCES_PKG.Delete_Row(
513: p_OFFER_PERFORMANCE_ID => p_OFFER_PERFORMANCE_ID);
514: --
515: -- End of API body

Line 512: OZF_OFFER_PERFORMANCES_PKG.Delete_Row(

508: -- Debug Message
509: ozf_utility_pvt.debug_message( 'Private API: Calling delete table handler');
510:
511: -- Invoke table handler(OZF_OFFER_PERFORMANCES_PKG.Delete_Row)
512: OZF_OFFER_PERFORMANCES_PKG.Delete_Row(
513: p_OFFER_PERFORMANCE_ID => p_OFFER_PERFORMANCE_ID);
514: --
515: -- End of API body
516: --

Line 597: FROM OZF_OFFER_PERFORMANCES

593: l_OFFER_PERFORMANCE_ID NUMBER;
594:
595: CURSOR c_Offer_Performance IS
596: SELECT OFFER_PERFORMANCE_ID
597: FROM OZF_OFFER_PERFORMANCES
598: WHERE OFFER_PERFORMANCE_ID = p_OFFER_PERFORMANCE_ID
599: AND object_version_number = p_object_version
600: FOR UPDATE NOWAIT;
601:

Line 713: 'OZF_OFFER_PERFORMANCES',

709:
710:
711: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
712: l_valid_flag := ozf_utility_pvt.check_uniqueness(
713: 'OZF_OFFER_PERFORMANCES',
714: ' PRODUCT_ATTRIBUTE ='||' '||p_offer_perf_rec.PRODUCT_ATTRIBUTE ||''||
715: ' AND PRODUCT_ATTR_VALUE ='||' '|| p_offer_perf_rec.PRODUCT_ATTR_VALUE||''||
716: ' AND CHANNEL_ID = '||' '|| p_offer_perf_rec.CHANNEL_ID||' '||
717: ' AND LIST_HEADER_ID = '||' '|| p_offer_perf_rec.LIST_HEADER_ID

Line 721: -- l_valid_flag := ozf_utility_pvt.check_uniqueness('OZF_OFFER_PERFORMANCES','OFFER_PERFORMANCE_ID = '||' '||p_offer_perf_rec.offer_performance_id||' '||

717: ' AND LIST_HEADER_ID = '||' '|| p_offer_perf_rec.LIST_HEADER_ID
718: );
719:
720: ELSE
721: -- l_valid_flag := ozf_utility_pvt.check_uniqueness('OZF_OFFER_PERFORMANCES','OFFER_PERFORMANCE_ID = '||' '||p_offer_perf_rec.offer_performance_id||' '||
722: -- ' AND REQUIRED_FLAG = '||' '|| p_offer_perf_rec.REQUIRED_FLAG||''||
723: -- ' AND ESTIMATED_VALUE = '||' '|| p_offer_perf_rec.ESTIMATED_VALUE||' '||
724: -- ' AND START_DATE = '||' '|| p_offer_perf_rec.START_DATE||' '||
725: -- ' AND END_DATE = '||' '|| p_offer_perf_rec.END_DATE||' '

Line 854: FROM OZF_offer_performances

850: l_return_status VARCHAR2(1);
851:
852: CURSOR c_complete IS
853: SELECT *
854: FROM OZF_offer_performances
855: WHERE offer_performance_id = p_offer_perf_rec.offer_performance_id;
856: l_offer_perf_rec c_complete%ROWTYPE;
857: BEGIN
858: x_complete_rec := p_offer_perf_rec;