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_CMG_PVT dependencies on OKL_CONDITION_MSSGS

Line 17: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_CONDITION_MSSGS_V';

13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
14: G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
15:
16: --GLOBAL VARIABLES
17: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_CONDITION_MSSGS_V';
18: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
19:
20: ---------------------------------------------------------------------------
21: -- FUNCTION get_seq_id

Line 53: -- FUNCTION get_rec for: OKL_CONDITION_MSSGS

49: null;
50: END api_copy;
51:
52: ---------------------------------------------------------------------------
53: -- FUNCTION get_rec for: OKL_CONDITION_MSSGS
54: ---------------------------------------------------------------------------
55: FUNCTION get_rec (
56: p_cmg_rec IN cmg_rec_type,
57: x_no_data_found OUT NOCOPY BOOLEAN

Line 87: FROM Okl_Condition_Mssgs

83: CREATION_DATE,
84: LAST_UPDATED_BY,
85: LAST_UPDATE_DATE,
86: LAST_UPDATE_LOGIN
87: FROM Okl_Condition_Mssgs
88: WHERE okl_condition_mssgs.id = p_id;
89: l_cmg_pk cmg_pk_csr%ROWTYPE;
90: l_cmg_rec cmg_rec_type;
91: BEGIN

Line 88: WHERE okl_condition_mssgs.id = p_id;

84: LAST_UPDATED_BY,
85: LAST_UPDATE_DATE,
86: LAST_UPDATE_LOGIN
87: FROM Okl_Condition_Mssgs
88: WHERE okl_condition_mssgs.id = p_id;
89: l_cmg_pk cmg_pk_csr%ROWTYPE;
90: l_cmg_rec cmg_rec_type;
91: BEGIN
92: x_no_data_found := TRUE;

Line 135: -- FUNCTION get_rec for: OKL_CONDITION_MSSGS_V

131: BEGIN
132: RETURN(get_rec(p_cmg_rec, l_row_notfound));
133: END get_rec;
134: ---------------------------------------------------------------------------
135: -- FUNCTION get_rec for: OKL_CONDITION_MSSGS_V
136: ---------------------------------------------------------------------------
137: FUNCTION get_rec (
138: p_cmgv_rec IN cmgv_rec_type,
139: x_no_data_found OUT NOCOPY BOOLEAN

Line 169: FROM Okl_Condition_Mssgs_V

165: CREATION_DATE,
166: LAST_UPDATED_BY,
167: LAST_UPDATE_DATE,
168: LAST_UPDATE_LOGIN
169: FROM Okl_Condition_Mssgs_V
170: WHERE okl_condition_mssgs_v.id = p_id;
171: l_okl_cmgv_pk okl_cmgv_pk_csr%ROWTYPE;
172: l_cmgv_rec cmgv_rec_type;
173: BEGIN

Line 170: WHERE okl_condition_mssgs_v.id = p_id;

166: LAST_UPDATED_BY,
167: LAST_UPDATE_DATE,
168: LAST_UPDATE_LOGIN
169: FROM Okl_Condition_Mssgs_V
170: WHERE okl_condition_mssgs_v.id = p_id;
171: l_okl_cmgv_pk okl_cmgv_pk_csr%ROWTYPE;
172: l_cmgv_rec cmgv_rec_type;
173: BEGIN
174: x_no_data_found := TRUE;

Line 218: -- FUNCTION null_out_defaults for: OKL_CONDITION_MSSGS_V --

214: RETURN(get_rec(p_cmgv_rec, l_row_notfound));
215: END get_rec;
216:
217: -----------------------------------------------------------
218: -- FUNCTION null_out_defaults for: OKL_CONDITION_MSSGS_V --
219: -----------------------------------------------------------
220: FUNCTION null_out_defaults (
221: p_cmgv_rec IN cmgv_rec_type
222: ) RETURN cmgv_rec_type IS

Line 467: p_token2_value => 'OKL_CONDITION_MSSGS_V',

463: p_msg_name => G_NO_PARENT_RECORD,
464: p_token1 => G_COL_NAME_TOKEN,
465: p_token1_value => 'ims_id',
466: p_token2 => G_CHILD_TABLE_TOKEN,
467: p_token2_value => 'OKL_CONDITION_MSSGS_V',
468: p_token3 => G_PARENT_TABLE_TOKEN,
469: p_token3_value => 'OKL_INVOICE_MSSGS_V');
470:
471: -- notify caller of en error

Line 556: p_token2_value => 'OKL_CONDITION_MSSGS_V',

552: p_msg_name => G_NO_PARENT_RECORD,
553: p_token1 => G_COL_NAME_TOKEN,
554: p_token1_value => 'ivm_id',
555: p_token2 => G_CHILD_TABLE_TOKEN,
556: p_token2_value => 'OKL_CONDITION_MSSGS_V',
557: p_token3 => G_PARENT_TABLE_TOKEN,
558: p_token3_value => 'OKL_INVC_MSS_PRCDRS_V');
559:
560: -- notify caller of en error

