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.OKC_RGP_PVT dependencies on OKC_RULE_GROUPS_TL

Line 913: DELETE FROM OKC_RULE_GROUPS_TL T

909: /* as a quick workaround to fix the time-consuming table handler issue */
910: /* Eventually we'll need to turn them into a separate fix_language procedure */
911: /*added hint as per appsperf team suggestion - bug13627948*/
912: /* Commented DELETE and UPDATE queres for 13781121
913: DELETE FROM OKC_RULE_GROUPS_TL T
914: WHERE NOT EXISTS (
915: SELECT NULL
916: FROM OKC_RULE_GROUPS_B B
917: WHERE B.ID = T.ID

Line 921: UPDATE OKC_RULE_GROUPS_TL T SET (

917: WHERE B.ID = T.ID
918: AND T.LANGUAGE = USERENV('LANG')
919: );
920:
921: UPDATE OKC_RULE_GROUPS_TL T SET (
922: COMMENTS) = (SELECT
923: B.COMMENTS
924: FROM OKC_RULE_GROUPS_TL B
925: WHERE B.ID = T.ID

Line 924: FROM OKC_RULE_GROUPS_TL B

920:
921: UPDATE OKC_RULE_GROUPS_TL T SET (
922: COMMENTS) = (SELECT
923: B.COMMENTS
924: FROM OKC_RULE_GROUPS_TL B
925: WHERE B.ID = T.ID
926: AND B.LANGUAGE = T.SOURCE_LANG)
927: WHERE (
928: T.ID,

Line 933: FROM OKC_RULE_GROUPS_TL SUBB, OKC_RULE_GROUPS_TL SUBT

929: T.LANGUAGE)
930: IN (SELECT
931: SUBT.ID,
932: SUBT.LANGUAGE
933: FROM OKC_RULE_GROUPS_TL SUBB, OKC_RULE_GROUPS_TL SUBT
934: WHERE SUBB.ID = SUBT.ID
935: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
936: AND (SUBB.COMMENTS <> SUBT.COMMENTS
937: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)

Line 944: INSERT /+ append parallel ( OKC_RULE_GROUPS_TL ) / INTO OKC_RULE_GROUPS_TL (

940: */
941:
942:
943: /*added hint as per appsperf team suggestion - bug13627948*/
944: INSERT /*+ append parallel ( OKC_RULE_GROUPS_TL ) */ INTO OKC_RULE_GROUPS_TL (
945: ID,
946: LANGUAGE,
947: SOURCE_LANG,
948: SFWT_FLAG,

Line 966: FROM OKC_RULE_GROUPS_TL B, FND_LANGUAGES L

962: B.CREATION_DATE,
963: B.LAST_UPDATED_BY,
964: B.LAST_UPDATE_DATE,
965: B.LAST_UPDATE_LOGIN
966: FROM OKC_RULE_GROUPS_TL B, FND_LANGUAGES L
967: WHERE L.INSTALLED_FLAG IN ('I', 'B')
968: AND B.LANGUAGE = USERENV('LANG')
969: AND NOT EXISTS(
970: SELECT NULL

Line 971: FROM OKC_RULE_GROUPS_TL T

967: WHERE L.INSTALLED_FLAG IN ('I', 'B')
968: AND B.LANGUAGE = USERENV('LANG')
969: AND NOT EXISTS(
970: SELECT NULL
971: FROM OKC_RULE_GROUPS_TL T
972: WHERE T.ID = B.ID
973: AND T.LANGUAGE = L.LANGUAGE_CODE
974: );
975: DELETE FROM OKC_RULE_GROUPS_TLH T

Line 975: DELETE FROM OKC_RULE_GROUPS_TLH T

971: FROM OKC_RULE_GROUPS_TL T
972: WHERE T.ID = B.ID
973: AND T.LANGUAGE = L.LANGUAGE_CODE
974: );
975: DELETE FROM OKC_RULE_GROUPS_TLH T
976: WHERE NOT EXISTS (
977: SELECT NULL
978: FROM OKC_RULE_GROUPS_BH B
979: WHERE B.ID = T.ID

Line 983: UPDATE OKC_RULE_GROUPS_TLH T SET (

979: WHERE B.ID = T.ID
980: AND B.MAJOR_VERSION = T.MAJOR_VERSION
981: );
982:
983: UPDATE OKC_RULE_GROUPS_TLH T SET (
984: COMMENTS) = (SELECT
985: B.COMMENTS
986: FROM OKC_RULE_GROUPS_TLH B
987: WHERE B.ID = T.ID

Line 986: FROM OKC_RULE_GROUPS_TLH B

982:
983: UPDATE OKC_RULE_GROUPS_TLH T SET (
984: COMMENTS) = (SELECT
985: B.COMMENTS
986: FROM OKC_RULE_GROUPS_TLH B
987: WHERE B.ID = T.ID
988: AND B.MAJOR_VERSION = T.MAJOR_VERSION
989: AND B.LANGUAGE = T.SOURCE_LANG)
990: WHERE (

Line 998: FROM OKC_RULE_GROUPS_TLH SUBB, OKC_RULE_GROUPS_TLH SUBT

994: IN (SELECT
995: SUBT.ID,
996: SUBT.MAJOR_VERSION,
997: SUBT.LANGUAGE
998: FROM OKC_RULE_GROUPS_TLH SUBB, OKC_RULE_GROUPS_TLH SUBT
999: WHERE SUBB.ID = SUBT.ID
1000: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
1001: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
1002: AND (SUBB.COMMENTS <> SUBT.COMMENTS

Line 1007: INSERT INTO OKC_RULE_GROUPS_TLH (

1003: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
1004: OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
1005: ));
1006:
1007: INSERT INTO OKC_RULE_GROUPS_TLH (
1008: ID,
1009: LANGUAGE,
1010: MAJOR_VERSION,
1011: SOURCE_LANG,

Line 1031: FROM OKC_RULE_GROUPS_TLH B, FND_LANGUAGES L

1027: B.CREATION_DATE,
1028: B.LAST_UPDATED_BY,
1029: B.LAST_UPDATE_DATE,
1030: B.LAST_UPDATE_LOGIN
1031: FROM OKC_RULE_GROUPS_TLH B, FND_LANGUAGES L
1032: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1033: AND B.LANGUAGE = USERENV('LANG')
1034: AND NOT EXISTS(
1035: SELECT NULL

Line 1036: FROM OKC_RULE_GROUPS_TLH T

1032: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1033: AND B.LANGUAGE = USERENV('LANG')
1034: AND NOT EXISTS(
1035: SELECT NULL
1036: FROM OKC_RULE_GROUPS_TLH T
1037: WHERE T.ID = B.ID
1038: AND T.MAJOR_VERSION = B.MAJOR_VERSION
1039: AND T.LANGUAGE = L.LANGUAGE_CODE
1040: );

Line 1136: -- FUNCTION get_rec for: OKC_RULE_GROUPS_TL

1132: BEGIN
1133: RETURN(get_rec(p_rgp_rec, l_row_notfound));
1134: END get_rec;
1135: ---------------------------------------------------------------------------
1136: -- FUNCTION get_rec for: OKC_RULE_GROUPS_TL
1137: ---------------------------------------------------------------------------
1138: FUNCTION get_rec (
1139: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
1140: x_no_data_found OUT NOCOPY BOOLEAN

Line 1139: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,

1135: ---------------------------------------------------------------------------
1136: -- FUNCTION get_rec for: OKC_RULE_GROUPS_TL
1137: ---------------------------------------------------------------------------
1138: FUNCTION get_rec (
1139: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
1140: x_no_data_found OUT NOCOPY BOOLEAN
1141: ) RETURN okc_rule_groups_tl_rec_type IS
1142: CURSOR rgp_pktl_csr (p_id IN NUMBER,
1143: p_language IN VARCHAR2) IS

Line 1141: ) RETURN okc_rule_groups_tl_rec_type IS

1137: ---------------------------------------------------------------------------
1138: FUNCTION get_rec (
1139: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
1140: x_no_data_found OUT NOCOPY BOOLEAN
1141: ) RETURN okc_rule_groups_tl_rec_type IS
1142: CURSOR rgp_pktl_csr (p_id IN NUMBER,
1143: p_language IN VARCHAR2) IS
1144: SELECT
1145: ID,

Line 1155: FROM Okc_Rule_Groups_Tl

1151: CREATION_DATE,
1152: LAST_UPDATED_BY,
1153: LAST_UPDATE_DATE,
1154: LAST_UPDATE_LOGIN
1155: FROM Okc_Rule_Groups_Tl
1156: WHERE okc_rule_groups_tl.id = p_id
1157: AND okc_rule_groups_tl.language = p_language;
1158: l_rgp_pktl rgp_pktl_csr%ROWTYPE;
1159: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

Line 1156: WHERE okc_rule_groups_tl.id = p_id

1152: LAST_UPDATED_BY,
1153: LAST_UPDATE_DATE,
1154: LAST_UPDATE_LOGIN
1155: FROM Okc_Rule_Groups_Tl
1156: WHERE okc_rule_groups_tl.id = p_id
1157: AND okc_rule_groups_tl.language = p_language;
1158: l_rgp_pktl rgp_pktl_csr%ROWTYPE;
1159: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1160: BEGIN

Line 1157: AND okc_rule_groups_tl.language = p_language;

1153: LAST_UPDATE_DATE,
1154: LAST_UPDATE_LOGIN
1155: FROM Okc_Rule_Groups_Tl
1156: WHERE okc_rule_groups_tl.id = p_id
1157: AND okc_rule_groups_tl.language = p_language;
1158: l_rgp_pktl rgp_pktl_csr%ROWTYPE;
1159: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1160: BEGIN
1161: x_no_data_found := TRUE;

Line 1159: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

1155: FROM Okc_Rule_Groups_Tl
1156: WHERE okc_rule_groups_tl.id = p_id
1157: AND okc_rule_groups_tl.language = p_language;
1158: l_rgp_pktl rgp_pktl_csr%ROWTYPE;
1159: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1160: BEGIN
1161: x_no_data_found := TRUE;
1162: -- Get current database values
1163: OPEN rgp_pktl_csr (p_okc_rule_groups_tl_rec.id,

Line 1163: OPEN rgp_pktl_csr (p_okc_rule_groups_tl_rec.id,

1159: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1160: BEGIN
1161: x_no_data_found := TRUE;
1162: -- Get current database values
1163: OPEN rgp_pktl_csr (p_okc_rule_groups_tl_rec.id,
1164: p_okc_rule_groups_tl_rec.language);
1165: FETCH rgp_pktl_csr INTO
1166: l_okc_rule_groups_tl_rec.ID,
1167: l_okc_rule_groups_tl_rec.LANGUAGE,

Line 1164: p_okc_rule_groups_tl_rec.language);

1160: BEGIN
1161: x_no_data_found := TRUE;
1162: -- Get current database values
1163: OPEN rgp_pktl_csr (p_okc_rule_groups_tl_rec.id,
1164: p_okc_rule_groups_tl_rec.language);
1165: FETCH rgp_pktl_csr INTO
1166: l_okc_rule_groups_tl_rec.ID,
1167: l_okc_rule_groups_tl_rec.LANGUAGE,
1168: l_okc_rule_groups_tl_rec.SOURCE_LANG,

Line 1166: l_okc_rule_groups_tl_rec.ID,

1162: -- Get current database values
1163: OPEN rgp_pktl_csr (p_okc_rule_groups_tl_rec.id,
1164: p_okc_rule_groups_tl_rec.language);
1165: FETCH rgp_pktl_csr INTO
1166: l_okc_rule_groups_tl_rec.ID,
1167: l_okc_rule_groups_tl_rec.LANGUAGE,
1168: l_okc_rule_groups_tl_rec.SOURCE_LANG,
1169: l_okc_rule_groups_tl_rec.SFWT_FLAG,
1170: l_okc_rule_groups_tl_rec.COMMENTS,

Line 1167: l_okc_rule_groups_tl_rec.LANGUAGE,

1163: OPEN rgp_pktl_csr (p_okc_rule_groups_tl_rec.id,
1164: p_okc_rule_groups_tl_rec.language);
1165: FETCH rgp_pktl_csr INTO
1166: l_okc_rule_groups_tl_rec.ID,
1167: l_okc_rule_groups_tl_rec.LANGUAGE,
1168: l_okc_rule_groups_tl_rec.SOURCE_LANG,
1169: l_okc_rule_groups_tl_rec.SFWT_FLAG,
1170: l_okc_rule_groups_tl_rec.COMMENTS,
1171: l_okc_rule_groups_tl_rec.CREATED_BY,

Line 1168: l_okc_rule_groups_tl_rec.SOURCE_LANG,

1164: p_okc_rule_groups_tl_rec.language);
1165: FETCH rgp_pktl_csr INTO
1166: l_okc_rule_groups_tl_rec.ID,
1167: l_okc_rule_groups_tl_rec.LANGUAGE,
1168: l_okc_rule_groups_tl_rec.SOURCE_LANG,
1169: l_okc_rule_groups_tl_rec.SFWT_FLAG,
1170: l_okc_rule_groups_tl_rec.COMMENTS,
1171: l_okc_rule_groups_tl_rec.CREATED_BY,
1172: l_okc_rule_groups_tl_rec.CREATION_DATE,

Line 1169: l_okc_rule_groups_tl_rec.SFWT_FLAG,

1165: FETCH rgp_pktl_csr INTO
1166: l_okc_rule_groups_tl_rec.ID,
1167: l_okc_rule_groups_tl_rec.LANGUAGE,
1168: l_okc_rule_groups_tl_rec.SOURCE_LANG,
1169: l_okc_rule_groups_tl_rec.SFWT_FLAG,
1170: l_okc_rule_groups_tl_rec.COMMENTS,
1171: l_okc_rule_groups_tl_rec.CREATED_BY,
1172: l_okc_rule_groups_tl_rec.CREATION_DATE,
1173: l_okc_rule_groups_tl_rec.LAST_UPDATED_BY,

Line 1170: l_okc_rule_groups_tl_rec.COMMENTS,

1166: l_okc_rule_groups_tl_rec.ID,
1167: l_okc_rule_groups_tl_rec.LANGUAGE,
1168: l_okc_rule_groups_tl_rec.SOURCE_LANG,
1169: l_okc_rule_groups_tl_rec.SFWT_FLAG,
1170: l_okc_rule_groups_tl_rec.COMMENTS,
1171: l_okc_rule_groups_tl_rec.CREATED_BY,
1172: l_okc_rule_groups_tl_rec.CREATION_DATE,
1173: l_okc_rule_groups_tl_rec.LAST_UPDATED_BY,
1174: l_okc_rule_groups_tl_rec.LAST_UPDATE_DATE,

Line 1171: l_okc_rule_groups_tl_rec.CREATED_BY,

1167: l_okc_rule_groups_tl_rec.LANGUAGE,
1168: l_okc_rule_groups_tl_rec.SOURCE_LANG,
1169: l_okc_rule_groups_tl_rec.SFWT_FLAG,
1170: l_okc_rule_groups_tl_rec.COMMENTS,
1171: l_okc_rule_groups_tl_rec.CREATED_BY,
1172: l_okc_rule_groups_tl_rec.CREATION_DATE,
1173: l_okc_rule_groups_tl_rec.LAST_UPDATED_BY,
1174: l_okc_rule_groups_tl_rec.LAST_UPDATE_DATE,
1175: l_okc_rule_groups_tl_rec.LAST_UPDATE_LOGIN;

Line 1172: l_okc_rule_groups_tl_rec.CREATION_DATE,

1168: l_okc_rule_groups_tl_rec.SOURCE_LANG,
1169: l_okc_rule_groups_tl_rec.SFWT_FLAG,
1170: l_okc_rule_groups_tl_rec.COMMENTS,
1171: l_okc_rule_groups_tl_rec.CREATED_BY,
1172: l_okc_rule_groups_tl_rec.CREATION_DATE,
1173: l_okc_rule_groups_tl_rec.LAST_UPDATED_BY,
1174: l_okc_rule_groups_tl_rec.LAST_UPDATE_DATE,
1175: l_okc_rule_groups_tl_rec.LAST_UPDATE_LOGIN;
1176: x_no_data_found := rgp_pktl_csr%NOTFOUND;

Line 1173: l_okc_rule_groups_tl_rec.LAST_UPDATED_BY,

1169: l_okc_rule_groups_tl_rec.SFWT_FLAG,
1170: l_okc_rule_groups_tl_rec.COMMENTS,
1171: l_okc_rule_groups_tl_rec.CREATED_BY,
1172: l_okc_rule_groups_tl_rec.CREATION_DATE,
1173: l_okc_rule_groups_tl_rec.LAST_UPDATED_BY,
1174: l_okc_rule_groups_tl_rec.LAST_UPDATE_DATE,
1175: l_okc_rule_groups_tl_rec.LAST_UPDATE_LOGIN;
1176: x_no_data_found := rgp_pktl_csr%NOTFOUND;
1177: CLOSE rgp_pktl_csr;

Line 1174: l_okc_rule_groups_tl_rec.LAST_UPDATE_DATE,

1170: l_okc_rule_groups_tl_rec.COMMENTS,
1171: l_okc_rule_groups_tl_rec.CREATED_BY,
1172: l_okc_rule_groups_tl_rec.CREATION_DATE,
1173: l_okc_rule_groups_tl_rec.LAST_UPDATED_BY,
1174: l_okc_rule_groups_tl_rec.LAST_UPDATE_DATE,
1175: l_okc_rule_groups_tl_rec.LAST_UPDATE_LOGIN;
1176: x_no_data_found := rgp_pktl_csr%NOTFOUND;
1177: CLOSE rgp_pktl_csr;
1178: RETURN(l_okc_rule_groups_tl_rec);

Line 1175: l_okc_rule_groups_tl_rec.LAST_UPDATE_LOGIN;

1171: l_okc_rule_groups_tl_rec.CREATED_BY,
1172: l_okc_rule_groups_tl_rec.CREATION_DATE,
1173: l_okc_rule_groups_tl_rec.LAST_UPDATED_BY,
1174: l_okc_rule_groups_tl_rec.LAST_UPDATE_DATE,
1175: l_okc_rule_groups_tl_rec.LAST_UPDATE_LOGIN;
1176: x_no_data_found := rgp_pktl_csr%NOTFOUND;
1177: CLOSE rgp_pktl_csr;
1178: RETURN(l_okc_rule_groups_tl_rec);
1179: END get_rec;

Line 1178: RETURN(l_okc_rule_groups_tl_rec);

1174: l_okc_rule_groups_tl_rec.LAST_UPDATE_DATE,
1175: l_okc_rule_groups_tl_rec.LAST_UPDATE_LOGIN;
1176: x_no_data_found := rgp_pktl_csr%NOTFOUND;
1177: CLOSE rgp_pktl_csr;
1178: RETURN(l_okc_rule_groups_tl_rec);
1179: END get_rec;
1180:
1181: FUNCTION get_rec (
1182: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type

Line 1182: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type

1178: RETURN(l_okc_rule_groups_tl_rec);
1179: END get_rec;
1180:
1181: FUNCTION get_rec (
1182: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type
1183: ) RETURN okc_rule_groups_tl_rec_type IS
1184: l_row_notfound BOOLEAN := TRUE;
1185: BEGIN
1186: RETURN(get_rec(p_okc_rule_groups_tl_rec, l_row_notfound));

Line 1183: ) RETURN okc_rule_groups_tl_rec_type IS

1179: END get_rec;
1180:
1181: FUNCTION get_rec (
1182: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type
1183: ) RETURN okc_rule_groups_tl_rec_type IS
1184: l_row_notfound BOOLEAN := TRUE;
1185: BEGIN
1186: RETURN(get_rec(p_okc_rule_groups_tl_rec, l_row_notfound));
1187: END get_rec;

Line 1186: RETURN(get_rec(p_okc_rule_groups_tl_rec, l_row_notfound));

1182: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type
1183: ) RETURN okc_rule_groups_tl_rec_type IS
1184: l_row_notfound BOOLEAN := TRUE;
1185: BEGIN
1186: RETURN(get_rec(p_okc_rule_groups_tl_rec, l_row_notfound));
1187: END get_rec;
1188: ---------------------------------------------------------------------------
1189: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V
1190: ---------------------------------------------------------------------------

Line 1513: p_to IN OUT NOCOPY okc_rule_groups_tl_rec_type

1509: p_to.attribute15 := p_from.attribute15;
1510: END migrate;
1511: PROCEDURE migrate (
1512: p_from IN rgpv_rec_type,
1513: p_to IN OUT NOCOPY okc_rule_groups_tl_rec_type
1514: ) IS
1515: BEGIN
1516: p_to.id := p_from.id;
1517: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1526: p_from IN okc_rule_groups_tl_rec_type,

1522: p_to.last_update_date := p_from.last_update_date;
1523: p_to.last_update_login := p_from.last_update_login;
1524: END migrate;
1525: PROCEDURE migrate (
1526: p_from IN okc_rule_groups_tl_rec_type,
1527: p_to IN OUT NOCOPY rgpv_rec_type
1528: ) IS
1529: BEGIN
1530: p_to.id := p_from.id;

Line 1559: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

1555: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1556: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1557: l_rgpv_rec rgpv_rec_type := p_rgpv_rec;
1558: l_rgp_rec rgp_rec_type;
1559: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1560: BEGIN
1561: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1562: G_PKG_NAME,
1563: p_init_msg_list,

Line 1834: -- insert_row for:OKC_RULE_GROUPS_TL --

1830: '_PVT'
1831: );
1832: END insert_row;
1833: ---------------------------------------
1834: -- insert_row for:OKC_RULE_GROUPS_TL --
1835: ---------------------------------------
1836: PROCEDURE insert_row(
1837: p_init_msg_list IN VARCHAR2,
1838: x_return_status OUT NOCOPY VARCHAR2,

Line 1841: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,

1837: p_init_msg_list IN VARCHAR2,
1838: x_return_status OUT NOCOPY VARCHAR2,
1839: x_msg_count OUT NOCOPY NUMBER,
1840: x_msg_data OUT NOCOPY VARCHAR2,
1841: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
1842: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type) IS
1843:
1844: l_api_version CONSTANT NUMBER := 1;
1845: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1842: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type) IS

1838: x_return_status OUT NOCOPY VARCHAR2,
1839: x_msg_count OUT NOCOPY NUMBER,
1840: x_msg_data OUT NOCOPY VARCHAR2,
1841: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
1842: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type) IS
1843:
1844: l_api_version CONSTANT NUMBER := 1;
1845: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1846: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1847: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type := p_okc_rule_groups_tl_rec;

1843:
1844: l_api_version CONSTANT NUMBER := 1;
1845: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1846: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1847: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type := p_okc_rule_groups_tl_rec;
1848: l_def_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1849: CURSOR get_languages IS
1850: SELECT *
1851: FROM FND_LANGUAGES

Line 1848: l_def_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

1844: l_api_version CONSTANT NUMBER := 1;
1845: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1846: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1847: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type := p_okc_rule_groups_tl_rec;
1848: l_def_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1849: CURSOR get_languages IS
1850: SELECT *
1851: FROM FND_LANGUAGES
1852: WHERE INSTALLED_FLAG IN ('I', 'B');

Line 1854: -- Set_Attributes for:OKC_RULE_GROUPS_TL --

1850: SELECT *
1851: FROM FND_LANGUAGES
1852: WHERE INSTALLED_FLAG IN ('I', 'B');
1853: -------------------------------------------
1854: -- Set_Attributes for:OKC_RULE_GROUPS_TL --
1855: -------------------------------------------
1856: FUNCTION Set_Attributes (
1857: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
1858: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type

Line 1857: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,

1853: -------------------------------------------
1854: -- Set_Attributes for:OKC_RULE_GROUPS_TL --
1855: -------------------------------------------
1856: FUNCTION Set_Attributes (
1857: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
1858: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
1859: ) RETURN VARCHAR2 IS
1860: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1861: BEGIN

Line 1858: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type

1854: -- Set_Attributes for:OKC_RULE_GROUPS_TL --
1855: -------------------------------------------
1856: FUNCTION Set_Attributes (
1857: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
1858: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
1859: ) RETURN VARCHAR2 IS
1860: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1861: BEGIN
1862: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;

Line 1862: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;

1858: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
1859: ) RETURN VARCHAR2 IS
1860: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1861: BEGIN
1862: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
1863: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1864: x_okc_rule_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1865: RETURN(l_return_status);
1866: END Set_Attributes;

Line 1863: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

1859: ) RETURN VARCHAR2 IS
1860: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1861: BEGIN
1862: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
1863: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1864: x_okc_rule_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1865: RETURN(l_return_status);
1866: END Set_Attributes;
1867: BEGIN

Line 1864: x_okc_rule_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

1860: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1861: BEGIN
1862: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
1863: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1864: x_okc_rule_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1865: RETURN(l_return_status);
1866: END Set_Attributes;
1867: BEGIN
1868: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1879: p_okc_rule_groups_tl_rec, -- IN

1875: RAISE OKC_API.G_EXCEPTION_ERROR;
1876: END IF;
1877: --- Setting item attributes
1878: l_return_status := Set_Attributes(
1879: p_okc_rule_groups_tl_rec, -- IN
1880: l_okc_rule_groups_tl_rec); -- OUT
1881: --- If any errors happen abort API
1882: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1880: l_okc_rule_groups_tl_rec); -- OUT

1876: END IF;
1877: --- Setting item attributes
1878: l_return_status := Set_Attributes(
1879: p_okc_rule_groups_tl_rec, -- IN
1880: l_okc_rule_groups_tl_rec); -- OUT
1881: --- If any errors happen abort API
1882: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1888: l_okc_rule_groups_tl_rec.language := l_lang_rec.language_code;

1884: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1885: RAISE OKC_API.G_EXCEPTION_ERROR;
1886: END IF;
1887: FOR l_lang_rec IN get_languages LOOP
1888: l_okc_rule_groups_tl_rec.language := l_lang_rec.language_code;
1889: INSERT INTO OKC_RULE_GROUPS_TL(
1890: id,
1891: language,
1892: source_lang,

Line 1889: INSERT INTO OKC_RULE_GROUPS_TL(

1885: RAISE OKC_API.G_EXCEPTION_ERROR;
1886: END IF;
1887: FOR l_lang_rec IN get_languages LOOP
1888: l_okc_rule_groups_tl_rec.language := l_lang_rec.language_code;
1889: INSERT INTO OKC_RULE_GROUPS_TL(
1890: id,
1891: language,
1892: source_lang,
1893: sfwt_flag,

Line 1901: l_okc_rule_groups_tl_rec.id,

1897: last_updated_by,
1898: last_update_date,
1899: last_update_login)
1900: VALUES (
1901: l_okc_rule_groups_tl_rec.id,
1902: l_okc_rule_groups_tl_rec.language,
1903: l_okc_rule_groups_tl_rec.source_lang,
1904: l_okc_rule_groups_tl_rec.sfwt_flag,
1905: l_okc_rule_groups_tl_rec.comments,

Line 1902: l_okc_rule_groups_tl_rec.language,

1898: last_update_date,
1899: last_update_login)
1900: VALUES (
1901: l_okc_rule_groups_tl_rec.id,
1902: l_okc_rule_groups_tl_rec.language,
1903: l_okc_rule_groups_tl_rec.source_lang,
1904: l_okc_rule_groups_tl_rec.sfwt_flag,
1905: l_okc_rule_groups_tl_rec.comments,
1906: l_okc_rule_groups_tl_rec.created_by,

Line 1903: l_okc_rule_groups_tl_rec.source_lang,

1899: last_update_login)
1900: VALUES (
1901: l_okc_rule_groups_tl_rec.id,
1902: l_okc_rule_groups_tl_rec.language,
1903: l_okc_rule_groups_tl_rec.source_lang,
1904: l_okc_rule_groups_tl_rec.sfwt_flag,
1905: l_okc_rule_groups_tl_rec.comments,
1906: l_okc_rule_groups_tl_rec.created_by,
1907: l_okc_rule_groups_tl_rec.creation_date,

Line 1904: l_okc_rule_groups_tl_rec.sfwt_flag,

1900: VALUES (
1901: l_okc_rule_groups_tl_rec.id,
1902: l_okc_rule_groups_tl_rec.language,
1903: l_okc_rule_groups_tl_rec.source_lang,
1904: l_okc_rule_groups_tl_rec.sfwt_flag,
1905: l_okc_rule_groups_tl_rec.comments,
1906: l_okc_rule_groups_tl_rec.created_by,
1907: l_okc_rule_groups_tl_rec.creation_date,
1908: l_okc_rule_groups_tl_rec.last_updated_by,

Line 1905: l_okc_rule_groups_tl_rec.comments,

1901: l_okc_rule_groups_tl_rec.id,
1902: l_okc_rule_groups_tl_rec.language,
1903: l_okc_rule_groups_tl_rec.source_lang,
1904: l_okc_rule_groups_tl_rec.sfwt_flag,
1905: l_okc_rule_groups_tl_rec.comments,
1906: l_okc_rule_groups_tl_rec.created_by,
1907: l_okc_rule_groups_tl_rec.creation_date,
1908: l_okc_rule_groups_tl_rec.last_updated_by,
1909: l_okc_rule_groups_tl_rec.last_update_date,

Line 1906: l_okc_rule_groups_tl_rec.created_by,

1902: l_okc_rule_groups_tl_rec.language,
1903: l_okc_rule_groups_tl_rec.source_lang,
1904: l_okc_rule_groups_tl_rec.sfwt_flag,
1905: l_okc_rule_groups_tl_rec.comments,
1906: l_okc_rule_groups_tl_rec.created_by,
1907: l_okc_rule_groups_tl_rec.creation_date,
1908: l_okc_rule_groups_tl_rec.last_updated_by,
1909: l_okc_rule_groups_tl_rec.last_update_date,
1910: l_okc_rule_groups_tl_rec.last_update_login);

Line 1907: l_okc_rule_groups_tl_rec.creation_date,

1903: l_okc_rule_groups_tl_rec.source_lang,
1904: l_okc_rule_groups_tl_rec.sfwt_flag,
1905: l_okc_rule_groups_tl_rec.comments,
1906: l_okc_rule_groups_tl_rec.created_by,
1907: l_okc_rule_groups_tl_rec.creation_date,
1908: l_okc_rule_groups_tl_rec.last_updated_by,
1909: l_okc_rule_groups_tl_rec.last_update_date,
1910: l_okc_rule_groups_tl_rec.last_update_login);
1911: END LOOP;

Line 1908: l_okc_rule_groups_tl_rec.last_updated_by,

1904: l_okc_rule_groups_tl_rec.sfwt_flag,
1905: l_okc_rule_groups_tl_rec.comments,
1906: l_okc_rule_groups_tl_rec.created_by,
1907: l_okc_rule_groups_tl_rec.creation_date,
1908: l_okc_rule_groups_tl_rec.last_updated_by,
1909: l_okc_rule_groups_tl_rec.last_update_date,
1910: l_okc_rule_groups_tl_rec.last_update_login);
1911: END LOOP;
1912: -- Set OUT values

Line 1909: l_okc_rule_groups_tl_rec.last_update_date,

1905: l_okc_rule_groups_tl_rec.comments,
1906: l_okc_rule_groups_tl_rec.created_by,
1907: l_okc_rule_groups_tl_rec.creation_date,
1908: l_okc_rule_groups_tl_rec.last_updated_by,
1909: l_okc_rule_groups_tl_rec.last_update_date,
1910: l_okc_rule_groups_tl_rec.last_update_login);
1911: END LOOP;
1912: -- Set OUT values
1913: x_okc_rule_groups_tl_rec := l_okc_rule_groups_tl_rec;

Line 1910: l_okc_rule_groups_tl_rec.last_update_login);

