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_DRS_PVT dependencies on OKL_DISB_RULE_STY_TYPES

Line 66: CURSOR c_pk_csr IS SELECT okl_disb_rule_sty_types_s.NEXTVAL FROM DUAL;

62: -- FUNCTION get_seq_id
63: ---------------------------------------------------------------------------
64: FUNCTION get_seq_id RETURN NUMBER IS
65: l_pk_value NUMBER;
66: CURSOR c_pk_csr IS SELECT okl_disb_rule_sty_types_s.NEXTVAL FROM DUAL;
67: BEGIN
68: /* Fetch the pk value from the sequence */
69: OPEN c_pk_csr;
70: FETCH c_pk_csr INTO l_pk_value;

Line 100: -- FUNCTION get_rec for: OKL_DISB_RULE_STY_TYPES

96: null;
97: END api_copy;
98:
99: ---------------------------------------------------------------------------
100: -- FUNCTION get_rec for: OKL_DISB_RULE_STY_TYPES
101: ---------------------------------------------------------------------------
102: FUNCTION get_rec (
103: p_drs_rec IN drs_rec_type,
104: x_no_data_found OUT NOCOPY BOOLEAN

Line 133: FROM Okl_Disb_Rule_Sty_Types

129: CREATION_DATE,
130: LAST_UPDATED_BY,
131: LAST_UPDATE_DATE,
132: LAST_UPDATE_LOGIN
133: FROM Okl_Disb_Rule_Sty_Types
134: WHERE okl_disb_rule_sty_types.disb_rule_sty_type_id = p_disb_rule_sty_type_id;
135: l_okl_drs_pk okl_drs_pk_csr%ROWTYPE;
136: l_drs_rec drs_rec_type;
137: BEGIN

Line 134: WHERE okl_disb_rule_sty_types.disb_rule_sty_type_id = p_disb_rule_sty_type_id;

130: LAST_UPDATED_BY,
131: LAST_UPDATE_DATE,
132: LAST_UPDATE_LOGIN
133: FROM Okl_Disb_Rule_Sty_Types
134: WHERE okl_disb_rule_sty_types.disb_rule_sty_type_id = p_disb_rule_sty_type_id;
135: l_okl_drs_pk okl_drs_pk_csr%ROWTYPE;
136: l_drs_rec drs_rec_type;
137: BEGIN
138: x_no_data_found := TRUE;

Line 201: -- FUNCTION null_out_defaults for: OKL_DISB_RULE_STY_TYPES

197: BEGIN
198: RETURN(get_rec(p_drs_rec, l_row_not_found));
199: END get_rec;
200: ---------------------------------------------------------------------------
201: -- FUNCTION null_out_defaults for: OKL_DISB_RULE_STY_TYPES
202: ---------------------------------------------------------------------------
203: FUNCTION null_out_defaults (
204: p_drs_rec IN drs_rec_type
205: ) RETURN drs_rec_type IS

Line 389: -- Validate_Attributes for:OKL_DISB_RULE_STY_TYPES --

385: ---------------------------------------------------------------------------
386: -- FUNCTION Validate_Attributes
387: ---------------------------------------------------------------------------
388: -----------------------------------------------------
389: -- Validate_Attributes for:OKL_DISB_RULE_STY_TYPES --
390: -----------------------------------------------------
391: FUNCTION Validate_Attributes (
392: p_drs_rec IN drs_rec_type
393: ) RETURN VARCHAR2 IS

Line 454: -- Validate Record for:OKL_DISB_RULE_STY_TYPES --

450: ---------------------------------------------------------------------------
451: -- PROCEDURE Validate_Record
452: ---------------------------------------------------------------------------
453: -------------------------------------------------
454: -- Validate Record for:OKL_DISB_RULE_STY_TYPES --
455: -------------------------------------------------
456: FUNCTION Validate_Record (
457: p_drs_rec IN drs_rec_type,
458: p_db_drs_rec IN drs_rec_type

Line 482: -- validate_row for:OKL_DISB_RULE_STY_TYPES --

478: ---------------------------------------------------------------------------
479: -- PROCEDURE validate_row
480: ---------------------------------------------------------------------------
481: ----------------------------------------------
482: -- validate_row for:OKL_DISB_RULE_STY_TYPES --
483: ----------------------------------------------
484: PROCEDURE validate_row(
485: p_api_version IN NUMBER,
486: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 557: -- PL/SQL TBL validate_row for:OKL_DISB_RULE_STY_TYPES --

553: '_PVT'
554: );
555: END validate_row;
556: ---------------------------------------------------------
557: -- PL/SQL TBL validate_row for:OKL_DISB_RULE_STY_TYPES --
558: ---------------------------------------------------------
559: PROCEDURE validate_row(
560: p_api_version IN NUMBER,
561: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 653: -- PL/SQL TBL validate_row for:OKL_DISB_RULE_STY_TYPES --

649: );
650: END validate_row;
651:
652: ---------------------------------------------------------
653: -- PL/SQL TBL validate_row for:OKL_DISB_RULE_STY_TYPES --
654: ---------------------------------------------------------
655: PROCEDURE validate_row(
656: p_api_version IN NUMBER,
657: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 718: -- insert_row for:OKL_DISB_RULE_STY_TYPES --

714: ---------------------------------------------------------------------------
715: -- PROCEDURE insert_row
716: ---------------------------------------------------------------------------
717: --------------------------------------------
718: -- insert_row for:OKL_DISB_RULE_STY_TYPES --
719: --------------------------------------------
720: PROCEDURE insert_row(
721: p_api_version IN NUMBER,
722: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 750: -- Set_Attributes for:OKL_DISB_RULE_STY_TYPES --

746: l_drs_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
747: RETURN(l_drs_rec);
748: END fill_who_columns;
749: ------------------------------------------------
750: -- Set_Attributes for:OKL_DISB_RULE_STY_TYPES --
751: ------------------------------------------------
752: FUNCTION Set_Attributes (
753: p_drs_rec IN drs_rec_type,
754: x_drs_rec OUT NOCOPY drs_rec_type

Line 803: INSERT INTO OKL_DISB_RULE_STY_TYPES(

799: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
800: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_ERROR;
802: END IF;
803: INSERT INTO OKL_DISB_RULE_STY_TYPES(
804: disb_rule_sty_type_id,
805: object_version_number,
806: disb_rule_id,
807: stream_type_purpose,

Line 1056: -- lock_row for:OKL_DISB_RULE_STY_TYPES --

1052: ---------------------------------------------------------------------------
1053: -- PROCEDURE lock_row
1054: ---------------------------------------------------------------------------
1055: ------------------------------------------
1056: -- lock_row for:OKL_DISB_RULE_STY_TYPES --
1057: ------------------------------------------
1058: PROCEDURE lock_row(
1059: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1060: x_return_status OUT NOCOPY VARCHAR2,

Line 1069: FROM OKL_DISB_RULE_STY_TYPES

1065: E_Resource_Busy EXCEPTION;
1066: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1067: CURSOR lock_csr (p_drs_rec IN drs_rec_type) IS
1068: SELECT OBJECT_VERSION_NUMBER
1069: FROM OKL_DISB_RULE_STY_TYPES
1070: WHERE DISB_RULE_STY_TYPE_ID = p_drs_rec.disb_rule_sty_type_id
1071: AND OBJECT_VERSION_NUMBER = p_drs_rec.object_version_number
1072: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1073:

Line 1077: FROM OKL_DISB_RULE_STY_TYPES

1073:
1074:
1075: CURSOR lchk_csr (p_drs_rec IN drs_rec_type) IS
1076: SELECT OBJECT_VERSION_NUMBER
1077: FROM OKL_DISB_RULE_STY_TYPES
1078: WHERE DISB_RULE_STY_TYPE_ID = p_drs_rec.disb_rule_sty_type_id;
1079: l_api_version CONSTANT NUMBER := 1;
1080: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1081: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1082: l_object_version_number OKL_DISB_RULE_STY_TYPES.OBJECT_VERSION_NUMBER%TYPE;

1078: WHERE DISB_RULE_STY_TYPE_ID = p_drs_rec.disb_rule_sty_type_id;
1079: l_api_version CONSTANT NUMBER := 1;
1080: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1081: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1082: l_object_version_number OKL_DISB_RULE_STY_TYPES.OBJECT_VERSION_NUMBER%TYPE;
1083: lc_object_version_number OKL_DISB_RULE_STY_TYPES.OBJECT_VERSION_NUMBER%TYPE;
1084: l_row_notfound BOOLEAN := FALSE;
1085: lc_row_notfound BOOLEAN := FALSE;
1086: BEGIN

Line 1083: lc_object_version_number OKL_DISB_RULE_STY_TYPES.OBJECT_VERSION_NUMBER%TYPE;

1079: l_api_version CONSTANT NUMBER := 1;
1080: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1081: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1082: l_object_version_number OKL_DISB_RULE_STY_TYPES.OBJECT_VERSION_NUMBER%TYPE;
1083: lc_object_version_number OKL_DISB_RULE_STY_TYPES.OBJECT_VERSION_NUMBER%TYPE;
1084: l_row_notfound BOOLEAN := FALSE;
1085: lc_row_notfound BOOLEAN := FALSE;
1086: BEGIN
1087: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1166: -- lock_row for: OKL_DISB_RULE_STY_TYPES --

1162: '_PVT'
1163: );
1164: END lock_row;
1165: -------------------------------------------
1166: -- lock_row for: OKL_DISB_RULE_STY_TYPES --
1167: -------------------------------------------
1168: PROCEDURE lock_row(
1169: p_api_version IN NUMBER,
1170: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1405: -- update_row for:OKL_DISB_RULE_STY_TYPES --

1401: ---------------------------------------------------------------------------
1402: -- PROCEDURE update_row
1403: ---------------------------------------------------------------------------
1404: --------------------------------------------
1405: -- update_row for:OKL_DISB_RULE_STY_TYPES --
1406: --------------------------------------------
1407: PROCEDURE update_row(
1408: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1409: x_return_status OUT NOCOPY VARCHAR2,

Line 1515: -- Set_Attributes for:OKL_DISB_RULE_STY_TYPES --

1511: END IF;
1512: RETURN(l_return_status);
1513: END populate_new_record;
1514: ------------------------------------------------
1515: -- Set_Attributes for:OKL_DISB_RULE_STY_TYPES --
1516: ------------------------------------------------
1517: FUNCTION Set_Attributes (
1518: p_drs_rec IN drs_rec_type,
1519: x_drs_rec OUT NOCOPY drs_rec_type

Line 1553: UPDATE OKL_DISB_RULE_STY_TYPES

1549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1551: RAISE OKL_API.G_EXCEPTION_ERROR;
1552: END IF;
1553: UPDATE OKL_DISB_RULE_STY_TYPES
1554: SET OBJECT_VERSION_NUMBER = l_def_drs_rec.object_version_number,
1555: DISB_RULE_ID = l_def_drs_rec.disb_rule_id,
1556: STREAM_TYPE_PURPOSE = l_def_drs_rec.stream_type_purpose,
1557: ATTRIBUTE_CATEGORY = l_def_drs_rec.attribute_category,

Line 1616: -- update_row for:OKL_DISB_RULE_STY_TYPES --

1612: '_PVT'
1613: );
1614: END update_row;
1615: --------------------------------------------
1616: -- update_row for:OKL_DISB_RULE_STY_TYPES --
1617: --------------------------------------------
1618: PROCEDURE update_row(
1619: p_api_version IN NUMBER,
1620: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1744: -- Set_Attributes for:OKL_DISB_RULE_STY_TYPES --

1740: END IF;
1741: RETURN(l_return_status);
1742: END populate_new_record;
1743: ------------------------------------------------
1744: -- Set_Attributes for:OKL_DISB_RULE_STY_TYPES --
1745: ------------------------------------------------
1746: FUNCTION Set_Attributes (
1747: p_drs_rec IN drs_rec_type,
1748: x_drs_rec OUT NOCOPY drs_rec_type

Line 2036: -- delete_row for:OKL_DISB_RULE_STY_TYPES --

2032: ---------------------------------------------------------------------------
2033: -- PROCEDURE delete_row
2034: ---------------------------------------------------------------------------
2035: --------------------------------------------
2036: -- delete_row for:OKL_DISB_RULE_STY_TYPES --
2037: --------------------------------------------
2038: PROCEDURE delete_row(
2039: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2040: x_return_status OUT NOCOPY VARCHAR2,

Line 2061: DELETE FROM OKL_DISB_RULE_STY_TYPES

2057: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2058: RAISE OKL_API.G_EXCEPTION_ERROR;
2059: END IF;
2060:
2061: DELETE FROM OKL_DISB_RULE_STY_TYPES
2062: WHERE DISB_RULE_STY_TYPE_ID = p_drs_rec.disb_rule_sty_type_id;
2063:
2064: x_return_status := l_return_status;
2065: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2099: -- delete_row for:OKL_DISB_RULE_STY_TYPES --

2095: '_PVT'
2096: );
2097: END delete_row;
2098: --------------------------------------------
2099: -- delete_row for:OKL_DISB_RULE_STY_TYPES --
2100: --------------------------------------------
2101: PROCEDURE delete_row(
2102: p_api_version IN NUMBER,
2103: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2179: -- PL/SQL TBL delete_row for:OKL_DISB_RULE_STY_TYPES --

2175: '_PVT'
2176: );
2177: END delete_row;
2178: -------------------------------------------------------
2179: -- PL/SQL TBL delete_row for:OKL_DISB_RULE_STY_TYPES --
2180: -------------------------------------------------------
2181: PROCEDURE delete_row(
2182: p_api_version IN NUMBER,
2183: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2275: -- PL/SQL TBL delete_row for:OKL_DISB_RULE_STY_TYPES --

2271: );
2272: END delete_row;
2273:
2274: -------------------------------------------------------
2275: -- PL/SQL TBL delete_row for:OKL_DISB_RULE_STY_TYPES --
2276: -------------------------------------------------------
2277: PROCEDURE delete_row(
2278: p_api_version IN NUMBER,
2279: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,