Line 600: FROM okl_condition_mssgs_v

596: ) RETURN VARCHAR2 IS
597:
598: CURSOR l_cmgv_csr IS
599: SELECT 'x'
600: FROM okl_condition_mssgs_v
601: WHERE ims_id = p_cmgv_rec.ims_id
602: AND ivm_id = p_cmgv_rec.ivm_id
603: AND id <> nvl (p_cmgv_rec.id, -99999);
604:

Line 664: -- Validate_Attributes for:OKL_CONDITION_MSSGS_V --

660: -- Post-Generation Change
661: -- By RDRAGUIL on 24-APR-2001
662: ---------------------------------------------------------------------------
663: ---------------------------------------------------
664: -- Validate_Attributes for:OKL_CONDITION_MSSGS_V --
665: ---------------------------------------------------
666: FUNCTION Validate_Attributes (
667: p_cmgv_rec IN cmgv_rec_type
668: ) RETURN VARCHAR2 IS

Line 743: -- Validate_Record for:OKL_CONDITION_MSSGS_V --

739: -- Post-Generation Change
740: -- By RDRAGUIL on 24-APR-2001
741: ---------------------------------------------------------------------------
742: -----------------------------------------------
743: -- Validate_Record for:OKL_CONDITION_MSSGS_V --
744: -----------------------------------------------
745: FUNCTION Validate_Record (
746: p_cmgv_rec IN cmgv_rec_type
747: ) RETURN VARCHAR2 IS

Line 853: -- validate_row for:OKL_CONDITION_MSSGS_V --

