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.

[Home] [Help]

APPS.OKS_QUA_PVT dependencies on OKS_QUALIFIERS

Line 37: -- FUNCTION get_rec for: OKS_QUALIFIERS

33: null;
34: END api_copy;
35:
36: ---------------------------------------------------------------------------
37: -- FUNCTION get_rec for: OKS_QUALIFIERS
38: ---------------------------------------------------------------------------
39: FUNCTION get_rec (
40: p_qua_rec IN qua_rec_type,
41: x_no_data_found OUT NOCOPY BOOLEAN

Line 90: FROM oks_qualifiers

86: ,ACTIVE_FLAG
87: ,LIST_TYPE_CODE
88: ,QUAL_ATTR_VALUE_FROM_NUMBER
89: ,QUAL_ATTR_VALUE_TO_NUMBER
90: FROM oks_qualifiers
91: WHERE qualifier_id = p_id;
92: l_qua_pk qua_pk_csr%ROWTYPE;
93: l_qua_rec qua_rec_type;
94: BEGIN

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 2421: -- insert_row for:OKS_QUALIFIERS --

2417: ---------------------------------------------------------------------------
2418: -- PROCEDURE insert_row
2419: ---------------------------------------------------------------------------
2420: ---------------------------------------
2421: -- insert_row for:OKS_QUALIFIERS --
2422: ---------------------------------------
2423: PROCEDURE insert_row(
2424: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2425: x_return_status OUT NOCOPY VARCHAR2,

Line 2468: INSERT INTO OKS_QUALIFIERS(

2464: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2465: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2466: RAISE OKC_API.G_EXCEPTION_ERROR;
2467: END IF;
2468: INSERT INTO OKS_QUALIFIERS(
2469: QUALIFIER_ID
2470: ,CREATION_DATE
2471: ,CREATED_BY
2472: ,LAST_UPDATE_DATE

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 2824: FROM OKS_QUALIFIERS

2820: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2821:
2822: CURSOR lchk_csr (p_qua_rec IN qua_rec_type) IS
2823: SELECT qualifier_id
2824: FROM OKS_QUALIFIERS
2825: WHERE QUALIFIER_ID = p_qua_rec.qualifier_id;
2826: l_api_version CONSTANT NUMBER := 1;
2827: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
2828: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2829: l_qualifier_id OKS_QUALIFIERS.qualifier_id%TYPE;

2825: WHERE QUALIFIER_ID = p_qua_rec.qualifier_id;
2826: l_api_version CONSTANT NUMBER := 1;
2827: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
2828: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2829: l_qualifier_id OKS_QUALIFIERS.qualifier_id%TYPE;
2830: lc_qualifier_id OKS_QUALIFIERS.qualifier_id%TYPE;
2831: l_row_notfound BOOLEAN := FALSE;
2832: lc_row_notfound BOOLEAN := FALSE;
2833: BEGIN

Line 2830: lc_qualifier_id OKS_QUALIFIERS.qualifier_id%TYPE;

2826: l_api_version CONSTANT NUMBER := 1;
2827: l_api_name CONSTANT VARCHAR2(30) := 'LINES_lock_row';
2828: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2829: l_qualifier_id OKS_QUALIFIERS.qualifier_id%TYPE;
2830: lc_qualifier_id OKS_QUALIFIERS.qualifier_id%TYPE;
2831: l_row_notfound BOOLEAN := FALSE;
2832: lc_row_notfound BOOLEAN := FALSE;
2833: BEGIN
2834: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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 3040: -- update_row for:OKS_QUALIFIERS --

3036: ---------------------------------------------------------------------------
3037: -- PROCEDURE update_row
3038: ---------------------------------------------------------------------------
3039: ---------------------------------------
3040: -- update_row for:OKS_QUALIFIERS --
3041: ---------------------------------------
3042: PROCEDURE update_row(
3043: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3044: x_return_status OUT NOCOPY VARCHAR2,

Line 3278: -- Set_Attributes for:OKS_QUALIFIERS --

3274:
3275: RETURN(l_return_status);
3276: END populate_new_record;
3277: -------------------------------------------
3278: -- Set_Attributes for:OKS_QUALIFIERS --
3279: -------------------------------------------
3280: FUNCTION Set_Attributes (
3281: p_qua_rec IN qua_rec_type,
3282: x_qua_rec OUT NOCOPY qua_rec_type

Line 3315: UPDATE OKS_QUALIFIERS

3311: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3312: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3313: RAISE OKC_API.G_EXCEPTION_ERROR;
3314: END IF;
3315: UPDATE OKS_QUALIFIERS
3316: SET
3317: QUALIFIER_ID = l_def_qua_rec.QUALIFIER_ID ,
3318: CREATION_DATE = l_def_qua_rec.CREATION_DATE ,
3319: CREATED_BY = l_def_qua_rec.CREATED_BY ,

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 3828: -- delete_row for:OKS_QUALIFIERS --

3824: ---------------------------------------------------------------------------
3825: -- PROCEDURE delete_row
3826: ---------------------------------------------------------------------------
3827: ---------------------------------------
3828: -- delete_row for:OKS_QUALIFIERS --
3829: ---------------------------------------
3830: PROCEDURE delete_row(
3831: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3832: x_return_status OUT NOCOPY VARCHAR2,

Line 3852: DELETE FROM OKS_QUALIFIERS

3848: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3849: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3850: RAISE OKC_API.G_EXCEPTION_ERROR;
3851: END IF;
3852: DELETE FROM OKS_QUALIFIERS
3853: WHERE QUALIFIER_ID = l_qua_rec.qualifier_id;
3854:
3855: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3856: EXCEPTION

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,