1906: l_okc_rule_groups_tl_rec.created_by,
1907: l_okc_rule_groups_tl_rec.creation_date,
1908: l_okc_rule_groups_tl_rec.last_updated_by,
1909: l_okc_rule_groups_tl_rec.last_update_date,
1910: l_okc_rule_groups_tl_rec.last_update_login);
1911: END LOOP;
1912: -- Set OUT values
1913: x_okc_rule_groups_tl_rec := l_okc_rule_groups_tl_rec;
1914: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1913: x_okc_rule_groups_tl_rec := l_okc_rule_groups_tl_rec;

1909: l_okc_rule_groups_tl_rec.last_update_date,
1910: l_okc_rule_groups_tl_rec.last_update_login);
1911: END LOOP;
1912: -- Set OUT values
1913: x_okc_rule_groups_tl_rec := l_okc_rule_groups_tl_rec;
1914: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1915: EXCEPTION
1916: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1917: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1966: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

1962: l_rgpv_rec rgpv_rec_type;
1963: l_def_rgpv_rec rgpv_rec_type;
1964: l_rgp_rec rgp_rec_type;
1965: lx_rgp_rec rgp_rec_type;
1966: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1967: lx_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1968: -------------------------------
1969: -- FUNCTION fill_who_columns --
1970: -------------------------------

