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_LSS_PVT dependencies on OKC_LINE_STYLE_SOURCES

Line 40: -- FUNCTION get_rec for: OKC_LINE_STYLE_SOURCES

36: null;
37: END api_copy;
38:
39: ---------------------------------------------------------------------------
40: -- FUNCTION get_rec for: OKC_LINE_STYLE_SOURCES
41: ---------------------------------------------------------------------------
42: FUNCTION get_rec (
43: p_lss_rec IN lss_rec_type,
44: x_no_data_found OUT NOCOPY BOOLEAN

Line 60: FROM Okc_Line_Style_Sources

56: LAST_UPDATED_BY,
57: LAST_UPDATE_DATE,
58: END_DATE,
59: LAST_UPDATE_LOGIN
60: FROM Okc_Line_Style_Sources
61: WHERE okc_line_style_sources.lse_id = p_lse_id
62: AND okc_line_style_sources.jtot_object_code = p_jtot_object_code;
63: l_lss_pk lss_pk_csr%ROWTYPE;
64: l_lss_rec lss_rec_type;

Line 61: WHERE okc_line_style_sources.lse_id = p_lse_id

57: LAST_UPDATE_DATE,
58: END_DATE,
59: LAST_UPDATE_LOGIN
60: FROM Okc_Line_Style_Sources
61: WHERE okc_line_style_sources.lse_id = p_lse_id
62: AND okc_line_style_sources.jtot_object_code = p_jtot_object_code;
63: l_lss_pk lss_pk_csr%ROWTYPE;
64: l_lss_rec lss_rec_type;
65: BEGIN

Line 62: AND okc_line_style_sources.jtot_object_code = p_jtot_object_code;

58: END_DATE,
59: LAST_UPDATE_LOGIN
60: FROM Okc_Line_Style_Sources
61: WHERE okc_line_style_sources.lse_id = p_lse_id
62: AND okc_line_style_sources.jtot_object_code = p_jtot_object_code;
63: l_lss_pk lss_pk_csr%ROWTYPE;
64: l_lss_rec lss_rec_type;
65: BEGIN
66: x_no_data_found := TRUE;

Line 95: -- FUNCTION get_rec for: OKC_LINE_STYLE_SOURCES_V

91: BEGIN
92: RETURN(get_rec(p_lss_rec, l_row_notfound));
93: END get_rec;
94: ---------------------------------------------------------------------------
95: -- FUNCTION get_rec for: OKC_LINE_STYLE_SOURCES_V
96: ---------------------------------------------------------------------------
97: FUNCTION get_rec (
98: p_lssv_rec IN lssv_rec_type,
99: x_no_data_found OUT NOCOPY BOOLEAN

Line 115: FROM Okc_Line_Style_Sources

111: CREATION_DATE,
112: LAST_UPDATED_BY,
113: LAST_UPDATE_DATE,
114: LAST_UPDATE_LOGIN
115: FROM Okc_Line_Style_Sources
116: WHERE okc_line_style_sources.lse_id = p_lse_id
117: AND okc_line_style_sources.jtot_object_code = p_jtot_object_code;
118: l_okc_lssv_pk okc_lssv_pk_csr%ROWTYPE;
119: l_lssv_rec lssv_rec_type;

Line 116: WHERE okc_line_style_sources.lse_id = p_lse_id

112: LAST_UPDATED_BY,
113: LAST_UPDATE_DATE,
114: LAST_UPDATE_LOGIN
115: FROM Okc_Line_Style_Sources
116: WHERE okc_line_style_sources.lse_id = p_lse_id
117: AND okc_line_style_sources.jtot_object_code = p_jtot_object_code;
118: l_okc_lssv_pk okc_lssv_pk_csr%ROWTYPE;
119: l_lssv_rec lssv_rec_type;
120: BEGIN

Line 117: AND okc_line_style_sources.jtot_object_code = p_jtot_object_code;

113: LAST_UPDATE_DATE,
114: LAST_UPDATE_LOGIN
115: FROM Okc_Line_Style_Sources
116: WHERE okc_line_style_sources.lse_id = p_lse_id
117: AND okc_line_style_sources.jtot_object_code = p_jtot_object_code;
118: l_okc_lssv_pk okc_lssv_pk_csr%ROWTYPE;
119: l_lssv_rec lssv_rec_type;
120: BEGIN
121: x_no_data_found := TRUE;

Line 151: -- FUNCTION null_out_defaults for: OKC_LINE_STYLE_SOURCES_V --

147: RETURN(get_rec(p_lssv_rec, l_row_notfound));
148: END get_rec;
149:
150: --------------------------------------------------------------
151: -- FUNCTION null_out_defaults for: OKC_LINE_STYLE_SOURCES_V --
152: --------------------------------------------------------------
153: FUNCTION null_out_defaults (
154: p_lssv_rec IN lssv_rec_type
155: ) RETURN lssv_rec_type IS

Line 194: -- Validate_Attributes for:OKC_LINE_STYLE_SOURCES_V --

190: ---------------------------------------------------------------------------
191: -- PROCEDURE Validate_Attributes
192: ---------------------------------------------------------------------------
193: ------------------------------------------------------
194: -- Validate_Attributes for:OKC_LINE_STYLE_SOURCES_V --
195: ------------------------------------------------------
196: --**** Change from TAPI Code---follow till end of change---------------
197:
198:

Line 217: Cursor C1 is select start_date from okc_line_style_sources where lse_id=p_lssv_rec.lse_id

213: x_return_status VARCHAR2(1);
214: l_excp_error EXCEPTION;
215: l_row_found BOOLEAN:= FALSE;
216:
217: Cursor C1 is select start_date from okc_line_style_sources where lse_id=p_lssv_rec.lse_id
218: and end_date is null and jtot_object_code<>p_lssv_rec.jtot_object_code;
219:
220: Cursor C2(p_date IN date) is select start_date,nvl(end_date,p_date+1)
221: from OKC_LINE_STYLE_SOURCES where

Line 221: from OKC_LINE_STYLE_SOURCES where

217: Cursor C1 is select start_date from okc_line_style_sources where lse_id=p_lssv_rec.lse_id
218: and end_date is null and jtot_object_code<>p_lssv_rec.jtot_object_code;
219:
220: Cursor C2(p_date IN date) is select start_date,nvl(end_date,p_date+1)
221: from OKC_LINE_STYLE_SOURCES where
222: lse_id=p_lssv_rec.lse_id and jtot_object_code<>p_lssv_rec.jtot_object_code;
223:
224: BEGIN
225: IF (l_debug = 'Y') THEN

Line 311: ,'SOURCE','OKC_LINE_STYLE_SOURCES');

307: CLOSE C2;
308: END IF;
309: OKC_API.set_message(G_APP_NAME, G_TOO_MANY_SOURCES,'DATE',
310: fnd_date.date_to_chardate(l_date)
311: ,'SOURCE','OKC_LINE_STYLE_SOURCES');
312: return x_return_status;
313:
314: WHEN OTHERS THEN
315: -- store SQL error message on message stack for caller

Line 346: Cursor C1 is select start_date from okc_line_style_sources where lse_id=p_lssv_rec.lse_id

342: RETURN VARCHAR2 IS
343: l_date date:=OKC_API.G_MISS_DATE;
344: x_return_status VARCHAR2(1);
345: l_excp_error EXCEPTION;
346: Cursor C1 is select start_date from okc_line_style_sources where lse_id=p_lssv_rec.lse_id
347: and end_date is null;
348:
349: Cursor C2(p_date IN date) is select p_date from OKC_LINE_STYLE_SOURCES where
350: lse_id=p_lssv_rec.lse_id and jtot_object_code<>p_lssv_rec.jtot_object_code and

Line 349: Cursor C2(p_date IN date) is select p_date from OKC_LINE_STYLE_SOURCES where

345: l_excp_error EXCEPTION;
346: Cursor C1 is select start_date from okc_line_style_sources where lse_id=p_lssv_rec.lse_id
347: and end_date is null;
348:
349: Cursor C2(p_date IN date) is select p_date from OKC_LINE_STYLE_SOURCES where
350: lse_id=p_lssv_rec.lse_id and jtot_object_code<>p_lssv_rec.jtot_object_code and
351: trunc(p_date) between trunc(start_date) and trunc(nvl(end_date,p_date));
352:
353: Cursor C3(p_date IN date) is select start_date from OKC_LINE_STYLE_SOURCES where

Line 353: Cursor C3(p_date IN date) is select start_date from OKC_LINE_STYLE_SOURCES where

349: Cursor C2(p_date IN date) is select p_date from OKC_LINE_STYLE_SOURCES where
350: lse_id=p_lssv_rec.lse_id and jtot_object_code<>p_lssv_rec.jtot_object_code and
351: trunc(p_date) between trunc(start_date) and trunc(nvl(end_date,p_date));
352:
353: Cursor C3(p_date IN date) is select start_date from OKC_LINE_STYLE_SOURCES where
354: lse_id=p_lssv_rec.lse_id and jtot_object_code<>p_lssv_rec.jtot_object_code and
355: trunc(start_date) between trunc(p_date) and trunc(end_date);
356: BEGIN
357:

Line 398: ,'SOURCE','OKC_LINE_STYLE_SOURCES');

