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_PAC_PVT dependencies on OKC_PRICE_ADJ_ASSOCS

Line 46: -- FUNCTION get_rec for: OKC_PRICE_ADJ_ASSOCS

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

Line 70: FROM Okc_Price_Adj_Assocs

66: PROGRAM_ID,
67: PROGRAM_UPDATE_DATE,
68: REQUEST_ID,
69: OBJECT_VERSION_NUMBER
70: FROM Okc_Price_Adj_Assocs
71: WHERE okc_price_adj_assocs.id = p_id;
72: l_pac_pk pac_pk_csr%ROWTYPE;
73: l_pac_rec pac_rec_type;
74: BEGIN

Line 71: WHERE okc_price_adj_assocs.id = p_id;

67: PROGRAM_UPDATE_DATE,
68: REQUEST_ID,
69: OBJECT_VERSION_NUMBER
70: FROM Okc_Price_Adj_Assocs
71: WHERE okc_price_adj_assocs.id = p_id;
72: l_pac_pk pac_pk_csr%ROWTYPE;
73: l_pac_rec pac_rec_type;
74: BEGIN
75:

Line 123: -- FUNCTION get_rec for: OKC_PRICE_ADJ_ASSOCS_V

119: RETURN(get_rec(p_pac_rec, l_row_notfound));
120:
121: END get_rec;
122: ---------------------------------------------------------------------------
123: -- FUNCTION get_rec for: OKC_PRICE_ADJ_ASSOCS_V
124: ---------------------------------------------------------------------------
125: FUNCTION get_rec (
126: p_pacv_rec IN pacv_rec_type,
127: x_no_data_found OUT NOCOPY BOOLEAN

Line 147: FROM Okc_Price_Adj_Assocs_V

143: PROGRAM_ID,
144: PROGRAM_UPDATE_DATE,
145: REQUEST_ID,
146: OBJECT_VERSION_NUMBER
147: FROM Okc_Price_Adj_Assocs_V
148: WHERE okc_price_adj_assocs_v.id = p_id;
149: l_okc_pacv_pk okc_pacv_pk_csr%ROWTYPE;
150: l_pacv_rec pacv_rec_type;
151: BEGIN

Line 148: WHERE okc_price_adj_assocs_v.id = p_id;

144: PROGRAM_UPDATE_DATE,
145: REQUEST_ID,
146: OBJECT_VERSION_NUMBER
147: FROM Okc_Price_Adj_Assocs_V
148: WHERE okc_price_adj_assocs_v.id = p_id;
149: l_okc_pacv_pk okc_pacv_pk_csr%ROWTYPE;
150: l_pacv_rec pacv_rec_type;
151: BEGIN
152:

Line 202: -- FUNCTION null_out_defaults for: OKC_PRICE_ADJ_ASSOCS_V --

198:
199: END get_rec;
200:
201: ------------------------------------------------------------
202: -- FUNCTION null_out_defaults for: OKC_PRICE_ADJ_ASSOCS_V --
203: ------------------------------------------------------------
204: FUNCTION null_out_defaults (
205: p_pacv_rec IN pacv_rec_type
206: ) RETURN pacv_rec_type IS

Line 364: -- Validate_Attributes for:OKC_PRICE_ADJ_ASSOCS_V --

360: ---------------------------------------------------------------------------
361: -- PROCEDURE Validate_Attributes
362: ---------------------------------------------------------------------------
363: ----------------------------------------------------
364: -- Validate_Attributes for:OKC_PRICE_ADJ_ASSOCS_V --
365: ----------------------------------------------------
366: FUNCTION Validate_Attributes (
367: p_pacv_rec IN pacv_rec_type
368: ) RETURN VARCHAR2 IS

Line 381: OKC_UTIL.ADD_VIEW('OKC_PRICE_ADJ_ASSOCS_V', l_return_status);

377:
378: ---------------------------------------------------------------------------------------
379: --Attribute Level Validation Procedure Calls Starts(Modification on TAPI generated Code.)--
380: ---------------------------------------------------------------------------------------
381: OKC_UTIL.ADD_VIEW('OKC_PRICE_ADJ_ASSOCS_V', l_return_status);
382: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
383: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
384: x_return_status := l_return_status;
385: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 451: -- Validate_Record for:OKC_PRICE_ADJ_ASSOCS_V --

447: ---------------------------------------------------------------------------
448: -- PROCEDURE Validate_Record
449: ---------------------------------------------------------------------------
450: ------------------------------------------------
451: -- Validate_Record for:OKC_PRICE_ADJ_ASSOCS_V --
452: ------------------------------------------------
453: FUNCTION Validate_Record (
454: p_pacv_rec IN pacv_rec_type
455: ) RETURN VARCHAR2 IS

Line 641: -- validate_row for:OKC_PRICE_ADJ_ASSOCS_V --

637: ---------------------------------------------------------------------------
638: -- PROCEDURE validate_row
639: ---------------------------------------------------------------------------
640: ---------------------------------------------
641: -- validate_row for:OKC_PRICE_ADJ_ASSOCS_V --
642: ---------------------------------------------
643: PROCEDURE validate_row(
644: p_api_version IN NUMBER,
645: p_init_msg_list IN VARCHAR2 ,

Line 847: -- insert_row for:OKC_PRICE_ADJ_ASSOCS --

843: ---------------------------------------------------------------------------
844: -- PROCEDURE insert_row
845: ---------------------------------------------------------------------------
846: -----------------------------------------
847: -- insert_row for:OKC_PRICE_ADJ_ASSOCS --
848: -----------------------------------------
849: PROCEDURE insert_row(
850: p_init_msg_list IN VARCHAR2 ,
851: x_return_status OUT NOCOPY VARCHAR2,

Line 863: -- Set_Attributes for:OKC_PRICE_ADJ_ASSOCS --

859: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
860: l_pac_rec pac_rec_type := p_pac_rec;
861: l_def_pac_rec pac_rec_type;
862: ---------------------------------------------
863: -- Set_Attributes for:OKC_PRICE_ADJ_ASSOCS --
864: ---------------------------------------------
865: FUNCTION Set_Attributes (
866: p_pac_rec IN pac_rec_type,
867: x_pac_rec OUT NOCOPY pac_rec_type

Line 902: INSERT INTO OKC_PRICE_ADJ_ASSOCS(

898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
900: RAISE OKC_API.G_EXCEPTION_ERROR;
901: END IF;
902: INSERT INTO OKC_PRICE_ADJ_ASSOCS(
903: id,
904: pat_id,
905: pat_id_from,
906: bsl_id,

Line 997: -- insert_row for:OKC_PRICE_ADJ_ASSOCS_V --

993: );
994:
995: END insert_row;
996: -------------------------------------------
997: -- insert_row for:OKC_PRICE_ADJ_ASSOCS_V --
998: -------------------------------------------
999: PROCEDURE insert_row(
1000: p_api_version IN NUMBER,
1001: p_init_msg_list IN VARCHAR2 ,

Line 1033: -- Set_Attributes for:OKC_PRICE_ADJ_ASSOCS_V --

1029: RETURN(l_pacv_rec);
1030:
1031: END fill_who_columns;
1032: -----------------------------------------------
1033: -- Set_Attributes for:OKC_PRICE_ADJ_ASSOCS_V --
1034: -----------------------------------------------
1035: FUNCTION Set_Attributes (
1036: p_pacv_rec IN pacv_rec_type,
1037: x_pacv_rec OUT NOCOPY pacv_rec_type

Line 1277: -- lock_row for:OKC_PRICE_ADJ_ASSOCS --

1273: ---------------------------------------------------------------------------
1274: -- PROCEDURE lock_row
1275: ---------------------------------------------------------------------------
1276: ---------------------------------------
1277: -- lock_row for:OKC_PRICE_ADJ_ASSOCS --
1278: ---------------------------------------
1279: PROCEDURE lock_row(
1280: p_init_msg_list IN VARCHAR2 ,
1281: x_return_status OUT NOCOPY VARCHAR2,

Line 1290: FROM OKC_PRICE_ADJ_ASSOCS

1286: E_Resource_Busy EXCEPTION;
1287: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1288: CURSOR lock_csr (p_pac_rec IN pac_rec_type) IS
1289: SELECT *
1290: FROM OKC_PRICE_ADJ_ASSOCS
1291: WHERE ID = p_pac_rec.id
1292: FOR UPDATE NOWAIT;
1293:
1294: l_api_version CONSTANT NUMBER := 1;

Line 1466: -- lock_row for:OKC_PRICE_ADJ_ASSOCS_V --

1462: );
1463:
1464: END lock_row;
1465: -----------------------------------------
1466: -- lock_row for:OKC_PRICE_ADJ_ASSOCS_V --
1467: -----------------------------------------
1468: PROCEDURE lock_row(
1469: p_api_version IN NUMBER,
1470: p_init_msg_list IN VARCHAR2 ,

Line 1676: -- update_row for:OKC_PRICE_ADJ_ASSOCS --

1672: ---------------------------------------------------------------------------
1673: -- PROCEDURE update_row
1674: ---------------------------------------------------------------------------
1675: -----------------------------------------
1676: -- update_row for:OKC_PRICE_ADJ_ASSOCS --
1677: -----------------------------------------
1678: PROCEDURE update_row(
1679: p_init_msg_list IN VARCHAR2 ,
1680: x_return_status OUT NOCOPY VARCHAR2,

Line 1789: -- Set_Attributes for:OKC_PRICE_ADJ_ASSOCS --

1785: RETURN(l_return_status);
1786:
1787: END populate_new_record;
1788: ---------------------------------------------
1789: -- Set_Attributes for:OKC_PRICE_ADJ_ASSOCS --
1790: ---------------------------------------------
1791: FUNCTION Set_Attributes (
1792: p_pac_rec IN pac_rec_type,
1793: x_pac_rec OUT NOCOPY pac_rec_type

Line 1834: UPDATE OKC_PRICE_ADJ_ASSOCS

1830: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1831: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1832: RAISE OKC_API.G_EXCEPTION_ERROR;
1833: END IF;
1834: UPDATE OKC_PRICE_ADJ_ASSOCS
1835: SET PAT_ID = l_def_pac_rec.pat_id,
1836: PAT_ID_FROM = l_def_pac_rec.pat_id_from,
1837: BSL_ID = l_def_pac_rec.bsl_id,
1838: CLE_ID = l_def_pac_rec.cle_id,

Line 1913: -- update_row for:OKC_PRICE_ADJ_ASSOCS_V --

1909: );
1910:
1911: END update_row;
1912: -------------------------------------------
1913: -- update_row for:OKC_PRICE_ADJ_ASSOCS_V --
1914: -------------------------------------------
1915: PROCEDURE update_row(
1916: p_api_version IN NUMBER,
1917: p_init_msg_list IN VARCHAR2 ,

Line 2044: -- Set_Attributes for:OKC_PRICE_ADJ_ASSOCS_V --

2040: RETURN(l_return_status);
2041:
2042: END populate_new_record;
2043: -----------------------------------------------
2044: -- Set_Attributes for:OKC_PRICE_ADJ_ASSOCS_V --
2045: -----------------------------------------------
2046: FUNCTION Set_Attributes (
2047: p_pacv_rec IN pacv_rec_type,
2048: x_pacv_rec OUT NOCOPY pacv_rec_type

Line 2291: -- delete_row for:OKC_PRICE_ADJ_ASSOCS --

2287: ---------------------------------------------------------------------------
2288: -- PROCEDURE delete_row
2289: ---------------------------------------------------------------------------
2290: -----------------------------------------
2291: -- delete_row for:OKC_PRICE_ADJ_ASSOCS --
2292: -----------------------------------------
2293: PROCEDURE delete_row(
2294: p_init_msg_list IN VARCHAR2 ,
2295: x_return_status OUT NOCOPY VARCHAR2,

Line 2321: DELETE FROM OKC_PRICE_ADJ_ASSOCS

2317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2318: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2319: RAISE OKC_API.G_EXCEPTION_ERROR;
2320: END IF;
2321: DELETE FROM OKC_PRICE_ADJ_ASSOCS
2322: WHERE ID = l_pac_rec.id;
2323:
2324: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2325:

Line 2383: -- delete_row for:OKC_PRICE_ADJ_ASSOCS_V --

2379: );
2380:
2381: END delete_row;
2382: -------------------------------------------
2383: -- delete_row for:OKC_PRICE_ADJ_ASSOCS_V --
2384: -------------------------------------------
2385: PROCEDURE delete_row(
2386: p_api_version IN NUMBER,
2387: p_init_msg_list IN VARCHAR2 ,

Line 2604: INSERT INTO okc_price_adj_assocs_h

2600: okc_debug.Set_Indentation('OKC_PAC_PVT');
2601: okc_debug.log('10700: Entered create_version', 2);
2602: END IF;
2603:
2604: INSERT INTO okc_price_adj_assocs_h
2605: (
2606: id,
2607: pat_id,
2608: pat_id_from,

Line 2642: FROM okc_price_adj_assocs

2638: request_id,
2639: object_version_number,
2640: p_major_version
2641:
2642: FROM okc_price_adj_assocs
2643: WHERE pat_id_from IN
2644: ( SELECT pat_id
2645: FROM OKC_PRICE_ADJUSTMENTS
2646: WHERE chr_id = p_chr_id

Line 2694: INSERT INTO okc_price_adj_assocs

2690: okc_debug.Set_Indentation('OKC_PAC_PVT');
2691: okc_debug.log('11000: Entered restore_version', 2);
2692: END IF;
2693:
2694: INSERT INTO okc_price_adj_assocs
2695: (
2696: id,
2697: pat_id,
2698: pat_id_from,

Line 2730: FROM okc_price_adj_assocs_h

2726: program_id,
2727: program_update_date,
2728: request_id,
2729: object_version_number
2730: FROM okc_price_adj_assocs_h
2731: WHERE pat_id_from IN
2732: ( SELECT pat_id
2733: FROM OKC_PRICE_ADJUSTMENTS
2734: WHERE chr_id = p_chr_id