APPS.OZF_OFFER_BACKDATE_PVT dependencies on OZF_OFFER_ADJUSTMENTS_B_S

Line 63: SELECT ozf_OFFER_ADJUSTMENTS_B_s.NEXTVAL

59: l_OFFER_ADJUSTMENT_ID NUMBER;
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

Line 1153: SELECT ozf_OFFER_ADJUSTMENTS_B_s.NEXTVAL

1149: l_operand NUMBER;
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

Line 2489: l_newStatus OZF_OFFER_ADJUSTMENTS_B.STATUS_CODE%TYPE;

2485: ,x_budgetAdjFlag OUT NOCOPY VARCHAR2
2486: )
2487: IS
2488:
2489: l_newStatus OZF_OFFER_ADJUSTMENTS_B.STATUS_CODE%TYPE;
2490: CURSOR c_closeAdjustment(cp_offerAdjustmentId NUMBER) IS
2491: SELECT decode(greatest(a.effective_date,sysdate) , a.effective_date, 'Y','N') close_adjustment
2492: FROM ozf_offer_adjustments_b a
2493: WHERE offer_adjustment_id = cp_offerAdjustmentId;

Line 2530: l_newStatus OZF_OFFER_ADJUSTMENTS_B.STATUS_CODE%TYPE;

2526: ,x_msg_count OUT NOCOPY NUMBER
2527: ,x_msg_data OUT NOCOPY VARCHAR2
2528: )
2529: IS
2530: l_newStatus OZF_OFFER_ADJUSTMENTS_B.STATUS_CODE%TYPE;
2531:
2532: CURSOR c_closeAdjustment(cp_offerAdjustmentId NUMBER) IS
2533: SELECT decode(greatest(a.effective_date,sysdate) , a.effective_date, 'Y','N') close_adjustment,
2534: list_header_id offer_id