eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_PH_LINE_BREAKS_V

Line 2203: FUNCTION get_okc_ph_line_breaks_v_rec(p_okc_ph_line_breaks_v_id IN NUMBER,

2199: ----------------------------------------------------------------------------
2200: --Function to populate the price hold line breaks record to be copied.
2201:
2202: ----------------------------------------------------------------------------
2203: FUNCTION get_okc_ph_line_breaks_v_rec(p_okc_ph_line_breaks_v_id IN NUMBER,
2204: x_okc_ph_line_breaks_v_rec OUT NOCOPY OKC_PH_LINE_BREAKS_PUB.okc_ph_line_breaks_v_rec_type)
2205: RETURN VARCHAR2 IS
2206:
2207: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2204: x_okc_ph_line_breaks_v_rec OUT NOCOPY OKC_PH_LINE_BREAKS_PUB.okc_ph_line_breaks_v_rec_type)

2200: --Function to populate the price hold line breaks record to be copied.
2201:
2202: ----------------------------------------------------------------------------
2203: FUNCTION get_okc_ph_line_breaks_v_rec(p_okc_ph_line_breaks_v_id IN NUMBER,
2204: x_okc_ph_line_breaks_v_rec OUT NOCOPY OKC_PH_LINE_BREAKS_PUB.okc_ph_line_breaks_v_rec_type)
2205: RETURN VARCHAR2 IS
2206:
2207: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2208: l_no_data_found BOOLEAN := TRUE;

Line 2210: CURSOR c_okc_ph_line_breaks_v_rec IS

2206:
2207: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2208: l_no_data_found BOOLEAN := TRUE;
2209:
2210: CURSOR c_okc_ph_line_breaks_v_rec IS
2211: SELECT
2212: --ID
2213: CLE_ID,
2214: VALUE_FROM,

Line 2230: FROM OKC_PH_LINE_BREAKS_V

2226: CREATION_DATE,
2227: LAST_UPDATED_BY,
2228: LAST_UPDATE_DATE
2229:
2230: FROM OKC_PH_LINE_BREAKS_V
2231: WHERE ID = p_okc_ph_line_breaks_v_id;
2232: BEGIN
2233: OPEN c_okc_ph_line_breaks_v_rec;
2234: FETCH c_okc_ph_line_breaks_v_rec

Line 2231: WHERE ID = p_okc_ph_line_breaks_v_id;

2227: LAST_UPDATED_BY,
2228: LAST_UPDATE_DATE
2229:
2230: FROM OKC_PH_LINE_BREAKS_V
2231: WHERE ID = p_okc_ph_line_breaks_v_id;
2232: BEGIN
2233: OPEN c_okc_ph_line_breaks_v_rec;
2234: FETCH c_okc_ph_line_breaks_v_rec
2235: INTO

Line 2233: OPEN c_okc_ph_line_breaks_v_rec;

2229:
2230: FROM OKC_PH_LINE_BREAKS_V
2231: WHERE ID = p_okc_ph_line_breaks_v_id;
2232: BEGIN
2233: OPEN c_okc_ph_line_breaks_v_rec;
2234: FETCH c_okc_ph_line_breaks_v_rec
2235: INTO
2236: -----x_okc_ph_line_breaks_v_rec.CLE_ID,
2237:

Line 2234: FETCH c_okc_ph_line_breaks_v_rec

2230: FROM OKC_PH_LINE_BREAKS_V
2231: WHERE ID = p_okc_ph_line_breaks_v_id;
2232: BEGIN
2233: OPEN c_okc_ph_line_breaks_v_rec;
2234: FETCH c_okc_ph_line_breaks_v_rec
2235: INTO
2236: -----x_okc_ph_line_breaks_v_rec.CLE_ID,
2237:
2238: x_okc_ph_line_breaks_v_rec.CLE_ID,

Line 2236: -----x_okc_ph_line_breaks_v_rec.CLE_ID,

2232: BEGIN
2233: OPEN c_okc_ph_line_breaks_v_rec;
2234: FETCH c_okc_ph_line_breaks_v_rec
2235: INTO
2236: -----x_okc_ph_line_breaks_v_rec.CLE_ID,
2237:
2238: x_okc_ph_line_breaks_v_rec.CLE_ID,
2239: x_okc_ph_line_breaks_v_rec.VALUE_FROM,
2240: x_okc_ph_line_breaks_v_rec.VALUE_TO,

Line 2238: x_okc_ph_line_breaks_v_rec.CLE_ID,