394: WHEN l_excp_error then
395: x_return_status:=OKC_API.G_RET_STS_ERROR;
396: OKC_API.set_message(G_APP_NAME, G_TOO_MANY_SOURCES,'DATE',
397: fnd_date.date_to_chardate(l_date)
398: ,'SOURCE','OKC_LINE_STYLE_SOURCES');
399: return x_return_status;
400:
401: WHEN OTHERS THEN
402: -- store SQL error message on message stack for caller

Line 724: -- Validate_Record for:OKC_LINE_STYLE_SOURCES_V --

720: ---------------------------------------------------------------------------
721: -- PROCEDURE Validate_Record
722: ---------------------------------------------------------------------------
723: -----------------------------------------------
724: -- Validate_Record for:OKC_LINE_STYLE_SOURCES_V --
725: -----------------------------------------------
726: FUNCTION Validate_Record (
727: p_lssv_rec IN lssv_rec_type
728: ) RETURN VARCHAR2 IS

Line 735: FROM okc_line_style_sources

731: -- To check for any matching row, for unique combination.
732: -- ------------------------------------------------------
733: CURSOR cur_lss IS
734: SELECT 'x'
735: FROM okc_line_style_sources
736: WHERE lse_id = p_lssv_rec.LSE_ID
737: AND jtot_object_code = p_lssv_rec.JTOT_OBJECT_CODE;
738:
739:

