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.

APPS.OKC_AAE_PVT dependencies on OKC_ACTION_ATTRIBUTES_V

Line 281: -- FUNCTION get_rec for: OKC_ACTION_ATTRIBUTES_V

277: BEGIN
278: RETURN(get_rec(p_okc_action_attributes_tl_rec, l_row_notfound));
279: END get_rec;
280: ---------------------------------------------------------------------------
281: -- FUNCTION get_rec for: OKC_ACTION_ATTRIBUTES_V
282: ---------------------------------------------------------------------------
283: FUNCTION get_rec (
284: p_aaev_rec IN aaev_rec_type,
285: x_no_data_found OUT NOCOPY BOOLEAN

Line 331: FROM Okc_Action_Attributes_V

327: CREATION_DATE,
328: LAST_UPDATED_BY,
329: LAST_UPDATE_DATE,
330: LAST_UPDATE_LOGIN
331: FROM Okc_Action_Attributes_V
332: WHERE okc_action_attributes_v.id = p_id;
333: l_okc_aaev_pk okc_aaev_pk_csr%ROWTYPE;
334: l_aaev_rec aaev_rec_type;
335: BEGIN

Line 332: WHERE okc_action_attributes_v.id = p_id;

328: LAST_UPDATED_BY,
329: LAST_UPDATE_DATE,
330: LAST_UPDATE_LOGIN
331: FROM Okc_Action_Attributes_V
332: WHERE okc_action_attributes_v.id = p_id;
333: l_okc_aaev_pk okc_aaev_pk_csr%ROWTYPE;
334: l_aaev_rec aaev_rec_type;
335: BEGIN
336: x_no_data_found := TRUE;

Line 396: -- FUNCTION null_out_defaults for: OKC_ACTION_ATTRIBUTES_V --

392: RETURN(get_rec(p_aaev_rec, l_row_notfound));
393: END get_rec;
394:
395: -------------------------------------------------------------
396: -- FUNCTION null_out_defaults for: OKC_ACTION_ATTRIBUTES_V --
397: -------------------------------------------------------------
398: FUNCTION null_out_defaults (
399: p_aaev_rec IN aaev_rec_type
400: ) RETURN aaev_rec_type IS

Line 534: -- Validate_Attributes for:OKC_ACTION_ATTRIBUTES_V --

530: ---------------------------------------------------------------------------
531: -- PROCEDURE Validate_Attributes
532: ---------------------------------------------------------------------------
533: -----------------------------------------------------
534: -- Validate_Attributes for:OKC_ACTION_ATTRIBUTES_V --
535: -----------------------------------------------------
536: FUNCTION Validate_Attributes (
537: p_aaev_rec IN aaev_rec_type
538: ) RETURN VARCHAR2 IS

Line 594: -- Validate_Record for:OKC_ACTION_ATTRIBUTES_V --

590: ---------------------------------------------------------------------------
591: -- PROCEDURE Validate_Record
592: ---------------------------------------------------------------------------
593: -------------------------------------------------
594: -- Validate_Record for:OKC_ACTION_ATTRIBUTES_V --
595: -------------------------------------------------
596: FUNCTION Validate_Record (
597: p_aaev_rec IN aaev_rec_type
598: ) RETURN VARCHAR2 IS

Line 1535: FROM Okc_Action_Attributes_V

1531: IS
1532:
1533: CURSOR okc_doi_csr (p_id IN NUMBER) IS
1534: SELECT '1'
1535: FROM Okc_Action_Attributes_V
1536: WHERE okc_action_attributes_v.acn_id = p_id
1537: AND okc_action_attributes_v.date_of_interest_yn = 'Y';
1538:
1539: l_dummy_var VARCHAR2(1);

Line 1536: WHERE okc_action_attributes_v.acn_id = p_id

1532:
1533: CURSOR okc_doi_csr (p_id IN NUMBER) IS
1534: SELECT '1'
1535: FROM Okc_Action_Attributes_V
1536: WHERE okc_action_attributes_v.acn_id = p_id
1537: AND okc_action_attributes_v.date_of_interest_yn = 'Y';
1538:
1539: l_dummy_var VARCHAR2(1);
1540:

Line 1537: AND okc_action_attributes_v.date_of_interest_yn = 'Y';

1533: CURSOR okc_doi_csr (p_id IN NUMBER) IS
1534: SELECT '1'
1535: FROM Okc_Action_Attributes_V
1536: WHERE okc_action_attributes_v.acn_id = p_id
1537: AND okc_action_attributes_v.date_of_interest_yn = 'Y';
1538:
1539: l_dummy_var VARCHAR2(1);
1540:
1541: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2042: CURSOR c1(p_acn_id okc_action_attributes_v.acn_id%TYPE,

2038: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2039: l_unq_tbl OKC_UTIL.unq_tbl_type;
2040: l_dummy VARCHAR2(1);
2041: l_row_found Boolean := False;
2042: CURSOR c1(p_acn_id okc_action_attributes_v.acn_id%TYPE,
2043: p_element_name okc_Action_attributes_v.element_name%TYPE) is
2044: SELECT 1
2045: FROM okc_action_attributes_b
2046: WHERE acn_id = p_acn_id

Line 2043: p_element_name okc_Action_attributes_v.element_name%TYPE) is

2039: l_unq_tbl OKC_UTIL.unq_tbl_type;
2040: l_dummy VARCHAR2(1);
2041: l_row_found Boolean := False;
2042: CURSOR c1(p_acn_id okc_action_attributes_v.acn_id%TYPE,
2043: p_element_name okc_Action_attributes_v.element_name%TYPE) is
2044: SELECT 1
2045: FROM okc_action_attributes_b
2046: WHERE acn_id = p_acn_id
2047: AND element_name = p_element_name

Line 2069: OKC_UTIL.check_comp_unique(p_view_name => 'OKC_ACTION_ATTRIBUTES_V'

2065: -- initialize return status
2066: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2067:
2068: -- call check_comp_unique utility
2069: OKC_UTIL.check_comp_unique(p_view_name => 'OKC_ACTION_ATTRIBUTES_V'
2070: ,p_col_tbl => l_unq_tbl
2071: ,p_id => p_aaev_rec.id
2072: ,x_return_status => l_return_status);
2073: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 2469: -- validate_row for:OKC_ACTION_ATTRIBUTES_V --

2465: ---------------------------------------------------------------------------
2466: -- PROCEDURE validate_row
2467: ---------------------------------------------------------------------------
2468: ----------------------------------------------
2469: -- validate_row for:OKC_ACTION_ATTRIBUTES_V --
2470: ----------------------------------------------
2471: PROCEDURE validate_row(
2472: p_api_version IN NUMBER,
2473: p_init_msg_list IN VARCHAR2 ,

Line 2893: -- insert_row for:OKC_ACTION_ATTRIBUTES_V --

2889: '_PVT'
2890: );
2891: END insert_row;
2892: --------------------------------------------
2893: -- insert_row for:OKC_ACTION_ATTRIBUTES_V --
2894: --------------------------------------------
2895: PROCEDURE insert_row(
2896: p_api_version IN NUMBER,
2897: p_init_msg_list IN VARCHAR2 ,

Line 2930: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_V --

2926: l_aaev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2927: RETURN(l_aaev_rec);
2928: END fill_who_columns;
2929: ------------------------------------------------
2930: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_V --
2931: ------------------------------------------------
2932: FUNCTION Set_Attributes (
2933: p_aaev_rec IN aaev_rec_type,
2934: x_aaev_rec OUT NOCOPY aaev_rec_type

Line 3326: -- lock_row for:OKC_ACTION_ATTRIBUTES_V --

3322: '_PVT'
3323: );
3324: END lock_row;
3325: ------------------------------------------
3326: -- lock_row for:OKC_ACTION_ATTRIBUTES_V --
3327: ------------------------------------------
3328: PROCEDURE lock_row(
3329: p_api_version IN NUMBER,
3330: p_init_msg_list IN VARCHAR2 ,

Line 3965: -- update_row for:OKC_ACTION_ATTRIBUTES_V --

3961: '_PVT'
3962: );
3963: END update_row;
3964: --------------------------------------------
3965: -- update_row for:OKC_ACTION_ATTRIBUTES_V --
3966: --------------------------------------------
3967: PROCEDURE update_row(
3968: p_api_version IN NUMBER,
3969: p_init_msg_list IN VARCHAR2 ,

Line 4186: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_V --

4182: END IF;
4183: RETURN(l_return_status);
4184: END populate_new_record;
4185: ------------------------------------------------
4186: -- Set_Attributes for:OKC_ACTION_ATTRIBUTES_V --
4187: ------------------------------------------------
4188: FUNCTION Set_Attributes (
4189: p_aaev_rec IN aaev_rec_type,
4190: x_aaev_rec OUT NOCOPY aaev_rec_type

Line 4542: -- delete_row for:OKC_ACTION_ATTRIBUTES_V --

4538: '_PVT'
4539: );
4540: END delete_row;
4541: --------------------------------------------
4542: -- delete_row for:OKC_ACTION_ATTRIBUTES_V --
4543: --------------------------------------------
4544: PROCEDURE delete_row(
4545: p_api_version IN NUMBER,
4546: p_init_msg_list IN VARCHAR2 ,