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_V

Line 92: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_RULES_V';

88: G_NO_DEVELOPER_FLEX_DEFINED CONSTANT VARCHAR2(200) := 'OKC_NO_DEVELOPER_FLEX_DEFINED';
89: G_NO_VALUE_SET_DEFINED CONSTANT VARCHAR2(200) := 'OKC_NO_VALUE_SET_DEFINED';
90: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
91: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
92: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_RULES_V';
93: G_DF_COUNT CONSTANT NUMBER(2) := 15;
94: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
95: g_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
96: g_clob_used VARCHAR2(1) := 'N';

Line 796: l_rule_information OKC_RULES_V.RULE_INFORMATION1%TYPE;

792: TYPE l_info_type IS REF CURSOR;
793: l_info_csr l_info_type;
794: sql_stmt VARCHAR2(4000);
795: l_end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE;
796: l_rule_information OKC_RULES_V.RULE_INFORMATION1%TYPE;
797: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;
798: l_required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE;
799: l_row_notfound Boolean;
800:

Line 1264: l_object_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;

1260: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1261: TYPE l_int_type IS REF CURSOR;
1262: l_int_csr l_int_type;
1263: sql_stmt VARCHAR2(4000);
1264: l_object_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
1265: l_object_id2 OKC_RULES_V.OBJECT1_ID2%TYPE;
1266: jtot_object_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
1267: l_from_table JTF_OBJECTS_VL.FROM_TABLE%TYPE;
1268: l_where_clause varchar2(4000);

Line 1265: l_object_id2 OKC_RULES_V.OBJECT1_ID2%TYPE;

1261: TYPE l_int_type IS REF CURSOR;
1262: l_int_csr l_int_type;
1263: sql_stmt VARCHAR2(4000);
1264: l_object_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
1265: l_object_id2 OKC_RULES_V.OBJECT1_ID2%TYPE;
1266: jtot_object_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
1267: l_from_table JTF_OBJECTS_VL.FROM_TABLE%TYPE;
1268: l_where_clause varchar2(4000);
1269: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;

Line 1266: jtot_object_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;

1262: l_int_csr l_int_type;
1263: sql_stmt VARCHAR2(4000);
1264: l_object_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
1265: l_object_id2 OKC_RULES_V.OBJECT1_ID2%TYPE;
1266: jtot_object_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
1267: l_from_table JTF_OBJECTS_VL.FROM_TABLE%TYPE;
1268: l_where_clause varchar2(4000);
1269: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;
1270: TYPE l_info_type IS REF CURSOR;

Line 1610: l_object_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;

1606: function set_fk_comments(p_rulv_rec rulv_rec_type) return varchar2 as
1607: TYPE l_info_type IS REF CURSOR;
1608: l_info_csr l_info_type;
1609: sql_stmt VARCHAR2(4000);
1610: l_object_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
1611: l_object_id2 OKC_RULES_V.OBJECT1_ID2%TYPE;
1612: l_jtot_object_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
1613: l_from_table JTF_OBJECTS_VL.FROM_TABLE%TYPE;
1614: l_where_clause varchar2(4000);

Line 1611: l_object_id2 OKC_RULES_V.OBJECT1_ID2%TYPE;

1607: TYPE l_info_type IS REF CURSOR;
1608: l_info_csr l_info_type;
1609: sql_stmt VARCHAR2(4000);
1610: l_object_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
1611: l_object_id2 OKC_RULES_V.OBJECT1_ID2%TYPE;
1612: l_jtot_object_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
1613: l_from_table JTF_OBJECTS_VL.FROM_TABLE%TYPE;
1614: l_where_clause varchar2(4000);
1615: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;

Line 1612: l_jtot_object_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;

1608: l_info_csr l_info_type;
1609: sql_stmt VARCHAR2(4000);
1610: l_object_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
1611: l_object_id2 OKC_RULES_V.OBJECT1_ID2%TYPE;
1612: l_jtot_object_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
1613: l_from_table JTF_OBJECTS_VL.FROM_TABLE%TYPE;
1614: l_where_clause varchar2(4000);
1615: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;
1616: CURSOR l_jtot_csr IS

Line 1709: l_rule_information OKC_RULES_V.RULE_INFORMATION1%TYPE;

1705: TYPE l_info_type IS REF CURSOR;
1706: l_info_csr l_info_type;
1707: sql_stmt VARCHAR2(4000);
1708: l_end_user_column_name FND_DESCR_FLEX_COL_USAGE_VL.END_USER_COLUMN_NAME%TYPE;
1709: l_rule_information OKC_RULES_V.RULE_INFORMATION1%TYPE;
1710: l_flex_value_set_id FND_DESCR_FLEX_COL_USAGE_VL.FLEX_VALUE_SET_ID%TYPE;
1711: l_required_flag FND_DESCR_FLEX_COL_USAGE_VL.REQUIRED_FLAG%TYPE;
1712:
1713: CURSOR l_fvs_csr IS

Line 2294: -- FUNCTION get_rec for: OKC_RULES_V

