DBA Data[Home] [Help]

APPS.OKC_RGP_PVT dependencies on OKC_RULE_GROUPS_V

Line 13: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_RULE_GROUPS_V';

9: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11: G_SQLERRM_TOKEn CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
13: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_RULE_GROUPS_V';
14: G_EXCEPTION_HALT_VALIDATION exception;
15: g_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
16:
17: -- Start of comments

Line 623: p_token3_value => 'OKC_RULE_GROUPS_V');

619: p_token1_value => 'parent_rgp_id',
620: p_token2 => G_CHILD_TABLE_TOKEN,
621: p_token2_value => G_VIEW,
622: p_token3 => G_PARENT_TABLE_TOKEN,
623: p_token3_value => 'OKC_RULE_GROUPS_V');
624: -- notify caller of an error
625: x_return_status := OKC_API.G_RET_STS_ERROR;
626: END IF;
627: END IF;

Line 1189: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V

1185: BEGIN
1186: RETURN(get_rec(p_okc_rule_groups_tl_rec, l_row_notfound));
1187: END get_rec;
1188: ---------------------------------------------------------------------------
1189: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V
1190: ---------------------------------------------------------------------------
1191: FUNCTION get_rec (
1192: p_rgpv_rec IN rgpv_rec_type,
1193: x_no_data_found OUT NOCOPY BOOLEAN

Line 1229: FROM Okc_Rule_Groups_V

1225: CREATION_DATE,
1226: LAST_UPDATED_BY,
1227: LAST_UPDATE_DATE,
1228: LAST_UPDATE_LOGIN
1229: FROM Okc_Rule_Groups_V
1230: WHERE okc_rule_groups_v.id = p_id;
1231: l_okc_rgpv_pk okc_rgpv_pk_csr%ROWTYPE;
1232: l_rgpv_rec rgpv_rec_type;
1233: BEGIN

Line 1230: WHERE okc_rule_groups_v.id = p_id;

1226: LAST_UPDATED_BY,
1227: LAST_UPDATE_DATE,
1228: LAST_UPDATE_LOGIN
1229: FROM Okc_Rule_Groups_V
1230: WHERE okc_rule_groups_v.id = p_id;
1231: l_okc_rgpv_pk okc_rgpv_pk_csr%ROWTYPE;
1232: l_rgpv_rec rgpv_rec_type;
1233: BEGIN
1234: x_no_data_found := TRUE;

Line 1284: -- FUNCTION null_out_defaults for: OKC_RULE_GROUPS_V --

1280: RETURN(get_rec(p_rgpv_rec, l_row_notfound));
1281: END get_rec;
1282:
1283: -------------------------------------------------------
1284: -- FUNCTION null_out_defaults for: OKC_RULE_GROUPS_V --
1285: -------------------------------------------------------
1286: FUNCTION null_out_defaults (
1287: p_rgpv_rec IN rgpv_rec_type
1288: ) RETURN rgpv_rec_type IS

Line 1390: -- Validate_Attributes for:OKC_RULE_GROUPS_V --

1386: ---------------------------------------------------------------------------
1387: -- PROCEDURE Validate_Attributes
1388: ---------------------------------------------------------------------------
1389: -----------------------------------------------
1390: -- Validate_Attributes for:OKC_RULE_GROUPS_V --
1391: -----------------------------------------------
1392: /* commenting out nocopy generated code in favor of hand-coded procedure
1393: FUNCTION Validate_Attributes (
1394: p_rgpv_rec IN rgpv_rec_type

Line 1426: -- Validate_Record for:OKC_RULE_GROUPS_V --

1422: ---------------------------------------------------------------------------
1423: -- PROCEDURE Validate_Record
1424: ---------------------------------------------------------------------------
1425: -------------------------------------------
1426: -- Validate_Record for:OKC_RULE_GROUPS_V --
1427: -------------------------------------------
1428: FUNCTION Validate_Record (
1429: p_rgpv_rec IN rgpv_rec_type
1430: ) RETURN VARCHAR2 IS

Line 1544: -- validate_row for:OKC_RULE_GROUPS_V --

1540: ---------------------------------------------------------------------------
1541: -- PROCEDURE validate_row
1542: ---------------------------------------------------------------------------
1543: ----------------------------------------
1544: -- validate_row for:OKC_RULE_GROUPS_V --
1545: ----------------------------------------
1546: PROCEDURE validate_row(
1547: p_api_version IN NUMBER,
1548: p_init_msg_list IN VARCHAR2,

Line 1948: -- insert_row for:OKC_RULE_GROUPS_V --

1944: '_PVT'
1945: );
1946: END insert_row;
1947: --------------------------------------
1948: -- insert_row for:OKC_RULE_GROUPS_V --
1949: --------------------------------------
1950: PROCEDURE insert_row(
1951: p_api_version IN NUMBER,
1952: p_init_msg_list IN VARCHAR2,

Line 1984: -- Set_Attributes for:OKC_RULE_GROUPS_V --

1980: l_rgpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1981: RETURN(l_rgpv_rec);
1982: END fill_who_columns;
1983: ------------------------------------------
1984: -- Set_Attributes for:OKC_RULE_GROUPS_V --
1985: ------------------------------------------
1986: FUNCTION Set_Attributes (
1987: p_rgpv_rec IN rgpv_rec_type,
1988: x_rgpv_rec OUT NOCOPY rgpv_rec_type

Line 2371: -- lock_row for:OKC_RULE_GROUPS_V --

2367: '_PVT'
2368: );
2369: END lock_row;
2370: ------------------------------------
2371: -- lock_row for:OKC_RULE_GROUPS_V --
2372: ------------------------------------
2373: PROCEDURE lock_row(
2374: p_api_version IN NUMBER,
2375: p_init_msg_list IN VARCHAR2,

Line 2958: -- update_row for:OKC_RULE_GROUPS_V --

2954: '_PVT'
2955: );
2956: END update_row;
2957: --------------------------------------
2958: -- update_row for:OKC_RULE_GROUPS_V --
2959: --------------------------------------
2960: PROCEDURE update_row(
2961: p_api_version IN NUMBER,
2962: p_init_msg_list IN VARCHAR2,

Line 3139: -- Set_Attributes for:OKC_RULE_GROUPS_V --

3135: END IF;
3136: RETURN(l_return_status);
3137: END populate_new_record;
3138: ------------------------------------------
3139: -- Set_Attributes for:OKC_RULE_GROUPS_V --
3140: ------------------------------------------
3141: FUNCTION Set_Attributes (
3142: p_rgpv_rec IN rgpv_rec_type,
3143: x_rgpv_rec OUT NOCOPY rgpv_rec_type

Line 3482: -- delete_row for:OKC_RULE_GROUPS_V --

3478: '_PVT'
3479: );
3480: END delete_row;
3481: --------------------------------------
3482: -- delete_row for:OKC_RULE_GROUPS_V --
3483: --------------------------------------
3484: PROCEDURE delete_row(
3485: p_api_version IN NUMBER,
3486: p_init_msg_list IN VARCHAR2,