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 912: DELETE FROM OKC_RULE_GROUPS_TL T

908: /* The following delete and update statements are commented out */
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:
912: DELETE FROM OKC_RULE_GROUPS_TL T
913: WHERE NOT EXISTS (
914: SELECT NULL
915: FROM OKC_RULE_GROUPS_B B
916: WHERE B.ID = T.ID

Line 920: UPDATE OKC_RULE_GROUPS_TL T SET (

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

Line 923: FROM OKC_RULE_GROUPS_TL B

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

Line 932: FROM OKC_RULE_GROUPS_TL SUBB, OKC_RULE_GROUPS_TL SUBT

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

Line 940: INSERT INTO OKC_RULE_GROUPS_TL (

936: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
937: OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
938: ));
939:
940: INSERT INTO OKC_RULE_GROUPS_TL (
941: ID,
942: LANGUAGE,
943: SOURCE_LANG,
944: SFWT_FLAG,

Line 962: FROM OKC_RULE_GROUPS_TL B, FND_LANGUAGES L

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

Line 967: FROM OKC_RULE_GROUPS_TL T

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

Line 971: DELETE FROM OKC_RULE_GROUPS_TLH T

967: FROM OKC_RULE_GROUPS_TL T
968: WHERE T.ID = B.ID
969: AND T.LANGUAGE = L.LANGUAGE_CODE
970: );
971: DELETE FROM OKC_RULE_GROUPS_TLH T
972: WHERE NOT EXISTS (
973: SELECT NULL
974: FROM OKC_RULE_GROUPS_BH B
975: WHERE B.ID = T.ID

Line 979: UPDATE OKC_RULE_GROUPS_TLH T SET (

975: WHERE B.ID = T.ID
976: AND B.MAJOR_VERSION = T.MAJOR_VERSION
977: );
978:
979: UPDATE OKC_RULE_GROUPS_TLH T SET (
980: COMMENTS) = (SELECT
981: B.COMMENTS
982: FROM OKC_RULE_GROUPS_TLH B
983: WHERE B.ID = T.ID

Line 982: FROM OKC_RULE_GROUPS_TLH B

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

Line 994: FROM OKC_RULE_GROUPS_TLH SUBB, OKC_RULE_GROUPS_TLH SUBT

990: IN (SELECT
991: SUBT.ID,
992: SUBT.MAJOR_VERSION,
993: SUBT.LANGUAGE
994: FROM OKC_RULE_GROUPS_TLH SUBB, OKC_RULE_GROUPS_TLH SUBT
995: WHERE SUBB.ID = SUBT.ID
996: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
997: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
998: AND (SUBB.COMMENTS <> SUBT.COMMENTS

Line 1003: INSERT INTO OKC_RULE_GROUPS_TLH (

999: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
1000: OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
1001: ));
1002:
1003: INSERT INTO OKC_RULE_GROUPS_TLH (
1004: ID,
1005: LANGUAGE,
1006: MAJOR_VERSION,
1007: SOURCE_LANG,

Line 1027: FROM OKC_RULE_GROUPS_TLH B, FND_LANGUAGES L

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

Line 1032: FROM OKC_RULE_GROUPS_TLH T

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

Line 1132: -- FUNCTION get_rec for: OKC_RULE_GROUPS_TL

1128: BEGIN
1129: RETURN(get_rec(p_rgp_rec, l_row_notfound));
1130: END get_rec;
1131: ---------------------------------------------------------------------------
1132: -- FUNCTION get_rec for: OKC_RULE_GROUPS_TL
1133: ---------------------------------------------------------------------------
1134: FUNCTION get_rec (
1135: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
1136: x_no_data_found OUT NOCOPY BOOLEAN

Line 1135: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,

1131: ---------------------------------------------------------------------------
1132: -- FUNCTION get_rec for: OKC_RULE_GROUPS_TL
1133: ---------------------------------------------------------------------------
1134: FUNCTION get_rec (
1135: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
1136: x_no_data_found OUT NOCOPY BOOLEAN
1137: ) RETURN okc_rule_groups_tl_rec_type IS
1138: CURSOR rgp_pktl_csr (p_id IN NUMBER,
1139: p_language IN VARCHAR2) IS

Line 1137: ) RETURN okc_rule_groups_tl_rec_type IS

1133: ---------------------------------------------------------------------------
1134: FUNCTION get_rec (
1135: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
1136: x_no_data_found OUT NOCOPY BOOLEAN
1137: ) RETURN okc_rule_groups_tl_rec_type IS
1138: CURSOR rgp_pktl_csr (p_id IN NUMBER,
1139: p_language IN VARCHAR2) IS
1140: SELECT
1141: ID,

Line 1151: FROM Okc_Rule_Groups_Tl

1147: CREATION_DATE,
1148: LAST_UPDATED_BY,
1149: LAST_UPDATE_DATE,
1150: LAST_UPDATE_LOGIN
1151: FROM Okc_Rule_Groups_Tl
1152: WHERE okc_rule_groups_tl.id = p_id
1153: AND okc_rule_groups_tl.language = p_language;
1154: l_rgp_pktl rgp_pktl_csr%ROWTYPE;
1155: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

Line 1152: WHERE okc_rule_groups_tl.id = p_id

1148: LAST_UPDATED_BY,
1149: LAST_UPDATE_DATE,
1150: LAST_UPDATE_LOGIN
1151: FROM Okc_Rule_Groups_Tl
1152: WHERE okc_rule_groups_tl.id = p_id
1153: AND okc_rule_groups_tl.language = p_language;
1154: l_rgp_pktl rgp_pktl_csr%ROWTYPE;
1155: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1156: BEGIN

Line 1153: AND okc_rule_groups_tl.language = p_language;

1149: LAST_UPDATE_DATE,
1150: LAST_UPDATE_LOGIN
1151: FROM Okc_Rule_Groups_Tl
1152: WHERE okc_rule_groups_tl.id = p_id
1153: AND okc_rule_groups_tl.language = p_language;
1154: l_rgp_pktl rgp_pktl_csr%ROWTYPE;
1155: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1156: BEGIN
1157: x_no_data_found := TRUE;

Line 1155: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

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

Line 1159: OPEN rgp_pktl_csr (p_okc_rule_groups_tl_rec.id,

1155: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1156: BEGIN
1157: x_no_data_found := TRUE;
1158: -- Get current database values
1159: OPEN rgp_pktl_csr (p_okc_rule_groups_tl_rec.id,
1160: p_okc_rule_groups_tl_rec.language);
1161: FETCH rgp_pktl_csr INTO
1162: l_okc_rule_groups_tl_rec.ID,
1163: l_okc_rule_groups_tl_rec.LANGUAGE,

Line 1160: p_okc_rule_groups_tl_rec.language);

1156: BEGIN
1157: x_no_data_found := TRUE;
1158: -- Get current database values
1159: OPEN rgp_pktl_csr (p_okc_rule_groups_tl_rec.id,
1160: p_okc_rule_groups_tl_rec.language);
1161: FETCH rgp_pktl_csr INTO
1162: l_okc_rule_groups_tl_rec.ID,
1163: l_okc_rule_groups_tl_rec.LANGUAGE,
1164: l_okc_rule_groups_tl_rec.SOURCE_LANG,

Line 1162: l_okc_rule_groups_tl_rec.ID,

1158: -- Get current database values
1159: OPEN rgp_pktl_csr (p_okc_rule_groups_tl_rec.id,
1160: p_okc_rule_groups_tl_rec.language);
1161: FETCH rgp_pktl_csr INTO
1162: l_okc_rule_groups_tl_rec.ID,
1163: l_okc_rule_groups_tl_rec.LANGUAGE,
1164: l_okc_rule_groups_tl_rec.SOURCE_LANG,
1165: l_okc_rule_groups_tl_rec.SFWT_FLAG,
1166: l_okc_rule_groups_tl_rec.COMMENTS,

Line 1163: l_okc_rule_groups_tl_rec.LANGUAGE,

1159: OPEN rgp_pktl_csr (p_okc_rule_groups_tl_rec.id,
1160: p_okc_rule_groups_tl_rec.language);
1161: FETCH rgp_pktl_csr INTO
1162: l_okc_rule_groups_tl_rec.ID,
1163: l_okc_rule_groups_tl_rec.LANGUAGE,
1164: l_okc_rule_groups_tl_rec.SOURCE_LANG,
1165: l_okc_rule_groups_tl_rec.SFWT_FLAG,
1166: l_okc_rule_groups_tl_rec.COMMENTS,
1167: l_okc_rule_groups_tl_rec.CREATED_BY,

Line 1164: l_okc_rule_groups_tl_rec.SOURCE_LANG,

1160: p_okc_rule_groups_tl_rec.language);
1161: FETCH rgp_pktl_csr INTO
1162: l_okc_rule_groups_tl_rec.ID,
1163: l_okc_rule_groups_tl_rec.LANGUAGE,
1164: l_okc_rule_groups_tl_rec.SOURCE_LANG,
1165: l_okc_rule_groups_tl_rec.SFWT_FLAG,
1166: l_okc_rule_groups_tl_rec.COMMENTS,
1167: l_okc_rule_groups_tl_rec.CREATED_BY,
1168: l_okc_rule_groups_tl_rec.CREATION_DATE,

Line 1165: l_okc_rule_groups_tl_rec.SFWT_FLAG,

1161: FETCH rgp_pktl_csr INTO
1162: l_okc_rule_groups_tl_rec.ID,
1163: l_okc_rule_groups_tl_rec.LANGUAGE,
1164: l_okc_rule_groups_tl_rec.SOURCE_LANG,
1165: l_okc_rule_groups_tl_rec.SFWT_FLAG,
1166: l_okc_rule_groups_tl_rec.COMMENTS,
1167: l_okc_rule_groups_tl_rec.CREATED_BY,
1168: l_okc_rule_groups_tl_rec.CREATION_DATE,
1169: l_okc_rule_groups_tl_rec.LAST_UPDATED_BY,

Line 1166: l_okc_rule_groups_tl_rec.COMMENTS,

1162: l_okc_rule_groups_tl_rec.ID,
1163: l_okc_rule_groups_tl_rec.LANGUAGE,
1164: l_okc_rule_groups_tl_rec.SOURCE_LANG,
1165: l_okc_rule_groups_tl_rec.SFWT_FLAG,
1166: l_okc_rule_groups_tl_rec.COMMENTS,
1167: l_okc_rule_groups_tl_rec.CREATED_BY,
1168: l_okc_rule_groups_tl_rec.CREATION_DATE,
1169: l_okc_rule_groups_tl_rec.LAST_UPDATED_BY,
1170: l_okc_rule_groups_tl_rec.LAST_UPDATE_DATE,

Line 1167: l_okc_rule_groups_tl_rec.CREATED_BY,

1163: l_okc_rule_groups_tl_rec.LANGUAGE,
1164: l_okc_rule_groups_tl_rec.SOURCE_LANG,
1165: l_okc_rule_groups_tl_rec.SFWT_FLAG,
1166: l_okc_rule_groups_tl_rec.COMMENTS,
1167: l_okc_rule_groups_tl_rec.CREATED_BY,
1168: l_okc_rule_groups_tl_rec.CREATION_DATE,
1169: l_okc_rule_groups_tl_rec.LAST_UPDATED_BY,
1170: l_okc_rule_groups_tl_rec.LAST_UPDATE_DATE,
1171: l_okc_rule_groups_tl_rec.LAST_UPDATE_LOGIN;

Line 1168: l_okc_rule_groups_tl_rec.CREATION_DATE,

1164: l_okc_rule_groups_tl_rec.SOURCE_LANG,
1165: l_okc_rule_groups_tl_rec.SFWT_FLAG,
1166: l_okc_rule_groups_tl_rec.COMMENTS,
1167: l_okc_rule_groups_tl_rec.CREATED_BY,
1168: l_okc_rule_groups_tl_rec.CREATION_DATE,
1169: l_okc_rule_groups_tl_rec.LAST_UPDATED_BY,
1170: l_okc_rule_groups_tl_rec.LAST_UPDATE_DATE,
1171: l_okc_rule_groups_tl_rec.LAST_UPDATE_LOGIN;
1172: x_no_data_found := rgp_pktl_csr%NOTFOUND;

Line 1169: l_okc_rule_groups_tl_rec.LAST_UPDATED_BY,

1165: l_okc_rule_groups_tl_rec.SFWT_FLAG,
1166: l_okc_rule_groups_tl_rec.COMMENTS,
1167: l_okc_rule_groups_tl_rec.CREATED_BY,
1168: l_okc_rule_groups_tl_rec.CREATION_DATE,
1169: l_okc_rule_groups_tl_rec.LAST_UPDATED_BY,
1170: l_okc_rule_groups_tl_rec.LAST_UPDATE_DATE,
1171: l_okc_rule_groups_tl_rec.LAST_UPDATE_LOGIN;
1172: x_no_data_found := rgp_pktl_csr%NOTFOUND;
1173: CLOSE rgp_pktl_csr;

Line 1170: l_okc_rule_groups_tl_rec.LAST_UPDATE_DATE,

1166: l_okc_rule_groups_tl_rec.COMMENTS,
1167: l_okc_rule_groups_tl_rec.CREATED_BY,
1168: l_okc_rule_groups_tl_rec.CREATION_DATE,
1169: l_okc_rule_groups_tl_rec.LAST_UPDATED_BY,
1170: l_okc_rule_groups_tl_rec.LAST_UPDATE_DATE,
1171: l_okc_rule_groups_tl_rec.LAST_UPDATE_LOGIN;
1172: x_no_data_found := rgp_pktl_csr%NOTFOUND;
1173: CLOSE rgp_pktl_csr;
1174: RETURN(l_okc_rule_groups_tl_rec);

Line 1171: l_okc_rule_groups_tl_rec.LAST_UPDATE_LOGIN;

1167: l_okc_rule_groups_tl_rec.CREATED_BY,
1168: l_okc_rule_groups_tl_rec.CREATION_DATE,
1169: l_okc_rule_groups_tl_rec.LAST_UPDATED_BY,
1170: l_okc_rule_groups_tl_rec.LAST_UPDATE_DATE,
1171: l_okc_rule_groups_tl_rec.LAST_UPDATE_LOGIN;
1172: x_no_data_found := rgp_pktl_csr%NOTFOUND;
1173: CLOSE rgp_pktl_csr;
1174: RETURN(l_okc_rule_groups_tl_rec);
1175: END get_rec;

Line 1174: RETURN(l_okc_rule_groups_tl_rec);

1170: l_okc_rule_groups_tl_rec.LAST_UPDATE_DATE,
1171: l_okc_rule_groups_tl_rec.LAST_UPDATE_LOGIN;
1172: x_no_data_found := rgp_pktl_csr%NOTFOUND;
1173: CLOSE rgp_pktl_csr;
1174: RETURN(l_okc_rule_groups_tl_rec);
1175: END get_rec;
1176:
1177: FUNCTION get_rec (
1178: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type

Line 1178: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type

1174: RETURN(l_okc_rule_groups_tl_rec);
1175: END get_rec;
1176:
1177: FUNCTION get_rec (
1178: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type
1179: ) RETURN okc_rule_groups_tl_rec_type IS
1180: l_row_notfound BOOLEAN := TRUE;
1181: BEGIN
1182: RETURN(get_rec(p_okc_rule_groups_tl_rec, l_row_notfound));

Line 1179: ) RETURN okc_rule_groups_tl_rec_type IS

1175: END get_rec;
1176:
1177: FUNCTION get_rec (
1178: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type
1179: ) RETURN okc_rule_groups_tl_rec_type IS
1180: l_row_notfound BOOLEAN := TRUE;
1181: BEGIN
1182: RETURN(get_rec(p_okc_rule_groups_tl_rec, l_row_notfound));
1183: END get_rec;

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

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

Line 1509: p_to IN OUT NOCOPY okc_rule_groups_tl_rec_type

1505: p_to.attribute15 := p_from.attribute15;
1506: END migrate;
1507: PROCEDURE migrate (
1508: p_from IN rgpv_rec_type,
1509: p_to IN OUT NOCOPY okc_rule_groups_tl_rec_type
1510: ) IS
1511: BEGIN
1512: p_to.id := p_from.id;
1513: p_to.sfwt_flag := p_from.sfwt_flag;

Line 1522: p_from IN okc_rule_groups_tl_rec_type,

1518: p_to.last_update_date := p_from.last_update_date;
1519: p_to.last_update_login := p_from.last_update_login;
1520: END migrate;
1521: PROCEDURE migrate (
1522: p_from IN okc_rule_groups_tl_rec_type,
1523: p_to IN OUT NOCOPY rgpv_rec_type
1524: ) IS
1525: BEGIN
1526: p_to.id := p_from.id;

Line 1555: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

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

Line 1830: -- insert_row for:OKC_RULE_GROUPS_TL --

1826: '_PVT'
1827: );
1828: END insert_row;
1829: ---------------------------------------
1830: -- insert_row for:OKC_RULE_GROUPS_TL --
1831: ---------------------------------------
1832: PROCEDURE insert_row(
1833: p_init_msg_list IN VARCHAR2,
1834: x_return_status OUT NOCOPY VARCHAR2,

Line 1837: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,

1833: p_init_msg_list IN VARCHAR2,
1834: x_return_status OUT NOCOPY VARCHAR2,
1835: x_msg_count OUT NOCOPY NUMBER,
1836: x_msg_data OUT NOCOPY VARCHAR2,
1837: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
1838: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type) IS
1839:
1840: l_api_version CONSTANT NUMBER := 1;
1841: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line 1838: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type) IS

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

Line 1843: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type := p_okc_rule_groups_tl_rec;

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

Line 1844: l_def_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

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

Line 1850: -- Set_Attributes for:OKC_RULE_GROUPS_TL --

1846: SELECT *
1847: FROM FND_LANGUAGES
1848: WHERE INSTALLED_FLAG IN ('I', 'B');
1849: -------------------------------------------
1850: -- Set_Attributes for:OKC_RULE_GROUPS_TL --
1851: -------------------------------------------
1852: FUNCTION Set_Attributes (
1853: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
1854: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type

Line 1853: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,

1849: -------------------------------------------
1850: -- Set_Attributes for:OKC_RULE_GROUPS_TL --
1851: -------------------------------------------
1852: FUNCTION Set_Attributes (
1853: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
1854: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
1855: ) RETURN VARCHAR2 IS
1856: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1857: BEGIN

Line 1854: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type

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

Line 1858: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;

1854: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
1855: ) RETURN VARCHAR2 IS
1856: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1857: BEGIN
1858: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
1859: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1860: x_okc_rule_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1861: RETURN(l_return_status);
1862: END Set_Attributes;

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

1855: ) RETURN VARCHAR2 IS
1856: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1857: BEGIN
1858: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
1859: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1860: x_okc_rule_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1861: RETURN(l_return_status);
1862: END Set_Attributes;
1863: BEGIN

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

1856: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1857: BEGIN
1858: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
1859: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1860: x_okc_rule_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1861: RETURN(l_return_status);
1862: END Set_Attributes;
1863: BEGIN
1864: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1875: p_okc_rule_groups_tl_rec, -- IN

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

Line 1876: l_okc_rule_groups_tl_rec); -- OUT

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

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

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

