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_TQD_PVT dependencies on OKL_TXD_QUOTE_LINE_DTLS

Line 37: -- FUNCTION get_rec for: OKL_TXD_QUOTE_LINE_DTLS_V

33: null;
34: END api_copy;
35:
36: ---------------------------------------------------------------------------
37: -- FUNCTION get_rec for: OKL_TXD_QUOTE_LINE_DTLS_V
38: ---------------------------------------------------------------------------
39: FUNCTION get_rec (p_tqdv_rec IN tqdv_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN)
41: RETURN tqdv_rec_type IS

Line 75: FROM OKL_TXD_QUOTE_LINE_DTLS

71: ATTRIBUTE12,
72: ATTRIBUTE13,
73: ATTRIBUTE14,
74: ATTRIBUTE15
75: FROM OKL_TXD_QUOTE_LINE_DTLS
76: WHERE OKL_TXD_QUOTE_LINE_DTLS.id = p_id;
77: l_okl_tqdv_pk okl_tqdv_pk_csr%ROWTYPE;
78: l_tqdv_rec tqdv_rec_type;
79: BEGIN

Line 76: WHERE OKL_TXD_QUOTE_LINE_DTLS.id = p_id;

72: ATTRIBUTE13,
73: ATTRIBUTE14,
74: ATTRIBUTE15
75: FROM OKL_TXD_QUOTE_LINE_DTLS
76: WHERE OKL_TXD_QUOTE_LINE_DTLS.id = p_id;
77: l_okl_tqdv_pk okl_tqdv_pk_csr%ROWTYPE;
78: l_tqdv_rec tqdv_rec_type;
79: BEGIN
80: x_no_data_found := TRUE;

Line 147: -- FUNCTION get_rec for: OKL_TXD_QUOTE_LINE_DTLS

143: BEGIN
144: RETURN(get_rec(p_tqdv_rec, l_row_not_found));
145: END get_rec;
146: ---------------------------------------------------------------------------
147: -- FUNCTION get_rec for: OKL_TXD_QUOTE_LINE_DTLS
148: ---------------------------------------------------------------------------
149: FUNCTION get_rec (p_tqd_rec IN tqd_rec_type,
150: x_no_data_found OUT NOCOPY BOOLEAN)
151: RETURN tqd_rec_type IS

Line 152: CURSOR okl_txd_quote_line_dtls_pk_csr (p_id IN NUMBER) IS

148: ---------------------------------------------------------------------------
149: FUNCTION get_rec (p_tqd_rec IN tqd_rec_type,
150: x_no_data_found OUT NOCOPY BOOLEAN)
151: RETURN tqd_rec_type IS
152: CURSOR okl_txd_quote_line_dtls_pk_csr (p_id IN NUMBER) IS
153: SELECT ID,
154: OBJECT_VERSION_NUMBER,
155: NUMBER_OF_UNITS,
156: KLE_ID,

Line 184: FROM Okl_Txd_Quote_Line_Dtls

180: ATTRIBUTE12,
181: ATTRIBUTE13,
182: ATTRIBUTE14,
183: ATTRIBUTE15
184: FROM Okl_Txd_Quote_Line_Dtls
185: WHERE okl_txd_quote_line_dtls.id = p_id;
186: l_okl_txd_quote_line_dtls_pk okl_txd_quote_line_dtls_pk_csr%ROWTYPE;
187: l_tqd_rec tqd_rec_type;
188: BEGIN

Line 185: WHERE okl_txd_quote_line_dtls.id = p_id;

181: ATTRIBUTE13,
182: ATTRIBUTE14,
183: ATTRIBUTE15
184: FROM Okl_Txd_Quote_Line_Dtls
185: WHERE okl_txd_quote_line_dtls.id = p_id;
186: l_okl_txd_quote_line_dtls_pk okl_txd_quote_line_dtls_pk_csr%ROWTYPE;
187: l_tqd_rec tqd_rec_type;
188: BEGIN
189: x_no_data_found := TRUE;