2234: FETCH c_okc_ph_line_breaks_v_rec
2235: INTO
2236: -----x_okc_ph_line_breaks_v_rec.CLE_ID,
2237:
2238: x_okc_ph_line_breaks_v_rec.CLE_ID,
2239: x_okc_ph_line_breaks_v_rec.VALUE_FROM,
2240: x_okc_ph_line_breaks_v_rec.VALUE_TO,
2241: x_okc_ph_line_breaks_v_rec.PRICING_TYPE,
2242: x_okc_ph_line_breaks_v_rec.VALUE,

Line 2239: x_okc_ph_line_breaks_v_rec.VALUE_FROM,

2235: INTO
2236: -----x_okc_ph_line_breaks_v_rec.CLE_ID,
2237:
2238: x_okc_ph_line_breaks_v_rec.CLE_ID,
2239: x_okc_ph_line_breaks_v_rec.VALUE_FROM,
2240: x_okc_ph_line_breaks_v_rec.VALUE_TO,
2241: x_okc_ph_line_breaks_v_rec.PRICING_TYPE,
2242: x_okc_ph_line_breaks_v_rec.VALUE,
2243: x_okc_ph_line_breaks_v_rec.START_DATE,

Line 2240: x_okc_ph_line_breaks_v_rec.VALUE_TO,

2236: -----x_okc_ph_line_breaks_v_rec.CLE_ID,
2237:
2238: x_okc_ph_line_breaks_v_rec.CLE_ID,
2239: x_okc_ph_line_breaks_v_rec.VALUE_FROM,
2240: x_okc_ph_line_breaks_v_rec.VALUE_TO,
2241: x_okc_ph_line_breaks_v_rec.PRICING_TYPE,
2242: x_okc_ph_line_breaks_v_rec.VALUE,
2243: x_okc_ph_line_breaks_v_rec.START_DATE,
2244: x_okc_ph_line_breaks_v_rec.END_DATE,

Line 2241: x_okc_ph_line_breaks_v_rec.PRICING_TYPE,

2237:
2238: x_okc_ph_line_breaks_v_rec.CLE_ID,
2239: x_okc_ph_line_breaks_v_rec.VALUE_FROM,
2240: x_okc_ph_line_breaks_v_rec.VALUE_TO,
2241: x_okc_ph_line_breaks_v_rec.PRICING_TYPE,
2242: x_okc_ph_line_breaks_v_rec.VALUE,
2243: x_okc_ph_line_breaks_v_rec.START_DATE,
2244: x_okc_ph_line_breaks_v_rec.END_DATE,
2245: x_okc_ph_line_breaks_v_rec.INTEGRATED_WITH_QP,

Line 2242: x_okc_ph_line_breaks_v_rec.VALUE,

2238: x_okc_ph_line_breaks_v_rec.CLE_ID,
2239: x_okc_ph_line_breaks_v_rec.VALUE_FROM,
2240: x_okc_ph_line_breaks_v_rec.VALUE_TO,
2241: x_okc_ph_line_breaks_v_rec.PRICING_TYPE,
2242: x_okc_ph_line_breaks_v_rec.VALUE,
2243: x_okc_ph_line_breaks_v_rec.START_DATE,
2244: x_okc_ph_line_breaks_v_rec.END_DATE,
2245: x_okc_ph_line_breaks_v_rec.INTEGRATED_WITH_QP,
2246: x_okc_ph_line_breaks_v_rec.QP_REFERENCE_ID,

Line 2243: x_okc_ph_line_breaks_v_rec.START_DATE,

2239: x_okc_ph_line_breaks_v_rec.VALUE_FROM,
2240: x_okc_ph_line_breaks_v_rec.VALUE_TO,
2241: x_okc_ph_line_breaks_v_rec.PRICING_TYPE,
2242: x_okc_ph_line_breaks_v_rec.VALUE,
2243: x_okc_ph_line_breaks_v_rec.START_DATE,
2244: x_okc_ph_line_breaks_v_rec.END_DATE,
2245: x_okc_ph_line_breaks_v_rec.INTEGRATED_WITH_QP,
2246: x_okc_ph_line_breaks_v_rec.QP_REFERENCE_ID,
2247: x_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID,

Line 2244: x_okc_ph_line_breaks_v_rec.END_DATE,