Line 1885: INSERT INTO OKC_RULE_GROUPS_TL(

1881: RAISE OKC_API.G_EXCEPTION_ERROR;
1882: END IF;
1883: FOR l_lang_rec IN get_languages LOOP
1884: l_okc_rule_groups_tl_rec.language := l_lang_rec.language_code;
1885: INSERT INTO OKC_RULE_GROUPS_TL(
1886: id,
1887: language,
1888: source_lang,
1889: sfwt_flag,

Line 1897: l_okc_rule_groups_tl_rec.id,

1893: last_updated_by,
1894: last_update_date,
1895: last_update_login)
1896: VALUES (
1897: l_okc_rule_groups_tl_rec.id,
1898: l_okc_rule_groups_tl_rec.language,
1899: l_okc_rule_groups_tl_rec.source_lang,
1900: l_okc_rule_groups_tl_rec.sfwt_flag,
1901: l_okc_rule_groups_tl_rec.comments,

Line 1898: l_okc_rule_groups_tl_rec.language,

1894: last_update_date,
1895: last_update_login)
1896: VALUES (
1897: l_okc_rule_groups_tl_rec.id,
1898: l_okc_rule_groups_tl_rec.language,
1899: l_okc_rule_groups_tl_rec.source_lang,
1900: l_okc_rule_groups_tl_rec.sfwt_flag,
1901: l_okc_rule_groups_tl_rec.comments,
1902: l_okc_rule_groups_tl_rec.created_by,

Line 1899: l_okc_rule_groups_tl_rec.source_lang,

1895: last_update_login)
1896: VALUES (
1897: l_okc_rule_groups_tl_rec.id,
1898: l_okc_rule_groups_tl_rec.language,
1899: l_okc_rule_groups_tl_rec.source_lang,
1900: l_okc_rule_groups_tl_rec.sfwt_flag,
1901: l_okc_rule_groups_tl_rec.comments,
1902: l_okc_rule_groups_tl_rec.created_by,
1903: l_okc_rule_groups_tl_rec.creation_date,

Line 1900: l_okc_rule_groups_tl_rec.sfwt_flag,

1896: VALUES (
1897: l_okc_rule_groups_tl_rec.id,
1898: l_okc_rule_groups_tl_rec.language,
1899: l_okc_rule_groups_tl_rec.source_lang,
1900: l_okc_rule_groups_tl_rec.sfwt_flag,
1901: l_okc_rule_groups_tl_rec.comments,
1902: l_okc_rule_groups_tl_rec.created_by,
1903: l_okc_rule_groups_tl_rec.creation_date,
1904: l_okc_rule_groups_tl_rec.last_updated_by,

Line 1901: l_okc_rule_groups_tl_rec.comments,

1897: l_okc_rule_groups_tl_rec.id,
1898: l_okc_rule_groups_tl_rec.language,
1899: l_okc_rule_groups_tl_rec.source_lang,
1900: l_okc_rule_groups_tl_rec.sfwt_flag,
1901: l_okc_rule_groups_tl_rec.comments,
1902: l_okc_rule_groups_tl_rec.created_by,
1903: l_okc_rule_groups_tl_rec.creation_date,
1904: l_okc_rule_groups_tl_rec.last_updated_by,
1905: l_okc_rule_groups_tl_rec.last_update_date,

Line 1902: l_okc_rule_groups_tl_rec.created_by,

1898: l_okc_rule_groups_tl_rec.language,
1899: l_okc_rule_groups_tl_rec.source_lang,
1900: l_okc_rule_groups_tl_rec.sfwt_flag,
1901: l_okc_rule_groups_tl_rec.comments,
1902: l_okc_rule_groups_tl_rec.created_by,
1903: l_okc_rule_groups_tl_rec.creation_date,
1904: l_okc_rule_groups_tl_rec.last_updated_by,
1905: l_okc_rule_groups_tl_rec.last_update_date,
1906: l_okc_rule_groups_tl_rec.last_update_login);

Line 1903: l_okc_rule_groups_tl_rec.creation_date,

1899: l_okc_rule_groups_tl_rec.source_lang,
1900: l_okc_rule_groups_tl_rec.sfwt_flag,
1901: l_okc_rule_groups_tl_rec.comments,
1902: l_okc_rule_groups_tl_rec.created_by,
1903: l_okc_rule_groups_tl_rec.creation_date,
1904: l_okc_rule_groups_tl_rec.last_updated_by,
1905: l_okc_rule_groups_tl_rec.last_update_date,
1906: l_okc_rule_groups_tl_rec.last_update_login);
1907: END LOOP;

Line 1904: l_okc_rule_groups_tl_rec.last_updated_by,

1900: l_okc_rule_groups_tl_rec.sfwt_flag,
1901: l_okc_rule_groups_tl_rec.comments,
1902: l_okc_rule_groups_tl_rec.created_by,
1903: l_okc_rule_groups_tl_rec.creation_date,
1904: l_okc_rule_groups_tl_rec.last_updated_by,
1905: l_okc_rule_groups_tl_rec.last_update_date,
1906: l_okc_rule_groups_tl_rec.last_update_login);
1907: END LOOP;
1908: -- Set OUT values

