APPS.OZF_OFFER_ADJ_LINE_PVT dependencies on OZF_OFFER_ADJUSTMENT_LINES

Line 356: SELECT ozf_offer_adjustment_lines_s.NEXTVAL

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

Line 361: FROM ozf_OFFER_ADJUSTMENT_LINES

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

Line 849: FROM ozf_OFFER_ADJUSTMENT_LINES

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

Line 1615: -- 'ozf_offer_adjustment_lines',

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

Line 1621: 'ozf_offer_adjustment_lines',

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

Line 1944: FROM ozf_offer_adjustment_lines

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