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_B

Line 55: FROM okc_rule_groups_b

51: -- The following cursor has been changed by MSENGUPT on 12/08/2001 to use dnz_chr_id instead of chr_id
52:
53: CURSOR csr_chr_rg_cnt IS
54: SELECT count('X')
55: FROM okc_rule_groups_b
56: WHERE rgd_code = p_rgpv_rec.rgd_code
57: AND (dnz_chr_id = p_rgpv_rec.chr_id and cle_id IS NULL)
58: AND id <> NVL(p_rgpv_rec.id,-1);
59:

Line 62: FROM okc_rule_groups_b

58: AND id <> NVL(p_rgpv_rec.id,-1);
59:
60: CURSOR csr_cle_rg_cnt IS
61: SELECT count('X')
62: FROM okc_rule_groups_b
63: WHERE rgd_code = p_rgpv_rec.rgd_code
64: AND (dnz_chr_id = p_rgpv_rec.dnz_chr_id and cle_id = p_rgpv_rec.cle_id)
65: AND id <> NVL(p_rgpv_rec.id,-1);
66:

Line 578: FROM OKC_RULE_GROUPS_B rgpv

574: ) IS
575: l_dummy_var VARCHAR2(1) := '?';
576: CURSOR l_rgpv_csr IS
577: SELECT 'x'
578: FROM OKC_RULE_GROUPS_B rgpv
579: WHERE rgpv.ID = p_rgpv_rec.PARENT_RGP_ID;
580: BEGIN
581: -- initialize return status
582: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 915: FROM OKC_RULE_GROUPS_B B

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
917: AND T.LANGUAGE = USERENV('LANG')
918: );
919:

Line 974: FROM OKC_RULE_GROUPS_BH B

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
976: AND B.MAJOR_VERSION = T.MAJOR_VERSION
977: );
978:

Line 1042: -- FUNCTION get_rec for: OKC_RULE_GROUPS_B