Line 1905: l_okc_rule_groups_tl_rec.last_update_date,

1901: l_okc_rule_groups_tl_rec.comments,
1902: l_okc_rule_groups_tl_rec.created_by,
1903: l_okc_rule_groups_tl_rec.creation_date,
1904: l_okc_rule_groups_tl_rec.last_updated_by,
1905: l_okc_rule_groups_tl_rec.last_update_date,
1906: l_okc_rule_groups_tl_rec.last_update_login);
1907: END LOOP;
1908: -- Set OUT values
1909: x_okc_rule_groups_tl_rec := l_okc_rule_groups_tl_rec;

Line 1906: l_okc_rule_groups_tl_rec.last_update_login);

1902: l_okc_rule_groups_tl_rec.created_by,
1903: l_okc_rule_groups_tl_rec.creation_date,
1904: l_okc_rule_groups_tl_rec.last_updated_by,
1905: l_okc_rule_groups_tl_rec.last_update_date,
1906: l_okc_rule_groups_tl_rec.last_update_login);
1907: END LOOP;
1908: -- Set OUT values
1909: x_okc_rule_groups_tl_rec := l_okc_rule_groups_tl_rec;
1910: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1909: x_okc_rule_groups_tl_rec := l_okc_rule_groups_tl_rec;

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

