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 1185: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V

1181: BEGIN
1182: RETURN(get_rec(p_okc_rule_groups_tl_rec, l_row_notfound));
1183: END get_rec;
1184: ---------------------------------------------------------------------------
1185: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V
1186: ---------------------------------------------------------------------------
1187: FUNCTION get_rec (
1188: p_rgpv_rec IN rgpv_rec_type,
1189: x_no_data_found OUT NOCOPY BOOLEAN

Line 1225: FROM Okc_Rule_Groups_V

1221: CREATION_DATE,
1222: LAST_UPDATED_BY,
1223: LAST_UPDATE_DATE,
1224: LAST_UPDATE_LOGIN
1225: FROM Okc_Rule_Groups_V
1226: WHERE okc_rule_groups_v.id = p_id;
1227: l_okc_rgpv_pk okc_rgpv_pk_csr%ROWTYPE;
1228: l_rgpv_rec rgpv_rec_type;
1229: BEGIN

Line 1226: WHERE okc_rule_groups_v.id = p_id;

1222: LAST_UPDATED_BY,
1223: LAST_UPDATE_DATE,
1224: LAST_UPDATE_LOGIN
1225: FROM Okc_Rule_Groups_V
1226: WHERE okc_rule_groups_v.id = p_id;
1227: l_okc_rgpv_pk okc_rgpv_pk_csr%ROWTYPE;
1228: l_rgpv_rec rgpv_rec_type;
1229: BEGIN
1230: x_no_data_found := TRUE;

Line 1280: -- FUNCTION null_out_defaults for: OKC_RULE_GROUPS_V --

1276: RETURN(get_rec(p_rgpv_rec, l_row_notfound));
1277: END get_rec;
1278:
1279: -------------------------------------------------------
1280: -- FUNCTION null_out_defaults for: OKC_RULE_GROUPS_V --
1281: -------------------------------------------------------
1282: FUNCTION null_out_defaults (
1283: p_rgpv_rec IN rgpv_rec_type
1284: ) RETURN rgpv_rec_type IS

Line 1386: -- Validate_Attributes for:OKC_RULE_GROUPS_V --

1382: ---------------------------------------------------------------------------
1383: -- PROCEDURE Validate_Attributes
1384: ---------------------------------------------------------------------------
1385: -----------------------------------------------
1386: -- Validate_Attributes for:OKC_RULE_GROUPS_V --
1387: -----------------------------------------------
1388: /* commenting out nocopy generated code in favor of hand-coded procedure
1389: FUNCTION Validate_Attributes (
1390: p_rgpv_rec IN rgpv_rec_type

Line 1422: -- Validate_Record for:OKC_RULE_GROUPS_V --

1418: ---------------------------------------------------------------------------
1419: -- PROCEDURE Validate_Record
1420: ---------------------------------------------------------------------------
1421: -------------------------------------------
1422: -- Validate_Record for:OKC_RULE_GROUPS_V --
1423: -------------------------------------------
1424: FUNCTION Validate_Record (
1425: p_rgpv_rec IN rgpv_rec_type
1426: ) RETURN VARCHAR2 IS

Line 1540: -- validate_row for:OKC_RULE_GROUPS_V --

1536: ---------------------------------------------------------------------------
1537: -- PROCEDURE validate_row
1538: ---------------------------------------------------------------------------
1539: ----------------------------------------
1540: -- validate_row for:OKC_RULE_GROUPS_V --
1541: ----------------------------------------
1542: PROCEDURE validate_row(
1543: p_api_version IN NUMBER,
1544: p_init_msg_list IN VARCHAR2,

Line 1944: -- insert_row for:OKC_RULE_GROUPS_V --

1940: '_PVT'
1941: );
1942: END insert_row;
1943: --------------------------------------
1944: -- insert_row for:OKC_RULE_GROUPS_V --
1945: --------------------------------------
1946: PROCEDURE insert_row(
1947: p_api_version IN NUMBER,
1948: p_init_msg_list IN VARCHAR2,

Line 1980: -- Set_Attributes for:OKC_RULE_GROUPS_V --

1976: l_rgpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1977: RETURN(l_rgpv_rec);
1978: END fill_who_columns;
1979: ------------------------------------------
1980: -- Set_Attributes for:OKC_RULE_GROUPS_V --
1981: ------------------------------------------
1982: FUNCTION Set_Attributes (
1983: p_rgpv_rec IN rgpv_rec_type,
1984: x_rgpv_rec OUT NOCOPY rgpv_rec_type

Line 2367: -- lock_row for:OKC_RULE_GROUPS_V --

2363: '_PVT'
2364: );
2365: END lock_row;
2366: ------------------------------------
2367: -- lock_row for:OKC_RULE_GROUPS_V --
2368: ------------------------------------
2369: PROCEDURE lock_row(
2370: p_api_version IN NUMBER,
2371: p_init_msg_list IN VARCHAR2,

Line 2954: -- update_row for:OKC_RULE_GROUPS_V --

2950: '_PVT'
2951: );
2952: END update_row;
2953: --------------------------------------
2954: -- update_row for:OKC_RULE_GROUPS_V --
2955: --------------------------------------
2956: PROCEDURE update_row(
2957: p_api_version IN NUMBER,
2958: p_init_msg_list IN VARCHAR2,

Line 3135: -- Set_Attributes for:OKC_RULE_GROUPS_V --

3131: END IF;
3132: RETURN(l_return_status);
3133: END populate_new_record;
3134: ------------------------------------------
3135: -- Set_Attributes for:OKC_RULE_GROUPS_V --
3136: ------------------------------------------
3137: FUNCTION Set_Attributes (
3138: p_rgpv_rec IN rgpv_rec_type,
3139: x_rgpv_rec OUT NOCOPY rgpv_rec_type

Line 3478: -- delete_row for:OKC_RULE_GROUPS_V --

3474: '_PVT'
3475: );
3476: END delete_row;
3477: --------------------------------------
3478: -- delete_row for:OKC_RULE_GROUPS_V --
3479: --------------------------------------
3480: PROCEDURE delete_row(
3481: p_api_version IN NUMBER,
3482: p_init_msg_list IN VARCHAR2,