APPS.OZF_OFFER_ADJ_LINE_PVT dependencies on OZF_OFFER_ADJUSTMENT_LINES

Line 357: SELECT ozf_offer_adjustment_lines_s.NEXTVAL

353: l_org_id NUMBER := FND_API.G_MISS_NUM;
354: l_offer_adjustment_line_id NUMBER;
355: l_dummy NUMBER;
356: CURSOR c_id IS
357: SELECT ozf_offer_adjustment_lines_s.NEXTVAL
358: FROM dual;
359:
360: CURSOR c_id_exists (l_id IN NUMBER) IS
361: SELECT 1

Line 362: FROM ozf_OFFER_ADJUSTMENT_LINES

358: FROM dual;
359:
360: CURSOR c_id_exists (l_id IN NUMBER) IS
361: SELECT 1
362: FROM ozf_OFFER_ADJUSTMENT_LINES
363: WHERE offer_adjustment_line_id = l_id;
364: BEGIN
365: -- Standard Start of API savepoint
366: SAVEPOINT create_offer_adj_line_pvt;

Line 850: FROM ozf_OFFER_ADJUSTMENT_LINES

846:
847:
848: CURSOR c_get_offer_adj_line(offer_adjustment_line_id NUMBER) IS
849: SELECT *
850: FROM ozf_OFFER_ADJUSTMENT_LINES
851: WHERE offer_adjustment_line_id = p_offadj_line_rec.offer_adjustment_line_id;
852: -- Hint: Developer need to provide Where clause
853:
854:

Line 1616: -- 'ozf_offer_adjustment_lines',

1612: x_return_status := FND_API.g_ret_sts_success;
1613:
1614: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1615: -- l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1616: -- 'ozf_offer_adjustment_lines',
1617: -- 'offer_adjustment_line_id = ''' || p_offadj_line_rec.offer_adjustment_line_id ||''''
1618: -- );
1619: l_valid_flag := FND_API.g_true;
1620: ELSE

Line 1622: 'ozf_offer_adjustment_lines',

1618: -- );
1619: l_valid_flag := FND_API.g_true;
1620: ELSE
1621: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1622: 'ozf_offer_adjustment_lines',
1623: 'offer_adjustment_line_id = ''' || p_offadj_line_rec.offer_adjustment_line_id ||
1624: ''' AND offer_adjustment_line_id <> ' || p_offadj_line_rec.offer_adjustment_line_id
1625: );
1626: END IF;

Line 1945: FROM ozf_offer_adjustment_lines

1941: l_return_status VARCHAR2(1);
1942:
1943: CURSOR c_complete IS
1944: SELECT *
1945: FROM ozf_offer_adjustment_lines
1946: WHERE offer_adjustment_line_id = p_offadj_line_rec.offer_adjustment_line_id and offer_adjustment_id = p_offadj_line_rec.offer_adjustment_id;
1947:
1948: l_offadj_line_rec c_complete%ROWTYPE;
1949: BEGIN