Line 1962: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

1958: l_rgpv_rec rgpv_rec_type;
1959: l_def_rgpv_rec rgpv_rec_type;
1960: l_rgp_rec rgp_rec_type;
1961: lx_rgp_rec rgp_rec_type;
1962: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1963: lx_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1964: -------------------------------
1965: -- FUNCTION fill_who_columns --
1966: -------------------------------

Line 1963: lx_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

1959: l_def_rgpv_rec rgpv_rec_type;
1960: l_rgp_rec rgp_rec_type;
1961: lx_rgp_rec rgp_rec_type;
1962: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1963: lx_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
1964: -------------------------------
1965: -- FUNCTION fill_who_columns --
1966: -------------------------------
1967: FUNCTION fill_who_columns (

Line 2038: migrate(l_def_rgpv_rec, l_okc_rule_groups_tl_rec);

2034: --------------------------------------
2035: -- Move VIEW record to "Child" records
2036: --------------------------------------
2037: migrate(l_def_rgpv_rec, l_rgp_rec);
2038: migrate(l_def_rgpv_rec, l_okc_rule_groups_tl_rec);
2039: --------------------------------------------
2040: -- Call the INSERT_ROW for each child record
2041: --------------------------------------------
2042: insert_row(

Line 2061: l_okc_rule_groups_tl_rec,

2057: p_init_msg_list,
2058: x_return_status,
2059: x_msg_count,
2060: x_msg_data,
2061: l_okc_rule_groups_tl_rec,
2062: lx_okc_rule_groups_tl_rec
2063: );
2064: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2065: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2062: lx_okc_rule_groups_tl_rec

2058: x_return_status,
2059: x_msg_count,
2060: x_msg_data,
2061: l_okc_rule_groups_tl_rec,
2062: lx_okc_rule_groups_tl_rec
2063: );
2064: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2065: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2066: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2069: migrate(lx_okc_rule_groups_tl_rec, l_def_rgpv_rec);

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