2290: RETURN(get_rec(p_okc_rules_tl_rec, l_row_notfound));
2291: END get_rec;
2292: */
2293: ---------------------------------------------------------------------------
2294: -- FUNCTION get_rec for: OKC_RULES_V
2295: ---------------------------------------------------------------------------
2296: FUNCTION get_rec (
2297: p_rulv_rec IN rulv_rec_type,
2298: x_no_data_found OUT NOCOPY BOOLEAN

Line 2363: FROM Okc_Rules_V

2359: ans_set_jtot_object_code,
2360: ans_set_jtot_object_id1,
2361: ans_set_jtot_object_id2,
2362: DISPLAY_SEQUENCE
2363: FROM Okc_Rules_V
2364: WHERE okc_rules_v.id = p_id;
2365: l_okc_rulv_pk okc_rulv_pk_csr%ROWTYPE;
2366: l_rulv_rec rulv_rec_type;
2367: --

Line 2364: WHERE okc_rules_v.id = p_id;

2360: ans_set_jtot_object_id1,
2361: ans_set_jtot_object_id2,
2362: DISPLAY_SEQUENCE
2363: FROM Okc_Rules_V
2364: WHERE okc_rules_v.id = p_id;
2365: l_okc_rulv_pk okc_rulv_pk_csr%ROWTYPE;
2366: l_rulv_rec rulv_rec_type;
2367: --
2368: l_proc varchar2(72) := g_package||'get_rec';

Line 2453: -- FUNCTION null_out_defaults for: OKC_RULES_V --

2449: RETURN(get_rec(p_rulv_rec, l_row_notfound));
2450: END get_rec;
2451:
2452: -------------------------------------------------
2453: -- FUNCTION null_out_defaults for: OKC_RULES_V --
2454: -------------------------------------------------
2455: FUNCTION null_out_defaults (
2456: p_rulv_rec IN rulv_rec_type
2457: ) RETURN rulv_rec_type IS

Line 2652: -- Validate_Attributes for:OKC_RULES_V --

2648: ---------------------------------------------------------------------------
2649: -- PROCEDURE Validate_Attributes
2650: ---------------------------------------------------------------------------
2651: -----------------------------------------
2652: -- Validate_Attributes for:OKC_RULES_V --
2653: -----------------------------------------
2654: /* commenting out nocopy generated code in favor of hand-coded procedure
2655: FUNCTION Validate_Attributes (
2656: p_rulv_rec IN rulv_rec_type

Line 2709: -- Validate_Record for:OKC_RULES_V --

2705: ---------------------------------------------------------------------------
2706: -- PROCEDURE Validate_Record
2707: ---------------------------------------------------------------------------
2708: -------------------------------------
2709: -- Validate_Record for:OKC_RULES_V --
2710: -------------------------------------
2711: FUNCTION Validate_Record (
2712: p_rulv_rec IN rulv_rec_type
2713: ) RETURN VARCHAR2 IS

Line 2933: -- validate_row for:OKC_RULES_V --

2929: ---------------------------------------------------------------------------
2930: -- PROCEDURE validate_row
2931: ---------------------------------------------------------------------------
2932: ----------------------------------
2933: -- validate_row for:OKC_RULES_V --
2934: ----------------------------------
2935: PROCEDURE validate_row(
2936: p_api_version IN NUMBER,
2937: p_init_msg_list IN VARCHAR2,

Line 3473: -- insert_row for:OKC_RULES_V --

3469: );
3470: END insert_row;
3471: */
3472: --------------------------------
3473: -- insert_row for:OKC_RULES_V --
3474: --------------------------------
3475: PROCEDURE insert_row(
3476: p_api_version IN NUMBER,
3477: p_init_msg_list IN VARCHAR2,

Line 3512: -- Set_Attributes for:OKC_RULES_V --

3508: l_rulv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3509: RETURN(l_rulv_rec);
3510: END fill_who_columns;
3511: ------------------------------------
3512: -- Set_Attributes for:OKC_RULES_V --
3513: ------------------------------------
3514: FUNCTION Set_Attributes (
3515: p_rulv_rec IN rulv_rec_type,
3516: x_rulv_rec OUT NOCOPY rulv_rec_type

Line 3979: -- lock_row for:OKC_RULES_V --

3975: );
3976: END lock_row;
3977: */
3978: ------------------------------
3979: -- lock_row for:OKC_RULES_V --
3980: ------------------------------
3981: PROCEDURE lock_row(
3982: p_api_version IN NUMBER,
3983: p_init_msg_list IN VARCHAR2,

Line 4802: -- update_row for:OKC_RULES_V --

4798: );
4799: END update_row;
4800: */
4801: --------------------------------
4802: -- update_row for:OKC_RULES_V --
4803: --------------------------------
4804: PROCEDURE update_row(
4805: p_api_version IN NUMBER,
4806: p_init_msg_list IN VARCHAR2,

Line 5106: -- Set_Attributes for:OKC_RULES_V --

5102: END IF;
5103: RETURN(l_return_status);
5104: END populate_new_record;
5105: ------------------------------------
5106: -- Set_Attributes for:OKC_RULES_V --
5107: ------------------------------------
5108: FUNCTION Set_Attributes (
5109: p_rulv_rec IN rulv_rec_type,
5110: x_rulv_rec OUT NOCOPY rulv_rec_type

Line 5526: -- delete_row for:OKC_RULES_V --

5522: );
5523: END delete_row;
5524: */
5525: --------------------------------
5526: -- delete_row for:OKC_RULES_V --
5527: --------------------------------
5528: PROCEDURE delete_row(
5529: p_api_version IN NUMBER,
5530: p_init_msg_list IN VARCHAR2,