Line 1967: lx_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

1963: l_def_rgpv_rec rgpv_rec_type;
1964: l_rgp_rec rgp_rec_type;
1965: lx_rgp_rec rgp_rec_type;
1966: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1967: lx_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1968: -------------------------------
1969: -- FUNCTION fill_who_columns --
1970: -------------------------------
1971: FUNCTION fill_who_columns (

Line 2042: migrate(l_def_rgpv_rec, l_okc_rule_groups_tl_rec);

2038: --------------------------------------
2039: -- Move VIEW record to "Child" records
2040: --------------------------------------
2041: migrate(l_def_rgpv_rec, l_rgp_rec);
2042: migrate(l_def_rgpv_rec, l_okc_rule_groups_tl_rec);
2043: --------------------------------------------
2044: -- Call the INSERT_ROW for each child record
2045: --------------------------------------------
2046: insert_row(

Line 2065: l_okc_rule_groups_tl_rec,

2061: p_init_msg_list,
2062: x_return_status,
2063: x_msg_count,
2064: x_msg_data,
2065: l_okc_rule_groups_tl_rec,
2066: lx_okc_rule_groups_tl_rec
2067: );
2068: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2066: lx_okc_rule_groups_tl_rec

2062: x_return_status,
2063: x_msg_count,
2064: x_msg_data,
2065: l_okc_rule_groups_tl_rec,
2066: lx_okc_rule_groups_tl_rec
2067: );
2068: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2070: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2073: migrate(lx_okc_rule_groups_tl_rec, l_def_rgpv_rec);