Line 2282: -- lock_row for:OKC_RULE_GROUPS_TL --

2278: '_PVT'
2279: );
2280: END lock_row;
2281: -------------------------------------
2282: -- lock_row for:OKC_RULE_GROUPS_TL --
2283: -------------------------------------
2284: PROCEDURE lock_row(
2285: p_init_msg_list IN VARCHAR2,
2286: x_return_status OUT NOCOPY VARCHAR2,

Line 2289: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type) IS

2285: p_init_msg_list IN VARCHAR2,
2286: x_return_status OUT NOCOPY VARCHAR2,
2287: x_msg_count OUT NOCOPY NUMBER,
2288: x_msg_data OUT NOCOPY VARCHAR2,
2289: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type) IS
2290:
2291: E_Resource_Busy EXCEPTION;
2292: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2293: CURSOR lock_csr (p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type) IS

Line 2293: CURSOR lock_csr (p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type) IS

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

Line 2295: FROM OKC_RULE_GROUPS_TL

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

Line 2296: WHERE ID = p_okc_rule_groups_tl_rec.id

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

Line 2316: OPEN lock_csr(p_okc_rule_groups_tl_rec);

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

Line 2381: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

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

Line 2399: migrate(p_rgpv_rec, l_okc_rule_groups_tl_rec);