Line 742: FROM okc_line_style_sources

738:
739:
740: CURSOR cur_lss_1 IS
741: SELECT 'x'
742: FROM okc_line_style_sources
743: WHERE lse_id = p_lssv_rec.LSE_ID;
744:
745:
746: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 759: -- uniqueness for LSE_ID + JTOT_OBJECT_CODE in OKC_LINE_STYLE_SOURCES_V

755: -- ---------------------------------------------------------------------
756: -- Bug 1636056 related changes - Shyam
757: -- OKC_UTIL.check_comp_unique call is replaced with
758: -- the explicit cursors above, for identical function to check
759: -- uniqueness for LSE_ID + JTOT_OBJECT_CODE in OKC_LINE_STYLE_SOURCES_V
760: -- ---------------------------------------------------------------------
761: IF G_RECORD_STATUS = 'I' THEN
762: IF (l_debug = 'Y') THEN
763: okc_debug.log('100:invalidate_record',1);

Line 884: -- validate_row for:OKC_LINE_STYLE_SOURCES_V --

880: ---------------------------------------------------------------------------
881: -- PROCEDURE validate_row
882: ---------------------------------------------------------------------------
883: -----------------------------------------------
884: -- validate_row for:OKC_LINE_STYLE_SOURCES_V --
885: -----------------------------------------------
886: PROCEDURE validate_row(
887: p_api_version IN NUMBER,
888: p_init_msg_list IN VARCHAR2 ,

Line 1028: -- insert_row for:OKC_LINE_STYLE_SOURCES --

1024: ---------------------------------------------------------------------------
1025: -- PROCEDURE insert_row
1026: ---------------------------------------------------------------------------
1027: -------------------------------------------
1028: -- insert_row for:OKC_LINE_STYLE_SOURCES --
1029: -------------------------------------------
1030: PROCEDURE insert_row(
1031: p_init_msg_list IN VARCHAR2 ,
1032: x_return_status OUT NOCOPY VARCHAR2,

Line 1044: -- Set_Attributes for:OKC_LINE_STYLE_SOURCES --

1040: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1041: l_lss_rec lss_rec_type := p_lss_rec;
1042: l_def_lss_rec lss_rec_type;
1043: -----------------------------------------------
1044: -- Set_Attributes for:OKC_LINE_STYLE_SOURCES --
1045: -----------------------------------------------
1046: FUNCTION Set_Attributes (
1047: p_lss_rec IN lss_rec_type,
1048: x_lss_rec OUT NOCOPY lss_rec_type

Line 1079: INSERT INTO OKC_LINE_STYLE_SOURCES(

1075: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1076: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1077: RAISE OKC_API.G_EXCEPTION_ERROR;
1078: END IF;
1079: INSERT INTO OKC_LINE_STYLE_SOURCES(
1080: lse_id,
1081: jtot_object_code,
1082: start_date,
1083: object_version_number,

Line 1142: -- insert_row for:OKC_LINE_STYLE_SOURCES_V --

1138: okc_debug.reset_indentation;
1139: END IF;
1140: END insert_row;
1141: ---------------------------------------------
1142: -- insert_row for:OKC_LINE_STYLE_SOURCES_V --
1143: ---------------------------------------------
1144: PROCEDURE insert_row(
1145: p_api_version IN NUMBER,
1146: p_init_msg_list IN VARCHAR2 ,

Line 1176: -- Set_Attributes for:OKC_LINE_STYLE_SOURCES_V --

1172: l_lssv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1173: RETURN(l_lssv_rec);
1174: END fill_who_columns;
1175: -------------------------------------------------
1176: -- Set_Attributes for:OKC_LINE_STYLE_SOURCES_V --
1177: -------------------------------------------------
1178: FUNCTION Set_Attributes (
1179: p_lssv_rec IN lssv_rec_type,
1180: x_lssv_rec OUT NOCOPY lssv_rec_type

Line 1357: -- lock_row for:OKC_LINE_STYLE_SOURCES --

1353: ---------------------------------------------------------------------------
1354: -- PROCEDURE lock_row
1355: ---------------------------------------------------------------------------
1356: -----------------------------------------
1357: -- lock_row for:OKC_LINE_STYLE_SOURCES --
1358: -----------------------------------------
1359: PROCEDURE lock_row(
1360: p_init_msg_list IN VARCHAR2 ,
1361: x_return_status OUT NOCOPY VARCHAR2,

Line 1370: FROM OKC_LINE_STYLE_SOURCES

1366: E_Resource_Busy EXCEPTION;
1367: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1368: CURSOR lock_csr (p_lss_rec IN lss_rec_type) IS
1369: SELECT OBJECT_VERSION_NUMBER
1370: FROM OKC_LINE_STYLE_SOURCES
1371: WHERE LSE_ID = p_lss_rec.lse_id
1372: AND JTOT_OBJECT_CODE = p_lss_rec.jtot_object_code
1373: AND OBJECT_VERSION_NUMBER = p_lss_rec.object_version_number
1374: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 1378: FROM OKC_LINE_STYLE_SOURCES

1374: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1375:
1376: CURSOR lchk_csr (p_lss_rec IN lss_rec_type) IS
1377: SELECT OBJECT_VERSION_NUMBER
1378: FROM OKC_LINE_STYLE_SOURCES
1379: WHERE LSE_ID = p_lss_rec.lse_id
1380: AND JTOT_OBJECT_CODE = p_lss_rec.jtot_object_code;
1381: l_api_version CONSTANT NUMBER := 1;
1382: l_api_name CONSTANT VARCHAR2(30) := 'SOURCES_lock_row';

Line 1384: l_object_version_number OKC_LINE_STYLE_SOURCES.OBJECT_VERSION_NUMBER%TYPE;

1380: AND JTOT_OBJECT_CODE = p_lss_rec.jtot_object_code;
1381: l_api_version CONSTANT NUMBER := 1;
1382: l_api_name CONSTANT VARCHAR2(30) := 'SOURCES_lock_row';
1383: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1384: l_object_version_number OKC_LINE_STYLE_SOURCES.OBJECT_VERSION_NUMBER%TYPE;
1385: lc_object_version_number OKC_LINE_STYLE_SOURCES.OBJECT_VERSION_NUMBER%TYPE;
1386: l_row_notfound BOOLEAN := FALSE;
1387: lc_row_notfound BOOLEAN := FALSE;
1388: BEGIN

Line 1385: lc_object_version_number OKC_LINE_STYLE_SOURCES.OBJECT_VERSION_NUMBER%TYPE;

1381: l_api_version CONSTANT NUMBER := 1;
1382: l_api_name CONSTANT VARCHAR2(30) := 'SOURCES_lock_row';
1383: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1384: l_object_version_number OKC_LINE_STYLE_SOURCES.OBJECT_VERSION_NUMBER%TYPE;
1385: lc_object_version_number OKC_LINE_STYLE_SOURCES.OBJECT_VERSION_NUMBER%TYPE;
1386: l_row_notfound BOOLEAN := FALSE;
1387: lc_row_notfound BOOLEAN := FALSE;
1388: BEGIN
1389: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1465: -- lock_row for:OKC_LINE_STYLE_SOURCES_V --

1461: '_PVT'
1462: );
1463: END lock_row;
1464: -------------------------------------------
1465: -- lock_row for:OKC_LINE_STYLE_SOURCES_V --
1466: -------------------------------------------
1467: PROCEDURE lock_row(
1468: p_api_version IN NUMBER,
1469: p_init_msg_list IN VARCHAR2 ,

Line 1613: -- update_row for:OKC_LINE_STYLE_SOURCES --

1609: ---------------------------------------------------------------------------
1610: -- PROCEDURE update_row
1611: ---------------------------------------------------------------------------
1612: -------------------------------------------
1613: -- update_row for:OKC_LINE_STYLE_SOURCES --
1614: -------------------------------------------
1615: PROCEDURE update_row(
1616: p_init_msg_list IN VARCHAR2 ,
1617: x_return_status OUT NOCOPY VARCHAR2,

Line 1693: -- Set_Attributes for:OKC_LINE_STYLE_SOURCES --

1689: END IF;
1690: RETURN(l_return_status);
1691: END populate_new_record;
1692: -----------------------------------------------
1693: -- Set_Attributes for:OKC_LINE_STYLE_SOURCES --
1694: -----------------------------------------------
1695: FUNCTION Set_Attributes (
1696: p_lss_rec IN lss_rec_type,
1697: x_lss_rec OUT NOCOPY lss_rec_type

Line 1734: UPDATE OKC_LINE_STYLE_SOURCES

1730: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1731: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1732: RAISE OKC_API.G_EXCEPTION_ERROR;
1733: END IF;
1734: UPDATE OKC_LINE_STYLE_SOURCES
1735: SET START_DATE = l_def_lss_rec.start_date,
1736: OBJECT_VERSION_NUMBER = l_def_lss_rec.object_version_number,
1737: CREATED_BY = l_def_lss_rec.created_by,
1738: CREATION_DATE = l_def_lss_rec.creation_date,

Line 1785: -- update_row for:OKC_LINE_STYLE_SOURCES_V --

1781: okc_debug.reset_indentation;
1782: END IF;
1783: END update_row;
1784: ---------------------------------------------
1785: -- update_row for:OKC_LINE_STYLE_SOURCES_V --
1786: ---------------------------------------------
1787: PROCEDURE update_row(
1788: p_api_version IN NUMBER,
1789: p_init_msg_list IN VARCHAR2 ,

Line 1880: -- Set_Attributes for:OKC_LINE_STYLE_SOURCES_V --

1876: END IF;
1877: RETURN(l_return_status);
1878: END populate_new_record;
1879: -------------------------------------------------
1880: -- Set_Attributes for:OKC_LINE_STYLE_SOURCES_V --
1881: -------------------------------------------------
1882: FUNCTION Set_Attributes (
1883: p_lssv_rec IN lssv_rec_type,
1884: x_lssv_rec OUT NOCOPY lssv_rec_type

Line 2063: -- delete_row for:OKC_LINE_STYLE_SOURCES --

2059: ---------------------------------------------------------------------------
2060: -- PROCEDURE delete_row
2061: ---------------------------------------------------------------------------
2062: -------------------------------------------
2063: -- delete_row for:OKC_LINE_STYLE_SOURCES --
2064: -------------------------------------------
2065: PROCEDURE delete_row(
2066: p_init_msg_list IN VARCHAR2 ,
2067: x_return_status OUT NOCOPY VARCHAR2,

Line 2087: DELETE FROM OKC_LINE_STYLE_SOURCES

2083: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2084: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2085: RAISE OKC_API.G_EXCEPTION_ERROR;
2086: END IF;
2087: DELETE FROM OKC_LINE_STYLE_SOURCES
2088: WHERE LSE_ID = l_lss_rec.lse_id AND
2089: JTOT_OBJECT_CODE = l_lss_rec.jtot_object_code;
2090:
2091: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2125: -- delete_row for:OKC_LINE_STYLE_SOURCES_V --

2121: '_PVT'
2122: );
2123: END delete_row;
2124: ---------------------------------------------
2125: -- delete_row for:OKC_LINE_STYLE_SOURCES_V --
2126: ---------------------------------------------
2127: PROCEDURE delete_row(
2128: p_api_version IN NUMBER,
2129: p_init_msg_list IN VARCHAR2 ,