Line 186: l_okl_txd_quote_line_dtls_pk okl_txd_quote_line_dtls_pk_csr%ROWTYPE;

182: ATTRIBUTE14,
183: ATTRIBUTE15
184: FROM Okl_Txd_Quote_Line_Dtls
185: WHERE okl_txd_quote_line_dtls.id = p_id;
186: l_okl_txd_quote_line_dtls_pk okl_txd_quote_line_dtls_pk_csr%ROWTYPE;
187: l_tqd_rec tqd_rec_type;
188: BEGIN
189: x_no_data_found := TRUE;
190: -- Get current database values

Line 191: OPEN okl_txd_quote_line_dtls_pk_csr (p_tqd_rec.id);

187: l_tqd_rec tqd_rec_type;
188: BEGIN
189: x_no_data_found := TRUE;
190: -- Get current database values
191: OPEN okl_txd_quote_line_dtls_pk_csr (p_tqd_rec.id);
192: FETCH okl_txd_quote_line_dtls_pk_csr INTO
193: l_tqd_rec.id,
194: l_tqd_rec.object_version_number,
195: l_tqd_rec.number_of_units,

Line 192: FETCH okl_txd_quote_line_dtls_pk_csr INTO

188: BEGIN
189: x_no_data_found := TRUE;
190: -- Get current database values
191: OPEN okl_txd_quote_line_dtls_pk_csr (p_tqd_rec.id);
192: FETCH okl_txd_quote_line_dtls_pk_csr INTO
193: l_tqd_rec.id,
194: l_tqd_rec.object_version_number,
195: l_tqd_rec.number_of_units,
196: l_tqd_rec.kle_id,

Line 224: x_no_data_found := okl_txd_quote_line_dtls_pk_csr%NOTFOUND;

220: l_tqd_rec.attribute12,
221: l_tqd_rec.attribute13,
222: l_tqd_rec.attribute14,
223: l_tqd_rec.attribute15;
224: x_no_data_found := okl_txd_quote_line_dtls_pk_csr%NOTFOUND;
225: CLOSE okl_txd_quote_line_dtls_pk_csr;
226: RETURN(l_tqd_rec);
227: END get_rec;
228:

Line 225: CLOSE okl_txd_quote_line_dtls_pk_csr;

221: l_tqd_rec.attribute13,
222: l_tqd_rec.attribute14,
223: l_tqd_rec.attribute15;
224: x_no_data_found := okl_txd_quote_line_dtls_pk_csr%NOTFOUND;
225: CLOSE okl_txd_quote_line_dtls_pk_csr;
226: RETURN(l_tqd_rec);
227: END get_rec;
228:
229: ------------------------------------------------------------------

Line 256: -- FUNCTION null_out_defaults for: OKL_TXD_QUOTE_LINE_DTLS_V

252: BEGIN
253: RETURN(get_rec(p_tqd_rec, l_row_not_found));
254: END get_rec;
255: ---------------------------------------------------------------------------
256: -- FUNCTION null_out_defaults for: OKL_TXD_QUOTE_LINE_DTLS_V
257: ---------------------------------------------------------------------------
258: FUNCTION null_out_defaults (p_tqdv_rec IN tqdv_rec_type)
259: RETURN tqdv_rec_type IS
260: l_tqdv_rec tqdv_rec_type := p_tqdv_rec;

Line 554: -- Validate_Attributes for:OKL_TXD_QUOTE_LINE_DTLS_V --

550: ---------------------------------------------------------------------------
551: -- FUNCTION Validate_Attributes
552: ---------------------------------------------------------------------------
553: -------------------------------------------------------
554: -- Validate_Attributes for:OKL_TXD_QUOTE_LINE_DTLS_V --
555: -------------------------------------------------------
556: FUNCTION Validate_Attributes (
557: p_tqdv_rec IN tqdv_rec_type
558: ) RETURN VARCHAR2 IS

Line 603: -- Validate Record for:OKL_TXD_QUOTE_LINE_DTLS_V --