2395: --------------------------------------
2396: -- Move VIEW record to "Child" records
2397: --------------------------------------
2398: migrate(p_rgpv_rec, l_rgp_rec);
2399: migrate(p_rgpv_rec, l_okc_rule_groups_tl_rec);
2400: --------------------------------------------
2401: -- Call the LOCK_ROW for each child record
2402: --------------------------------------------
2403: lock_row(

Line 2420: l_okc_rule_groups_tl_rec

2416: p_init_msg_list,
2417: x_return_status,
2418: x_msg_count,
2419: x_msg_data,
2420: l_okc_rule_groups_tl_rec
2421: );
2422: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2423: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2424: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 2789: -- update_row for:OKC_RULE_GROUPS_TL --

2785: '_PVT'
2786: );
2787: END update_row;
2788: ---------------------------------------
2789: -- update_row for:OKC_RULE_GROUPS_TL --
2790: ---------------------------------------
2791: PROCEDURE update_row(
2792: p_init_msg_list IN VARCHAR2,
2793: x_return_status OUT NOCOPY VARCHAR2,

Line 2796: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,

2792: p_init_msg_list IN VARCHAR2,
2793: x_return_status OUT NOCOPY VARCHAR2,
2794: x_msg_count OUT NOCOPY NUMBER,
2795: x_msg_data OUT NOCOPY VARCHAR2,
2796: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
2797: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type) IS
2798:
2799: l_api_version CONSTANT NUMBER := 1;
2800: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';

Line 2797: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type) IS

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

Line 2802: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type := p_okc_rule_groups_tl_rec;

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

Line 2803: l_def_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

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

Line 2809: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,

2805: ----------------------------------
2806: -- FUNCTION populate_new_record --
2807: ----------------------------------
2808: FUNCTION populate_new_record (
2809: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
2810: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
2811: ) RETURN VARCHAR2 IS
2812: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
2813: l_row_notfound BOOLEAN := TRUE;

Line 2810: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type

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

Line 2812: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

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

Line 2816: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;

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

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

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

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

2818: l_okc_rule_groups_tl_rec := get_rec(p_okc_rule_groups_tl_rec, l_row_notfound);
2819: IF (l_row_notfound) THEN
2820: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2821: END IF;
2822: IF (x_okc_rule_groups_tl_rec.id = OKC_API.G_MISS_NUM)
2823: THEN
2824: x_okc_rule_groups_tl_rec.id := l_okc_rule_groups_tl_rec.id;
2825: END IF;
2826: IF (x_okc_rule_groups_tl_rec.language = OKC_API.G_MISS_CHAR)

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

2820: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2821: END IF;
2822: IF (x_okc_rule_groups_tl_rec.id = OKC_API.G_MISS_NUM)
2823: THEN
2824: x_okc_rule_groups_tl_rec.id := l_okc_rule_groups_tl_rec.id;
2825: END IF;
2826: IF (x_okc_rule_groups_tl_rec.language = OKC_API.G_MISS_CHAR)
2827: THEN
2828: x_okc_rule_groups_tl_rec.language := l_okc_rule_groups_tl_rec.language;

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