2069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2070: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2071: RAISE OKC_API.G_EXCEPTION_ERROR;
2072: END IF;
2073: migrate(lx_okc_rule_groups_tl_rec, l_def_rgpv_rec);
2074: -- Set OUT values
2075: x_rgpv_rec := l_def_rgpv_rec;
2076: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2077: EXCEPTION

Line 2286: -- lock_row for:OKC_RULE_GROUPS_TL --

2282: '_PVT'
2283: );
2284: END lock_row;
2285: -------------------------------------
2286: -- lock_row for:OKC_RULE_GROUPS_TL --
2287: -------------------------------------
2288: PROCEDURE lock_row(
2289: p_init_msg_list IN VARCHAR2,
2290: x_return_status OUT NOCOPY VARCHAR2,

Line 2293: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type) IS

2289: p_init_msg_list IN VARCHAR2,
2290: x_return_status OUT NOCOPY VARCHAR2,
2291: x_msg_count OUT NOCOPY NUMBER,
2292: x_msg_data OUT NOCOPY VARCHAR2,
2293: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type) IS
2294:
2295: E_Resource_Busy EXCEPTION;
2296: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2297: CURSOR lock_csr (p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type) IS

Line 2297: CURSOR lock_csr (p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type) IS

2293: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type) IS
2294:
2295: E_Resource_Busy EXCEPTION;
2296: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2297: CURSOR lock_csr (p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type) IS
2298: SELECT *
2299: FROM OKC_RULE_GROUPS_TL
2300: WHERE ID = p_okc_rule_groups_tl_rec.id
2301: FOR UPDATE NOWAIT;

Line 2299: FROM OKC_RULE_GROUPS_TL

2295: E_Resource_Busy EXCEPTION;
2296: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2297: CURSOR lock_csr (p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type) IS
2298: SELECT *
2299: FROM OKC_RULE_GROUPS_TL
2300: WHERE ID = p_okc_rule_groups_tl_rec.id
2301: FOR UPDATE NOWAIT;
2302:
2303: l_api_version CONSTANT NUMBER := 1;

Line 2300: WHERE ID = p_okc_rule_groups_tl_rec.id