849: ---------------------------------------------------------------------------
850: -- PROCEDURE validate_row
851: ---------------------------------------------------------------------------
852: --------------------------------------------
853: -- validate_row for:OKL_CONDITION_MSSGS_V --
854: --------------------------------------------
855: PROCEDURE validate_row(
856: p_api_version IN NUMBER,
857: p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false,

Line 1016: -- insert_row for:OKL_CONDITION_MSSGS --

1012: ---------------------------------------------------------------------------
1013: -- PROCEDURE insert_row
1014: ---------------------------------------------------------------------------
1015: ----------------------------------------
1016: -- insert_row for:OKL_CONDITION_MSSGS --
1017: ----------------------------------------
1018: PROCEDURE insert_row(
1019: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1020: x_return_status OUT NOCOPY VARCHAR2,

Line 1032: -- Set_Attributes for:OKL_CONDITION_MSSGS --

1028: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1029: l_cmg_rec cmg_rec_type := p_cmg_rec;
1030: l_def_cmg_rec cmg_rec_type;
1031: --------------------------------------------
1032: -- Set_Attributes for:OKL_CONDITION_MSSGS --
1033: --------------------------------------------
1034: FUNCTION Set_Attributes (
1035: p_cmg_rec IN cmg_rec_type,
1036: x_cmg_rec OUT NOCOPY cmg_rec_type

Line 1063: INSERT INTO OKL_CONDITION_MSSGS(

1059: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1060: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1061: RAISE OKL_API.G_EXCEPTION_ERROR;
1062: END IF;
1063: INSERT INTO OKL_CONDITION_MSSGS(
1064: id,
1065: ims_id,
1066: ivm_id,
1067: object_version_number,

Line 1153: -- insert_row for:OKL_CONDITION_MSSGS_V --

1149: '_PVT'
1150: );
1151: END insert_row;
1152: ------------------------------------------
1153: -- insert_row for:OKL_CONDITION_MSSGS_V --
1154: ------------------------------------------
1155: PROCEDURE insert_row(
1156: p_api_version IN NUMBER,
1157: p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false,

Line 1188: -- Set_Attributes for:OKL_CONDITION_MSSGS_V --

1184: l_cmgv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1185: RETURN(l_cmgv_rec);
1186: END fill_who_columns;
1187: ----------------------------------------------
1188: -- Set_Attributes for:OKL_CONDITION_MSSGS_V --
1189: ----------------------------------------------
1190: FUNCTION Set_Attributes (
1191: p_cmgv_rec IN cmgv_rec_type,
1192: x_cmgv_rec OUT NOCOPY cmgv_rec_type

Line 1386: -- lock_row for:OKL_CONDITION_MSSGS --

1382: ---------------------------------------------------------------------------
1383: -- PROCEDURE lock_row
1384: ---------------------------------------------------------------------------
1385: --------------------------------------
1386: -- lock_row for:OKL_CONDITION_MSSGS --
1387: --------------------------------------
1388: PROCEDURE lock_row(
1389: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1390: x_return_status OUT NOCOPY VARCHAR2,

Line 1399: FROM OKL_CONDITION_MSSGS

1395: E_Resource_Busy EXCEPTION;
1396: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1397: CURSOR lock_csr (p_cmg_rec IN cmg_rec_type) IS
1398: SELECT OBJECT_VERSION_NUMBER
1399: FROM OKL_CONDITION_MSSGS
1400: WHERE ID = p_cmg_rec.id
1401: AND OBJECT_VERSION_NUMBER = p_cmg_rec.object_version_number
1402: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1403:

Line 1406: FROM OKL_CONDITION_MSSGS

1402: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1403:
1404: CURSOR lchk_csr (p_cmg_rec IN cmg_rec_type) IS
1405: SELECT OBJECT_VERSION_NUMBER
1406: FROM OKL_CONDITION_MSSGS
1407: WHERE ID = p_cmg_rec.id;
1408: l_api_version CONSTANT NUMBER := 1;
1409: l_api_name CONSTANT VARCHAR2(30) := 'MSSGS_lock_row';
1410: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1411: l_object_version_number OKL_CONDITION_MSSGS.OBJECT_VERSION_NUMBER%TYPE;

1407: WHERE ID = p_cmg_rec.id;
1408: l_api_version CONSTANT NUMBER := 1;
1409: l_api_name CONSTANT VARCHAR2(30) := 'MSSGS_lock_row';
1410: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1411: l_object_version_number OKL_CONDITION_MSSGS.OBJECT_VERSION_NUMBER%TYPE;
1412: lc_object_version_number OKL_CONDITION_MSSGS.OBJECT_VERSION_NUMBER%TYPE;
1413: l_row_notfound BOOLEAN := FALSE;
1414: lc_row_notfound BOOLEAN := FALSE;
1415: BEGIN

Line 1412: lc_object_version_number OKL_CONDITION_MSSGS.OBJECT_VERSION_NUMBER%TYPE;

1408: l_api_version CONSTANT NUMBER := 1;
1409: l_api_name CONSTANT VARCHAR2(30) := 'MSSGS_lock_row';
1410: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1411: l_object_version_number OKL_CONDITION_MSSGS.OBJECT_VERSION_NUMBER%TYPE;
1412: lc_object_version_number OKL_CONDITION_MSSGS.OBJECT_VERSION_NUMBER%TYPE;
1413: l_row_notfound BOOLEAN := FALSE;
1414: lc_row_notfound BOOLEAN := FALSE;
1415: BEGIN
1416: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1492: -- lock_row for:OKL_CONDITION_MSSGS_V --

1488: '_PVT'
1489: );
1490: END lock_row;
1491: ----------------------------------------
1492: -- lock_row for:OKL_CONDITION_MSSGS_V --
1493: ----------------------------------------
1494: PROCEDURE lock_row(
1495: p_api_version IN NUMBER,
1496: p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false,

Line 1659: -- update_row for:OKL_CONDITION_MSSGS --

1655: ---------------------------------------------------------------------------
1656: -- PROCEDURE update_row
1657: ---------------------------------------------------------------------------
1658: ----------------------------------------
1659: -- update_row for:OKL_CONDITION_MSSGS --
1660: ----------------------------------------
1661: PROCEDURE update_row(
1662: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1663: x_return_status OUT NOCOPY VARCHAR2,

Line 1799: -- Set_Attributes for:OKL_CONDITION_MSSGS --

1795: END IF;
1796: RETURN(l_return_status);
1797: END populate_new_record;
1798: --------------------------------------------
1799: -- Set_Attributes for:OKL_CONDITION_MSSGS --
1800: --------------------------------------------
1801: FUNCTION Set_Attributes (
1802: p_cmg_rec IN cmg_rec_type,
1803: x_cmg_rec OUT NOCOPY cmg_rec_type

Line 1836: UPDATE OKL_CONDITION_MSSGS

1832: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1833: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1834: RAISE OKL_API.G_EXCEPTION_ERROR;
1835: END IF;
1836: UPDATE OKL_CONDITION_MSSGS
1837: SET IMS_ID = l_def_cmg_rec.ims_id,
1838: IVM_ID = l_def_cmg_rec.ivm_id,
1839: OBJECT_VERSION_NUMBER = l_def_cmg_rec.object_version_number,
1840: SEQUENCE_NUMBER = l_def_cmg_rec.sequence_number,

Line 1899: -- update_row for:OKL_CONDITION_MSSGS_V --

1895: '_PVT'
1896: );
1897: END update_row;
1898: ------------------------------------------
1899: -- update_row for:OKL_CONDITION_MSSGS_V --
1900: ------------------------------------------
1901: PROCEDURE update_row(
1902: p_api_version IN NUMBER,
1903: p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false,

Line 2055: -- Set_Attributes for:OKL_CONDITION_MSSGS_V --

2051: END IF;
2052: RETURN(l_return_status);
2053: END populate_new_record;
2054: ----------------------------------------------
2055: -- Set_Attributes for:OKL_CONDITION_MSSGS_V --
2056: ----------------------------------------------
2057: FUNCTION Set_Attributes (
2058: p_cmgv_rec IN cmgv_rec_type,
2059: x_cmgv_rec OUT NOCOPY cmgv_rec_type

Line 2256: -- delete_row for:OKL_CONDITION_MSSGS --

2252: ---------------------------------------------------------------------------
2253: -- PROCEDURE delete_row
2254: ---------------------------------------------------------------------------
2255: ----------------------------------------
2256: -- delete_row for:OKL_CONDITION_MSSGS --
2257: ----------------------------------------
2258: PROCEDURE delete_row(
2259: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2260: x_return_status OUT NOCOPY VARCHAR2,

Line 2280: DELETE FROM OKL_CONDITION_MSSGS

2276: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2277: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2278: RAISE OKL_API.G_EXCEPTION_ERROR;
2279: END IF;
2280: DELETE FROM OKL_CONDITION_MSSGS
2281: WHERE ID = l_cmg_rec.id;
2282:
2283: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2284: EXCEPTION

Line 2317: -- delete_row for:OKL_CONDITION_MSSGS_V --

2313: '_PVT'
2314: );
2315: END delete_row;
2316: ------------------------------------------
2317: -- delete_row for:OKL_CONDITION_MSSGS_V --
2318: ------------------------------------------
2319: PROCEDURE delete_row(
2320: p_api_version IN NUMBER,
2321: p_init_msg_list IN VARCHAR2 DEFAULT okc_api.g_false,