2822: IF (x_okc_rule_groups_tl_rec.id = OKC_API.G_MISS_NUM)
2823: THEN
2824: x_okc_rule_groups_tl_rec.id := l_okc_rule_groups_tl_rec.id;
2825: END IF;
2826: IF (x_okc_rule_groups_tl_rec.language = OKC_API.G_MISS_CHAR)
2827: THEN
2828: x_okc_rule_groups_tl_rec.language := l_okc_rule_groups_tl_rec.language;
2829: END IF;
2830: IF (x_okc_rule_groups_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2865: -- Set_Attributes for:OKC_RULE_GROUPS_TL --

2861: END IF;
2862: RETURN(l_return_status);
2863: END populate_new_record;
2864: -------------------------------------------
2865: -- Set_Attributes for:OKC_RULE_GROUPS_TL --
2866: -------------------------------------------
2867: FUNCTION Set_Attributes (
2868: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
2869: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type

Line 2868: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,

2864: -------------------------------------------
2865: -- Set_Attributes for:OKC_RULE_GROUPS_TL --
2866: -------------------------------------------
2867: FUNCTION Set_Attributes (
2868: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
2869: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
2870: ) RETURN VARCHAR2 IS
2871: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2872: BEGIN

Line 2869: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type

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

Line 2873: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;

2869: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
2870: ) RETURN VARCHAR2 IS
2871: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2872: BEGIN
2873: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
2874: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2875: x_okc_rule_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2876: RETURN(l_return_status);
2877: END Set_Attributes;

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

2870: ) RETURN VARCHAR2 IS
2871: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2872: BEGIN
2873: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
2874: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2875: x_okc_rule_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2876: RETURN(l_return_status);
2877: END Set_Attributes;
2878: BEGIN

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

2871: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2872: BEGIN
2873: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
2874: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2875: x_okc_rule_groups_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
2876: RETURN(l_return_status);
2877: END Set_Attributes;
2878: BEGIN
2879: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2890: p_okc_rule_groups_tl_rec, -- IN

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

Line 2891: l_okc_rule_groups_tl_rec); -- OUT

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

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

2894: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2895: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2896: RAISE OKC_API.G_EXCEPTION_ERROR;
2897: END IF;
2898: l_return_status := populate_new_record(l_okc_rule_groups_tl_rec, l_def_okc_rule_groups_tl_rec);
2899: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2900: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2901: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2902: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2904: UPDATE OKC_RULE_GROUPS_TL

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

Line 2905: SET COMMENTS = l_def_okc_rule_groups_tl_rec.comments,

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

Line 2906: CREATED_BY = l_def_okc_rule_groups_tl_rec.created_by,

2902: RAISE OKC_API.G_EXCEPTION_ERROR;
2903: END IF;
2904: UPDATE OKC_RULE_GROUPS_TL
2905: SET COMMENTS = l_def_okc_rule_groups_tl_rec.comments,
2906: CREATED_BY = l_def_okc_rule_groups_tl_rec.created_by,
2907: CREATION_DATE = l_def_okc_rule_groups_tl_rec.creation_date,
2908: LAST_UPDATED_BY = l_def_okc_rule_groups_tl_rec.last_updated_by,
2909: LAST_UPDATE_DATE = l_def_okc_rule_groups_tl_rec.last_update_date,
2910: LAST_UPDATE_LOGIN = l_def_okc_rule_groups_tl_rec.last_update_login

Line 2907: CREATION_DATE = l_def_okc_rule_groups_tl_rec.creation_date,

2903: END IF;
2904: UPDATE OKC_RULE_GROUPS_TL
2905: SET COMMENTS = l_def_okc_rule_groups_tl_rec.comments,
2906: CREATED_BY = l_def_okc_rule_groups_tl_rec.created_by,
2907: CREATION_DATE = l_def_okc_rule_groups_tl_rec.creation_date,
2908: LAST_UPDATED_BY = l_def_okc_rule_groups_tl_rec.last_updated_by,
2909: LAST_UPDATE_DATE = l_def_okc_rule_groups_tl_rec.last_update_date,
2910: LAST_UPDATE_LOGIN = l_def_okc_rule_groups_tl_rec.last_update_login
2911: WHERE ID = l_def_okc_rule_groups_tl_rec.id

Line 2908: LAST_UPDATED_BY = l_def_okc_rule_groups_tl_rec.last_updated_by,

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

Line 2909: LAST_UPDATE_DATE = l_def_okc_rule_groups_tl_rec.last_update_date,

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

Line 2910: LAST_UPDATE_LOGIN = l_def_okc_rule_groups_tl_rec.last_update_login

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

Line 2911: WHERE ID = l_def_okc_rule_groups_tl_rec.id

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

Line 2914: UPDATE OKC_RULE_GROUPS_TL

2910: LAST_UPDATE_LOGIN = l_def_okc_rule_groups_tl_rec.last_update_login
2911: WHERE ID = l_def_okc_rule_groups_tl_rec.id
2912: AND SOURCE_LANG = USERENV('LANG');
2913:
2914: UPDATE OKC_RULE_GROUPS_TL
2915: SET SFWT_FLAG = 'Y'
2916: WHERE ID = l_def_okc_rule_groups_tl_rec.id
2917: AND SOURCE_LANG <> USERENV('LANG');
2918:

Line 2916: WHERE ID = l_def_okc_rule_groups_tl_rec.id

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

Line 2919: x_okc_rule_groups_tl_rec := l_def_okc_rule_groups_tl_rec;

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

Line 2970: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

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

Line 2971: lx_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

2967: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2968: l_rgpv_rec rgpv_rec_type := p_rgpv_rec;
2969: l_def_rgpv_rec rgpv_rec_type;
2970: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
2971: lx_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
2972: l_rgp_rec rgp_rec_type;
2973: lx_rgp_rec rgp_rec_type;
2974: -------------------------------
2975: -- FUNCTION fill_who_columns --

Line 3195: migrate(l_def_rgpv_rec, l_okc_rule_groups_tl_rec);

3191:
3192: --------------------------------------
3193: -- Move VIEW record to "Child" records
3194: --------------------------------------
3195: migrate(l_def_rgpv_rec, l_okc_rule_groups_tl_rec);
3196: migrate(l_def_rgpv_rec, l_rgp_rec);
3197: --------------------------------------------
3198: -- Call the UPDATE_ROW for each child record
3199: --------------------------------------------