2296: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2297: CURSOR lock_csr (p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type) IS
2298: SELECT *
2299: FROM OKC_RULE_GROUPS_TL
2300: WHERE ID = p_okc_rule_groups_tl_rec.id
2301: FOR UPDATE NOWAIT;
2302:
2303: l_api_version CONSTANT NUMBER := 1;
2304: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';

Line 2320: OPEN lock_csr(p_okc_rule_groups_tl_rec);

2316: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2317: RAISE OKC_API.G_EXCEPTION_ERROR;
2318: END IF;
2319: BEGIN
2320: OPEN lock_csr(p_okc_rule_groups_tl_rec);
2321: FETCH lock_csr INTO l_lock_var;
2322: l_row_notfound := lock_csr%NOTFOUND;
2323: CLOSE lock_csr;
2324: EXCEPTION

Line 2385: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

2381: l_api_version CONSTANT NUMBER := 1;
2382: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2383: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2384: l_rgp_rec rgp_rec_type;
2385: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
2386: BEGIN
2387: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2388: G_PKG_NAME,
2389: p_init_msg_list,

Line 2403: migrate(p_rgpv_rec, l_okc_rule_groups_tl_rec);

2399: --------------------------------------
2400: -- Move VIEW record to "Child" records
2401: --------------------------------------
2402: migrate(p_rgpv_rec, l_rgp_rec);
2403: migrate(p_rgpv_rec, l_okc_rule_groups_tl_rec);
2404: --------------------------------------------
2405: -- Call the LOCK_ROW for each child record
2406: --------------------------------------------
2407: lock_row(

Line 2424: l_okc_rule_groups_tl_rec

2420: p_init_msg_list,
2421: x_return_status,
2422: x_msg_count,
2423: x_msg_data,
2424: l_okc_rule_groups_tl_rec
2425: );
2426: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2427: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2428: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2793: -- update_row for:OKC_RULE_GROUPS_TL --

2789: '_PVT'
2790: );
2791: END update_row;
2792: ---------------------------------------
2793: -- update_row for:OKC_RULE_GROUPS_TL --
2794: ---------------------------------------
2795: PROCEDURE update_row(
2796: p_init_msg_list IN VARCHAR2,
2797: x_return_status OUT NOCOPY VARCHAR2,

Line 2800: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,

2796: p_init_msg_list IN VARCHAR2,
2797: x_return_status OUT NOCOPY VARCHAR2,
2798: x_msg_count OUT NOCOPY NUMBER,
2799: x_msg_data OUT NOCOPY VARCHAR2,
2800: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
2801: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type) IS
2802:
2803: l_api_version CONSTANT NUMBER := 1;
2804: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2801: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type) IS

2797: x_return_status OUT NOCOPY VARCHAR2,
2798: x_msg_count OUT NOCOPY NUMBER,
2799: x_msg_data OUT NOCOPY VARCHAR2,
2800: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
2801: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type) IS
2802:
2803: l_api_version CONSTANT NUMBER := 1;
2804: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2805: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2806: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type := p_okc_rule_groups_tl_rec;

2802:
2803: l_api_version CONSTANT NUMBER := 1;
2804: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2805: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2806: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type := p_okc_rule_groups_tl_rec;
2807: l_def_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
2808: l_row_notfound BOOLEAN := TRUE;
2809: ----------------------------------
2810: -- FUNCTION populate_new_record --

Line 2807: l_def_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

2803: l_api_version CONSTANT NUMBER := 1;
2804: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2805: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2806: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type := p_okc_rule_groups_tl_rec;
2807: l_def_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
2808: l_row_notfound BOOLEAN := TRUE;
2809: ----------------------------------
2810: -- FUNCTION populate_new_record --
2811: ----------------------------------

Line 2813: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,

2809: ----------------------------------
2810: -- FUNCTION populate_new_record --
2811: ----------------------------------
2812: FUNCTION populate_new_record (
2813: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
2814: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
2815: ) RETURN VARCHAR2 IS
2816: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
2817: l_row_notfound BOOLEAN := TRUE;

Line 2814: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type

2810: -- FUNCTION populate_new_record --
2811: ----------------------------------
2812: FUNCTION populate_new_record (
2813: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
2814: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
2815: ) RETURN VARCHAR2 IS
2816: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
2817: l_row_notfound BOOLEAN := TRUE;
2818: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2816: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

2812: FUNCTION populate_new_record (
2813: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
2814: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
2815: ) RETURN VARCHAR2 IS
2816: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
2817: l_row_notfound BOOLEAN := TRUE;
2818: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2819: BEGIN
2820: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;

Line 2820: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;

2816: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
2817: l_row_notfound BOOLEAN := TRUE;
2818: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2819: BEGIN
2820: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
2821: -- Get current database values
2822: l_okc_rule_groups_tl_rec := get_rec(p_okc_rule_groups_tl_rec, l_row_notfound);
2823: IF (l_row_notfound) THEN
2824: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2822: l_okc_rule_groups_tl_rec := get_rec(p_okc_rule_groups_tl_rec, l_row_notfound);

2818: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2819: BEGIN
2820: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
2821: -- Get current database values
2822: l_okc_rule_groups_tl_rec := get_rec(p_okc_rule_groups_tl_rec, l_row_notfound);
2823: IF (l_row_notfound) THEN
2824: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2825: END IF;
2826: IF (x_okc_rule_groups_tl_rec.id = OKC_API.G_MISS_NUM)

Line 2826: IF (x_okc_rule_groups_tl_rec.id = OKC_API.G_MISS_NUM)

