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_PROD_PVT dependencies on OZF_OFFER_ADJ_NEW_PRODUCTS

Line 46: SELECT OZF_OFFER_ADJ_NEW_PRODUCTS_s.NEXTVAL

42: l_OFFER_ADJ_NEW_PRODUCT_ID NUMBER;
43: l_dummy NUMBER;
44:
45: CURSOR c_id IS
46: SELECT OZF_OFFER_ADJ_NEW_PRODUCTS_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_PRODUCTS

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

Line 131: -- Invoke table handler(OZF_OFFER_ADJ_NEW_PRODUCTS_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_PRODUCTS_PKG.Insert_Row)
132: OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Insert_Row(
133: px_offer_adj_new_product_id => l_offer_adj_new_product_id,
134: p_offer_adj_new_line_id => p_adj_new_prod_rec.offer_adj_new_line_id,
135: p_offer_adjustment_id => p_adj_new_prod_rec.offer_adjustment_id,

Line 132: OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Insert_Row(

128: -- Debug Message
129: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
130:
131: -- Invoke table handler(OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Insert_Row)
132: OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Insert_Row(
133: px_offer_adj_new_product_id => l_offer_adj_new_product_id,
134: p_offer_adj_new_line_id => p_adj_new_prod_rec.offer_adj_new_line_id,
135: p_offer_adjustment_id => p_adj_new_prod_rec.offer_adjustment_id,
136: p_product_context => p_adj_new_prod_rec.product_context,

Line 229: FROM OZF_OFFER_ADJ_NEW_PRODUCTS

225:
226: IS
227: CURSOR c_get_adj_new_prod(cp_offerAdjNewProductId NUMBER, cp_objectVersionNumber NUMBER) IS
228: SELECT *
229: FROM OZF_OFFER_ADJ_NEW_PRODUCTS
230: WHERE offer_adj_new_product_id = cp_offerAdjNewProductId
231: AND object_version_number = cp_objectVersionNumber;
232: -- Hint: Developer need to provide Where clause
233: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Adj_New_Prod';

Line 313: -- Invoke table handler(OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Update_Row)

309: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
310: RAISE FND_API.G_EXC_ERROR;
311: END IF;
312:
313: -- Invoke table handler(OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Update_Row)
314: OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Update_Row(
315: p_offer_adj_new_product_id => p_adj_new_prod_rec.offer_adj_new_product_id,
316: p_offer_adj_new_line_id => p_adj_new_prod_rec.offer_adj_new_line_id,
317: p_offer_adjustment_id => p_adj_new_prod_rec.offer_adjustment_id,

Line 314: OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Update_Row(

310: RAISE FND_API.G_EXC_ERROR;
311: END IF;
312:
313: -- Invoke table handler(OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Update_Row)
314: OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Update_Row(
315: p_offer_adj_new_product_id => p_adj_new_prod_rec.offer_adj_new_product_id,
316: p_offer_adj_new_line_id => p_adj_new_prod_rec.offer_adj_new_line_id,
317: p_offer_adjustment_id => p_adj_new_prod_rec.offer_adjustment_id,
318: p_product_context => p_adj_new_prod_rec.product_context,

Line 431: -- Invoke table handler(OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Delete_Row)

427: -- Api body
428: --
429: -- Debug Message
430: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
431: -- Invoke table handler(OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Delete_Row)
432: OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Delete_Row(
433: p_OFFER_ADJ_NEW_PRODUCT_ID => p_OFFER_ADJ_NEW_PRODUCT_ID);
434: --
435: -- End of API body

Line 432: OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Delete_Row(

428: --
429: -- Debug Message
430: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
431: -- Invoke table handler(OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Delete_Row)
432: OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Delete_Row(
433: p_OFFER_ADJ_NEW_PRODUCT_ID => p_OFFER_ADJ_NEW_PRODUCT_ID);
434: --
435: -- End of API body
436: --

Line 510: FROM OZF_OFFER_ADJ_NEW_PRODUCTS

506: l_OFFER_ADJ_NEW_PRODUCT_ID NUMBER;
507:
508: CURSOR c_Adj_New_Prod IS
509: SELECT OFFER_ADJ_NEW_PRODUCT_ID
510: FROM OZF_OFFER_ADJ_NEW_PRODUCTS
511: WHERE OFFER_ADJ_NEW_PRODUCT_ID = p_OFFER_ADJ_NEW_PRODUCT_ID
512: AND object_version_number = p_object_version
513: FOR UPDATE NOWAIT;
514:

Line 614: 'OZF_OFFER_ADJ_NEW_PRODUCTS',

610: BEGIN
611: x_return_status := FND_API.g_ret_sts_success;
612: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
613: l_valid_flag := OZF_UTILITY_PVT.check_uniqueness(
614: 'OZF_OFFER_ADJ_NEW_PRODUCTS',
615: 'OFFER_ADJ_NEW_PRODUCT_ID = ''' || p_adj_new_prod_rec.OFFER_ADJ_NEW_PRODUCT_ID ||''''
616: );
617: ELSE
618: l_valid_flag := OZF_UTILITY_PVT.check_uniqueness(

Line 619: 'OZF_OFFER_ADJ_NEW_PRODUCTS',

615: 'OFFER_ADJ_NEW_PRODUCT_ID = ''' || p_adj_new_prod_rec.OFFER_ADJ_NEW_PRODUCT_ID ||''''
616: );
617: ELSE
618: l_valid_flag := OZF_UTILITY_PVT.check_uniqueness(
619: 'OZF_OFFER_ADJ_NEW_PRODUCTS',
620: 'OFFER_ADJ_NEW_PRODUCT_ID = ''' || p_adj_new_prod_rec.OFFER_ADJ_NEW_PRODUCT_ID ||
621: ''' AND OFFER_ADJ_NEW_PRODUCT_ID <> ' || p_adj_new_prod_rec.OFFER_ADJ_NEW_PRODUCT_ID
622: );
623: END IF;

Line 1026: FROM ozf_offer_adj_new_products

1022: l_return_status VARCHAR2(1);
1023:
1024: CURSOR c_complete IS
1025: SELECT *
1026: FROM ozf_offer_adj_new_products
1027: WHERE offer_adj_new_product_id = p_adj_new_prod_rec.offer_adj_new_product_id;
1028: l_adj_new_prod_rec c_complete%ROWTYPE;
1029: BEGIN
1030: x_complete_rec := p_adj_new_prod_rec;