Line 3205: l_okc_rule_groups_tl_rec,

3201: p_init_msg_list,
3202: x_return_status,
3203: x_msg_count,
3204: x_msg_data,
3205: l_okc_rule_groups_tl_rec,
3206: lx_okc_rule_groups_tl_rec
3207: );
3208: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3209: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3206: lx_okc_rule_groups_tl_rec

3202: x_return_status,
3203: x_msg_count,
3204: x_msg_data,
3205: l_okc_rule_groups_tl_rec,
3206: lx_okc_rule_groups_tl_rec
3207: );
3208: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3209: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3210: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3213: migrate(lx_okc_rule_groups_tl_rec, l_def_rgpv_rec);

3209: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3210: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3211: RAISE OKC_API.G_EXCEPTION_ERROR;
3212: END IF;
3213: migrate(lx_okc_rule_groups_tl_rec, l_def_rgpv_rec);
3214: update_row(
3215: p_init_msg_list,
3216: x_return_status,
3217: x_msg_count,

Line 3394: -- delete_row for:OKC_RULE_GROUPS_TL --

3390: '_PVT'
3391: );
3392: END delete_row;
3393: ---------------------------------------
3394: -- delete_row for:OKC_RULE_GROUPS_TL --
3395: ---------------------------------------
3396: PROCEDURE delete_row(
3397: p_init_msg_list IN VARCHAR2,
3398: x_return_status OUT NOCOPY VARCHAR2,

Line 3401: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type) IS

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

Line 3406: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type:= p_okc_rule_groups_tl_rec;

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

Line 3409: -- Set_Attributes for:OKC_RULE_GROUPS_TL --

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

Line 3412: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,

3408: -------------------------------------------
3409: -- Set_Attributes for:OKC_RULE_GROUPS_TL --
3410: -------------------------------------------
3411: FUNCTION Set_Attributes (
3412: p_okc_rule_groups_tl_rec IN okc_rule_groups_tl_rec_type,
3413: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
3414: ) RETURN VARCHAR2 IS
3415: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3416: BEGIN

Line 3413: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type

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

Line 3417: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;

3413: x_okc_rule_groups_tl_rec OUT NOCOPY okc_rule_groups_tl_rec_type
3414: ) RETURN VARCHAR2 IS
3415: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3416: BEGIN
3417: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
3418: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3419: RETURN(l_return_status);
3420: END Set_Attributes;
3421: BEGIN

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

3414: ) RETURN VARCHAR2 IS
3415: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3416: BEGIN
3417: x_okc_rule_groups_tl_rec := p_okc_rule_groups_tl_rec;
3418: x_okc_rule_groups_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
3419: RETURN(l_return_status);
3420: END Set_Attributes;
3421: BEGIN
3422: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3433: p_okc_rule_groups_tl_rec, -- IN

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

Line 3434: l_okc_rule_groups_tl_rec); -- OUT

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

Line 3441: DELETE FROM OKC_RULE_GROUPS_TL

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

Line 3442: WHERE ID = l_okc_rule_groups_tl_rec.id;

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

Line 3492: l_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;

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

Line 3510: migrate(l_rgpv_rec, l_okc_rule_groups_tl_rec);

3506: END IF;
3507: --------------------------------------
3508: -- Move VIEW record to "Child" records
3509: --------------------------------------
3510: migrate(l_rgpv_rec, l_okc_rule_groups_tl_rec);
3511: migrate(l_rgpv_rec, l_rgp_rec);
3512: --------------------------------------------
3513: -- Call the DELETE_ROW for each child record
3514: --------------------------------------------

Line 3520: l_okc_rule_groups_tl_rec

3516: p_init_msg_list,
3517: x_return_status,
3518: x_msg_count,
3519: x_msg_data,
3520: l_okc_rule_groups_tl_rec
3521: );
3522: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3523: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3524: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 3792: INSERT INTO OKC_RULE_GROUPS_TL(

3788: );
3789:
3790: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
3791: FORALL i in 1..l_tabsize
3792: INSERT INTO OKC_RULE_GROUPS_TL(
3793: id,
3794: language,
3795: source_lang,
3796: sfwt_flag,

Line 3919: INSERT INTO okc_rule_groups_tlh

3915: -------------------------------
3916: -- Versioning TL Table
3917: -------------------------------
3918:
3919: INSERT INTO okc_rule_groups_tlh
3920: (
3921: major_version,
3922: id,
3923: language,

Line 3945: FROM okc_rule_groups_tl

3941: creation_date,
3942: last_updated_by,
3943: last_update_date,
3944: last_update_login
3945: FROM okc_rule_groups_tl
3946: WHERE id in (select id
3947: from okc_rule_groups_b
3948: where dnz_chr_id = p_chr_id);
3949:

Line 3981: INSERT INTO okc_rule_groups_tl

3977:
3978: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3979:
3980: BEGIN
3981: INSERT INTO okc_rule_groups_tl
3982: (
3983: id,
3984: language,
3985: source_lang,

Line 4005: FROM okc_rule_groups_tlh

4001: creation_date,
4002: last_updated_by,
4003: last_update_date,
4004: last_update_login
4005: FROM okc_rule_groups_tlh
4006: WHERE id in (SELECT id
4007: FROM okc_rule_groups_bh
4008: WHERE dnz_chr_id = p_chr_id)
4009: AND major_version = p_major_version;