DBA Data[Home] [Help]

APPS.OKS_QUA_PVT dependencies on OKS_QUALIFIERS_V

Line 158: -- FUNCTION get_rec for: OKS_QUALIFIERS_V

154: BEGIN
155: RETURN(get_rec(p_qua_rec, l_row_notfound));
156: END get_rec;
157: ---------------------------------------------------------------------------
158: -- FUNCTION get_rec for: OKS_QUALIFIERS_V
159: ---------------------------------------------------------------------------
160: FUNCTION get_rec (
161: p_quav_rec IN quav_rec_type,
162: x_no_data_found OUT NOCOPY BOOLEAN

Line 211: FROM Oks_QUALIFIERS_V

207: ,ACTIVE_FLAG
208: ,LIST_TYPE_CODE
209: ,QUAL_ATTR_VALUE_FROM_NUMBER
210: ,QUAL_ATTR_VALUE_TO_NUMBER
211: FROM Oks_QUALIFIERS_V
212: WHERE oks_qualifiers_v.qualifier_id = p_id;
213: l_oks_quav_pk oks_quav_pk_csr%ROWTYPE;
214: l_quav_rec quav_rec_type;
215: BEGIN

Line 212: WHERE oks_qualifiers_v.qualifier_id = p_id;

208: ,LIST_TYPE_CODE
209: ,QUAL_ATTR_VALUE_FROM_NUMBER
210: ,QUAL_ATTR_VALUE_TO_NUMBER
211: FROM Oks_QUALIFIERS_V
212: WHERE oks_qualifiers_v.qualifier_id = p_id;
213: l_oks_quav_pk oks_quav_pk_csr%ROWTYPE;
214: l_quav_rec quav_rec_type;
215: BEGIN
216: x_no_data_found := TRUE;

Line 281: -- FUNCTION null_out_defaults for: OKS_QUALIFIERS_V --

277: RETURN(get_rec(p_quav_rec, l_row_notfound));
278: END get_rec;
279:
280: ----------------------------------------------------------
281: -- FUNCTION null_out_defaults for: OKS_QUALIFIERS_V --
282: ----------------------------------------------------------
283: FUNCTION null_out_defaults (
284: p_quav_rec IN quav_rec_type
285: ) RETURN quav_rec_type IS

Line 1430: -- Validate_Attributes for:OKS_QUALIFIERS_V--

1426:
1427:
1428:
1429: --------------------------------------------------
1430: -- Validate_Attributes for:OKS_QUALIFIERS_V--
1431: --------------------------------------------------
1432: /*
1433: FUNCTION Validate_Attributes (
1434: p_quav_rec IN quav_rec_type

Line 1478: OKC_UTIL.ADD_VIEW('OKS_QUALIFIERS_V',x_return_status);

1474:
1475: Begin
1476: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
1477:
1478: OKC_UTIL.ADD_VIEW('OKS_QUALIFIERS_V',x_return_status);
1479:
1480: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1481: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1482: -- need to leave

Line 2087: -- Validate_Record for:OKS_QUALIFIERS_V --

2083: ---------------------------------------------------------------------------
2084: -- PROCEDURE Validate_Record
2085: ---------------------------------------------------------------------------
2086: ----------------------------------------------
2087: -- Validate_Record for:OKS_QUALIFIERS_V --
2088: ----------------------------------------------
2089: FUNCTION Validate_Record (
2090: p_quav_rec IN quav_rec_type
2091: ) RETURN VARCHAR2 IS

Line 2277: -- validate_row for:OKS_QUALIFIERS_V --

2273: ---------------------------------------------------------------------------
2274: -- PROCEDURE validate_row
2275: ---------------------------------------------------------------------------
2276: -------------------------------------------
2277: -- validate_row for:OKS_QUALIFIERS_V --
2278: -------------------------------------------
2279: PROCEDURE validate_row(
2280: p_api_version IN NUMBER,
2281: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2596: -- insert_row for:OKS_QUALIFIERS_V --

2592: '_PVT'
2593: );
2594: END insert_row;
2595: -----------------------------------------
2596: -- insert_row for:OKS_QUALIFIERS_V --
2597: -----------------------------------------
2598: PROCEDURE insert_row(
2599: p_api_version IN NUMBER,
2600: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2630: -- Set_Attributes for:OKS_QUALIFIERS_V -

2626: l_quav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2627: RETURN(l_quav_rec);
2628: END fill_who_columns;
2629: ---------------------------------------------
2630: -- Set_Attributes for:OKS_QUALIFIERS_V -
2631: ---------------------------------------------
2632: FUNCTION Set_Attributes (
2633: p_quav_rec IN quav_rec_type,
2634: x_quav_rec OUT NOCOPY quav_rec_type

Line 2892: -- lock_row for:OKS_QUALIFIERS_V --

2888: '_PVT'
2889: );
2890: END lock_row;
2891: ---------------------------------------
2892: -- lock_row for:OKS_QUALIFIERS_V --
2893: ---------------------------------------
2894: PROCEDURE lock_row(
2895: p_api_version IN NUMBER,
2896: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3646: -- Set_Attributes for:OKS_QUALIFIERS_V --

3642:
3643: RETURN(l_return_status);
3644: END populate_new_record;
3645: ---------------------------------------------
3646: -- Set_Attributes for:OKS_QUALIFIERS_V --
3647: ---------------------------------------------
3648: FUNCTION Set_Attributes (
3649: p_quav_rec IN quav_rec_type,
3650: x_quav_rec OUT NOCOPY quav_rec_type

Line 3889: -- delete_row for:OKS_QUALIFIERS_V --

3885: '_PVT'
3886: );
3887: END delete_row;
3888: -----------------------------------------
3889: -- delete_row for:OKS_QUALIFIERS_V --
3890: -----------------------------------------
3891: PROCEDURE delete_row(
3892: p_api_version IN NUMBER,
3893: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,