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_IVM_PVT dependencies on OKL_INVC_MSS_PRCDRS

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

Line 53: -- FUNCTION get_rec for: OKL_INVC_MSS_PRCDRS

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

Line 87: FROM Okl_Invc_Mss_Prcdrs

83: CREATION_DATE,
84: LAST_UPDATED_BY,
85: LAST_UPDATE_DATE,
86: LAST_UPDATE_LOGIN
87: FROM Okl_Invc_Mss_Prcdrs
88: WHERE okl_invc_mss_prcdrs.id = p_id;
89: l_ivm_pk ivm_pk_csr%ROWTYPE;
90: l_ivm_rec ivm_rec_type;
91: BEGIN

Line 88: WHERE okl_invc_mss_prcdrs.id = p_id;

84: LAST_UPDATED_BY,
85: LAST_UPDATE_DATE,
86: LAST_UPDATE_LOGIN
87: FROM Okl_Invc_Mss_Prcdrs
88: WHERE okl_invc_mss_prcdrs.id = p_id;
89: l_ivm_pk ivm_pk_csr%ROWTYPE;
90: l_ivm_rec ivm_rec_type;
91: BEGIN
92: x_no_data_found := TRUE;

Line 135: -- FUNCTION get_rec for: OKL_INVC_MSS_PRCDRS_V

131: BEGIN
132: RETURN(get_rec(p_ivm_rec, l_row_notfound));
133: END get_rec;
134: ---------------------------------------------------------------------------
135: -- FUNCTION get_rec for: OKL_INVC_MSS_PRCDRS_V
136: ---------------------------------------------------------------------------
137: FUNCTION get_rec (
138: p_ivmv_rec IN ivmv_rec_type,
139: x_no_data_found OUT NOCOPY BOOLEAN

Line 169: FROM Okl_Invc_Mss_Prcdrs_V

165: CREATION_DATE,
166: LAST_UPDATED_BY,
167: LAST_UPDATE_DATE,
168: LAST_UPDATE_LOGIN
169: FROM Okl_Invc_Mss_Prcdrs_V
170: WHERE okl_invc_mss_prcdrs_v.id = p_id;
171: l_okl_ivmv_pk okl_ivmv_pk_csr%ROWTYPE;
172: l_ivmv_rec ivmv_rec_type;
173: BEGIN

Line 170: WHERE okl_invc_mss_prcdrs_v.id = p_id;

166: LAST_UPDATED_BY,
167: LAST_UPDATE_DATE,
168: LAST_UPDATE_LOGIN
169: FROM Okl_Invc_Mss_Prcdrs_V
170: WHERE okl_invc_mss_prcdrs_v.id = p_id;
171: l_okl_ivmv_pk okl_ivmv_pk_csr%ROWTYPE;
172: l_ivmv_rec ivmv_rec_type;
173: BEGIN
174: x_no_data_found := TRUE;

Line 218: -- FUNCTION null_out_defaults for: OKL_INVC_MSS_PRCDRS_V --

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

Line 584: FROM okl_invc_mss_prcdrs_v

580: ) RETURN VARCHAR2 IS
581:
582: CURSOR l_ivmv_csr IS
583: SELECT 'x'
584: FROM okl_invc_mss_prcdrs_v
585: WHERE package_name = p_ivmv_rec.package_name
586: AND procedure_name = p_ivmv_rec.procedure_name
587: AND id <> nvl (p_ivmv_rec.id, -99999);
588:

Line 648: -- Validate_Attributes for:OKL_INVC_MSS_PRCDRS_V --

644: -- Post-Generation Change
645: -- By RDRAGUIL on 24-APR-2001
646: ---------------------------------------------------------------------------
647: ---------------------------------------------------
648: -- Validate_Attributes for:OKL_INVC_MSS_PRCDRS_V --
649: ---------------------------------------------------
650: FUNCTION Validate_Attributes (
651: p_ivmv_rec IN ivmv_rec_type
652: ) RETURN VARCHAR2 IS

Line 737: -- Validate_Record for:OKL_INVC_MSS_PRCDRS_V --

733: -- Post-Generation Change
734: -- By RDRAGUIL on 24-APR-2001
735: ---------------------------------------------------------------------------
736: -----------------------------------------------
737: -- Validate_Record for:OKL_INVC_MSS_PRCDRS_V --
738: -----------------------------------------------
739: FUNCTION Validate_Record (
740: p_ivmv_rec IN ivmv_rec_type
741: ) RETURN VARCHAR2 IS

Line 847: -- validate_row for:OKL_INVC_MSS_PRCDRS_V --

