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_MRB_PVT dependencies on OKL_MASS_RBK_CRITERIA

Line 36: -- FUNCTION get_rec for: OKL_MASS_RBK_CRITERIA_V

32: null;
33: END api_copy;
34:
35: ---------------------------------------------------------------------------
36: -- FUNCTION get_rec for: OKL_MASS_RBK_CRITERIA_V
37: ---------------------------------------------------------------------------
38: FUNCTION get_rec (
39: p_mrbv_rec IN mrbv_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN

Line 76: FROM Okl_Mass_Rbk_Criteria_V

72: CREATION_DATE,
73: LAST_UPDATED_BY,
74: LAST_UPDATE_DATE,
75: LAST_UPDATE_LOGIN
76: FROM Okl_Mass_Rbk_Criteria_V
77: WHERE okl_mass_rbk_criteria_v.id = p_id;
78: l_okl_mrbv_pk okl_mrbv_pk_csr%ROWTYPE;
79: l_mrbv_rec mrbv_rec_type;
80: BEGIN

Line 77: WHERE okl_mass_rbk_criteria_v.id = p_id;

73: LAST_UPDATED_BY,
74: LAST_UPDATE_DATE,
75: LAST_UPDATE_LOGIN
76: FROM Okl_Mass_Rbk_Criteria_V
77: WHERE okl_mass_rbk_criteria_v.id = p_id;
78: l_okl_mrbv_pk okl_mrbv_pk_csr%ROWTYPE;
79: l_mrbv_rec mrbv_rec_type;
80: BEGIN
81: x_no_data_found := TRUE;

Line 151: -- FUNCTION get_rec for: OKL_MASS_RBK_CRITERIA

147: BEGIN
148: RETURN(get_rec(p_mrbv_rec, l_row_not_found));
149: END get_rec;
150: ---------------------------------------------------------------------------
151: -- FUNCTION get_rec for: OKL_MASS_RBK_CRITERIA
152: ---------------------------------------------------------------------------
153: FUNCTION get_rec (
154: p_mrb_rec IN mrb_rec_type,
155: x_no_data_found OUT NOCOPY BOOLEAN

Line 191: FROM Okl_Mass_Rbk_Criteria

187: CREATION_DATE,
188: LAST_UPDATED_BY,
189: LAST_UPDATE_DATE,
190: LAST_UPDATE_LOGIN
191: FROM Okl_Mass_Rbk_Criteria
192: WHERE okl_mass_rbk_criteria.id = p_id;
193: l_okl_mass_rbk_pk okl_mass_rbk_pk_csr%ROWTYPE;
194: l_mrb_rec mrb_rec_type;
195: BEGIN

Line 192: WHERE okl_mass_rbk_criteria.id = p_id;

188: LAST_UPDATED_BY,
189: LAST_UPDATE_DATE,
190: LAST_UPDATE_LOGIN
191: FROM Okl_Mass_Rbk_Criteria
192: WHERE okl_mass_rbk_criteria.id = p_id;
193: l_okl_mass_rbk_pk okl_mass_rbk_pk_csr%ROWTYPE;
194: l_mrb_rec mrb_rec_type;
195: BEGIN
196: x_no_data_found := TRUE;

Line 266: -- FUNCTION null_out_defaults for: OKL_MASS_RBK_CRITERIA_V

262: BEGIN
263: RETURN(get_rec(p_mrb_rec, l_row_not_found));
264: END get_rec;
265: ---------------------------------------------------------------------------
266: -- FUNCTION null_out_defaults for: OKL_MASS_RBK_CRITERIA_V
267: ---------------------------------------------------------------------------
268: FUNCTION null_out_defaults (
269: p_mrbv_rec IN mrbv_rec_type
270: ) RETURN mrbv_rec_type IS

Line 402: -- Validate_Attributes for:OKL_MASS_RBK_CRITERIA_V --

398: ---------------------------------------------------------------------------
399: -- FUNCTION Validate_Attributes
400: ---------------------------------------------------------------------------
401: -----------------------------------------------------
402: -- Validate_Attributes for:OKL_MASS_RBK_CRITERIA_V --
403: -----------------------------------------------------
404: FUNCTION Validate_Attributes (
405: p_mrbv_rec IN mrbv_rec_type
406: ) RETURN VARCHAR2 IS

Line 440: -- Validate Record for:OKL_MASS_RBK_CRITERIA_V --

436: ---------------------------------------------------------------------------
437: -- PROCEDURE Validate_Record
438: ---------------------------------------------------------------------------
439: -------------------------------------------------
440: -- Validate Record for:OKL_MASS_RBK_CRITERIA_V --
441: -------------------------------------------------
442: FUNCTION Validate_Record (
443: p_mrbv_rec IN mrbv_rec_type,
444: p_db_mrbv_rec IN mrbv_rec_type

Line 544: -- validate_row for:OKL_MASS_RBK_CRITERIA_V --

540: ---------------------------------------------------------------------------
541: -- PROCEDURE validate_row
542: ---------------------------------------------------------------------------
543: ----------------------------------------------
544: -- validate_row for:OKL_MASS_RBK_CRITERIA_V --
545: ----------------------------------------------
546: PROCEDURE validate_row(
547: p_api_version IN NUMBER,
548: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 621: -- PL/SQL TBL validate_row for:OKL_MASS_RBK_CRITERIA_V --

617: '_PVT'
618: );
619: END validate_row;
620: ---------------------------------------------------------
621: -- PL/SQL TBL validate_row for:OKL_MASS_RBK_CRITERIA_V --
622: ---------------------------------------------------------
623: PROCEDURE validate_row(
624: p_api_version IN NUMBER,
625: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 701: -- insert_row for:OKL_MASS_RBK_CRITERIA --

697: ---------------------------------------------------------------------------
698: -- PROCEDURE insert_row
699: ---------------------------------------------------------------------------
700: ------------------------------------------
701: -- insert_row for:OKL_MASS_RBK_CRITERIA --
702: ------------------------------------------
703: PROCEDURE insert_row(
704: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
705: x_return_status OUT NOCOPY VARCHAR2,

Line 717: -- Set_Attributes for:OKL_MASS_RBK_CRITERIA --

713: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
714: l_mrb_rec mrb_rec_type := p_mrb_rec;
715: l_def_mrb_rec mrb_rec_type;
716: ----------------------------------------------
717: -- Set_Attributes for:OKL_MASS_RBK_CRITERIA --
718: ----------------------------------------------
719: FUNCTION Set_Attributes (
720: p_mrb_rec IN mrb_rec_type,
721: x_mrb_rec OUT NOCOPY mrb_rec_type

Line 748: INSERT INTO OKL_MASS_RBK_CRITERIA(

744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
745: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
746: RAISE OKL_API.G_EXCEPTION_ERROR;
747: END IF;
748: INSERT INTO OKL_MASS_RBK_CRITERIA(
749: id,
750: request_name,
751: line_number,
752: rbr_code,

Line 851: -- insert_row for :OKL_MASS_RBK_CRITERIA_V --

847: '_PVT'
848: );
849: END insert_row;
850: ---------------------------------------------
851: -- insert_row for :OKL_MASS_RBK_CRITERIA_V --
852: ---------------------------------------------
853: PROCEDURE insert_row(
854: p_api_version IN NUMBER,
855: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 885: -- Set_Attributes for:OKL_MASS_RBK_CRITERIA_V --

881: l_mrbv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
882: RETURN(l_mrbv_rec);
883: END fill_who_columns;
884: ------------------------------------------------
885: -- Set_Attributes for:OKL_MASS_RBK_CRITERIA_V --
886: ------------------------------------------------
887: FUNCTION Set_Attributes (
888: p_mrbv_rec IN mrbv_rec_type,
889: x_mrbv_rec OUT NOCOPY mrbv_rec_type

Line 1076: -- lock_row for:OKL_MASS_RBK_CRITERIA --

1072: ---------------------------------------------------------------------------
1073: -- PROCEDURE lock_row
1074: ---------------------------------------------------------------------------
1075: ----------------------------------------
1076: -- lock_row for:OKL_MASS_RBK_CRITERIA --
1077: ----------------------------------------
1078: PROCEDURE lock_row(
1079: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1080: x_return_status OUT NOCOPY VARCHAR2,

Line 1089: FROM OKL_MASS_RBK_CRITERIA

1085: E_Resource_Busy EXCEPTION;
1086: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1087: CURSOR lock_csr (p_mrb_rec IN mrb_rec_type) IS
1088: SELECT *
1089: FROM OKL_MASS_RBK_CRITERIA
1090: WHERE ID = p_mrb_rec.id
1091: FOR UPDATE NOWAIT;
1092:
1093: l_api_version CONSTANT NUMBER := 1;

Line 1291: -- lock_row for: OKL_MASS_RBK_CRITERIA_V --

1287: '_PVT'
1288: );
1289: END lock_row;
1290: -------------------------------------------
1291: -- lock_row for: OKL_MASS_RBK_CRITERIA_V --
1292: -------------------------------------------
1293: PROCEDURE lock_row(
1294: p_api_version IN NUMBER,
1295: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1449: -- update_row for:OKL_MASS_RBK_CRITERIA --

1445: ---------------------------------------------------------------------------
1446: -- PROCEDURE update_row
1447: ---------------------------------------------------------------------------
1448: ------------------------------------------
1449: -- update_row for:OKL_MASS_RBK_CRITERIA --
1450: ------------------------------------------
1451: PROCEDURE update_row(
1452: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1453: x_return_status OUT NOCOPY VARCHAR2,

Line 1612: -- Set_Attributes for:OKL_MASS_RBK_CRITERIA --

1608: END IF;
1609: RETURN(l_return_status);
1610: END populate_new_record;
1611: ----------------------------------------------
1612: -- Set_Attributes for:OKL_MASS_RBK_CRITERIA --
1613: ----------------------------------------------
1614: FUNCTION Set_Attributes (
1615: p_mrb_rec IN mrb_rec_type,
1616: x_mrb_rec OUT NOCOPY mrb_rec_type

Line 1649: UPDATE OKL_MASS_RBK_CRITERIA

1645: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1646: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1647: RAISE OKL_API.G_EXCEPTION_ERROR;
1648: END IF;
1649: UPDATE OKL_MASS_RBK_CRITERIA
1650: SET REQUEST_NAME = l_def_mrb_rec.request_name,
1651: LINE_NUMBER = l_def_mrb_rec.line_number,
1652: RBR_CODE = l_def_mrb_rec.rbr_code,
1653: CRITERIA_CODE = l_def_mrb_rec.criteria_code,

Line 1719: -- update_row for:OKL_MASS_RBK_CRITERIA_V --

1715: '_PVT'
1716: );
1717: END update_row;
1718: --------------------------------------------
1719: -- update_row for:OKL_MASS_RBK_CRITERIA_V --
1720: --------------------------------------------
1721: PROCEDURE update_row(
1722: p_api_version IN NUMBER,
1723: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1899: -- Set_Attributes for:OKL_MASS_RBK_CRITERIA_V --

1895: END IF;
1896: RETURN(l_return_status);
1897: END populate_new_record;
1898: ------------------------------------------------
1899: -- Set_Attributes for:OKL_MASS_RBK_CRITERIA_V --
1900: ------------------------------------------------
1901: FUNCTION Set_Attributes (
1902: p_mrbv_rec IN mrbv_rec_type,
1903: x_mrbv_rec OUT NOCOPY mrbv_rec_type

Line 2091: -- delete_row for:OKL_MASS_RBK_CRITERIA --

2087: ---------------------------------------------------------------------------
2088: -- PROCEDURE delete_row
2089: ---------------------------------------------------------------------------
2090: ------------------------------------------
2091: -- delete_row for:OKL_MASS_RBK_CRITERIA --
2092: ------------------------------------------
2093: PROCEDURE delete_row(
2094: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2095: x_return_status OUT NOCOPY VARCHAR2,

Line 2116: DELETE FROM OKL_MASS_RBK_CRITERIA

2112: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2113: RAISE OKL_API.G_EXCEPTION_ERROR;
2114: END IF;
2115:
2116: DELETE FROM OKL_MASS_RBK_CRITERIA
2117: WHERE ID = p_mrb_rec.id;
2118:
2119: x_return_status := l_return_status;
2120: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2154: -- delete_row for:OKL_MASS_RBK_CRITERIA_V --

2150: '_PVT'
2151: );
2152: END delete_row;
2153: --------------------------------------------
2154: -- delete_row for:OKL_MASS_RBK_CRITERIA_V --
2155: --------------------------------------------
2156: PROCEDURE delete_row(
2157: p_api_version IN NUMBER,
2158: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2236: -- PL/SQL TBL delete_row for:OKL_MASS_RBK_CRITERIA_V --

2232: '_PVT'
2233: );
2234: END delete_row;
2235: -------------------------------------------------------
2236: -- PL/SQL TBL delete_row for:OKL_MASS_RBK_CRITERIA_V --
2237: -------------------------------------------------------
2238: PROCEDURE delete_row(
2239: p_api_version IN NUMBER,
2240: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,