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.OKL_PIT_PVT dependencies on OKL_PRD_PRICE_TMPLS

Line 36: -- FUNCTION get_rec for: OKL_PRD_PRICE_TMPLS

32: NULL;
33: END api_copy;
34:
35: ---------------------------------------------------------------------------
36: -- FUNCTION get_rec for: OKL_PRD_PRICE_TMPLS
37: ---------------------------------------------------------------------------
38: FUNCTION get_rec (
39: p_pit_rec IN pit_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN

Line 60: FROM Okl_Prd_Price_Tmpls

56: CREATION_DATE,
57: LAST_UPDATED_BY,
58: LAST_UPDATE_DATE,
59: LAST_UPDATE_LOGIN
60: FROM Okl_Prd_Price_Tmpls
61: WHERE okl_prd_price_tmpls.id = p_id;
62: l_pit_pk pit_pk_csr%ROWTYPE;
63: l_pit_rec pit_rec_type;
64: BEGIN

Line 61: WHERE okl_prd_price_tmpls.id = p_id;

57: LAST_UPDATED_BY,
58: LAST_UPDATE_DATE,
59: LAST_UPDATE_LOGIN
60: FROM Okl_Prd_Price_Tmpls
61: WHERE okl_prd_price_tmpls.id = p_id;
62: l_pit_pk pit_pk_csr%ROWTYPE;
63: l_pit_rec pit_rec_type;
64: BEGIN
65: x_no_data_found := TRUE;

Line 98: -- FUNCTION get_rec for: OKL_PRD_PRICE_TMPLS_V

94: BEGIN
95: RETURN(get_rec(p_pit_rec, l_row_notfound));
96: END get_rec;
97: ---------------------------------------------------------------------------
98: -- FUNCTION get_rec for: OKL_PRD_PRICE_TMPLS_V
99: ---------------------------------------------------------------------------
100: FUNCTION get_rec (
101: p_pitv_rec IN pitv_rec_type,
102: x_no_data_found OUT NOCOPY BOOLEAN

Line 122: FROM Okl_Prd_Price_Tmpls_V

118: CREATION_DATE,
119: LAST_UPDATED_BY,
120: LAST_UPDATE_DATE,
121: LAST_UPDATE_LOGIN
122: FROM Okl_Prd_Price_Tmpls_V
123: WHERE okl_prd_price_tmpls_v.id = p_id;
124: l_okl_pitv_pk okl_pitv_pk_csr%ROWTYPE;
125: l_pitv_rec pitv_rec_type;
126: BEGIN

Line 123: WHERE okl_prd_price_tmpls_v.id = p_id;

119: LAST_UPDATED_BY,
120: LAST_UPDATE_DATE,
121: LAST_UPDATE_LOGIN
122: FROM Okl_Prd_Price_Tmpls_V
123: WHERE okl_prd_price_tmpls_v.id = p_id;
124: l_okl_pitv_pk okl_pitv_pk_csr%ROWTYPE;
125: l_pitv_rec pitv_rec_type;
126: BEGIN
127: x_no_data_found := TRUE;

Line 161: -- FUNCTION null_out_defaults for: OKL_PRD_PRICE_TMPLS_V --

157: RETURN(get_rec(p_pitv_rec, l_row_notfound));
158: END get_rec;
159:
160: -----------------------------------------------------------
161: -- FUNCTION null_out_defaults for: OKL_PRD_PRICE_TMPLS_V --
162: -----------------------------------------------------------
163: FUNCTION null_out_defaults (
164: p_pitv_rec IN pitv_rec_type
165: ) RETURN pitv_rec_type IS

Line 222: -- Validate_Attributes for:OKL_PRD_PRICE_TMPLS_V --

218: ---------------------------------------------------------------------------
219: -- PROCEDURE Validate_Attributes
220: ---------------------------------------------------------------------------
221: ---------------------------------------------------
222: -- Validate_Attributes for:OKL_PRD_PRICE_TMPLS_V --
223: ---------------------------------------------------
224: FUNCTION Validate_Attributes (
225: p_pitv_rec IN pitv_rec_type
226: ) RETURN VARCHAR2 IS

Line 621: FROM OKL_PRD_PRICE_TMPLS_V

617:
618: -- Cursor for PIT Unique Key
619: CURSOR okl_pit_uk_csr(p_rec pitv_rec_type) IS
620: SELECT '1'
621: FROM OKL_PRD_PRICE_TMPLS_V
622: WHERE pdt_id = p_rec.pdt_id
623: AND version = p_rec.version
624: AND id <> NVL(p_rec.id,-9999);
625:

Line 986: -- Validate_Record for:OKL_PRD_PRICE_TMPLS_V --

982: ---------------------------------------------------------------------------
983: -- PROCEDURE Validate_Record
984: ---------------------------------------------------------------------------
985: -----------------------------------------------
986: -- Validate_Record for:OKL_PRD_PRICE_TMPLS_V --
987: -----------------------------------------------
988: FUNCTION Validate_Record (
989: p_pitv_rec IN pitv_rec_type
990: ) RETURN VARCHAR2 IS

Line 1051: -- validate_row for:OKL_PRD_PRICE_TMPLS_V --

1047: ---------------------------------------------------------------------------
1048: -- PROCEDURE validate_row
1049: ---------------------------------------------------------------------------
1050: --------------------------------------------
1051: -- validate_row for:OKL_PRD_PRICE_TMPLS_V --
1052: --------------------------------------------
1053: PROCEDURE validate_row(
1054: p_api_version IN NUMBER,
1055: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1215: -- insert_row for:OKL_PRD_PRICE_TMPLS --

1211: ---------------------------------------------------------------------------
1212: -- PROCEDURE insert_row
1213: ---------------------------------------------------------------------------
1214: ----------------------------------------
1215: -- insert_row for:OKL_PRD_PRICE_TMPLS --
1216: ----------------------------------------
1217: PROCEDURE insert_row(
1218: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1219: x_return_status OUT NOCOPY VARCHAR2,

Line 1231: -- Set_Attributes for:OKL_PRD_PRICE_TMPLS --

1227: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1228: l_pit_rec pit_rec_type := p_pit_rec;
1229: l_def_pit_rec pit_rec_type;
1230: --------------------------------------------
1231: -- Set_Attributes for:OKL_PRD_PRICE_TMPLS --
1232: --------------------------------------------
1233: FUNCTION Set_Attributes (
1234: p_pit_rec IN pit_rec_type,
1235: x_pit_rec OUT NOCOPY pit_rec_type

Line 1262: INSERT INTO OKL_PRD_PRICE_TMPLS(

1258: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1259: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1260: RAISE Okc_Api.G_EXCEPTION_ERROR;
1261: END IF;
1262: INSERT INTO OKL_PRD_PRICE_TMPLS(
1263: id,
1264: pdt_id,
1265: template_name,
1266: -- mvasudev , 05/13/2002

Line 1332: -- insert_row for:OKL_PRD_PRICE_TMPLS_V --

1328: '_PVT'
1329: );
1330: END insert_row;
1331: ------------------------------------------
1332: -- insert_row for:OKL_PRD_PRICE_TMPLS_V --
1333: ------------------------------------------
1334: PROCEDURE insert_row(
1335: p_api_version IN NUMBER,
1336: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1366: -- Set_Attributes for:OKL_PRD_PRICE_TMPLS_V --

1362: l_pitv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1363: RETURN(l_pitv_rec);
1364: END fill_who_columns;
1365: ----------------------------------------------
1366: -- Set_Attributes for:OKL_PRD_PRICE_TMPLS_V --
1367: ----------------------------------------------
1368: FUNCTION Set_Attributes (
1369: p_pitv_rec IN pitv_rec_type,
1370: x_pitv_rec OUT NOCOPY pitv_rec_type

Line 1579: -- lock_row for:OKL_PRD_PRICE_TMPLS --

1575: ---------------------------------------------------------------------------
1576: -- PROCEDURE lock_row
1577: ---------------------------------------------------------------------------
1578: --------------------------------------
1579: -- lock_row for:OKL_PRD_PRICE_TMPLS --
1580: --------------------------------------
1581: PROCEDURE lock_row(
1582: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1583: x_return_status OUT NOCOPY VARCHAR2,

Line 1592: FROM OKL_PRD_PRICE_TMPLS

1588: E_Resource_Busy EXCEPTION;
1589: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1590: CURSOR lock_csr (p_pit_rec IN pit_rec_type) IS
1591: SELECT OBJECT_VERSION_NUMBER
1592: FROM OKL_PRD_PRICE_TMPLS
1593: WHERE ID = p_pit_rec.id
1594: AND OBJECT_VERSION_NUMBER = p_pit_rec.object_version_number
1595: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1596:

Line 1599: FROM OKL_PRD_PRICE_TMPLS

1595: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1596:
1597: CURSOR lchk_csr (p_pit_rec IN pit_rec_type) IS
1598: SELECT OBJECT_VERSION_NUMBER
1599: FROM OKL_PRD_PRICE_TMPLS
1600: WHERE ID = p_pit_rec.id;
1601: l_api_version CONSTANT NUMBER := 1;
1602: l_api_name CONSTANT VARCHAR2(30) := 'TMPLS_lock_row';
1603: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 1604: l_object_version_number OKL_PRD_PRICE_TMPLS.OBJECT_VERSION_NUMBER%TYPE;

1600: WHERE ID = p_pit_rec.id;
1601: l_api_version CONSTANT NUMBER := 1;
1602: l_api_name CONSTANT VARCHAR2(30) := 'TMPLS_lock_row';
1603: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1604: l_object_version_number OKL_PRD_PRICE_TMPLS.OBJECT_VERSION_NUMBER%TYPE;
1605: lc_object_version_number OKL_PRD_PRICE_TMPLS.OBJECT_VERSION_NUMBER%TYPE;
1606: l_row_notfound BOOLEAN := FALSE;
1607: lc_row_notfound BOOLEAN := FALSE;
1608: BEGIN

Line 1605: lc_object_version_number OKL_PRD_PRICE_TMPLS.OBJECT_VERSION_NUMBER%TYPE;

1601: l_api_version CONSTANT NUMBER := 1;
1602: l_api_name CONSTANT VARCHAR2(30) := 'TMPLS_lock_row';
1603: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1604: l_object_version_number OKL_PRD_PRICE_TMPLS.OBJECT_VERSION_NUMBER%TYPE;
1605: lc_object_version_number OKL_PRD_PRICE_TMPLS.OBJECT_VERSION_NUMBER%TYPE;
1606: l_row_notfound BOOLEAN := FALSE;
1607: lc_row_notfound BOOLEAN := FALSE;
1608: BEGIN
1609: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 1685: -- lock_row for:OKL_PRD_PRICE_TMPLS_V --

1681: '_PVT'
1682: );
1683: END lock_row;
1684: ----------------------------------------
1685: -- lock_row for:OKL_PRD_PRICE_TMPLS_V --
1686: ----------------------------------------
1687: PROCEDURE lock_row(
1688: p_api_version IN NUMBER,
1689: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1851: -- update_row for:OKL_PRD_PRICE_TMPLS --

1847: ---------------------------------------------------------------------------
1848: -- PROCEDURE update_row
1849: ---------------------------------------------------------------------------
1850: ----------------------------------------
1851: -- update_row for:OKL_PRD_PRICE_TMPLS --
1852: ----------------------------------------
1853: PROCEDURE update_row(
1854: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1855: x_return_status OUT NOCOPY VARCHAR2,

Line 1945: -- Set_Attributes for:OKL_PRD_PRICE_TMPLS --

1941: END IF;
1942: RETURN(l_return_status);
1943: END populate_new_record;
1944: --------------------------------------------
1945: -- Set_Attributes for:OKL_PRD_PRICE_TMPLS --
1946: --------------------------------------------
1947: FUNCTION Set_Attributes (
1948: p_pit_rec IN pit_rec_type,
1949: x_pit_rec OUT NOCOPY pit_rec_type

Line 1982: UPDATE OKL_PRD_PRICE_TMPLS

1978: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1979: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1980: RAISE Okc_Api.G_EXCEPTION_ERROR;
1981: END IF;
1982: UPDATE OKL_PRD_PRICE_TMPLS
1983: SET PDT_ID = l_def_pit_rec.pdt_id,
1984: TEMPLATE_NAME = l_def_pit_rec.template_name,
1985: TEMPLATE_PATH = l_def_pit_rec.template_path,
1986: VERSION = l_def_pit_rec.version,

Line 2033: -- update_row for:OKL_PRD_PRICE_TMPLS_V --

2029: '_PVT'
2030: );
2031: END update_row;
2032: ------------------------------------------
2033: -- update_row for:OKL_PRD_PRICE_TMPLS_V --
2034: ------------------------------------------
2035: PROCEDURE update_row(
2036: p_api_version IN NUMBER,
2037: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2142: -- Set_Attributes for:OKL_PRD_PRICE_TMPLS_V --

2138: END IF;
2139: RETURN(l_return_status);
2140: END populate_new_record;
2141: ----------------------------------------------
2142: -- Set_Attributes for:OKL_PRD_PRICE_TMPLS_V --
2143: ----------------------------------------------
2144: FUNCTION Set_Attributes (
2145: p_pitv_rec IN pitv_rec_type,
2146: x_pitv_rec OUT NOCOPY pitv_rec_type

Line 2344: -- delete_row for:OKL_PRD_PRICE_TMPLS --

2340: ---------------------------------------------------------------------------
2341: -- PROCEDURE delete_row
2342: ---------------------------------------------------------------------------
2343: ----------------------------------------
2344: -- delete_row for:OKL_PRD_PRICE_TMPLS --
2345: ----------------------------------------
2346: PROCEDURE delete_row(
2347: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2348: x_return_status OUT NOCOPY VARCHAR2,

Line 2368: DELETE FROM OKL_PRD_PRICE_TMPLS

2364: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2365: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2366: RAISE Okc_Api.G_EXCEPTION_ERROR;
2367: END IF;
2368: DELETE FROM OKL_PRD_PRICE_TMPLS
2369: WHERE ID = l_pit_rec.id;
2370:
2371: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2372: EXCEPTION

Line 2405: -- delete_row for:OKL_PRD_PRICE_TMPLS_V --

2401: '_PVT'
2402: );
2403: END delete_row;
2404: ------------------------------------------
2405: -- delete_row for:OKL_PRD_PRICE_TMPLS_V --
2406: ------------------------------------------
2407: PROCEDURE delete_row(
2408: p_api_version IN NUMBER,
2409: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,