2240: x_okc_ph_line_breaks_v_rec.VALUE_TO,
2241: x_okc_ph_line_breaks_v_rec.PRICING_TYPE,
2242: x_okc_ph_line_breaks_v_rec.VALUE,
2243: x_okc_ph_line_breaks_v_rec.START_DATE,
2244: x_okc_ph_line_breaks_v_rec.END_DATE,
2245: x_okc_ph_line_breaks_v_rec.INTEGRATED_WITH_QP,
2246: x_okc_ph_line_breaks_v_rec.QP_REFERENCE_ID,
2247: x_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID,
2248: x_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID,

Line 2245: x_okc_ph_line_breaks_v_rec.INTEGRATED_WITH_QP,

2241: x_okc_ph_line_breaks_v_rec.PRICING_TYPE,
2242: x_okc_ph_line_breaks_v_rec.VALUE,
2243: x_okc_ph_line_breaks_v_rec.START_DATE,
2244: x_okc_ph_line_breaks_v_rec.END_DATE,
2245: x_okc_ph_line_breaks_v_rec.INTEGRATED_WITH_QP,
2246: x_okc_ph_line_breaks_v_rec.QP_REFERENCE_ID,
2247: x_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID,
2248: x_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID,
2249: x_okc_ph_line_breaks_v_rec.OBJECT_VERSION_NUMBER,

Line 2246: x_okc_ph_line_breaks_v_rec.QP_REFERENCE_ID,

2242: x_okc_ph_line_breaks_v_rec.VALUE,
2243: x_okc_ph_line_breaks_v_rec.START_DATE,
2244: x_okc_ph_line_breaks_v_rec.END_DATE,
2245: x_okc_ph_line_breaks_v_rec.INTEGRATED_WITH_QP,
2246: x_okc_ph_line_breaks_v_rec.QP_REFERENCE_ID,
2247: x_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID,
2248: x_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID,
2249: x_okc_ph_line_breaks_v_rec.OBJECT_VERSION_NUMBER,
2250: x_okc_ph_line_breaks_v_rec.CREATED_BY,

Line 2247: x_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID,

2243: x_okc_ph_line_breaks_v_rec.START_DATE,
2244: x_okc_ph_line_breaks_v_rec.END_DATE,
2245: x_okc_ph_line_breaks_v_rec.INTEGRATED_WITH_QP,
2246: x_okc_ph_line_breaks_v_rec.QP_REFERENCE_ID,
2247: x_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID,
2248: x_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID,
2249: x_okc_ph_line_breaks_v_rec.OBJECT_VERSION_NUMBER,
2250: x_okc_ph_line_breaks_v_rec.CREATED_BY,
2251: x_okc_ph_line_breaks_v_rec.CREATION_DATE,

Line 2248: x_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID,

2244: x_okc_ph_line_breaks_v_rec.END_DATE,
2245: x_okc_ph_line_breaks_v_rec.INTEGRATED_WITH_QP,
2246: x_okc_ph_line_breaks_v_rec.QP_REFERENCE_ID,
2247: x_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID,
2248: x_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID,
2249: x_okc_ph_line_breaks_v_rec.OBJECT_VERSION_NUMBER,
2250: x_okc_ph_line_breaks_v_rec.CREATED_BY,
2251: x_okc_ph_line_breaks_v_rec.CREATION_DATE,
2252: x_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY,

Line 2249: x_okc_ph_line_breaks_v_rec.OBJECT_VERSION_NUMBER,

2245: x_okc_ph_line_breaks_v_rec.INTEGRATED_WITH_QP,
2246: x_okc_ph_line_breaks_v_rec.QP_REFERENCE_ID,
2247: x_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID,
2248: x_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID,
2249: x_okc_ph_line_breaks_v_rec.OBJECT_VERSION_NUMBER,
2250: x_okc_ph_line_breaks_v_rec.CREATED_BY,
2251: x_okc_ph_line_breaks_v_rec.CREATION_DATE,
2252: x_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY,
2253: x_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE;

Line 2250: x_okc_ph_line_breaks_v_rec.CREATED_BY,

2246: x_okc_ph_line_breaks_v_rec.QP_REFERENCE_ID,
2247: x_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID,
2248: x_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID,
2249: x_okc_ph_line_breaks_v_rec.OBJECT_VERSION_NUMBER,
2250: x_okc_ph_line_breaks_v_rec.CREATED_BY,
2251: x_okc_ph_line_breaks_v_rec.CREATION_DATE,
2252: x_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY,
2253: x_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE;
2254:

Line 2251: x_okc_ph_line_breaks_v_rec.CREATION_DATE,

2247: x_okc_ph_line_breaks_v_rec.SHIP_TO_ORGANIZATION_ID,
2248: x_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID,
2249: x_okc_ph_line_breaks_v_rec.OBJECT_VERSION_NUMBER,
2250: x_okc_ph_line_breaks_v_rec.CREATED_BY,
2251: x_okc_ph_line_breaks_v_rec.CREATION_DATE,
2252: x_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY,
2253: x_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE;
2254:
2255:

Line 2252: x_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY,

2248: x_okc_ph_line_breaks_v_rec.SHIP_TO_LOCATION_ID,
2249: x_okc_ph_line_breaks_v_rec.OBJECT_VERSION_NUMBER,
2250: x_okc_ph_line_breaks_v_rec.CREATED_BY,
2251: x_okc_ph_line_breaks_v_rec.CREATION_DATE,
2252: x_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY,
2253: x_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE;
2254:
2255:
2256: l_no_data_found := c_okc_ph_line_breaks_v_rec%NOTFOUND;

Line 2253: x_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE;

2249: x_okc_ph_line_breaks_v_rec.OBJECT_VERSION_NUMBER,
2250: x_okc_ph_line_breaks_v_rec.CREATED_BY,
2251: x_okc_ph_line_breaks_v_rec.CREATION_DATE,
2252: x_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY,
2253: x_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE;
2254:
2255:
2256: l_no_data_found := c_okc_ph_line_breaks_v_rec%NOTFOUND;
2257: CLOSE c_okc_ph_line_breaks_v_rec;

Line 2256: l_no_data_found := c_okc_ph_line_breaks_v_rec%NOTFOUND;

2252: x_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY,
2253: x_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE;
2254:
2255:
2256: l_no_data_found := c_okc_ph_line_breaks_v_rec%NOTFOUND;
2257: CLOSE c_okc_ph_line_breaks_v_rec;
2258: IF l_no_data_found THEN
2259: l_return_status := OKC_API.G_RET_STS_ERROR;
2260: return(l_return_status);

Line 2257: CLOSE c_okc_ph_line_breaks_v_rec;

2253: x_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE;
2254:
2255:
2256: l_no_data_found := c_okc_ph_line_breaks_v_rec%NOTFOUND;
2257: CLOSE c_okc_ph_line_breaks_v_rec;
2258: IF l_no_data_found THEN
2259: l_return_status := OKC_API.G_RET_STS_ERROR;
2260: return(l_return_status);
2261: ELSE

Line 2272: END get_okc_ph_line_breaks_v_rec;