843: ---------------------------------------------------------------------------
844: -- PROCEDURE validate_row
845: ---------------------------------------------------------------------------
846: --------------------------------------------
847: -- validate_row for:OKL_INVC_MSS_PRCDRS_V --
848: --------------------------------------------
849: PROCEDURE validate_row(
850: p_api_version IN NUMBER,
851: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1008: -- insert_row for:OKL_INVC_MSS_PRCDRS --

1004: ---------------------------------------------------------------------------
1005: -- PROCEDURE insert_row
1006: ---------------------------------------------------------------------------
1007: ----------------------------------------
1008: -- insert_row for:OKL_INVC_MSS_PRCDRS --
1009: ----------------------------------------
1010: PROCEDURE insert_row(
1011: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1012: x_return_status OUT NOCOPY VARCHAR2,

Line 1024: -- Set_Attributes for:OKL_INVC_MSS_PRCDRS --

1020: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1021: l_ivm_rec ivm_rec_type := p_ivm_rec;
1022: l_def_ivm_rec ivm_rec_type;
1023: --------------------------------------------
1024: -- Set_Attributes for:OKL_INVC_MSS_PRCDRS --
1025: --------------------------------------------
1026: FUNCTION Set_Attributes (
1027: p_ivm_rec IN ivm_rec_type,
1028: x_ivm_rec OUT NOCOPY ivm_rec_type

Line 1055: INSERT INTO OKL_INVC_MSS_PRCDRS(

1051: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1052: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1053: RAISE OKL_API.G_EXCEPTION_ERROR;
1054: END IF;
1055: INSERT INTO OKL_INVC_MSS_PRCDRS(
1056: id,
1057: package_name,
1058: procedure_name,
1059: sequence_number,

Line 1145: -- insert_row for:OKL_INVC_MSS_PRCDRS_V --

1141: '_PVT'
1142: );
1143: END insert_row;
1144: ------------------------------------------
1145: -- insert_row for:OKL_INVC_MSS_PRCDRS_V --
1146: ------------------------------------------
1147: PROCEDURE insert_row(
1148: p_api_version IN NUMBER,
1149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1179: -- Set_Attributes for:OKL_INVC_MSS_PRCDRS_V --

1175: l_ivmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1176: RETURN(l_ivmv_rec);
1177: END fill_who_columns;
1178: ----------------------------------------------
1179: -- Set_Attributes for:OKL_INVC_MSS_PRCDRS_V --
1180: ----------------------------------------------
1181: FUNCTION Set_Attributes (
1182: p_ivmv_rec IN ivmv_rec_type,
1183: x_ivmv_rec OUT NOCOPY ivmv_rec_type

Line 1376: -- lock_row for:OKL_INVC_MSS_PRCDRS --

1372: ---------------------------------------------------------------------------
1373: -- PROCEDURE lock_row
1374: ---------------------------------------------------------------------------
1375: --------------------------------------
1376: -- lock_row for:OKL_INVC_MSS_PRCDRS --
1377: --------------------------------------
1378: PROCEDURE lock_row(
1379: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1380: x_return_status OUT NOCOPY VARCHAR2,

Line 1389: FROM OKL_INVC_MSS_PRCDRS

1385: E_Resource_Busy EXCEPTION;
1386: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1387: CURSOR lock_csr (p_ivm_rec IN ivm_rec_type) IS
1388: SELECT OBJECT_VERSION_NUMBER
1389: FROM OKL_INVC_MSS_PRCDRS
1390: WHERE ID = p_ivm_rec.id
1391: AND OBJECT_VERSION_NUMBER = p_ivm_rec.object_version_number
1392: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1393:

Line 1396: FROM OKL_INVC_MSS_PRCDRS

1392: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1393:
1394: CURSOR lchk_csr (p_ivm_rec IN ivm_rec_type) IS
1395: SELECT OBJECT_VERSION_NUMBER
1396: FROM OKL_INVC_MSS_PRCDRS
1397: WHERE ID = p_ivm_rec.id;
1398: l_api_version CONSTANT NUMBER := 1;
1399: l_api_name CONSTANT VARCHAR2(30) := 'PRCDRS_lock_row';
1400: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1401: l_object_version_number OKL_INVC_MSS_PRCDRS.OBJECT_VERSION_NUMBER%TYPE;

1397: WHERE ID = p_ivm_rec.id;
1398: l_api_version CONSTANT NUMBER := 1;
1399: l_api_name CONSTANT VARCHAR2(30) := 'PRCDRS_lock_row';
1400: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1401: l_object_version_number OKL_INVC_MSS_PRCDRS.OBJECT_VERSION_NUMBER%TYPE;
1402: lc_object_version_number OKL_INVC_MSS_PRCDRS.OBJECT_VERSION_NUMBER%TYPE;
1403: l_row_notfound BOOLEAN := FALSE;
1404: lc_row_notfound BOOLEAN := FALSE;
1405: BEGIN

Line 1402: lc_object_version_number OKL_INVC_MSS_PRCDRS.OBJECT_VERSION_NUMBER%TYPE;

1398: l_api_version CONSTANT NUMBER := 1;
1399: l_api_name CONSTANT VARCHAR2(30) := 'PRCDRS_lock_row';
1400: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1401: l_object_version_number OKL_INVC_MSS_PRCDRS.OBJECT_VERSION_NUMBER%TYPE;
1402: lc_object_version_number OKL_INVC_MSS_PRCDRS.OBJECT_VERSION_NUMBER%TYPE;
1403: l_row_notfound BOOLEAN := FALSE;
1404: lc_row_notfound BOOLEAN := FALSE;
1405: BEGIN
1406: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1482: -- lock_row for:OKL_INVC_MSS_PRCDRS_V --

1478: '_PVT'
1479: );
1480: END lock_row;
1481: ----------------------------------------
1482: -- lock_row for:OKL_INVC_MSS_PRCDRS_V --
1483: ----------------------------------------
1484: PROCEDURE lock_row(
1485: p_api_version IN NUMBER,
1486: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1647: -- update_row for:OKL_INVC_MSS_PRCDRS --

1643: ---------------------------------------------------------------------------
1644: -- PROCEDURE update_row
1645: ---------------------------------------------------------------------------
1646: ----------------------------------------
1647: -- update_row for:OKL_INVC_MSS_PRCDRS --
1648: ----------------------------------------
1649: PROCEDURE update_row(
1650: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1651: x_return_status OUT NOCOPY VARCHAR2,

Line 1787: -- Set_Attributes for:OKL_INVC_MSS_PRCDRS --

1783: END IF;
1784: RETURN(l_return_status);
1785: END populate_new_record;
1786: --------------------------------------------
1787: -- Set_Attributes for:OKL_INVC_MSS_PRCDRS --
1788: --------------------------------------------
1789: FUNCTION Set_Attributes (
1790: p_ivm_rec IN ivm_rec_type,
1791: x_ivm_rec OUT NOCOPY ivm_rec_type

Line 1824: UPDATE OKL_INVC_MSS_PRCDRS

1820: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1821: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1822: RAISE OKL_API.G_EXCEPTION_ERROR;
1823: END IF;
1824: UPDATE OKL_INVC_MSS_PRCDRS
1825: SET PACKAGE_NAME = l_def_ivm_rec.package_name,
1826: PROCEDURE_NAME = l_def_ivm_rec.procedure_name,
1827: SEQUENCE_NUMBER = l_def_ivm_rec.sequence_number,
1828: OBJECT_VERSION_NUMBER = l_def_ivm_rec.object_version_number,

Line 1887: -- update_row for:OKL_INVC_MSS_PRCDRS_V --

1883: '_PVT'
1884: );
1885: END update_row;
1886: ------------------------------------------
1887: -- update_row for:OKL_INVC_MSS_PRCDRS_V --
1888: ------------------------------------------
1889: PROCEDURE update_row(
1890: p_api_version IN NUMBER,
1891: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2042: -- Set_Attributes for:OKL_INVC_MSS_PRCDRS_V --

2038: END IF;
2039: RETURN(l_return_status);
2040: END populate_new_record;
2041: ----------------------------------------------
2042: -- Set_Attributes for:OKL_INVC_MSS_PRCDRS_V --
2043: ----------------------------------------------
2044: FUNCTION Set_Attributes (
2045: p_ivmv_rec IN ivmv_rec_type,
2046: x_ivmv_rec OUT NOCOPY ivmv_rec_type

Line 2242: -- delete_row for:OKL_INVC_MSS_PRCDRS --

2238: ---------------------------------------------------------------------------
2239: -- PROCEDURE delete_row
2240: ---------------------------------------------------------------------------
2241: ----------------------------------------
2242: -- delete_row for:OKL_INVC_MSS_PRCDRS --
2243: ----------------------------------------
2244: PROCEDURE delete_row(
2245: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2246: x_return_status OUT NOCOPY VARCHAR2,

Line 2266: DELETE FROM OKL_INVC_MSS_PRCDRS

2262: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2263: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2264: RAISE OKL_API.G_EXCEPTION_ERROR;
2265: END IF;
2266: DELETE FROM OKL_INVC_MSS_PRCDRS
2267: WHERE ID = l_ivm_rec.id;
2268:
2269: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2270: EXCEPTION

Line 2303: -- delete_row for:OKL_INVC_MSS_PRCDRS_V --

2299: '_PVT'
2300: );
2301: END delete_row;
2302: ------------------------------------------
2303: -- delete_row for:OKL_INVC_MSS_PRCDRS_V --
2304: ------------------------------------------
2305: PROCEDURE delete_row(
2306: p_api_version IN NUMBER,
2307: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,