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_PAT_PVT dependencies on OKC_PRICE_ADJUSTMENTS

Line 46: -- FUNCTION get_rec for: OKC_PRICE_ADJUSTMENTS

42:
43: END api_copy;
44:
45: ---------------------------------------------------------------------------
46: -- FUNCTION get_rec for: OKC_PRICE_ADJUSTMENTS
47: ---------------------------------------------------------------------------
48: FUNCTION get_rec (
49: p_pat_rec IN pat_rec_type,
50: x_no_data_found OUT NOCOPY BOOLEAN

Line 121: FROM Okc_Price_Adjustments

117: ATTRIBUTE14,
118: ATTRIBUTE15,
119: LAST_UPDATE_LOGIN,
120: REBATE_TRANSACTION_TYPE_CODE
121: FROM Okc_Price_Adjustments
122: WHERE okc_price_adjustments.id = p_id;
123: l_pat_pk pat_pk_csr%ROWTYPE;
124: l_pat_rec pat_rec_type;
125: BEGIN

Line 122: WHERE okc_price_adjustments.id = p_id;

118: ATTRIBUTE15,
119: LAST_UPDATE_LOGIN,
120: REBATE_TRANSACTION_TYPE_CODE
121: FROM Okc_Price_Adjustments
122: WHERE okc_price_adjustments.id = p_id;
123: l_pat_pk pat_pk_csr%ROWTYPE;
124: l_pat_rec pat_rec_type;
125: BEGIN
126:

Line 225: -- FUNCTION get_rec for: OKC_PRICE_ADJUSTMENTS_V

221: RETURN(get_rec(p_pat_rec, l_row_notfound));
222:
223: END get_rec;
224: ---------------------------------------------------------------------------
225: -- FUNCTION get_rec for: OKC_PRICE_ADJUSTMENTS_V
226: ---------------------------------------------------------------------------
227: FUNCTION get_rec (
228: p_patv_rec IN patv_rec_type,
229: x_no_data_found OUT NOCOPY BOOLEAN

Line 300: FROM Okc_Price_Adjustments_V

296: LAST_UPDATED_BY,
297: LAST_UPDATE_DATE,
298: LAST_UPDATE_LOGIN,
299: REBATE_TRANSACTION_TYPE_CODE
300: FROM Okc_Price_Adjustments_V
301: WHERE okc_price_adjustments_v.id = p_id;
302: l_okc_patv_pk okc_patv_pk_csr%ROWTYPE;
303: l_patv_rec patv_rec_type;
304: BEGIN

Line 301: WHERE okc_price_adjustments_v.id = p_id;

297: LAST_UPDATE_DATE,
298: LAST_UPDATE_LOGIN,
299: REBATE_TRANSACTION_TYPE_CODE
300: FROM Okc_Price_Adjustments_V
301: WHERE okc_price_adjustments_v.id = p_id;
302: l_okc_patv_pk okc_patv_pk_csr%ROWTYPE;
303: l_patv_rec patv_rec_type;
304: BEGIN
305:

Line 405: -- FUNCTION null_out_defaults for: OKC_PRICE_ADJUSTMENTS_V --

401:
402: END get_rec;
403:
404: -------------------------------------------------------------
405: -- FUNCTION null_out_defaults for: OKC_PRICE_ADJUSTMENTS_V --
406: -------------------------------------------------------------
407: FUNCTION null_out_defaults (
408: p_patv_rec IN patv_rec_type
409: ) RETURN patv_rec_type IS

Line 1160: -- Validate_Attributes for:OKC_PRICE_ADJUSTMENTS_V --

1156: ---------------------------------------------------------------------------
1157: -- PROCEDURE Validate_Attributes
1158: ---------------------------------------------------------------------------
1159: -----------------------------------------------------
1160: -- Validate_Attributes for:OKC_PRICE_ADJUSTMENTS_V --
1161: -----------------------------------------------------
1162: FUNCTION Validate_Attributes (
1163: p_patv_rec IN patv_rec_type
1164: ) RETURN VARCHAR2 IS

Line 1312: -- Validate_Record for:OKC_PRICE_ADJUSTMENTS_V --

1308: ---------------------------------------------------------------------------
1309: -- PROCEDURE Validate_Record
1310: ---------------------------------------------------------------------------
1311: -------------------------------------------------
1312: -- Validate_Record for:OKC_PRICE_ADJUSTMENTS_V --
1313: -------------------------------------------------
1314: FUNCTION Validate_Record (
1315: p_patv_rec IN patv_rec_type
1316: ) RETURN VARCHAR2 IS

Line 1328: FROM Okc_Price_Adjustments_V

1324: item_not_found_error EXCEPTION;
1325: CURSOR okc_patv_pk_csr (p_id IN NUMBER) IS
1326: SELECT
1327: 'x'
1328: FROM Okc_Price_Adjustments_V
1329: WHERE okc_price_adjustments_v.id = p_id;
1330: l_okc_patv_pk okc_patv_pk_csr%ROWTYPE;
1331: CURSOR okc_chrv_pk_csr (p_id IN NUMBER) IS
1332: SELECT

Line 1329: WHERE okc_price_adjustments_v.id = p_id;

1325: CURSOR okc_patv_pk_csr (p_id IN NUMBER) IS
1326: SELECT
1327: 'x'
1328: FROM Okc_Price_Adjustments_V
1329: WHERE okc_price_adjustments_v.id = p_id;
1330: l_okc_patv_pk okc_patv_pk_csr%ROWTYPE;
1331: CURSOR okc_chrv_pk_csr (p_id IN NUMBER) IS
1332: SELECT
1333: 'x'

Line 1346: not required during insertion of okc_price_adjustments.

1342: l_okc_clev_pk okc_clev_pk_csr%ROWTYPE;
1343:
1344: /*01-SEP-2005 -mchoudha
1345: Bug#4520703: Commenting these validations as they are
1346: not required during insertion of okc_price_adjustments.
1347: Moreover, these are already validated during initial phase
1348: of Main billing.As per discussion with Umesh.
1349:
1350:

Line 1412: not required during insertion of okc_price_adjustments.

1408: END IF;
1409:
1410: /*01-SEP-2005 -mchoudha
1411: Bug#4520703: Commenting these validations as they are
1412: not required during insertion of okc_price_adjustments.
1413: Moreover, these are already validated during initial phase
1414: of Main billing.As per discussion with Umesh.
1415:
1416: IF (p_patv_rec.BSL_ID IS NOT NULL)

Line 1626: -- validate_row for:OKC_PRICE_ADJUSTMENTS_V --

1622: ---------------------------------------------------------------------------
1623: -- PROCEDURE validate_row
1624: ---------------------------------------------------------------------------
1625: ----------------------------------------------
1626: -- validate_row for:OKC_PRICE_ADJUSTMENTS_V --
1627: ----------------------------------------------
1628: PROCEDURE validate_row(
1629: p_api_version IN NUMBER,
1630: p_init_msg_list IN VARCHAR2 ,

Line 1832: -- insert_row for:OKC_PRICE_ADJUSTMENTS --

1828: ---------------------------------------------------------------------------
1829: -- PROCEDURE insert_row
1830: ---------------------------------------------------------------------------
1831: ------------------------------------------
1832: -- insert_row for:OKC_PRICE_ADJUSTMENTS --
1833: ------------------------------------------
1834: PROCEDURE insert_row(
1835: p_init_msg_list IN VARCHAR2 ,
1836: x_return_status OUT NOCOPY VARCHAR2,

Line 1848: -- Set_Attributes for:OKC_PRICE_ADJUSTMENTS --

1844: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1845: l_pat_rec pat_rec_type := p_pat_rec;
1846: l_def_pat_rec pat_rec_type;
1847: ----------------------------------------------
1848: -- Set_Attributes for:OKC_PRICE_ADJUSTMENTS --
1849: ----------------------------------------------
1850: FUNCTION Set_Attributes (
1851: p_pat_rec IN pat_rec_type,
1852: x_pat_rec OUT NOCOPY pat_rec_type

Line 1887: INSERT INTO OKC_PRICE_ADJUSTMENTS(

1883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1885: RAISE OKC_API.G_EXCEPTION_ERROR;
1886: END IF;
1887: INSERT INTO OKC_PRICE_ADJUSTMENTS(
1888: id,
1889: pat_id,
1890: chr_id,
1891: cle_id,

Line 2084: -- insert_row for:OKC_PRICE_ADJUSTMENTS_V --

2080: );
2081:
2082: END insert_row;
2083: --------------------------------------------
2084: -- insert_row for:OKC_PRICE_ADJUSTMENTS_V --
2085: --------------------------------------------
2086: PROCEDURE insert_row(
2087: p_api_version IN NUMBER,
2088: p_init_msg_list IN VARCHAR2 ,

Line 2120: -- Set_Attributes for:OKC_PRICE_ADJUSTMENTS_V --

2116: RETURN(l_patv_rec);
2117:
2118: END fill_who_columns;
2119: ------------------------------------------------
2120: -- Set_Attributes for:OKC_PRICE_ADJUSTMENTS_V --
2121: ------------------------------------------------
2122: FUNCTION Set_Attributes (
2123: p_patv_rec IN patv_rec_type,
2124: x_patv_rec OUT NOCOPY patv_rec_type

Line 2364: -- lock_row for:OKC_PRICE_ADJUSTMENTS --

2360: ---------------------------------------------------------------------------
2361: -- PROCEDURE lock_row
2362: ---------------------------------------------------------------------------
2363: ----------------------------------------
2364: -- lock_row for:OKC_PRICE_ADJUSTMENTS --
2365: ----------------------------------------
2366: PROCEDURE lock_row(
2367: p_init_msg_list IN VARCHAR2 ,
2368: x_return_status OUT NOCOPY VARCHAR2,

Line 2377: FROM OKC_PRICE_ADJUSTMENTS

2373: E_Resource_Busy EXCEPTION;
2374: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2375: CURSOR lock_csr (p_pat_rec IN pat_rec_type) IS
2376: SELECT OBJECT_VERSION_NUMBER
2377: FROM OKC_PRICE_ADJUSTMENTS
2378: WHERE ID = p_pat_rec.id
2379: AND OBJECT_VERSION_NUMBER = p_pat_rec.object_version_number
2380: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2381:

Line 2384: FROM OKC_PRICE_ADJUSTMENTS

2380: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2381:
2382: CURSOR lchk_csr (p_pat_rec IN pat_rec_type) IS
2383: SELECT OBJECT_VERSION_NUMBER
2384: FROM OKC_PRICE_ADJUSTMENTS
2385: WHERE ID = p_pat_rec.id;
2386:
2387: l_api_version CONSTANT NUMBER := 1;
2388: l_api_name CONSTANT VARCHAR2(30) := 'ADJUSTMENTS_lock_row';

Line 2390: l_object_version_number OKC_PRICE_ADJUSTMENTS.OBJECT_VERSION_NUMBER%TYPE;

2386:
2387: l_api_version CONSTANT NUMBER := 1;
2388: l_api_name CONSTANT VARCHAR2(30) := 'ADJUSTMENTS_lock_row';
2389: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2390: l_object_version_number OKC_PRICE_ADJUSTMENTS.OBJECT_VERSION_NUMBER%TYPE;
2391: lc_object_version_number OKC_PRICE_ADJUSTMENTS.OBJECT_VERSION_NUMBER%TYPE;
2392: l_row_notfound BOOLEAN := FALSE;
2393: lc_row_notfound BOOLEAN := FALSE;
2394: BEGIN

Line 2391: lc_object_version_number OKC_PRICE_ADJUSTMENTS.OBJECT_VERSION_NUMBER%TYPE;

2387: l_api_version CONSTANT NUMBER := 1;
2388: l_api_name CONSTANT VARCHAR2(30) := 'ADJUSTMENTS_lock_row';
2389: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2390: l_object_version_number OKC_PRICE_ADJUSTMENTS.OBJECT_VERSION_NUMBER%TYPE;
2391: lc_object_version_number OKC_PRICE_ADJUSTMENTS.OBJECT_VERSION_NUMBER%TYPE;
2392: l_row_notfound BOOLEAN := FALSE;
2393: lc_row_notfound BOOLEAN := FALSE;
2394: BEGIN
2395:

Line 2521: -- lock_row for:OKC_PRICE_ADJUSTMENTS_V --

2517: );
2518:
2519: END lock_row;
2520: ------------------------------------------
2521: -- lock_row for:OKC_PRICE_ADJUSTMENTS_V --
2522: ------------------------------------------
2523: PROCEDURE lock_row(
2524: p_api_version IN NUMBER,
2525: p_init_msg_list IN VARCHAR2 ,

Line 2731: -- update_row for:OKC_PRICE_ADJUSTMENTS --

2727: ---------------------------------------------------------------------------
2728: -- PROCEDURE update_row
2729: ---------------------------------------------------------------------------
2730: ------------------------------------------
2731: -- update_row for:OKC_PRICE_ADJUSTMENTS --
2732: ------------------------------------------
2733: PROCEDURE update_row(
2734: p_init_msg_list IN VARCHAR2 ,
2735: x_return_status OUT NOCOPY VARCHAR2,

Line 3049: -- Set_Attributes for:OKC_PRICE_ADJUSTMENTS --

3045: RETURN(l_return_status);
3046:
3047: END populate_new_record;
3048: ----------------------------------------------
3049: -- Set_Attributes for:OKC_PRICE_ADJUSTMENTS --
3050: ----------------------------------------------
3051: FUNCTION Set_Attributes (
3052: p_pat_rec IN pat_rec_type,
3053: x_pat_rec OUT NOCOPY pat_rec_type

Line 3094: UPDATE OKC_PRICE_ADJUSTMENTS

3090: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3091: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3092: RAISE OKC_API.G_EXCEPTION_ERROR;
3093: END IF;
3094: UPDATE OKC_PRICE_ADJUSTMENTS
3095: SET --PAT_ID = l_def_pat_rec.pat_id,
3096: --CHR_ID = l_def_pat_rec.chr_id,
3097: --CLE_ID = l_def_pat_rec.cle_id,
3098: BSL_ID = l_def_pat_rec.bsl_id,

Line 3224: -- update_row for:OKC_PRICE_ADJUSTMENTS_V --

3220: );
3221:
3222: END update_row;
3223: --------------------------------------------
3224: -- update_row for:OKC_PRICE_ADJUSTMENTS_V --
3225: --------------------------------------------
3226: PROCEDURE update_row(
3227: p_api_version IN NUMBER,
3228: p_init_msg_list IN VARCHAR2 ,

Line 3561: -- Set_Attributes for:OKC_PRICE_ADJUSTMENTS_V --

3557: RETURN(l_return_status);
3558:
3559: END populate_new_record;
3560: ------------------------------------------------
3561: -- Set_Attributes for:OKC_PRICE_ADJUSTMENTS_V --
3562: ------------------------------------------------
3563: FUNCTION Set_Attributes (
3564: p_patv_rec IN patv_rec_type,
3565: x_patv_rec OUT NOCOPY patv_rec_type

Line 3808: -- delete_row for:OKC_PRICE_ADJUSTMENTS --

3804: ---------------------------------------------------------------------------
3805: -- PROCEDURE delete_row
3806: ---------------------------------------------------------------------------
3807: ------------------------------------------
3808: -- delete_row for:OKC_PRICE_ADJUSTMENTS --
3809: ------------------------------------------
3810: PROCEDURE delete_row(
3811: p_init_msg_list IN VARCHAR2 ,
3812: x_return_status OUT NOCOPY VARCHAR2,

Line 3838: DELETE FROM OKC_PRICE_ADJUSTMENTS

3834: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3835: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3836: RAISE OKC_API.G_EXCEPTION_ERROR;
3837: END IF;
3838: DELETE FROM OKC_PRICE_ADJUSTMENTS
3839: WHERE ID = l_pat_rec.id;
3840:
3841: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3842:

Line 3900: -- delete_row for:OKC_PRICE_ADJUSTMENTS_V --

3896: );
3897:
3898: END delete_row;
3899: --------------------------------------------
3900: -- delete_row for:OKC_PRICE_ADJUSTMENTS_V --
3901: --------------------------------------------
3902: PROCEDURE delete_row(
3903: p_api_version IN NUMBER,
3904: p_init_msg_list IN VARCHAR2 ,

Line 4107: -- Procedure for mass insert in OKC_PRICE_ADJUSTMENTS _B and TL tables

4103:
4104: END delete_row;
4105:
4106: ---------------------------------------------------------------
4107: -- Procedure for mass insert in OKC_PRICE_ADJUSTMENTS _B and TL tables
4108: ---------------------------------------------------------------
4109: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_patv_tbl patv_tbl_type) IS
4110: l_tabsize NUMBER := p_patv_tbl.COUNT;
4111: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

Line 4268: INTO OKC_PRICE_ADJUSTMENTS

4264: END LOOP;
4265:
4266: FORALL i in 1..l_tabsize
4267: INSERT
4268: INTO OKC_PRICE_ADJUSTMENTS
4269: (
4270: id,
4271: pat_id,
4272: chr_id,

Line 4448: INSERT INTO okc_price_adjustments_h

4444: okc_debug.Set_Indentation('OKC_PAT_PVT');
4445: okc_debug.log('13600: Entered create_version', 2);
4446: END IF;
4447:
4448: INSERT INTO okc_price_adjustments_h
4449: (
4450: id,
4451: pat_id,
4452: chr_id,

Line 4590: FROM okc_price_adjustments

4586: last_update_login,
4587: rebate_transaction_type_code,
4588: p_major_version
4589:
4590: FROM okc_price_adjustments
4591: WHERE chr_id = p_chr_id;
4592:
4593: IF (l_debug = 'Y') THEN
4594: okc_debug.log('13700: Exiting create_version', 2);

Line 4637: INSERT INTO okc_price_adjustments

4633: okc_debug.Set_Indentation('OKC_PAT_PVT');
4634: okc_debug.log('13900: Entered restore_version', 2);
4635: END IF;
4636:
4637: INSERT INTO okc_price_adjustments
4638: (
4639: id,
4640: pat_id,
4641: chr_id,

Line 4777: FROM okc_price_adjustments_h

4773: attribute15,
4774: last_update_login,
4775: rebate_transaction_type_code
4776:
4777: FROM okc_price_adjustments_h
4778: WHERE chr_id = p_chr_id
4779: AND major_version = p_major_version;
4780:
4781: IF (l_debug = 'Y') THEN