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_RUL_PVT dependencies on OKC_RULES_B

Line 1932: FROM OKC_RULES_B B

1928:
1929: DELETE FROM OKC_RULES_TL T
1930: WHERE NOT EXISTS (
1931: SELECT NULL
1932: FROM OKC_RULES_B B
1933: WHERE B.ID = T.ID
1934: );
1935:
1936:

Line 1999: FROM OKC_RULES_BH B

1995: );
1996: DELETE FROM OKC_RULES_TLH T
1997: WHERE NOT EXISTS (
1998: SELECT NULL
1999: FROM OKC_RULES_BH B
2000: WHERE B.ID = T.ID
2001: AND B.MAJOR_VERSION = T.MAJOR_VERSION
2002: );
2003:

Line 2073: -- FUNCTION get_rec for: OKC_RULES_B

2069: */
2070: END add_language;
2071:
2072: ---------------------------------------------------------------------------
2073: -- FUNCTION get_rec for: OKC_RULES_B
2074: ---------------------------------------------------------------------------
2075: FUNCTION get_rec (
2076: p_rul_rec IN rul_rec_type,
2077: x_no_data_found OUT NOCOPY BOOLEAN

Line 2141: FROM Okc_Rules_B

2137: ans_set_jtot_object_id2,
2138: DISPLAY_SEQUENCE,
2139: --Bug 3055393
2140: comments
2141: FROM Okc_Rules_B
2142: WHERE okc_rules_b.id = p_id;
2143: l_rul_pk rul_pk_csr%ROWTYPE;
2144: l_rul_rec rul_rec_type;
2145: --

Line 2142: WHERE okc_rules_b.id = p_id;

2138: DISPLAY_SEQUENCE,
2139: --Bug 3055393
2140: comments
2141: FROM Okc_Rules_B
2142: WHERE okc_rules_b.id = p_id;
2143: l_rul_pk rul_pk_csr%ROWTYPE;
2144: l_rul_rec rul_rec_type;
2145: --
2146: l_proc varchar2(72) := g_package||'get_rec';

Line 3116: -- insert_row for:OKC_RULES_B --

3112: ---------------------------------------------------------------------------
3113: -- PROCEDURE insert_row
3114: ---------------------------------------------------------------------------
3115: --------------------------------
3116: -- insert_row for:OKC_RULES_B --
3117: --------------------------------
3118: PROCEDURE insert_row(
3119: p_init_msg_list IN VARCHAR2,
3120: x_return_status OUT NOCOPY VARCHAR2,

Line 3135: -- Set_Attributes for:OKC_RULES_B --

3131: --
3132: l_proc varchar2(72) := g_package||'insert_row';
3133: --
3134: ------------------------------------
3135: -- Set_Attributes for:OKC_RULES_B --
3136: ------------------------------------
3137: FUNCTION Set_Attributes (
3138: p_rul_rec IN rul_rec_type,
3139: x_rul_rec OUT NOCOPY rul_rec_type

Line 3170: INSERT INTO OKC_RULES_B(

3166: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3167: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3168: RAISE OKC_API.G_EXCEPTION_ERROR;
3169: END IF;
3170: INSERT INTO OKC_RULES_B(
3171: id,
3172: rgp_id,
3173: object1_id1,
3174: object2_id1,

Line 3752: -- lock_row for:OKC_RULES_B --

3748: ---------------------------------------------------------------------------
3749: -- PROCEDURE lock_row
3750: ---------------------------------------------------------------------------
3751: ------------------------------
3752: -- lock_row for:OKC_RULES_B --
3753: ------------------------------
3754: PROCEDURE lock_row(
3755: p_init_msg_list IN VARCHAR2,
3756: x_return_status OUT NOCOPY VARCHAR2,

Line 3765: FROM OKC_RULES_B

3761: E_Resource_Busy EXCEPTION;
3762: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3763: CURSOR lock_csr (p_rul_rec IN rul_rec_type) IS
3764: SELECT OBJECT_VERSION_NUMBER
3765: FROM OKC_RULES_B
3766: WHERE ID = p_rul_rec.id
3767: AND OBJECT_VERSION_NUMBER = p_rul_rec.object_version_number
3768: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3769:

Line 3772: FROM OKC_RULES_B

3768: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3769:
3770: CURSOR lchk_csr (p_rul_rec IN rul_rec_type) IS
3771: SELECT OBJECT_VERSION_NUMBER
3772: FROM OKC_RULES_B
3773: WHERE ID = p_rul_rec.id;
3774: l_api_version CONSTANT NUMBER := 1;
3775: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3776: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 3777: l_object_version_number OKC_RULES_B.OBJECT_VERSION_NUMBER%TYPE;

3773: WHERE ID = p_rul_rec.id;
3774: l_api_version CONSTANT NUMBER := 1;
3775: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3776: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3777: l_object_version_number OKC_RULES_B.OBJECT_VERSION_NUMBER%TYPE;
3778: lc_object_version_number OKC_RULES_B.OBJECT_VERSION_NUMBER%TYPE;
3779: l_row_notfound BOOLEAN := FALSE;
3780: lc_row_notfound BOOLEAN := FALSE;
3781: --

Line 3778: lc_object_version_number OKC_RULES_B.OBJECT_VERSION_NUMBER%TYPE;

3774: l_api_version CONSTANT NUMBER := 1;
3775: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3776: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3777: l_object_version_number OKC_RULES_B.OBJECT_VERSION_NUMBER%TYPE;
3778: lc_object_version_number OKC_RULES_B.OBJECT_VERSION_NUMBER%TYPE;
3779: l_row_notfound BOOLEAN := FALSE;
3780: lc_row_notfound BOOLEAN := FALSE;
3781: --
3782: l_proc varchar2(72) := g_package||'insert_row';

Line 4177: -- update_row for:OKC_RULES_B --

4173: ---------------------------------------------------------------------------
4174: -- PROCEDURE update_row
4175: ---------------------------------------------------------------------------
4176: --------------------------------
4177: -- update_row for:OKC_RULES_B --
4178: --------------------------------
4179: PROCEDURE update_row(
4180: p_init_msg_list IN VARCHAR2,
4181: x_return_status OUT NOCOPY VARCHAR2,

Line 4464: -- Set_Attributes for:OKC_RULES_B --

4460:
4461: RETURN(l_return_status);
4462: END populate_new_record;
4463: ------------------------------------
4464: -- Set_Attributes for:OKC_RULES_B --
4465: ------------------------------------
4466: FUNCTION Set_Attributes (
4467: p_rul_rec IN rul_rec_type,
4468: x_rul_rec OUT NOCOPY rul_rec_type

Line 4506: UPDATE OKC_RULES_B

4502: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4503: RAISE OKC_API.G_EXCEPTION_ERROR;
4504: END IF;
4505:
4506: UPDATE OKC_RULES_B
4507: SET RGP_ID = l_def_rul_rec.rgp_id,
4508: OBJECT1_ID1 = l_def_rul_rec.object1_id1,
4509: OBJECT2_ID1 = l_def_rul_rec.object2_id1,
4510: OBJECT3_ID1 = l_def_rul_rec.object3_id1,

Line 5345: -- delete_row for:OKC_RULES_B --

5341: ---------------------------------------------------------------------------
5342: -- PROCEDURE delete_row
5343: ---------------------------------------------------------------------------
5344: --------------------------------
5345: -- delete_row for:OKC_RULES_B --
5346: --------------------------------
5347: PROCEDURE delete_row(
5348: p_init_msg_list IN VARCHAR2,
5349: x_return_status OUT NOCOPY VARCHAR2,

Line 5376: DELETE FROM OKC_RULES_B

5372: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5373: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5374: RAISE OKC_API.G_EXCEPTION_ERROR;
5375: END IF;
5376: DELETE FROM OKC_RULES_B
5377: WHERE ID = l_rul_rec.id;
5378:
5379: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
5380:

Line 5868: INTO OKC_RULES_B

5864: END LOOP;
5865:
5866: FORALL i in 1..l_tabsize
5867: INSERT
5868: INTO OKC_RULES_B
5869: (
5870: id,
5871: rgp_id,
5872: object1_id1,

Line 6059: INSERT INTO okc_rules_bh

6055:
6056:
6057:
6058:
6059: INSERT INTO okc_rules_bh
6060: (
6061: major_version,
6062: id,
6063: rgp_id,

Line 6185: FROM okc_rules_b

6181: ans_set_jtot_object_id2,
6182: display_sequence,
6183: --Bug 3055393
6184: comments
6185: FROM okc_rules_b
6186: WHERE dnz_chr_id = p_chr_id;
6187:
6188: --------------------------------
6189: -- Versioning TL Table

Line 6222: from okc_rules_b

6218: last_update_date,
6219: last_update_login
6220: FROM okc_rules_tl
6221: WHERE id in (select id
6222: from okc_rules_b
6223: where dnz_chr_id = p_chr_id);
6224:
6225: */
6226:

Line 6293: FROM okc_rules_bh

6289: last_update_date,
6290: last_update_login
6291: FROM okc_rules_tlh
6292: WHERE id in (SELECT id
6293: FROM okc_rules_bh
6294: WHERE dnz_chr_id = p_chr_id)
6295: AND major_version = p_major_version;
6296: */
6297: -----------------------------------------

Line 6301: INSERT INTO okc_rules_b

6297: -----------------------------------------
6298: -- Restoring Base Table
6299: -----------------------------------------
6300:
6301: INSERT INTO okc_rules_b
6302: (
6303: id,
6304: rgp_id,
6305: object1_id1,

Line 6424: FROM okc_rules_bh

6420: ans_set_jtot_object_id2,
6421: display_sequence,
6422: --Bug 3055393
6423: comments
6424: FROM okc_rules_bh
6425: WHERE dnz_chr_id = p_chr_id
6426: AND major_version = p_major_version;
6427:
6428: