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_IMA_PVT dependencies on OKL_INV_MSSG_ATT

Line 17: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_INV_MSSG_ATT_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_INV_MSSG_ATT_V';
18: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
19:
20: ---------------------------------------------------------------------------
21: -- FUNCTION get_seq_id

Line 53: -- FUNCTION get_rec for: OKL_INV_MSSG_ATT

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

Line 86: FROM Okl_Inv_Mssg_Att

82: CREATION_DATE,
83: LAST_UPDATED_BY,
84: LAST_UPDATE_DATE,
85: LAST_UPDATE_LOGIN
86: FROM Okl_Inv_Mssg_Att
87: WHERE okl_inv_mssg_att.id = p_id;
88: l_ima_pk ima_pk_csr%ROWTYPE;
89: l_ima_rec ima_rec_type;
90: BEGIN

Line 87: WHERE okl_inv_mssg_att.id = p_id;

83: LAST_UPDATED_BY,
84: LAST_UPDATE_DATE,
85: LAST_UPDATE_LOGIN
86: FROM Okl_Inv_Mssg_Att
87: WHERE okl_inv_mssg_att.id = p_id;
88: l_ima_pk ima_pk_csr%ROWTYPE;
89: l_ima_rec ima_rec_type;
90: BEGIN
91: x_no_data_found := TRUE;

Line 133: -- FUNCTION get_rec for: OKL_INV_MSSG_ATT_V

129: BEGIN
130: RETURN(get_rec(p_ima_rec, l_row_notfound));
131: END get_rec;
132: ---------------------------------------------------------------------------
133: -- FUNCTION get_rec for: OKL_INV_MSSG_ATT_V
134: ---------------------------------------------------------------------------
135: FUNCTION get_rec (
136: p_imav_rec IN imav_rec_type,
137: x_no_data_found OUT NOCOPY BOOLEAN

Line 166: FROM Okl_Inv_Mssg_Att_V

162: CREATION_DATE,
163: LAST_UPDATED_BY,
164: LAST_UPDATE_DATE,
165: LAST_UPDATE_LOGIN
166: FROM Okl_Inv_Mssg_Att_V
167: WHERE okl_inv_mssg_att_v.id = p_id;
168: l_okl_imav_pk okl_imav_pk_csr%ROWTYPE;
169: l_imav_rec imav_rec_type;
170: BEGIN

Line 167: WHERE okl_inv_mssg_att_v.id = p_id;

163: LAST_UPDATED_BY,
164: LAST_UPDATE_DATE,
165: LAST_UPDATE_LOGIN
166: FROM Okl_Inv_Mssg_Att_V
167: WHERE okl_inv_mssg_att_v.id = p_id;
168: l_okl_imav_pk okl_imav_pk_csr%ROWTYPE;
169: l_imav_rec imav_rec_type;
170: BEGIN
171: x_no_data_found := TRUE;

Line 214: -- FUNCTION null_out_defaults for: OKL_INV_MSSG_ATT_V --

210: RETURN(get_rec(p_imav_rec, l_row_notfound));
211: END get_rec;
212:
213: --------------------------------------------------------
214: -- FUNCTION null_out_defaults for: OKL_INV_MSSG_ATT_V --
215: --------------------------------------------------------
216: FUNCTION null_out_defaults (
217: p_imav_rec IN imav_rec_type
218: ) RETURN imav_rec_type IS

Line 592: FROM okl_inv_mssg_att_v

588: ) RETURN VARCHAR2 IS
589:
590: CURSOR l_imav_csr IS
591: SELECT 'x'
592: FROM okl_inv_mssg_att_v
593: WHERE ims_id = p_imav_rec.ims_id
594: AND cnr_id = p_imav_rec.cnr_id
595: AND id <> nvl (p_imav_rec.id, -99999);
596:

Line 656: -- Validate_Attributes for:OKL_INV_MSSG_ATT_V --

652: -- Post-Generation Change
653: -- By RDRAGUIL on 24-APR-2001
654: ---------------------------------------------------------------------------
655: ---------------------------------------------------
656: -- Validate_Attributes for:OKL_INV_MSSG_ATT_V --
657: ---------------------------------------------------
658: FUNCTION Validate_Attributes (
659: p_imav_rec IN imav_rec_type
660: ) RETURN VARCHAR2 IS

Line 735: -- Validate_Record for:OKL_INV_MSSG_ATT_V --

731: -- Post-Generation Change
732: -- By RDRAGUIL on 24-APR-2001
733: ---------------------------------------------------------------------------
734: -----------------------------------------------
735: -- Validate_Record for:OKL_INV_MSSG_ATT_V --
736: -----------------------------------------------
737: FUNCTION Validate_Record (
738: p_imav_rec IN imav_rec_type
739: ) RETURN VARCHAR2 IS