599: ---------------------------------------------------------------------------
600: -- PROCEDURE Validate_Record
601: ---------------------------------------------------------------------------
602: ---------------------------------------------------
603: -- Validate Record for:OKL_TXD_QUOTE_LINE_DTLS_V --
604: ---------------------------------------------------
605: FUNCTION Validate_Record (p_tqdv_rec IN tqdv_rec_type,
606: p_db_tqdv_rec IN tqdv_rec_type) RETURN VARCHAR2 IS
607: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 700: -- validate_row for:OKL_TXD_QUOTE_LINE_DTLS_V --

696: ---------------------------------------------------------------------------
697: -- PROCEDURE validate_row
698: ---------------------------------------------------------------------------
699: ------------------------------------------------
700: -- validate_row for:OKL_TXD_QUOTE_LINE_DTLS_V --
701: ------------------------------------------------
702: PROCEDURE validate_row(
703: p_api_version IN NUMBER,
704: p_init_msg_list IN VARCHAR2,

Line 770: -- PL/SQL TBL validate_row for:OKL_TXD_QUOTE_LINE_DTLS_V --

766: x_msg_data,
767: '_PVT');
768: END validate_row;
769: -----------------------------------------------------------
770: -- PL/SQL TBL validate_row for:OKL_TXD_QUOTE_LINE_DTLS_V --
771: -----------------------------------------------------------
772: PROCEDURE validate_row(
773: p_api_version IN NUMBER,
774: p_init_msg_list IN VARCHAR2,

Line 840: -- insert_row for:OKL_TXD_QUOTE_LINE_DTLS --

836: ---------------------------------------------------------------------------
837: -- PROCEDURE insert_row
838: ---------------------------------------------------------------------------
839: --------------------------------------------
840: -- insert_row for:OKL_TXD_QUOTE_LINE_DTLS --
841: --------------------------------------------
842: PROCEDURE insert_row(
843: p_init_msg_list IN VARCHAR2,
844: x_return_status OUT NOCOPY VARCHAR2,

Line 855: -- Set_Attributes for:OKL_TXD_QUOTE_LINE_DTLS --

851: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
852: l_tqd_rec tqd_rec_type := p_tqd_rec;
853: l_def_tqd_rec tqd_rec_type;
854: ------------------------------------------------
855: -- Set_Attributes for:OKL_TXD_QUOTE_LINE_DTLS --
856: ------------------------------------------------
857: FUNCTION Set_Attributes (p_tqd_rec IN tqd_rec_type,
858: x_tqd_rec OUT NOCOPY tqd_rec_type) RETURN VARCHAR2 IS
859: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 884: INSERT INTO OKL_TXD_QUOTE_LINE_DTLS(

880: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
881: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
882: RAISE OKC_API.G_EXCEPTION_ERROR;
883: END IF;
884: INSERT INTO OKL_TXD_QUOTE_LINE_DTLS(
885: id,
886: object_version_number,
887: number_of_units,
888: kle_id,

Line 978: -- insert_row for :OKL_TXD_QUOTE_LINE_DTLS_V --

974: x_msg_data,
975: '_PVT');
976: END insert_row;
977: -----------------------------------------------
978: -- insert_row for :OKL_TXD_QUOTE_LINE_DTLS_V --
979: -----------------------------------------------
980: PROCEDURE insert_row(
981: p_api_version IN NUMBER,
982: p_init_msg_list IN VARCHAR2,

Line 1011: -- Set_Attributes for:OKL_TXD_QUOTE_LINE_DTLS_V --

1007: l_tqdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1008: RETURN(l_tqdv_rec);
1009: END fill_who_columns;
1010: --------------------------------------------------
1011: -- Set_Attributes for:OKL_TXD_QUOTE_LINE_DTLS_V --
1012: --------------------------------------------------
1013: FUNCTION Set_Attributes (
1014: p_tqdv_rec IN tqdv_rec_type,
1015: x_tqdv_rec OUT NOCOPY tqdv_rec_type

Line 1187: -- lock_row for:OKL_TXD_QUOTE_LINE_DTLS --

1183: ---------------------------------------------------------------------------
1184: -- PROCEDURE lock_row
1185: ---------------------------------------------------------------------------
1186: ------------------------------------------
1187: -- lock_row for:OKL_TXD_QUOTE_LINE_DTLS --
1188: ------------------------------------------
1189: PROCEDURE lock_row(
1190: p_init_msg_list IN VARCHAR2,
1191: x_return_status OUT NOCOPY VARCHAR2,

Line 1200: FROM OKL_TXD_QUOTE_LINE_DTLS

1196: E_Resource_Busy EXCEPTION;
1197: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1198: CURSOR lock_csr (p_tqd_rec IN tqd_rec_type) IS
1199: SELECT OBJECT_VERSION_NUMBER
1200: FROM OKL_TXD_QUOTE_LINE_DTLS
1201: WHERE ID = p_tqd_rec.id
1202: AND OBJECT_VERSION_NUMBER = p_tqd_rec.object_version_number
1203: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1204:

Line 1207: FROM OKL_TXD_QUOTE_LINE_DTLS

1203: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1204:
1205: CURSOR lchk_csr (p_tqd_rec IN tqd_rec_type) IS
1206: SELECT OBJECT_VERSION_NUMBER
1207: FROM OKL_TXD_QUOTE_LINE_DTLS
1208: WHERE ID = p_tqd_rec.id;
1209: l_api_version CONSTANT NUMBER := 1;
1210: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1211: l_object_version_number OKL_TXD_QUOTE_LINE_DTLS.OBJECT_VERSION_NUMBER%TYPE;

Line 1211: l_object_version_number OKL_TXD_QUOTE_LINE_DTLS.OBJECT_VERSION_NUMBER%TYPE;

1207: FROM OKL_TXD_QUOTE_LINE_DTLS
1208: WHERE ID = p_tqd_rec.id;
1209: l_api_version CONSTANT NUMBER := 1;
1210: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1211: l_object_version_number OKL_TXD_QUOTE_LINE_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1212: lc_object_version_number OKL_TXD_QUOTE_LINE_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1213: l_row_notfound BOOLEAN := FALSE;
1214: lc_row_notfound BOOLEAN := FALSE;
1215: BEGIN

Line 1212: lc_object_version_number OKL_TXD_QUOTE_LINE_DTLS.OBJECT_VERSION_NUMBER%TYPE;

1208: WHERE ID = p_tqd_rec.id;
1209: l_api_version CONSTANT NUMBER := 1;
1210: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1211: l_object_version_number OKL_TXD_QUOTE_LINE_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1212: lc_object_version_number OKL_TXD_QUOTE_LINE_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1213: l_row_notfound BOOLEAN := FALSE;
1214: lc_row_notfound BOOLEAN := FALSE;
1215: BEGIN
1216: x_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1286: -- lock_row for: OKL_TXD_QUOTE_LINE_DTLS_V --

1282: x_msg_data,
1283: '_PVT');
1284: END lock_row;
1285: ---------------------------------------------
1286: -- lock_row for: OKL_TXD_QUOTE_LINE_DTLS_V --
1287: ---------------------------------------------
1288: PROCEDURE lock_row(
1289: p_api_version IN NUMBER,
1290: p_init_msg_list IN VARCHAR2,

Line 1429: -- update_row for:OKL_TXD_QUOTE_LINE_DTLS --

1425: ---------------------------------------------------------------------------
1426: -- PROCEDURE update_row
1427: ---------------------------------------------------------------------------
1428: --------------------------------------------
1429: -- update_row for:OKL_TXD_QUOTE_LINE_DTLS --
1430: --------------------------------------------
1431: PROCEDURE update_row(
1432: p_init_msg_list IN VARCHAR2,
1433: x_return_status OUT NOCOPY VARCHAR2,

Line 1587: -- Set_Attributes for:OKL_TXD_QUOTE_LINE_DTLS --

1583: END IF;
1584: RETURN(l_return_status);
1585: END populate_new_record;
1586: ------------------------------------------------
1587: -- Set_Attributes for:OKL_TXD_QUOTE_LINE_DTLS --
1588: ------------------------------------------------
1589: FUNCTION Set_Attributes (
1590: p_tqd_rec IN tqd_rec_type,
1591: x_tqd_rec OUT NOCOPY tqd_rec_type

Line 1625: UPDATE OKL_TXD_QUOTE_LINE_DTLS

1621: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1622: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1623: RAISE OKC_API.G_EXCEPTION_ERROR;
1624: END IF;
1625: UPDATE OKL_TXD_QUOTE_LINE_DTLS
1626: SET OBJECT_VERSION_NUMBER = l_def_tqd_rec.object_version_number,
1627: NUMBER_OF_UNITS = l_def_tqd_rec.number_of_units,
1628: KLE_ID = l_def_tqd_rec.kle_id,
1629: TQL_ID = l_def_tqd_rec.tql_id,

Line 1690: -- update_row for:OKL_TXD_QUOTE_LINE_DTLS_V --

1686: x_msg_data,
1687: '_PVT');
1688: END update_row;
1689: ----------------------------------------------
1690: -- update_row for:OKL_TXD_QUOTE_LINE_DTLS_V --
1691: ----------------------------------------------
1692: PROCEDURE update_row(
1693: p_api_version IN NUMBER,
1694: p_init_msg_list IN VARCHAR2,

Line 1865: -- Set_Attributes for:OKL_TXD_QUOTE_LINE_DTLS_V --

1861: END IF;
1862: RETURN(l_return_status);
1863: END populate_new_record;
1864: --------------------------------------------------
1865: -- Set_Attributes for:OKL_TXD_QUOTE_LINE_DTLS_V --
1866: --------------------------------------------------
1867: FUNCTION Set_Attributes (
1868: p_tqdv_rec IN tqdv_rec_type,
1869: x_tqdv_rec OUT NOCOPY tqdv_rec_type

Line 2057: -- delete_row for:OKL_TXD_QUOTE_LINE_DTLS --

2053: ---------------------------------------------------------------------------
2054: -- PROCEDURE delete_row
2055: ---------------------------------------------------------------------------
2056: --------------------------------------------
2057: -- delete_row for:OKL_TXD_QUOTE_LINE_DTLS --
2058: --------------------------------------------
2059: PROCEDURE delete_row(
2060: p_init_msg_list IN VARCHAR2,
2061: x_return_status OUT NOCOPY VARCHAR2,

Line 2081: DELETE FROM OKL_TXD_QUOTE_LINE_DTLS

2077: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2078: RAISE OKC_API.G_EXCEPTION_ERROR;
2079: END IF;
2080:
2081: DELETE FROM OKL_TXD_QUOTE_LINE_DTLS
2082: WHERE ID = p_tqd_rec.id;
2083: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2084: EXCEPTION
2085: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2111: -- delete_row for:OKL_TXD_QUOTE_LINE_DTLS_V --

2107: x_msg_data,
2108: '_PVT');
2109: END delete_row;
2110: ----------------------------------------------
2111: -- delete_row for:OKL_TXD_QUOTE_LINE_DTLS_V --
2112: ----------------------------------------------
2113: PROCEDURE delete_row(
2114: p_api_version IN NUMBER,
2115: p_init_msg_list IN VARCHAR2,

Line 2185: -- PL/SQL TBL delete_row for:OKL_TXD_QUOTE_LINE_DTLS_V --

2181: x_msg_data,
2182: '_PVT');
2183: END delete_row;
2184: ---------------------------------------------------------
2185: -- PL/SQL TBL delete_row for:OKL_TXD_QUOTE_LINE_DTLS_V --
2186: ---------------------------------------------------------
2187: PROCEDURE delete_row(
2188: p_api_version IN NUMBER,
2189: p_init_msg_list IN VARCHAR2,