1038:
1039: END add_language;
1040:
1041: ---------------------------------------------------------------------------
1042: -- FUNCTION get_rec for: OKC_RULE_GROUPS_B
1043: ---------------------------------------------------------------------------
1044: FUNCTION get_rec (
1045: p_rgp_rec IN rgp_rec_type,
1046: x_no_data_found OUT NOCOPY BOOLEAN

Line 1080: FROM Okc_Rule_Groups_B

1076: ATTRIBUTE12,
1077: ATTRIBUTE13,
1078: ATTRIBUTE14,
1079: ATTRIBUTE15
1080: FROM Okc_Rule_Groups_B
1081: WHERE okc_rule_groups_b.id = p_id;
1082: l_rgp_pk rgp_pk_csr%ROWTYPE;
1083: l_rgp_rec rgp_rec_type;
1084: BEGIN

Line 1081: WHERE okc_rule_groups_b.id = p_id;

1077: ATTRIBUTE13,
1078: ATTRIBUTE14,
1079: ATTRIBUTE15
1080: FROM Okc_Rule_Groups_B
1081: WHERE okc_rule_groups_b.id = p_id;
1082: l_rgp_pk rgp_pk_csr%ROWTYPE;
1083: l_rgp_rec rgp_rec_type;
1084: BEGIN
1085: x_no_data_found := TRUE;

Line 1685: -- insert_row for:OKC_RULE_GROUPS_B --

1681: ---------------------------------------------------------------------------
1682: -- PROCEDURE insert_row
1683: ---------------------------------------------------------------------------
1684: --------------------------------------
1685: -- insert_row for:OKC_RULE_GROUPS_B --
1686: --------------------------------------
1687: PROCEDURE insert_row(
1688: p_init_msg_list IN VARCHAR2,
1689: x_return_status OUT NOCOPY VARCHAR2,

Line 1701: -- Set_Attributes for:OKC_RULE_GROUPS_B --

1697: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1698: l_rgp_rec rgp_rec_type := p_rgp_rec;
1699: l_def_rgp_rec rgp_rec_type;
1700: ------------------------------------------
1701: -- Set_Attributes for:OKC_RULE_GROUPS_B --
1702: ------------------------------------------
1703: FUNCTION Set_Attributes (
1704: p_rgp_rec IN rgp_rec_type,
1705: x_rgp_rec OUT NOCOPY rgp_rec_type

Line 1732: INSERT INTO OKC_RULE_GROUPS_B(

1728: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1729: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1730: RAISE OKC_API.G_EXCEPTION_ERROR;
1731: END IF;
1732: INSERT INTO OKC_RULE_GROUPS_B(
1733: id,
1734: rgd_code,
1735: sat_code,
1736: rgp_type,

Line 2176: -- lock_row for:OKC_RULE_GROUPS_B --

2172: ---------------------------------------------------------------------------
2173: -- PROCEDURE lock_row
2174: ---------------------------------------------------------------------------
2175: ------------------------------------
2176: -- lock_row for:OKC_RULE_GROUPS_B --
2177: ------------------------------------
2178: PROCEDURE lock_row(
2179: p_init_msg_list IN VARCHAR2,
2180: x_return_status OUT NOCOPY VARCHAR2,

Line 2189: FROM OKC_RULE_GROUPS_B

2185: E_Resource_Busy EXCEPTION;
2186: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2187: CURSOR lock_csr (p_rgp_rec IN rgp_rec_type) IS
2188: SELECT OBJECT_VERSION_NUMBER
2189: FROM OKC_RULE_GROUPS_B
2190: WHERE ID = p_rgp_rec.id
2191: AND OBJECT_VERSION_NUMBER = p_rgp_rec.object_version_number
2192: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2193:

Line 2196: FROM OKC_RULE_GROUPS_B

2192: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2193:
2194: CURSOR lchk_csr (p_rgp_rec IN rgp_rec_type) IS
2195: SELECT OBJECT_VERSION_NUMBER
2196: FROM OKC_RULE_GROUPS_B
2197: WHERE ID = p_rgp_rec.id;
2198: l_api_version CONSTANT NUMBER := 1;
2199: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2200: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2201: l_object_version_number OKC_RULE_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

2197: WHERE ID = p_rgp_rec.id;
2198: l_api_version CONSTANT NUMBER := 1;
2199: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2200: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2201: l_object_version_number OKC_RULE_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
2202: lc_object_version_number OKC_RULE_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
2203: l_row_notfound BOOLEAN := FALSE;
2204: lc_row_notfound BOOLEAN := FALSE;
2205: BEGIN

Line 2202: lc_object_version_number OKC_RULE_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

2198: l_api_version CONSTANT NUMBER := 1;
2199: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2200: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2201: l_object_version_number OKC_RULE_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
2202: lc_object_version_number OKC_RULE_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
2203: l_row_notfound BOOLEAN := FALSE;
2204: lc_row_notfound BOOLEAN := FALSE;
2205: BEGIN
2206: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2529: -- update_row for:OKC_RULE_GROUPS_B --

2525: ---------------------------------------------------------------------------
2526: -- PROCEDURE update_row
2527: ---------------------------------------------------------------------------
2528: --------------------------------------
2529: -- update_row for:OKC_RULE_GROUPS_B --
2530: --------------------------------------
2531: PROCEDURE update_row(
2532: p_init_msg_list IN VARCHAR2,
2533: x_return_status OUT NOCOPY VARCHAR2,

Line 2685: -- Set_Attributes for:OKC_RULE_GROUPS_B --

2681: END IF;
2682: RETURN(l_return_status);
2683: END populate_new_record;
2684: ------------------------------------------
2685: -- Set_Attributes for:OKC_RULE_GROUPS_B --
2686: ------------------------------------------
2687: FUNCTION Set_Attributes (
2688: p_rgp_rec IN rgp_rec_type,
2689: x_rgp_rec OUT NOCOPY rgp_rec_type

Line 2722: UPDATE OKC_RULE_GROUPS_B

2718: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2719: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2720: RAISE OKC_API.G_EXCEPTION_ERROR;
2721: END IF;
2722: UPDATE OKC_RULE_GROUPS_B
2723: SET RGD_CODE = l_def_rgp_rec.rgd_code,
2724: SAT_CODE = l_def_rgp_rec.sat_code,
2725: RGP_TYPE = l_def_rgp_rec.rgp_type,
2726: CHR_ID = l_def_rgp_rec.chr_id,

Line 3333: -- delete_row for:OKC_RULE_GROUPS_B --

3329: ---------------------------------------------------------------------------
3330: -- PROCEDURE delete_row
3331: ---------------------------------------------------------------------------
3332: --------------------------------------
3333: -- delete_row for:OKC_RULE_GROUPS_B --
3334: --------------------------------------
3335: PROCEDURE delete_row(
3336: p_init_msg_list IN VARCHAR2,
3337: x_return_status OUT NOCOPY VARCHAR2,

Line 3357: DELETE FROM OKC_RULE_GROUPS_B

3353: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3354: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3355: RAISE OKC_API.G_EXCEPTION_ERROR;
3356: END IF;
3357: DELETE FROM OKC_RULE_GROUPS_B
3358: WHERE ID = l_rgp_rec.id;
3359:
3360: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3361: EXCEPTION

Line 3722: INTO OKC_RULE_GROUPS_B

3718: END LOOP;
3719:
3720: FORALL i in 1..l_tabsize
3721: INSERT
3722: INTO OKC_RULE_GROUPS_B
3723: (
3724: id,
3725: rgd_code,
3726: chr_id,

Line 3846: INSERT INTO okc_rule_groups_bh

3842:
3843: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3844:
3845: BEGIN
3846: INSERT INTO okc_rule_groups_bh
3847: (
3848: major_version,
3849: id,
3850: rgd_code,

Line 3912: FROM okc_rule_groups_b

3908: attribute12,
3909: attribute13,
3910: attribute14,
3911: attribute15
3912: FROM okc_rule_groups_b
3913: WHERE dnz_chr_id = p_chr_id;
3914:
3915: -------------------------------
3916: -- Versioning TL Table

Line 3947: from okc_rule_groups_b

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:
3950: -- Lines changed above Dated 10/06/2000
3951:

Line 4007: FROM okc_rule_groups_bh

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;
4010:
4011: -----------------------------------------

Line 4015: INSERT INTO okc_rule_groups_b

4011: -----------------------------------------
4012: -- Restoring Base Table
4013: -----------------------------------------
4014:
4015: INSERT INTO okc_rule_groups_b
4016: (
4017: id,
4018: rgd_code,
4019: chr_id,

Line 4079: FROM okc_rule_groups_bh

4075: attribute12,
4076: attribute13,
4077: attribute14,
4078: attribute15
4079: FROM okc_rule_groups_bh
4080: WHERE dnz_chr_id = p_chr_id
4081: AND major_version = p_major_version;
4082:
4083: RETURN l_return_status;