APPS.OZF_OFFER_ADJ_PVT dependencies on DUAL

Line 1195: FROM dual;

1191: WHERE request_line_id = p_request_line_id;
1192:
1193: CURSOR c_reqest_lines_seq IS
1194: SELECT ozf_sd_request_lines_all_s.nextval
1195: FROM dual;
1196:
1197: l_get_sdr_line c_get_sdr_line%ROWTYPE;
1198: l_listLineId c_listLineId%ROWTYPE;
1199: l_req_line_seq NUMBER;

Line 3190: -- loop thru. individual lines and process each line

3186: WHERE tier_type <> 'DIS'
3187: AND offer_adjustment_id = cp_offerAdjustmentId;
3188: BEGIN
3189: -- initialize
3190: -- loop thru. individual lines and process each line
3191: x_return_status := FND_API.G_RET_STS_SUCCESS;
3192: FOR l_adjLines IN c_adjLines(cp_offerAdjustmentId => p_offerAdjustmentId) LOOP
3193: processNewBuyProduct
3194: (

Line 3411: -- loop thru. individual lines and process each line

3407: WHERE tier_type = 'DIS'
3408: AND offer_adjustment_id = cp_offerAdjustmentId;
3409: BEGIN
3410: -- initialize
3411: -- loop thru. individual lines and process each line
3412: x_return_status := FND_API.G_RET_STS_SUCCESS;
3413: FOR l_adjLines IN c_adjLines(cp_offerAdjustmentId => p_offerAdjustmentId) LOOP
3414: processNewGetProduct
3415: (

Line 3613: FROM dual;

3609: p_SDR_hdr_pub_rec IN OZF_SD_REQUEST_PUB.SDR_Hdr_rec_type)
3610: IS
3611: CURSOR c_reqest_lines_seq IS
3612: SELECT ozf_sd_request_lines_all_s.nextval
3613: FROM dual;
3614:
3615: CURSOR c_get_offer_hdr (p_list_header_id IN NUMBER) IS
3616: SELECT custom_setup_id
3617: FROM ozf_offers