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_IPM_PVT dependencies on OKL_TRX_PARAMS_B

Line 94: -- FUNCTION get_rec for: OKL_TRX_PARAMS_B

90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_TRX_PARAMS_B
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_ipm_rec IN ipm_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 100: CURSOR okl_trx_params_b_pk_csr (p_id IN NUMBER) IS

96: FUNCTION get_rec (
97: p_ipm_rec IN ipm_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN ipm_rec_type IS
100: CURSOR okl_trx_params_b_pk_csr (p_id IN NUMBER) IS
101: SELECT
102: ID,
103: SOURCE_TABLE,
104: SOURCE_ID,

Line 112: FROM Okl_Trx_Params_B

108: CREATION_DATE,
109: LAST_UPDATED_BY,
110: LAST_UPDATE_DATE,
111: LAST_UPDATE_LOGIN
112: FROM Okl_Trx_Params_B
113: WHERE okl_trx_params_b.id = p_id;
114: l_okl_trx_params_b_pk okl_trx_params_b_pk_csr%ROWTYPE;
115: l_ipm_rec ipm_rec_type;
116: BEGIN

Line 113: WHERE okl_trx_params_b.id = p_id;

109: LAST_UPDATED_BY,
110: LAST_UPDATE_DATE,
111: LAST_UPDATE_LOGIN
112: FROM Okl_Trx_Params_B
113: WHERE okl_trx_params_b.id = p_id;
114: l_okl_trx_params_b_pk okl_trx_params_b_pk_csr%ROWTYPE;
115: l_ipm_rec ipm_rec_type;
116: BEGIN
117: x_no_data_found := TRUE;

Line 114: l_okl_trx_params_b_pk okl_trx_params_b_pk_csr%ROWTYPE;

110: LAST_UPDATE_DATE,
111: LAST_UPDATE_LOGIN
112: FROM Okl_Trx_Params_B
113: WHERE okl_trx_params_b.id = p_id;
114: l_okl_trx_params_b_pk okl_trx_params_b_pk_csr%ROWTYPE;
115: l_ipm_rec ipm_rec_type;
116: BEGIN
117: x_no_data_found := TRUE;
118: -- Get current database values

Line 119: OPEN okl_trx_params_b_pk_csr (p_ipm_rec.id);

115: l_ipm_rec ipm_rec_type;
116: BEGIN
117: x_no_data_found := TRUE;
118: -- Get current database values
119: OPEN okl_trx_params_b_pk_csr (p_ipm_rec.id);
120: FETCH okl_trx_params_b_pk_csr INTO
121: l_ipm_rec.id,
122: l_ipm_rec.source_table,
123: l_ipm_rec.source_id,

Line 120: FETCH okl_trx_params_b_pk_csr INTO

116: BEGIN
117: x_no_data_found := TRUE;
118: -- Get current database values
119: OPEN okl_trx_params_b_pk_csr (p_ipm_rec.id);
120: FETCH okl_trx_params_b_pk_csr INTO
121: l_ipm_rec.id,
122: l_ipm_rec.source_table,
123: l_ipm_rec.source_id,
124: l_ipm_rec.param_name,

Line 131: x_no_data_found := okl_trx_params_b_pk_csr%NOTFOUND;

127: l_ipm_rec.creation_date,
128: l_ipm_rec.last_updated_by,
129: l_ipm_rec.last_update_date,
130: l_ipm_rec.last_update_login;
131: x_no_data_found := okl_trx_params_b_pk_csr%NOTFOUND;
132: CLOSE okl_trx_params_b_pk_csr;
133: RETURN(l_ipm_rec);
134: END get_rec;
135:

Line 132: CLOSE okl_trx_params_b_pk_csr;

128: l_ipm_rec.last_updated_by,
129: l_ipm_rec.last_update_date,
130: l_ipm_rec.last_update_login;
131: x_no_data_found := okl_trx_params_b_pk_csr%NOTFOUND;
132: CLOSE okl_trx_params_b_pk_csr;
133: RETURN(l_ipm_rec);
134: END get_rec;
135:
136: ------------------------------------------------------------------

Line 165: -- FUNCTION null_out_defaults for: OKL_TRX_PARAMS_B

161: BEGIN
162: RETURN(get_rec(p_ipm_rec, l_row_not_found));
163: END get_rec;
164: ---------------------------------------------------------------------------
165: -- FUNCTION null_out_defaults for: OKL_TRX_PARAMS_B
166: ---------------------------------------------------------------------------
167: FUNCTION null_out_defaults (
168: p_ipm_rec IN ipm_rec_type
169: ) RETURN ipm_rec_type IS

Line 351: -- Validate_Attributes for:OKL_TRX_PARAMS_B --

347: ---------------------------------------------------------------------------
348: -- FUNCTION Validate_Attributes
349: ---------------------------------------------------------------------------
350: ----------------------------------------------
351: -- Validate_Attributes for:OKL_TRX_PARAMS_B --
352: ----------------------------------------------
353: FUNCTION Validate_Attributes (
354: p_ipm_rec IN ipm_rec_type
355: ) RETURN VARCHAR2 IS

Line 422: -- Validate Record for:OKL_TRX_PARAMS_B --

418: ---------------------------------------------------------------------------
419: -- PROCEDURE Validate_Record
420: ---------------------------------------------------------------------------
421: ------------------------------------------
422: -- Validate Record for:OKL_TRX_PARAMS_B --
423: ------------------------------------------
424: FUNCTION Validate_Record (
425: p_ipm_rec IN ipm_rec_type,
426: p_db_ipm_rec IN ipm_rec_type

Line 466: -- validate_row for:OKL_TRX_PARAMS_B --

462: ---------------------------------------------------------------------------
463: -- PROCEDURE validate_row
464: ---------------------------------------------------------------------------
465: ---------------------------------------
466: -- validate_row for:OKL_TRX_PARAMS_B --
467: ---------------------------------------
468: PROCEDURE validate_row(
469: p_api_version IN NUMBER,
470: p_init_msg_list IN VARCHAR2,

Line 541: -- PL/SQL TBL validate_row for:OKL_TRX_PARAMS_B --

537: '_PVT'
538: );
539: END validate_row;
540: --------------------------------------------------
541: -- PL/SQL TBL validate_row for:OKL_TRX_PARAMS_B --
542: --------------------------------------------------
543: PROCEDURE validate_row(
544: p_api_version IN NUMBER,
545: p_init_msg_list IN VARCHAR2,

Line 637: -- PL/SQL TBL validate_row for:OKL_TRX_PARAMS_B --

633: );
634: END validate_row;
635:
636: --------------------------------------------------
637: -- PL/SQL TBL validate_row for:OKL_TRX_PARAMS_B --
638: --------------------------------------------------
639: PROCEDURE validate_row(
640: p_api_version IN NUMBER,
641: p_init_msg_list IN VARCHAR2,

Line 702: -- insert_row for:OKL_TRX_PARAMS_B --

698: ---------------------------------------------------------------------------
699: -- PROCEDURE insert_row
700: ---------------------------------------------------------------------------
701: -------------------------------------
702: -- insert_row for:OKL_TRX_PARAMS_B --
703: -------------------------------------
704: PROCEDURE insert_row(
705: p_api_version IN NUMBER,
706: p_init_msg_list IN VARCHAR2,

Line 736: -- Set_Attributes for:OKL_TRX_PARAMS_B --

732: -- dbms_output.put_line('created_by1 : '||to_char(l_ipm_rec.CREATED_BY));
733: RETURN(l_ipm_rec);
734: END fill_who_columns;
735: -----------------------------------------
736: -- Set_Attributes for:OKL_TRX_PARAMS_B --
737: -----------------------------------------
738: FUNCTION Set_Attributes (
739: p_ipm_rec IN ipm_rec_type,
740: x_ipm_rec OUT NOCOPY ipm_rec_type

Line 794: INSERT INTO OKL_TRX_PARAMS_B(

790: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
791: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
792: RAISE OKC_API.G_EXCEPTION_ERROR;
793: END IF;
794: INSERT INTO OKL_TRX_PARAMS_B(
795: id,
796: source_table,
797: source_id,
798: param_name,

Line 933: -- lock_row for:OKL_TRX_PARAMS_B --

929: ---------------------------------------------------------------------------
930: -- PROCEDURE lock_row
931: ---------------------------------------------------------------------------
932: -----------------------------------
933: -- lock_row for:OKL_TRX_PARAMS_B --
934: -----------------------------------
935: PROCEDURE lock_row(
936: p_init_msg_list IN VARCHAR2,
937: x_return_status OUT NOCOPY VARCHAR2,

Line 946: FROM OKL_TRX_PARAMS_B

942: E_Resource_Busy EXCEPTION;
943: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
944: CURSOR lock_csr (p_ipm_rec IN ipm_rec_type) IS
945: SELECT *
946: FROM OKL_TRX_PARAMS_B
947: WHERE ID = p_ipm_rec.id
948: FOR UPDATE NOWAIT;
949:
950: l_api_version CONSTANT NUMBER := 1;

Line 1060: -- lock_row for: OKL_TRX_PARAMS_B --

1056: '_PVT'
1057: );
1058: END lock_row;
1059: ------------------------------------
1060: -- lock_row for: OKL_TRX_PARAMS_B --
1061: ------------------------------------
1062: PROCEDURE lock_row(
1063: p_api_version IN NUMBER,
1064: p_init_msg_list IN VARCHAR2,

Line 1300: -- update_row for:OKL_TRX_PARAMS_B --

1296: ---------------------------------------------------------------------------
1297: -- PROCEDURE update_row
1298: ---------------------------------------------------------------------------
1299: -------------------------------------
1300: -- update_row for:OKL_TRX_PARAMS_B --
1301: -------------------------------------
1302: PROCEDURE update_row(
1303: p_init_msg_list IN VARCHAR2,
1304: x_return_status OUT NOCOPY VARCHAR2,

Line 1375: -- Set_Attributes for:OKL_TRX_PARAMS_B --

1371: END IF;
1372: RETURN(l_return_status);
1373: END populate_new_record;
1374: -----------------------------------------
1375: -- Set_Attributes for:OKL_TRX_PARAMS_B --
1376: -----------------------------------------
1377: FUNCTION Set_Attributes (
1378: p_ipm_rec IN ipm_rec_type,
1379: x_ipm_rec OUT NOCOPY ipm_rec_type

Line 1412: UPDATE OKL_TRX_PARAMS_B

1408: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1409: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1410: RAISE OKC_API.G_EXCEPTION_ERROR;
1411: END IF;
1412: UPDATE OKL_TRX_PARAMS_B
1413: SET SOURCE_TABLE = l_def_ipm_rec.source_table,
1414: SOURCE_ID = l_def_ipm_rec.source_id,
1415: PARAM_NAME = l_def_ipm_rec.param_name,
1416: PARAM_VALUE = l_def_ipm_rec.param_value,

Line 1460: -- update_row for:OKL_TRX_PARAMS_B --

1456: '_PVT'
1457: );
1458: END update_row;
1459: -------------------------------------
1460: -- update_row for:OKL_TRX_PARAMS_B --
1461: -------------------------------------
1462: PROCEDURE update_row(
1463: p_api_version IN NUMBER,
1464: p_init_msg_list IN VARCHAR2,

Line 1551: -- Set_Attributes for:OKL_TRX_PARAMS_B --

1547: END IF;
1548: RETURN(l_return_status);
1549: END populate_new_record;
1550: -----------------------------------------
1551: -- Set_Attributes for:OKL_TRX_PARAMS_B --
1552: -----------------------------------------
1553: FUNCTION Set_Attributes (
1554: p_ipm_rec IN ipm_rec_type,
1555: x_ipm_rec OUT NOCOPY ipm_rec_type

Line 1843: -- delete_row for:OKL_TRX_PARAMS_B --

1839: ---------------------------------------------------------------------------
1840: -- PROCEDURE delete_row
1841: ---------------------------------------------------------------------------
1842: -------------------------------------
1843: -- delete_row for:OKL_TRX_PARAMS_B --
1844: -------------------------------------
1845: PROCEDURE delete_row(
1846: p_init_msg_list IN VARCHAR2,
1847: x_return_status OUT NOCOPY VARCHAR2,

Line 1868: DELETE FROM OKL_TRX_PARAMS_B

1864: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1865: RAISE OKC_API.G_EXCEPTION_ERROR;
1866: END IF;
1867:
1868: DELETE FROM OKL_TRX_PARAMS_B
1869: WHERE ID = p_ipm_rec.id;
1870:
1871: x_return_status := l_return_status;
1872: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1906: -- delete_row for:OKL_TRX_PARAMS_B --

1902: '_PVT'
1903: );
1904: END delete_row;
1905: -------------------------------------
1906: -- delete_row for:OKL_TRX_PARAMS_B --
1907: -------------------------------------
1908: PROCEDURE delete_row(
1909: p_api_version IN NUMBER,
1910: p_init_msg_list IN VARCHAR2,

Line 1987: -- PL/SQL TBL delete_row for:OKL_TRX_PARAMS_B --

1983: '_PVT'
1984: );
1985: END delete_row;
1986: ------------------------------------------------
1987: -- PL/SQL TBL delete_row for:OKL_TRX_PARAMS_B --
1988: ------------------------------------------------
1989: PROCEDURE delete_row(
1990: p_api_version IN NUMBER,
1991: p_init_msg_list IN VARCHAR2,

Line 2083: -- PL/SQL TBL delete_row for:OKL_TRX_PARAMS_B --

2079: );
2080: END delete_row;
2081:
2082: ------------------------------------------------
2083: -- PL/SQL TBL delete_row for:OKL_TRX_PARAMS_B --
2084: ------------------------------------------------
2085: PROCEDURE delete_row(
2086: p_api_version IN NUMBER,
2087: p_init_msg_list IN VARCHAR2,