2822: l_okc_rule_groups_tl_rec := get_rec(p_okc_rule_groups_tl_rec, l_row_notfound);
2823: IF (l_row_notfound) THEN
2824: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2825: END IF;
2826: IF (x_okc_rule_groups_tl_rec.id = OKC_API.G_MISS_NUM)
2827: THEN
2828: x_okc_rule_groups_tl_rec.id := l_okc_rule_groups_tl_rec.id;
2829: END IF;
2830: IF (x_okc_rule_groups_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 2828: x_okc_rule_groups_tl_rec.id := l_okc_rule_groups_tl_rec.id;

2824: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2825: END IF;
2826: IF (x_okc_rule_groups_tl_rec.id = OKC_API.G_MISS_NUM)
2827: THEN
2828: x_okc_rule_groups_tl_rec.id := l_okc_rule_groups_tl_rec.id;
2829: END IF;
2830: IF (x_okc_rule_groups_tl_rec.language = OKC_API.G_MISS_CHAR)
2831: THEN
2832: x_okc_rule_groups_tl_rec.language := l_okc_rule_groups_tl_rec.language;

Line 2830: IF (x_okc_rule_groups_tl_rec.language = OKC_API.G_MISS_CHAR)

2826: IF (x_okc_rule_groups_tl_rec.id = OKC_API.G_MISS_NUM)
2827: THEN
2828: x_okc_rule_groups_tl_rec.id := l_okc_rule_groups_tl_rec.id;
2829: END IF;
2830: IF (x_okc_rule_groups_tl_rec.language = OKC_API.G_MISS_CHAR)
2831: THEN
2832: x_okc_rule_groups_tl_rec.language := l_okc_rule_groups_tl_rec.language;
2833: END IF;
2834: IF (x_okc_rule_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 2832: x_okc_rule_groups_tl_rec.language := l_okc_rule_groups_tl_rec.language;

2828: x_okc_rule_groups_tl_rec.id := l_okc_rule_groups_tl_rec.id;
2829: END IF;
2830: IF (x_okc_rule_groups_tl_rec.language = OKC_API.G_MISS_CHAR)
2831: THEN
2832: x_okc_rule_groups_tl_rec.language := l_okc_rule_groups_tl_rec.language;
2833: END IF;
2834: IF (x_okc_rule_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2835: THEN
2836: x_okc_rule_groups_tl_rec.source_lang := l_okc_rule_groups_tl_rec.source_lang;

Line 2834: IF (x_okc_rule_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

2830: IF (x_okc_rule_groups_tl_rec.language = OKC_API.G_MISS_CHAR)
2831: THEN
2832: x_okc_rule_groups_tl_rec.language := l_okc_rule_groups_tl_rec.language;
2833: END IF;
2834: IF (x_okc_rule_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2835: THEN
2836: x_okc_rule_groups_tl_rec.source_lang := l_okc_rule_groups_tl_rec.source_lang;
2837: END IF;
2838: IF (x_okc_rule_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 2836: x_okc_rule_groups_tl_rec.source_lang := l_okc_rule_groups_tl_rec.source_lang;

2832: x_okc_rule_groups_tl_rec.language := l_okc_rule_groups_tl_rec.language;
2833: END IF;
2834: IF (x_okc_rule_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2835: THEN
2836: x_okc_rule_groups_tl_rec.source_lang := l_okc_rule_groups_tl_rec.source_lang;
2837: END IF;
2838: IF (x_okc_rule_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2839: THEN
2840: x_okc_rule_groups_tl_rec.sfwt_flag := l_okc_rule_groups_tl_rec.sfwt_flag;

Line 2838: IF (x_okc_rule_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

2834: IF (x_okc_rule_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
2835: THEN
2836: x_okc_rule_groups_tl_rec.source_lang := l_okc_rule_groups_tl_rec.source_lang;
2837: END IF;
2838: IF (x_okc_rule_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2839: THEN
2840: x_okc_rule_groups_tl_rec.sfwt_flag := l_okc_rule_groups_tl_rec.sfwt_flag;
2841: END IF;
2842: IF (x_okc_rule_groups_tl_rec.comments = OKC_API.G_MISS_CHAR)

Line 2840: x_okc_rule_groups_tl_rec.sfwt_flag := l_okc_rule_groups_tl_rec.sfwt_flag;

2836: x_okc_rule_groups_tl_rec.source_lang := l_okc_rule_groups_tl_rec.source_lang;
2837: END IF;
2838: IF (x_okc_rule_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2839: THEN
2840: x_okc_rule_groups_tl_rec.sfwt_flag := l_okc_rule_groups_tl_rec.sfwt_flag;
2841: END IF;
2842: IF (x_okc_rule_groups_tl_rec.comments = OKC_API.G_MISS_CHAR)
2843: THEN
2844: x_okc_rule_groups_tl_rec.comments := l_okc_rule_groups_tl_rec.comments;

Line 2842: IF (x_okc_rule_groups_tl_rec.comments = OKC_API.G_MISS_CHAR)

2838: IF (x_okc_rule_groups_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
2839: THEN
2840: x_okc_rule_groups_tl_rec.sfwt_flag := l_okc_rule_groups_tl_rec.sfwt_flag;
2841: END IF;
2842: IF (x_okc_rule_groups_tl_rec.comments = OKC_API.G_MISS_CHAR)
2843: THEN
2844: x_okc_rule_groups_tl_rec.comments := l_okc_rule_groups_tl_rec.comments;
2845: END IF;
2846: IF (x_okc_rule_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 2844: x_okc_rule_groups_tl_rec.comments := l_okc_rule_groups_tl_rec.comments;

2840: x_okc_rule_groups_tl_rec.sfwt_flag := l_okc_rule_groups_tl_rec.sfwt_flag;
2841: END IF;
2842: IF (x_okc_rule_groups_tl_rec.comments = OKC_API.G_MISS_CHAR)
2843: THEN
2844: x_okc_rule_groups_tl_rec.comments := l_okc_rule_groups_tl_rec.comments;
2845: END IF;
2846: IF (x_okc_rule_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)
2847: THEN
2848: x_okc_rule_groups_tl_rec.created_by := l_okc_rule_groups_tl_rec.created_by;

Line 2846: IF (x_okc_rule_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)

2842: IF (x_okc_rule_groups_tl_rec.comments = OKC_API.G_MISS_CHAR)
2843: THEN
2844: x_okc_rule_groups_tl_rec.comments := l_okc_rule_groups_tl_rec.comments;
2845: END IF;
2846: IF (x_okc_rule_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)
2847: THEN
2848: x_okc_rule_groups_tl_rec.created_by := l_okc_rule_groups_tl_rec.created_by;
2849: END IF;
2850: IF (x_okc_rule_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2848: x_okc_rule_groups_tl_rec.created_by := l_okc_rule_groups_tl_rec.created_by;

2844: x_okc_rule_groups_tl_rec.comments := l_okc_rule_groups_tl_rec.comments;
2845: END IF;
2846: IF (x_okc_rule_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)
2847: THEN
2848: x_okc_rule_groups_tl_rec.created_by := l_okc_rule_groups_tl_rec.created_by;
2849: END IF;
2850: IF (x_okc_rule_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2851: THEN
2852: x_okc_rule_groups_tl_rec.creation_date := l_okc_rule_groups_tl_rec.creation_date;

Line 2850: IF (x_okc_rule_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)

2846: IF (x_okc_rule_groups_tl_rec.created_by = OKC_API.G_MISS_NUM)
2847: THEN
2848: x_okc_rule_groups_tl_rec.created_by := l_okc_rule_groups_tl_rec.created_by;
2849: END IF;
2850: IF (x_okc_rule_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2851: THEN
2852: x_okc_rule_groups_tl_rec.creation_date := l_okc_rule_groups_tl_rec.creation_date;
2853: END IF;
2854: IF (x_okc_rule_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2852: x_okc_rule_groups_tl_rec.creation_date := l_okc_rule_groups_tl_rec.creation_date;

2848: x_okc_rule_groups_tl_rec.created_by := l_okc_rule_groups_tl_rec.created_by;
2849: END IF;
2850: IF (x_okc_rule_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2851: THEN
2852: x_okc_rule_groups_tl_rec.creation_date := l_okc_rule_groups_tl_rec.creation_date;
2853: END IF;
2854: IF (x_okc_rule_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2855: THEN
2856: x_okc_rule_groups_tl_rec.last_updated_by := l_okc_rule_groups_tl_rec.last_updated_by;

Line 2854: IF (x_okc_rule_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

2850: IF (x_okc_rule_groups_tl_rec.creation_date = OKC_API.G_MISS_DATE)
2851: THEN
2852: x_okc_rule_groups_tl_rec.creation_date := l_okc_rule_groups_tl_rec.creation_date;
2853: END IF;
2854: IF (x_okc_rule_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2855: THEN
2856: x_okc_rule_groups_tl_rec.last_updated_by := l_okc_rule_groups_tl_rec.last_updated_by;
2857: END IF;
2858: IF (x_okc_rule_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2856: x_okc_rule_groups_tl_rec.last_updated_by := l_okc_rule_groups_tl_rec.last_updated_by;

2852: x_okc_rule_groups_tl_rec.creation_date := l_okc_rule_groups_tl_rec.creation_date;
2853: END IF;
2854: IF (x_okc_rule_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2855: THEN
2856: x_okc_rule_groups_tl_rec.last_updated_by := l_okc_rule_groups_tl_rec.last_updated_by;
2857: END IF;
2858: IF (x_okc_rule_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2859: THEN
2860: x_okc_rule_groups_tl_rec.last_update_date := l_okc_rule_groups_tl_rec.last_update_date;

Line 2858: IF (x_okc_rule_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

2854: IF (x_okc_rule_groups_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
2855: THEN
2856: x_okc_rule_groups_tl_rec.last_updated_by := l_okc_rule_groups_tl_rec.last_updated_by;
2857: END IF;
2858: IF (x_okc_rule_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2859: THEN
2860: x_okc_rule_groups_tl_rec.last_update_date := l_okc_rule_groups_tl_rec.last_update_date;
2861: END IF;
2862: IF (x_okc_rule_groups_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2860: x_okc_rule_groups_tl_rec.last_update_date := l_okc_rule_groups_tl_rec.last_update_date;

2856: x_okc_rule_groups_tl_rec.last_updated_by := l_okc_rule_groups_tl_rec.last_updated_by;
2857: END IF;
2858: IF (x_okc_rule_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2859: THEN
2860: x_okc_rule_groups_tl_rec.last_update_date := l_okc_rule_groups_tl_rec.last_update_date;
2861: END IF;
2862: IF (x_okc_rule_groups_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2863: THEN
2864: x_okc_rule_groups_tl_rec.last_update_login := l_okc_rule_groups_tl_rec.last_update_login;

Line 2862: IF (x_okc_rule_groups_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

2858: IF (x_okc_rule_groups_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
2859: THEN
2860: x_okc_rule_groups_tl_rec.last_update_date := l_okc_rule_groups_tl_rec.last_update_date;
2861: END IF;
2862: IF (x_okc_rule_groups_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2863: THEN
2864: x_okc_rule_groups_tl_rec.last_update_login := l_okc_rule_groups_tl_rec.last_update_login;
2865: END IF;
2866: RETURN(l_return_status);

Line 2864: x_okc_rule_groups_tl_rec.last_update_login := l_okc_rule_groups_tl_rec.last_update_login;

2860: x_okc_rule_groups_tl_rec.last_update_date := l_okc_rule_groups_tl_rec.last_update_date;
2861: END IF;
2862: IF (x_okc_rule_groups_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
2863: THEN
2864: x_okc_rule_groups_tl_rec.last_update_login := l_okc_rule_groups_tl_rec.last_update_login;
2865: END IF;
2866: RETURN(l_return_status);
2867: END populate_new_record;
2868: -------------------------------------------

Line 2869: -- Set_Attributes for:OKC_RULE_GROUPS_TL --

2865: END IF;
2866: RETURN(l_return_status);
2867: END populate_new_record;
2868: -------------------------------------------
2869: -- Set_Attributes for:OKC_RULE_GROUPS_TL --
2870: -------------------------------------------
2871: FUNCTION Set_Attributes (
2872: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
2873: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type

Line 2872: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,

2868: -------------------------------------------
2869: -- Set_Attributes for:OKC_RULE_GROUPS_TL --
2870: -------------------------------------------
2871: FUNCTION Set_Attributes (
2872: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
2873: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
2874: ) RETURN VARCHAR2 IS
2875: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2876: BEGIN

Line 2873: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type

2869: -- Set_Attributes for:OKC_RULE_GROUPS_TL --
2870: -------------------------------------------
2871: FUNCTION Set_Attributes (
2872: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
2873: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
2874: ) RETURN VARCHAR2 IS
2875: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2876: BEGIN
2877: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;

Line 2877: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;

2873: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
2874: ) RETURN VARCHAR2 IS
2875: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2876: BEGIN
2877: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
2878: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2879: x_okc_rule_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2880: RETURN(l_return_status);
2881: END Set_Attributes;

Line 2878: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

2874: ) RETURN VARCHAR2 IS
2875: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2876: BEGIN
2877: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
2878: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2879: x_okc_rule_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2880: RETURN(l_return_status);
2881: END Set_Attributes;
2882: BEGIN

Line 2879: x_okc_rule_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

2875: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2876: BEGIN
2877: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
2878: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2879: x_okc_rule_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2880: RETURN(l_return_status);
2881: END Set_Attributes;
2882: BEGIN
2883: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2894: p_okc_rule_groups_tl_rec, -- IN

2890: RAISE OKC_API.G_EXCEPTION_ERROR;
2891: END IF;
2892: --- Setting item attributes
2893: l_return_status := Set_Attributes(
2894: p_okc_rule_groups_tl_rec, -- IN
2895: l_okc_rule_groups_tl_rec); -- OUT
2896: --- If any errors happen abort API
2897: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2895: l_okc_rule_groups_tl_rec); -- OUT

2891: END IF;
2892: --- Setting item attributes
2893: l_return_status := Set_Attributes(
2894: p_okc_rule_groups_tl_rec, -- IN
2895: l_okc_rule_groups_tl_rec); -- OUT
2896: --- If any errors happen abort API
2897: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2899: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2902: l_return_status := populate_new_record(l_okc_rule_groups_tl_rec, l_def_okc_rule_groups_tl_rec);

2898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2899: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2900: RAISE OKC_API.G_EXCEPTION_ERROR;
2901: END IF;
2902: l_return_status := populate_new_record(l_okc_rule_groups_tl_rec, l_def_okc_rule_groups_tl_rec);
2903: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2904: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2905: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2906: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2908: UPDATE OKC_RULE_GROUPS_TL

2904: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2905: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2906: RAISE OKC_API.G_EXCEPTION_ERROR;
2907: END IF;
2908: UPDATE OKC_RULE_GROUPS_TL
2909: SET COMMENTS = l_def_okc_rule_groups_tl_rec.comments,
2910: CREATED_BY = l_def_okc_rule_groups_tl_rec.created_by,
2911: CREATION_DATE = l_def_okc_rule_groups_tl_rec.creation_date,
2912: LAST_UPDATED_BY = l_def_okc_rule_groups_tl_rec.last_updated_by,

Line 2909: SET COMMENTS = l_def_okc_rule_groups_tl_rec.comments,

2905: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2906: RAISE OKC_API.G_EXCEPTION_ERROR;
2907: END IF;
2908: UPDATE OKC_RULE_GROUPS_TL
2909: SET COMMENTS = l_def_okc_rule_groups_tl_rec.comments,
2910: CREATED_BY = l_def_okc_rule_groups_tl_rec.created_by,
2911: CREATION_DATE = l_def_okc_rule_groups_tl_rec.creation_date,
2912: LAST_UPDATED_BY = l_def_okc_rule_groups_tl_rec.last_updated_by,
2913: LAST_UPDATE_DATE = l_def_okc_rule_groups_tl_rec.last_update_date,

Line 2910: CREATED_BY = l_def_okc_rule_groups_tl_rec.created_by,

2906: RAISE OKC_API.G_EXCEPTION_ERROR;
2907: END IF;
2908: UPDATE OKC_RULE_GROUPS_TL
2909: SET COMMENTS = l_def_okc_rule_groups_tl_rec.comments,
2910: CREATED_BY = l_def_okc_rule_groups_tl_rec.created_by,
2911: CREATION_DATE = l_def_okc_rule_groups_tl_rec.creation_date,
2912: LAST_UPDATED_BY = l_def_okc_rule_groups_tl_rec.last_updated_by,
2913: LAST_UPDATE_DATE = l_def_okc_rule_groups_tl_rec.last_update_date,
2914: LAST_UPDATE_LOGIN = l_def_okc_rule_groups_tl_rec.last_update_login

Line 2911: CREATION_DATE = l_def_okc_rule_groups_tl_rec.creation_date,

2907: END IF;
2908: UPDATE OKC_RULE_GROUPS_TL
2909: SET COMMENTS = l_def_okc_rule_groups_tl_rec.comments,
2910: CREATED_BY = l_def_okc_rule_groups_tl_rec.created_by,
2911: CREATION_DATE = l_def_okc_rule_groups_tl_rec.creation_date,
2912: LAST_UPDATED_BY = l_def_okc_rule_groups_tl_rec.last_updated_by,
2913: LAST_UPDATE_DATE = l_def_okc_rule_groups_tl_rec.last_update_date,
2914: LAST_UPDATE_LOGIN = l_def_okc_rule_groups_tl_rec.last_update_login
2915: WHERE ID = l_def_okc_rule_groups_tl_rec.id

Line 2912: LAST_UPDATED_BY = l_def_okc_rule_groups_tl_rec.last_updated_by,

2908: UPDATE OKC_RULE_GROUPS_TL
2909: SET COMMENTS = l_def_okc_rule_groups_tl_rec.comments,
2910: CREATED_BY = l_def_okc_rule_groups_tl_rec.created_by,
2911: CREATION_DATE = l_def_okc_rule_groups_tl_rec.creation_date,
2912: LAST_UPDATED_BY = l_def_okc_rule_groups_tl_rec.last_updated_by,
2913: LAST_UPDATE_DATE = l_def_okc_rule_groups_tl_rec.last_update_date,
2914: LAST_UPDATE_LOGIN = l_def_okc_rule_groups_tl_rec.last_update_login
2915: WHERE ID = l_def_okc_rule_groups_tl_rec.id
2916: AND SOURCE_LANG = USERENV('LANG');

Line 2913: LAST_UPDATE_DATE = l_def_okc_rule_groups_tl_rec.last_update_date,

2909: SET COMMENTS = l_def_okc_rule_groups_tl_rec.comments,
2910: CREATED_BY = l_def_okc_rule_groups_tl_rec.created_by,
2911: CREATION_DATE = l_def_okc_rule_groups_tl_rec.creation_date,
2912: LAST_UPDATED_BY = l_def_okc_rule_groups_tl_rec.last_updated_by,
2913: LAST_UPDATE_DATE = l_def_okc_rule_groups_tl_rec.last_update_date,
2914: LAST_UPDATE_LOGIN = l_def_okc_rule_groups_tl_rec.last_update_login
2915: WHERE ID = l_def_okc_rule_groups_tl_rec.id
2916: AND SOURCE_LANG = USERENV('LANG');
2917:

Line 2914: LAST_UPDATE_LOGIN = l_def_okc_rule_groups_tl_rec.last_update_login

2910: CREATED_BY = l_def_okc_rule_groups_tl_rec.created_by,
2911: CREATION_DATE = l_def_okc_rule_groups_tl_rec.creation_date,
2912: LAST_UPDATED_BY = l_def_okc_rule_groups_tl_rec.last_updated_by,
2913: LAST_UPDATE_DATE = l_def_okc_rule_groups_tl_rec.last_update_date,
2914: LAST_UPDATE_LOGIN = l_def_okc_rule_groups_tl_rec.last_update_login
2915: WHERE ID = l_def_okc_rule_groups_tl_rec.id
2916: AND SOURCE_LANG = USERENV('LANG');
2917:
2918: UPDATE OKC_RULE_GROUPS_TL

Line 2915: WHERE ID = l_def_okc_rule_groups_tl_rec.id

2911: CREATION_DATE = l_def_okc_rule_groups_tl_rec.creation_date,
2912: LAST_UPDATED_BY = l_def_okc_rule_groups_tl_rec.last_updated_by,
2913: LAST_UPDATE_DATE = l_def_okc_rule_groups_tl_rec.last_update_date,
2914: LAST_UPDATE_LOGIN = l_def_okc_rule_groups_tl_rec.last_update_login
2915: WHERE ID = l_def_okc_rule_groups_tl_rec.id
2916: AND SOURCE_LANG = USERENV('LANG');
2917:
2918: UPDATE OKC_RULE_GROUPS_TL
2919: SET SFWT_FLAG = 'Y'

Line 2918: UPDATE OKC_RULE_GROUPS_TL

2914: LAST_UPDATE_LOGIN = l_def_okc_rule_groups_tl_rec.last_update_login
2915: WHERE ID = l_def_okc_rule_groups_tl_rec.id
2916: AND SOURCE_LANG = USERENV('LANG');
2917:
2918: UPDATE OKC_RULE_GROUPS_TL
2919: SET SFWT_FLAG = 'Y'
2920: WHERE ID = l_def_okc_rule_groups_tl_rec.id
2921: AND SOURCE_LANG <> USERENV('LANG');
2922:

Line 2920: WHERE ID = l_def_okc_rule_groups_tl_rec.id

2916: AND SOURCE_LANG = USERENV('LANG');
2917:
2918: UPDATE OKC_RULE_GROUPS_TL
2919: SET SFWT_FLAG = 'Y'
2920: WHERE ID = l_def_okc_rule_groups_tl_rec.id
2921: AND SOURCE_LANG <> USERENV('LANG');
2922:
2923: x_okc_rule_groups_tl_rec := l_def_okc_rule_groups_tl_rec;
2924: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2923: x_okc_rule_groups_tl_rec := l_def_okc_rule_groups_tl_rec;

2919: SET SFWT_FLAG = 'Y'
2920: WHERE ID = l_def_okc_rule_groups_tl_rec.id
2921: AND SOURCE_LANG <> USERENV('LANG');
2922:
2923: x_okc_rule_groups_tl_rec := l_def_okc_rule_groups_tl_rec;
2924: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2925: EXCEPTION
2926: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2927: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2974: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

2970: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2971: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2972: l_rgpv_rec rgpv_rec_type := p_rgpv_rec;
2973: l_def_rgpv_rec rgpv_rec_type;
2974: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
2975: lx_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
2976: l_rgp_rec rgp_rec_type;
2977: lx_rgp_rec rgp_rec_type;
2978: -------------------------------

Line 2975: lx_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

2971: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2972: l_rgpv_rec rgpv_rec_type := p_rgpv_rec;
2973: l_def_rgpv_rec rgpv_rec_type;
2974: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
2975: lx_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
2976: l_rgp_rec rgp_rec_type;
2977: lx_rgp_rec rgp_rec_type;
2978: -------------------------------
2979: -- FUNCTION fill_who_columns --

Line 3199: migrate(l_def_rgpv_rec, l_okc_rule_groups_tl_rec);

3195:
3196: --------------------------------------
3197: -- Move VIEW record to "Child" records
3198: --------------------------------------
3199: migrate(l_def_rgpv_rec, l_okc_rule_groups_tl_rec);
3200: migrate(l_def_rgpv_rec, l_rgp_rec);
3201: --------------------------------------------
3202: -- Call the UPDATE_ROW for each child record
3203: --------------------------------------------

Line 3209: l_okc_rule_groups_tl_rec,

3205: p_init_msg_list,
3206: x_return_status,
3207: x_msg_count,
3208: x_msg_data,
3209: l_okc_rule_groups_tl_rec,
3210: lx_okc_rule_groups_tl_rec
3211: );
3212: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3213: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3210: lx_okc_rule_groups_tl_rec

3206: x_return_status,
3207: x_msg_count,
3208: x_msg_data,
3209: l_okc_rule_groups_tl_rec,
3210: lx_okc_rule_groups_tl_rec
3211: );
3212: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3213: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3214: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3217: migrate(lx_okc_rule_groups_tl_rec, l_def_rgpv_rec);

3213: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3214: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3215: RAISE OKC_API.G_EXCEPTION_ERROR;
3216: END IF;
3217: migrate(lx_okc_rule_groups_tl_rec, l_def_rgpv_rec);
3218: update_row(
3219: p_init_msg_list,
3220: x_return_status,
3221: x_msg_count,

Line 3398: -- delete_row for:OKC_RULE_GROUPS_TL --

3394: '_PVT'
3395: );
3396: END delete_row;
3397: ---------------------------------------
3398: -- delete_row for:OKC_RULE_GROUPS_TL --
3399: ---------------------------------------
3400: PROCEDURE delete_row(
3401: p_init_msg_list IN VARCHAR2,
3402: x_return_status OUT NOCOPY VARCHAR2,

Line 3405: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type) IS

3401: p_init_msg_list IN VARCHAR2,
3402: x_return_status OUT NOCOPY VARCHAR2,
3403: x_msg_count OUT NOCOPY NUMBER,
3404: x_msg_data OUT NOCOPY VARCHAR2,
3405: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type) IS
3406:
3407: l_api_version CONSTANT NUMBER := 1;
3408: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3409: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3410: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type:= p_okc_rule_groups_tl_rec;

3406:
3407: l_api_version CONSTANT NUMBER := 1;
3408: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3409: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3410: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type:= p_okc_rule_groups_tl_rec;
3411: l_row_notfound BOOLEAN := TRUE;
3412: -------------------------------------------
3413: -- Set_Attributes for:OKC_RULE_GROUPS_TL --
3414: -------------------------------------------

Line 3413: -- Set_Attributes for:OKC_RULE_GROUPS_TL --

3409: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3410: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type:= p_okc_rule_groups_tl_rec;
3411: l_row_notfound BOOLEAN := TRUE;
3412: -------------------------------------------
3413: -- Set_Attributes for:OKC_RULE_GROUPS_TL --
3414: -------------------------------------------
3415: FUNCTION Set_Attributes (
3416: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
3417: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type

Line 3416: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,

3412: -------------------------------------------
3413: -- Set_Attributes for:OKC_RULE_GROUPS_TL --
3414: -------------------------------------------
3415: FUNCTION Set_Attributes (
3416: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
3417: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
3418: ) RETURN VARCHAR2 IS
3419: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3420: BEGIN

Line 3417: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type

3413: -- Set_Attributes for:OKC_RULE_GROUPS_TL --
3414: -------------------------------------------
3415: FUNCTION Set_Attributes (
3416: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
3417: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
3418: ) RETURN VARCHAR2 IS
3419: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3420: BEGIN
3421: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;

Line 3421: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;

3417: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
3418: ) RETURN VARCHAR2 IS
3419: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3420: BEGIN
3421: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
3422: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3423: RETURN(l_return_status);
3424: END Set_Attributes;
3425: BEGIN

Line 3422: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;

3418: ) RETURN VARCHAR2 IS
3419: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3420: BEGIN
3421: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
3422: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3423: RETURN(l_return_status);
3424: END Set_Attributes;
3425: BEGIN
3426: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3437: p_okc_rule_groups_tl_rec, -- IN

3433: RAISE OKC_API.G_EXCEPTION_ERROR;
3434: END IF;
3435: --- Setting item attributes
3436: l_return_status := Set_Attributes(
3437: p_okc_rule_groups_tl_rec, -- IN
3438: l_okc_rule_groups_tl_rec); -- OUT
3439: --- If any errors happen abort API
3440: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3441: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3438: l_okc_rule_groups_tl_rec); -- OUT

3434: END IF;
3435: --- Setting item attributes
3436: l_return_status := Set_Attributes(
3437: p_okc_rule_groups_tl_rec, -- IN
3438: l_okc_rule_groups_tl_rec); -- OUT
3439: --- If any errors happen abort API
3440: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3441: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3442: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3445: DELETE FROM OKC_RULE_GROUPS_TL

3441: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3442: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3443: RAISE OKC_API.G_EXCEPTION_ERROR;
3444: END IF;
3445: DELETE FROM OKC_RULE_GROUPS_TL
3446: WHERE ID = l_okc_rule_groups_tl_rec.id;
3447:
3448: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3449: EXCEPTION

Line 3446: WHERE ID = l_okc_rule_groups_tl_rec.id;

3442: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3443: RAISE OKC_API.G_EXCEPTION_ERROR;
3444: END IF;
3445: DELETE FROM OKC_RULE_GROUPS_TL
3446: WHERE ID = l_okc_rule_groups_tl_rec.id;
3447:
3448: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3449: EXCEPTION
3450: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 3496: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

3492: l_api_version CONSTANT NUMBER := 1;
3493: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3494: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3495: l_rgpv_rec rgpv_rec_type := p_rgpv_rec;
3496: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
3497: l_rgp_rec rgp_rec_type;
3498: BEGIN
3499: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
3500: G_PKG_NAME,

Line 3514: migrate(l_rgpv_rec, l_okc_rule_groups_tl_rec);

3510: END IF;
3511: --------------------------------------
3512: -- Move VIEW record to "Child" records
3513: --------------------------------------
3514: migrate(l_rgpv_rec, l_okc_rule_groups_tl_rec);
3515: migrate(l_rgpv_rec, l_rgp_rec);
3516: --------------------------------------------
3517: -- Call the DELETE_ROW for each child record
3518: --------------------------------------------

Line 3524: l_okc_rule_groups_tl_rec

3520: p_init_msg_list,
3521: x_return_status,
3522: x_msg_count,
3523: x_msg_data,
3524: l_okc_rule_groups_tl_rec
3525: );
3526: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3527: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3528: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3796: INSERT INTO OKC_RULE_GROUPS_TL(

3792: );
3793:
3794: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
3795: FORALL i in 1..l_tabsize
3796: INSERT INTO OKC_RULE_GROUPS_TL(
3797: id,
3798: language,
3799: source_lang,
3800: sfwt_flag,

Line 3923: INSERT INTO okc_rule_groups_tlh

3919: -------------------------------
3920: -- Versioning TL Table
3921: -------------------------------
3922:
3923: INSERT INTO okc_rule_groups_tlh
3924: (
3925: major_version,
3926: id,
3927: language,

Line 3949: FROM okc_rule_groups_tl

3945: creation_date,
3946: last_updated_by,
3947: last_update_date,
3948: last_update_login
3949: FROM okc_rule_groups_tl
3950: WHERE id in (select id
3951: from okc_rule_groups_b
3952: where dnz_chr_id = p_chr_id);
3953:

Line 3985: INSERT INTO okc_rule_groups_tl

3981:
3982: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3983:
3984: BEGIN
3985: INSERT INTO okc_rule_groups_tl
3986: (
3987: id,
3988: language,
3989: source_lang,

Line 4009: FROM okc_rule_groups_tlh

4005: creation_date,
4006: last_updated_by,
4007: last_update_date,
4008: last_update_login
4009: FROM okc_rule_groups_tlh
4010: WHERE id in (SELECT id
4011: FROM okc_rule_groups_bh
4012: WHERE dnz_chr_id = p_chr_id)
4013: AND major_version = p_major_version;