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 916: FROM OKC_RULE_GROUPS_B B

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

Line 978: FROM OKC_RULE_GROUPS_BH B

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
980: AND B.MAJOR_VERSION = T.MAJOR_VERSION
981: );
982:

Line 1046: -- FUNCTION get_rec for: OKC_RULE_GROUPS_B

1042:
1043: END add_language;
1044:
1045: ---------------------------------------------------------------------------
1046: -- FUNCTION get_rec for: OKC_RULE_GROUPS_B
1047: ---------------------------------------------------------------------------
1048: FUNCTION get_rec (
1049: p_rgp_rec IN rgp_rec_type,
1050: x_no_data_found OUT NOCOPY BOOLEAN

Line 1084: FROM Okc_Rule_Groups_B

1080: ATTRIBUTE12,
1081: ATTRIBUTE13,
1082: ATTRIBUTE14,
1083: ATTRIBUTE15
1084: FROM Okc_Rule_Groups_B
1085: WHERE okc_rule_groups_b.id = p_id;
1086: l_rgp_pk rgp_pk_csr%ROWTYPE;
1087: l_rgp_rec rgp_rec_type;
1088: BEGIN

Line 1085: WHERE okc_rule_groups_b.id = p_id;

1081: ATTRIBUTE13,
1082: ATTRIBUTE14,
1083: ATTRIBUTE15
1084: FROM Okc_Rule_Groups_B
1085: WHERE okc_rule_groups_b.id = p_id;
1086: l_rgp_pk rgp_pk_csr%ROWTYPE;
1087: l_rgp_rec rgp_rec_type;
1088: BEGIN
1089: x_no_data_found := TRUE;

Line 1689: -- insert_row for:OKC_RULE_GROUPS_B --

1685: ---------------------------------------------------------------------------
1686: -- PROCEDURE insert_row
1687: ---------------------------------------------------------------------------
1688: --------------------------------------
1689: -- insert_row for:OKC_RULE_GROUPS_B --
1690: --------------------------------------
1691: PROCEDURE insert_row(
1692: p_init_msg_list IN VARCHAR2,
1693: x_return_status OUT NOCOPY VARCHAR2,

Line 1705: -- Set_Attributes for:OKC_RULE_GROUPS_B --

1701: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1702: l_rgp_rec rgp_rec_type := p_rgp_rec;
1703: l_def_rgp_rec rgp_rec_type;
1704: ------------------------------------------
1705: -- Set_Attributes for:OKC_RULE_GROUPS_B --
1706: ------------------------------------------
1707: FUNCTION Set_Attributes (
1708: p_rgp_rec IN rgp_rec_type,
1709: x_rgp_rec OUT NOCOPY rgp_rec_type

Line 1736: INSERT INTO OKC_RULE_GROUPS_B(

1732: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1733: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1734: RAISE OKC_API.G_EXCEPTION_ERROR;
1735: END IF;
1736: INSERT INTO OKC_RULE_GROUPS_B(
1737: id,
1738: rgd_code,
1739: sat_code,
1740: rgp_type,

Line 2180: -- lock_row for:OKC_RULE_GROUPS_B --

2176: ---------------------------------------------------------------------------
2177: -- PROCEDURE lock_row
2178: ---------------------------------------------------------------------------
2179: ------------------------------------
2180: -- lock_row for:OKC_RULE_GROUPS_B --
2181: ------------------------------------
2182: PROCEDURE lock_row(
2183: p_init_msg_list IN VARCHAR2,
2184: x_return_status OUT NOCOPY VARCHAR2,

Line 2193: FROM OKC_RULE_GROUPS_B

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

Line 2200: FROM OKC_RULE_GROUPS_B

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

Line 2205: l_object_version_number OKC_RULE_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

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

Line 2206: lc_object_version_number OKC_RULE_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

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

Line 2533: -- update_row for:OKC_RULE_GROUPS_B --

2529: ---------------------------------------------------------------------------
2530: -- PROCEDURE update_row
2531: ---------------------------------------------------------------------------
2532: --------------------------------------
2533: -- update_row for:OKC_RULE_GROUPS_B --
2534: --------------------------------------
2535: PROCEDURE update_row(
2536: p_init_msg_list IN VARCHAR2,
2537: x_return_status OUT NOCOPY VARCHAR2,

Line 2689: -- Set_Attributes for:OKC_RULE_GROUPS_B --

2685: END IF;
2686: RETURN(l_return_status);
2687: END populate_new_record;
2688: ------------------------------------------
2689: -- Set_Attributes for:OKC_RULE_GROUPS_B --
2690: ------------------------------------------
2691: FUNCTION Set_Attributes (
2692: p_rgp_rec IN rgp_rec_type,
2693: x_rgp_rec OUT NOCOPY rgp_rec_type

Line 2726: UPDATE OKC_RULE_GROUPS_B

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

Line 3337: -- delete_row for:OKC_RULE_GROUPS_B --

3333: ---------------------------------------------------------------------------
3334: -- PROCEDURE delete_row
3335: ---------------------------------------------------------------------------
3336: --------------------------------------
3337: -- delete_row for:OKC_RULE_GROUPS_B --
3338: --------------------------------------
3339: PROCEDURE delete_row(
3340: p_init_msg_list IN VARCHAR2,
3341: x_return_status OUT NOCOPY VARCHAR2,

Line 3361: DELETE FROM OKC_RULE_GROUPS_B

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

Line 3726: INTO OKC_RULE_GROUPS_B

3722: END LOOP;
3723:
3724: FORALL i in 1..l_tabsize
3725: INSERT
3726: INTO OKC_RULE_GROUPS_B
3727: (
3728: id,
3729: rgd_code,
3730: chr_id,

Line 3850: INSERT INTO okc_rule_groups_bh

3846:
3847: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3848:
3849: BEGIN
3850: INSERT INTO okc_rule_groups_bh
3851: (
3852: major_version,
3853: id,
3854: rgd_code,

Line 3916: FROM okc_rule_groups_b

3912: attribute12,
3913: attribute13,
3914: attribute14,
3915: attribute15
3916: FROM okc_rule_groups_b
3917: WHERE dnz_chr_id = p_chr_id;
3918:
3919: -------------------------------
3920: -- Versioning TL Table

Line 3951: from okc_rule_groups_b

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

Line 4011: FROM okc_rule_groups_bh

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;
4014:
4015: -----------------------------------------

Line 4019: INSERT INTO okc_rule_groups_b

4015: -----------------------------------------
4016: -- Restoring Base Table
4017: -----------------------------------------
4018:
4019: INSERT INTO okc_rule_groups_b
4020: (
4021: id,
4022: rgd_code,
4023: chr_id,

Line 4083: FROM okc_rule_groups_bh

4079: attribute12,
4080: attribute13,
4081: attribute14,
4082: attribute15
4083: FROM okc_rule_groups_bh
4084: WHERE dnz_chr_id = p_chr_id
4085: AND major_version = p_major_version;
4086:
4087: RETURN l_return_status;