2268: -- notify caller of an UNEXPECTED error
2269: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2270: return(l_return_status);
2271:
2272: END get_okc_ph_line_breaks_v_rec;
2273:
2274:
2275:
2276: /********Commented for bug 3033281 *******************************

Line 2287: p_okc_ph_line_breaks_v_rec_id IN NUMBER,

2283: p_init_msg_list IN VARCHAR2 ,
2284: x_return_status OUT NOCOPY VARCHAR2,
2285: x_msg_count OUT NOCOPY NUMBER,
2286: x_msg_data OUT NOCOPY VARCHAR2,
2287: p_okc_ph_line_breaks_v_rec_id IN NUMBER,
2288: p_cle_id IN NUMBER ,
2289: ----p_chr_id IN NUMBER ,
2290: x_okc_ph_line_breaks_v_rec_id OUT NOCOPY NUMBER) IS
2291:

Line 2290: x_okc_ph_line_breaks_v_rec_id OUT NOCOPY NUMBER) IS

2286: x_msg_data OUT NOCOPY VARCHAR2,
2287: p_okc_ph_line_breaks_v_rec_id IN NUMBER,
2288: p_cle_id IN NUMBER ,
2289: ----p_chr_id IN NUMBER ,
2290: x_okc_ph_line_breaks_v_rec_id OUT NOCOPY NUMBER) IS
2291:
2292: l_okc_ph_line_breaks_v_rec OKC_PH_LINE_BREAKS_PUB.okc_ph_line_breaks_v_rec_type;
2293: x_okc_ph_line_breaks_v_rec OKC_PH_LINE_BREAKS_PUB.okc_ph_line_breaks_v_rec_type;
2294:

Line 2292: l_okc_ph_line_breaks_v_rec OKC_PH_LINE_BREAKS_PUB.okc_ph_line_breaks_v_rec_type;

2288: p_cle_id IN NUMBER ,
2289: ----p_chr_id IN NUMBER ,
2290: x_okc_ph_line_breaks_v_rec_id OUT NOCOPY NUMBER) IS
2291:
2292: l_okc_ph_line_breaks_v_rec OKC_PH_LINE_BREAKS_PUB.okc_ph_line_breaks_v_rec_type;
2293: x_okc_ph_line_breaks_v_rec OKC_PH_LINE_BREAKS_PUB.okc_ph_line_breaks_v_rec_type;
2294:
2295:
2296: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2293: x_okc_ph_line_breaks_v_rec OKC_PH_LINE_BREAKS_PUB.okc_ph_line_breaks_v_rec_type;

2289: ----p_chr_id IN NUMBER ,
2290: x_okc_ph_line_breaks_v_rec_id OUT NOCOPY NUMBER) IS
2291:
2292: l_okc_ph_line_breaks_v_rec OKC_PH_LINE_BREAKS_PUB.okc_ph_line_breaks_v_rec_type;
2293: x_okc_ph_line_breaks_v_rec OKC_PH_LINE_BREAKS_PUB.okc_ph_line_breaks_v_rec_type;
2294:
2295:
2296: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2297: l_cle_id NUMBER := OKC_API.G_MISS_NUM;

Line 2302: l_return_status := get_okc_ph_line_breaks_v_rec(p_okc_ph_line_breaks_v_id => p_okc_ph_line_breaks_v_rec_id,

2298:
2299: BEGIN
2300: x_return_status := l_return_status;
2301:
2302: l_return_status := get_okc_ph_line_breaks_v_rec(p_okc_ph_line_breaks_v_id => p_okc_ph_line_breaks_v_rec_id,
2303: x_okc_ph_line_breaks_v_rec => l_okc_ph_line_breaks_v_rec);
2304:
2305: ------l_scrv_rec.chr_id := p_chr_id;
2306: ------l_scrv_rec.dnz_chr_id := p_chr_id;

Line 2303: x_okc_ph_line_breaks_v_rec => l_okc_ph_line_breaks_v_rec);

2299: BEGIN
2300: x_return_status := l_return_status;
2301:
2302: l_return_status := get_okc_ph_line_breaks_v_rec(p_okc_ph_line_breaks_v_id => p_okc_ph_line_breaks_v_rec_id,
2303: x_okc_ph_line_breaks_v_rec => l_okc_ph_line_breaks_v_rec);
2304:
2305: ------l_scrv_rec.chr_id := p_chr_id;
2306: ------l_scrv_rec.dnz_chr_id := p_chr_id;
2307: l_okc_ph_line_breaks_v_rec.cle_id := p_cle_id;

Line 2307: l_okc_ph_line_breaks_v_rec.cle_id := p_cle_id;

2303: x_okc_ph_line_breaks_v_rec => l_okc_ph_line_breaks_v_rec);
2304:
2305: ------l_scrv_rec.chr_id := p_chr_id;
2306: ------l_scrv_rec.dnz_chr_id := p_chr_id;
2307: l_okc_ph_line_breaks_v_rec.cle_id := p_cle_id;
2308: l_okc_ph_line_breaks_v_rec.qp_reference_id := null;
2309: l_okc_ph_line_breaks_v_rec.integrated_with_qp := 'N';
2310:
2311:

Line 2308: l_okc_ph_line_breaks_v_rec.qp_reference_id := null;

2304:
2305: ------l_scrv_rec.chr_id := p_chr_id;
2306: ------l_scrv_rec.dnz_chr_id := p_chr_id;
2307: l_okc_ph_line_breaks_v_rec.cle_id := p_cle_id;
2308: l_okc_ph_line_breaks_v_rec.qp_reference_id := null;
2309: l_okc_ph_line_breaks_v_rec.integrated_with_qp := 'N';
2310:
2311:
2312: OKC_PH_LINE_BREAKS_PUB.create_Price_Hold_Line_Breaks(

Line 2309: l_okc_ph_line_breaks_v_rec.integrated_with_qp := 'N';

2305: ------l_scrv_rec.chr_id := p_chr_id;
2306: ------l_scrv_rec.dnz_chr_id := p_chr_id;
2307: l_okc_ph_line_breaks_v_rec.cle_id := p_cle_id;
2308: l_okc_ph_line_breaks_v_rec.qp_reference_id := null;
2309: l_okc_ph_line_breaks_v_rec.integrated_with_qp := 'N';
2310:
2311:
2312: OKC_PH_LINE_BREAKS_PUB.create_Price_Hold_Line_Breaks(
2313: p_api_version => p_api_version,

Line 2318: p_okc_ph_line_breaks_v_rec => l_okc_ph_line_breaks_v_rec,

2314: p_init_msg_list => p_init_msg_list,
2315: x_return_status => l_return_status,
2316: x_msg_count => x_msg_count,
2317: x_msg_data => x_msg_data,
2318: p_okc_ph_line_breaks_v_rec => l_okc_ph_line_breaks_v_rec,
2319: x_okc_ph_line_breaks_v_rec => x_okc_ph_line_breaks_v_rec);
2320:
2321:
2322:

Line 2319: x_okc_ph_line_breaks_v_rec => x_okc_ph_line_breaks_v_rec);

2315: x_return_status => l_return_status,
2316: x_msg_count => x_msg_count,
2317: x_msg_data => x_msg_data,
2318: p_okc_ph_line_breaks_v_rec => l_okc_ph_line_breaks_v_rec,
2319: x_okc_ph_line_breaks_v_rec => x_okc_ph_line_breaks_v_rec);
2320:
2321:
2322:
2323: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 2332: x_okc_ph_line_breaks_v_rec_id := x_okc_ph_line_breaks_v_rec.id; -- passes the new generated id to the caller.

2328: x_return_status := l_return_status;
2329: END IF;
2330: END IF;
2331:
2332: x_okc_ph_line_breaks_v_rec_id := x_okc_ph_line_breaks_v_rec.id; -- passes the new generated id to the caller.
2333:
2334: EXCEPTION
2335: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2336: NULL;

Line 3615: l_okc_ph_line_breaks_v_id NUMBER;

3611: l_converted_amount number := NULL; /* For Euro Conversion - Bug 2155930 */
3612:
3613: l_scrv_id NUMBER;
3614:
3615: l_okc_ph_line_breaks_v_id NUMBER;
3616:
3617: l_gvev_id NUMBER;
3618: l_category VARCHAR2(200); --added for bug 3764231
3619:

