DBA Data[Home] [Help]

APPS.OKC_RGR_PVT dependencies on OKC_RG_DEF_RULES_V

Line 16: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_RG_DEF_RULES_V';

12: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_RG_DEF_RULES_V';
17: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
18: G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
19:
20: -- Start of comments

Line 947: -- FUNCTION get_rec for: OKC_RG_DEF_RULES_V

943: RETURN(get_rec(p_rgr_rec, l_row_notfound));
944:
945: END get_rec;
946: ---------------------------------------------------------------------------
947: -- FUNCTION get_rec for: OKC_RG_DEF_RULES_V
948: ---------------------------------------------------------------------------
949: FUNCTION get_rec (
950: p_rgrv_rec IN rgrv_rec_type,
951: x_no_data_found OUT NOCOPY BOOLEAN

Line 969: FROM Okc_Rg_Def_Rules_V

965: MIN_CARDINALITY,
966: MAX_CARDINALITY,
967: PRICING_RELATED_YN,
968: ACCESS_LEVEL
969: FROM Okc_Rg_Def_Rules_V
970: WHERE okc_rg_def_rules_v.rgd_code = p_rgd_code
971: AND okc_rg_def_rules_v.rdf_code = p_rdf_code;
972: l_okc_rgrv_pk okc_rgrv_pk_csr%ROWTYPE;
973: l_rgrv_rec rgrv_rec_type;

Line 970: WHERE okc_rg_def_rules_v.rgd_code = p_rgd_code

966: MAX_CARDINALITY,
967: PRICING_RELATED_YN,
968: ACCESS_LEVEL
969: FROM Okc_Rg_Def_Rules_V
970: WHERE okc_rg_def_rules_v.rgd_code = p_rgd_code
971: AND okc_rg_def_rules_v.rdf_code = p_rdf_code;
972: l_okc_rgrv_pk okc_rgrv_pk_csr%ROWTYPE;
973: l_rgrv_rec rgrv_rec_type;
974: BEGIN

Line 971: AND okc_rg_def_rules_v.rdf_code = p_rdf_code;

967: PRICING_RELATED_YN,
968: ACCESS_LEVEL
969: FROM Okc_Rg_Def_Rules_V
970: WHERE okc_rg_def_rules_v.rgd_code = p_rgd_code
971: AND okc_rg_def_rules_v.rdf_code = p_rdf_code;
972: l_okc_rgrv_pk okc_rgrv_pk_csr%ROWTYPE;
973: l_rgrv_rec rgrv_rec_type;
974: BEGIN
975:

Line 1022: -- FUNCTION null_out_defaults for: OKC_RG_DEF_RULES_V --

1018:
1019: END get_rec;
1020:
1021: --------------------------------------------------------
1022: -- FUNCTION null_out_defaults for: OKC_RG_DEF_RULES_V --
1023: --------------------------------------------------------
1024: FUNCTION null_out_defaults (
1025: p_rgrv_rec IN rgrv_rec_type
1026: ) RETURN rgrv_rec_type IS

Line 1087: -- Validate_Attributes for:OKC_RG_DEF_RULES_V --

1083: ---------------------------------------------------------------------------
1084: -- PROCEDURE Validate_Attributes
1085: ---------------------------------------------------------------------------
1086: ------------------------------------------------
1087: -- Validate_Attributes for:OKC_RG_DEF_RULES_V --
1088: ------------------------------------------------
1089: /* commenting out nocopy generated code in favor of hand-coded procedure
1090: FUNCTION Validate_Attributes (
1091: p_rgrv_rec IN rgrv_rec_type

Line 1125: -- Validate_Record for:OKC_RG_DEF_RULES_V --

1121: ---------------------------------------------------------------------------
1122: -- PROCEDURE Validate_Record
1123: ---------------------------------------------------------------------------
1124: --------------------------------------------
1125: -- Validate_Record for:OKC_RG_DEF_RULES_V --
1126: --------------------------------------------
1127: FUNCTION Validate_Record (
1128: p_rgrv_rec IN rgrv_rec_type
1129: ) RETURN VARCHAR2 IS

Line 1187: -- validate_row for:OKC_RG_DEF_RULES_V --

1183: ---------------------------------------------------------------------------
1184: -- PROCEDURE validate_row
1185: ---------------------------------------------------------------------------
1186: -----------------------------------------
1187: -- validate_row for:OKC_RG_DEF_RULES_V --
1188: -----------------------------------------
1189: PROCEDURE validate_row(
1190: p_api_version IN NUMBER,
1191: p_init_msg_list IN VARCHAR2,

Line 1540: -- insert_row for:OKC_RG_DEF_RULES_V --

1536: );
1537:
1538: END insert_row;
1539: ---------------------------------------
1540: -- insert_row for:OKC_RG_DEF_RULES_V --
1541: ---------------------------------------
1542: PROCEDURE insert_row(
1543: p_api_version IN NUMBER,
1544: p_init_msg_list IN VARCHAR2,

Line 1576: -- Set_Attributes for:OKC_RG_DEF_RULES_V --

1572: RETURN(l_rgrv_rec);
1573:
1574: END fill_who_columns;
1575: -------------------------------------------
1576: -- Set_Attributes for:OKC_RG_DEF_RULES_V --
1577: -------------------------------------------
1578: FUNCTION Set_Attributes (
1579: p_rgrv_rec IN rgrv_rec_type,
1580: x_rgrv_rec OUT NOCOPY rgrv_rec_type

Line 1976: -- lock_row for:OKC_RG_DEF_RULES_V --

1972: );
1973:
1974: END lock_row;
1975: -------------------------------------
1976: -- lock_row for:OKC_RG_DEF_RULES_V --
1977: -------------------------------------
1978: PROCEDURE lock_row(
1979: p_api_version IN NUMBER,
1980: p_init_msg_list IN VARCHAR2,

Line 2408: -- update_row for:OKC_RG_DEF_RULES_V --

2404: );
2405:
2406: END update_row;
2407: ---------------------------------------
2408: -- update_row for:OKC_RG_DEF_RULES_V --
2409: ---------------------------------------
2410: PROCEDURE update_row(
2411: p_api_version IN NUMBER,
2412: p_init_msg_list IN VARCHAR2,

Line 2526: -- Set_Attributes for:OKC_RG_DEF_RULES_V --

2522: RETURN(l_return_status);
2523:
2524: END populate_new_record;
2525: -------------------------------------------
2526: -- Set_Attributes for:OKC_RG_DEF_RULES_V --
2527: -------------------------------------------
2528: FUNCTION Set_Attributes (
2529: p_rgrv_rec IN rgrv_rec_type,
2530: x_rgrv_rec OUT NOCOPY rgrv_rec_type

Line 2862: -- delete_row for:OKC_RG_DEF_RULES_V --

2858: );
2859:
2860: END delete_row;
2861: ---------------------------------------
2862: -- delete_row for:OKC_RG_DEF_RULES_V --
2863: ---------------------------------------
2864: PROCEDURE delete_row(
2865: p_api_version IN NUMBER,
2866: p_init_msg_list IN VARCHAR2,