60: l_dummy NUMBER;
61:
62: CURSOR c_id IS
63: SELECT ozf_OFFER_ADJUSTMENTS_B_s.NEXTVAL
64: FROM dual;
65:
66: CURSOR c_id_exists (l_id IN NUMBER) IS
67: SELECT 1
68: FROM ozf_OFFER_ADJUSTMENTS_B
1150: L_API_NAME CONSTANT VARCHAR2(30) := 'CREATE_INITIAL_ADJ';
1151: l_count NUMBER := 0;
1152: CURSOR c_id IS
1153: SELECT ozf_OFFER_ADJUSTMENTS_B_s.NEXTVAL
1154: FROM dual;
1155:
1156: CURSOR c_line_id IS
1157: SELECT ozf_OFFER_ADJUSTMENT_LINES_s.NEXTVAL
1158: FROM dual;
1154: FROM dual;
1155:
1156: CURSOR c_line_id IS
1157: SELECT ozf_OFFER_ADJUSTMENT_LINES_s.NEXTVAL
1158: FROM dual;
1159:
1160: CURSOR c_id_exists (l_id IN NUMBER) IS
1161: SELECT 1
1162: FROM ozf_OFFER_ADJUSTMENTS_B