Line 3733: CURSOR c_okc_ph_line_breaks_v IS

3729: ---Removed for Bug#3052910
3730: -- Bug# 3052910--Price hold is obsoleted hence this change is not required*
3731:
3732: -- cursor for price hold line breaks
3733: CURSOR c_okc_ph_line_breaks_v IS
3734: SELECT id
3735: FROM okc_ph_line_breaks_v
3736: WHERE cle_id = p_from_cle_id
3737: AND G_COPY_HISTORY_YN = 'N'

Line 3735: FROM okc_ph_line_breaks_v

3731:
3732: -- cursor for price hold line breaks
3733: CURSOR c_okc_ph_line_breaks_v IS
3734: SELECT id
3735: FROM okc_ph_line_breaks_v
3736: WHERE cle_id = p_from_cle_id
3737: AND G_COPY_HISTORY_YN = 'N'
3738: UNION ALL
3739: SELECT id

Line 4733: FOR l_c_okc_ph_line_breaks_v IN c_okc_ph_line_breaks_v LOOP

4729: IF (l_debug = 'Y') THEN
4730: OKC_DEBUG.log('1600 : ');
4731: END IF;
4732:
4733: FOR l_c_okc_ph_line_breaks_v IN c_okc_ph_line_breaks_v LOOP
4734:
4735: copy_price_hold_line_breaks (
4736: p_api_version => p_api_version,
4737: p_init_msg_list => p_init_msg_list,

Line 4741: p_okc_ph_line_breaks_v_rec_id => l_c_okc_ph_line_breaks_v.id,

4737: p_init_msg_list => p_init_msg_list,
4738: x_return_status => l_return_status,
4739: x_msg_count => x_msg_count,
4740: x_msg_data => x_msg_data,
4741: p_okc_ph_line_breaks_v_rec_id => l_c_okc_ph_line_breaks_v.id,
4742: p_cle_id => x_clev_rec.id,
4743: x_okc_ph_line_breaks_v_rec_id => l_okc_ph_line_breaks_v_id);
4744:
4745: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 4743: x_okc_ph_line_breaks_v_rec_id => l_okc_ph_line_breaks_v_id);

4739: x_msg_count => x_msg_count,
4740: x_msg_data => x_msg_data,
4741: p_okc_ph_line_breaks_v_rec_id => l_c_okc_ph_line_breaks_v.id,
4742: p_cle_id => x_clev_rec.id,
4743: x_okc_ph_line_breaks_v_rec_id => l_okc_ph_line_breaks_v_id);
4744:
4745: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4746: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4747: x_return_status := l_return_status;