Line 843: -- validate_row for:OKL_INV_MSSG_ATT_V --

839: ---------------------------------------------------------------------------
840: -- PROCEDURE validate_row
841: ---------------------------------------------------------------------------
842: -----------------------------------------
843: -- validate_row for:OKL_INV_MSSG_ATT_V --
844: -----------------------------------------
845: PROCEDURE validate_row(
846: p_api_version IN NUMBER,
847: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1004: -- insert_row for:OKL_INV_MSSG_ATT --

1000: ---------------------------------------------------------------------------
1001: -- PROCEDURE insert_row
1002: ---------------------------------------------------------------------------
1003: -------------------------------------
1004: -- insert_row for:OKL_INV_MSSG_ATT --
1005: -------------------------------------
1006: PROCEDURE insert_row(
1007: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1008: x_return_status OUT NOCOPY VARCHAR2,

Line 1020: -- Set_Attributes for:OKL_INV_MSSG_ATT --

1016: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1017: l_ima_rec ima_rec_type := p_ima_rec;
1018: l_def_ima_rec ima_rec_type;
1019: -----------------------------------------
1020: -- Set_Attributes for:OKL_INV_MSSG_ATT --
1021: -----------------------------------------
1022: FUNCTION Set_Attributes (
1023: p_ima_rec IN ima_rec_type,
1024: x_ima_rec OUT NOCOPY ima_rec_type

Line 1051: INSERT INTO OKL_INV_MSSG_ATT(

1047: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1048: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1049: RAISE OKL_API.G_EXCEPTION_ERROR;
1050: END IF;
1051: INSERT INTO OKL_INV_MSSG_ATT(
1052: id,
1053: cnr_id,
1054: ims_id,
1055: object_version_number,

Line 1139: -- insert_row for:OKL_INV_MSSG_ATT_V --

1135: '_PVT'
1136: );
1137: END insert_row;
1138: ---------------------------------------
1139: -- insert_row for:OKL_INV_MSSG_ATT_V --
1140: ---------------------------------------
1141: PROCEDURE insert_row(
1142: p_api_version IN NUMBER,
1143: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1173: -- Set_Attributes for:OKL_INV_MSSG_ATT_V --

1169: l_imav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1170: RETURN(l_imav_rec);
1171: END fill_who_columns;
1172: -------------------------------------------
1173: -- Set_Attributes for:OKL_INV_MSSG_ATT_V --
1174: -------------------------------------------
1175: FUNCTION Set_Attributes (
1176: p_imav_rec IN imav_rec_type,
1177: x_imav_rec OUT NOCOPY imav_rec_type

Line 1370: -- lock_row for:OKL_INV_MSSG_ATT --

1366: ---------------------------------------------------------------------------
1367: -- PROCEDURE lock_row
1368: ---------------------------------------------------------------------------
1369: -----------------------------------
1370: -- lock_row for:OKL_INV_MSSG_ATT --
1371: -----------------------------------
1372: PROCEDURE lock_row(
1373: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1374: x_return_status OUT NOCOPY VARCHAR2,

Line 1383: FROM OKL_INV_MSSG_ATT

1379: E_Resource_Busy EXCEPTION;
1380: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1381: CURSOR lock_csr (p_ima_rec IN ima_rec_type) IS
1382: SELECT OBJECT_VERSION_NUMBER
1383: FROM OKL_INV_MSSG_ATT
1384: WHERE ID = p_ima_rec.id
1385: AND OBJECT_VERSION_NUMBER = p_ima_rec.object_version_number
1386: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1387:

Line 1390: FROM OKL_INV_MSSG_ATT

1386: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1387:
1388: CURSOR lchk_csr (p_ima_rec IN ima_rec_type) IS
1389: SELECT OBJECT_VERSION_NUMBER
1390: FROM OKL_INV_MSSG_ATT
1391: WHERE ID = p_ima_rec.id;
1392: l_api_version CONSTANT NUMBER := 1;
1393: l_api_name CONSTANT VARCHAR2(30) := 'ATT_lock_row';
1394: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1395: l_object_version_number OKL_INV_MSSG_ATT.OBJECT_VERSION_NUMBER%TYPE;

1391: WHERE ID = p_ima_rec.id;
1392: l_api_version CONSTANT NUMBER := 1;
1393: l_api_name CONSTANT VARCHAR2(30) := 'ATT_lock_row';
1394: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1395: l_object_version_number OKL_INV_MSSG_ATT.OBJECT_VERSION_NUMBER%TYPE;
1396: lc_object_version_number OKL_INV_MSSG_ATT.OBJECT_VERSION_NUMBER%TYPE;
1397: l_row_notfound BOOLEAN := FALSE;
1398: lc_row_notfound BOOLEAN := FALSE;
1399: BEGIN

Line 1396: lc_object_version_number OKL_INV_MSSG_ATT.OBJECT_VERSION_NUMBER%TYPE;

1392: l_api_version CONSTANT NUMBER := 1;
1393: l_api_name CONSTANT VARCHAR2(30) := 'ATT_lock_row';
1394: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1395: l_object_version_number OKL_INV_MSSG_ATT.OBJECT_VERSION_NUMBER%TYPE;
1396: lc_object_version_number OKL_INV_MSSG_ATT.OBJECT_VERSION_NUMBER%TYPE;
1397: l_row_notfound BOOLEAN := FALSE;
1398: lc_row_notfound BOOLEAN := FALSE;
1399: BEGIN
1400: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1476: -- lock_row for:OKL_INV_MSSG_ATT_V --

1472: '_PVT'
1473: );
1474: END lock_row;
1475: -------------------------------------
1476: -- lock_row for:OKL_INV_MSSG_ATT_V --
1477: -------------------------------------
1478: PROCEDURE lock_row(
1479: p_api_version IN NUMBER,
1480: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1641: -- update_row for:OKL_INV_MSSG_ATT --

1637: ---------------------------------------------------------------------------
1638: -- PROCEDURE update_row
1639: ---------------------------------------------------------------------------
1640: -------------------------------------
1641: -- update_row for:OKL_INV_MSSG_ATT --
1642: -------------------------------------
1643: PROCEDURE update_row(
1644: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1645: x_return_status OUT NOCOPY VARCHAR2,

Line 1777: -- Set_Attributes for:OKL_INV_MSSG_ATT --

1773: END IF;
1774: RETURN(l_return_status);
1775: END populate_new_record;
1776: -----------------------------------------
1777: -- Set_Attributes for:OKL_INV_MSSG_ATT --
1778: -----------------------------------------
1779: FUNCTION Set_Attributes (
1780: p_ima_rec IN ima_rec_type,
1781: x_ima_rec OUT NOCOPY ima_rec_type

Line 1814: UPDATE OKL_INV_MSSG_ATT

1810: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1811: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1812: RAISE OKL_API.G_EXCEPTION_ERROR;
1813: END IF;
1814: UPDATE OKL_INV_MSSG_ATT
1815: SET CNR_ID = l_def_ima_rec.cnr_id,
1816: IMS_ID = l_def_ima_rec.ims_id,
1817: OBJECT_VERSION_NUMBER = l_def_ima_rec.object_version_number,
1818: ATTRIBUTE_CATEGORY = l_def_ima_rec.attribute_category,

Line 1876: -- update_row for:OKL_INV_MSSG_ATT_V --

1872: '_PVT'
1873: );
1874: END update_row;
1875: ---------------------------------------
1876: -- update_row for:OKL_INV_MSSG_ATT_V --
1877: ---------------------------------------
1878: PROCEDURE update_row(
1879: p_api_version IN NUMBER,
1880: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2027: -- Set_Attributes for:OKL_INV_MSSG_ATT_V --

2023: END IF;
2024: RETURN(l_return_status);
2025: END populate_new_record;
2026: -------------------------------------------
2027: -- Set_Attributes for:OKL_INV_MSSG_ATT_V --
2028: -------------------------------------------
2029: FUNCTION Set_Attributes (
2030: p_imav_rec IN imav_rec_type,
2031: x_imav_rec OUT NOCOPY imav_rec_type

Line 2227: -- delete_row for:OKL_INV_MSSG_ATT --

2223: ---------------------------------------------------------------------------
2224: -- PROCEDURE delete_row
2225: ---------------------------------------------------------------------------
2226: -------------------------------------
2227: -- delete_row for:OKL_INV_MSSG_ATT --
2228: -------------------------------------
2229: PROCEDURE delete_row(
2230: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2231: x_return_status OUT NOCOPY VARCHAR2,

Line 2251: DELETE FROM OKL_INV_MSSG_ATT

2247: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2248: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2249: RAISE OKL_API.G_EXCEPTION_ERROR;
2250: END IF;
2251: DELETE FROM OKL_INV_MSSG_ATT
2252: WHERE ID = l_ima_rec.id;
2253:
2254: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2255: EXCEPTION

Line 2288: -- delete_row for:OKL_INV_MSSG_ATT_V --

2284: '_PVT'
2285: );
2286: END delete_row;
2287: ---------------------------------------
2288: -- delete_row for:OKL_INV_MSSG_ATT_V --
2289: ---------------------------------------
2290: PROCEDURE delete_row(
2291: p_api_version IN NUMBER,
2292: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,