APPS.OKC_ACN_PVT dependencies on OKC_ACTIONS_V

Line 283: -- FUNCTION get_rec for: OKC_ACTIONS_V

279: BEGIN
280: RETURN(get_rec(p_okc_actions_tl_rec, l_row_notfound));
281: END get_rec;
282: ---------------------------------------------------------------------------
283: -- FUNCTION get_rec for: OKC_ACTIONS_V
284: ---------------------------------------------------------------------------
285: FUNCTION get_rec (
286: p_acnv_rec IN acnv_rec_type,
287: x_no_data_found OUT NOCOPY BOOLEAN

Line 327: FROM Okc_Actions_V

323: CREATION_DATE,
324: LAST_UPDATED_BY,
325: LAST_UPDATE_DATE,
326: LAST_UPDATE_LOGIN
327: FROM Okc_Actions_V
328: WHERE okc_actions_v.id = p_id;
329: l_okc_acnv_pk okc_acnv_pk_csr%ROWTYPE;
330: l_acnv_rec acnv_rec_type;
331: BEGIN

Line 328: WHERE okc_actions_v.id = p_id;

324: LAST_UPDATED_BY,
325: LAST_UPDATE_DATE,
326: LAST_UPDATE_LOGIN
327: FROM Okc_Actions_V
328: WHERE okc_actions_v.id = p_id;
329: l_okc_acnv_pk okc_acnv_pk_csr%ROWTYPE;
330: l_acnv_rec acnv_rec_type;
331: BEGIN
332: x_no_data_found := TRUE;

Line 386: -- FUNCTION null_out_defaults for: OKC_ACTIONS_V --

382: RETURN(get_rec(p_acnv_rec, l_row_notfound));
383: END get_rec;
384:
385: ---------------------------------------------------
386: -- FUNCTION null_out_defaults for: OKC_ACTIONS_V --
387: ---------------------------------------------------
388: FUNCTION null_out_defaults (
389: p_acnv_rec IN acnv_rec_type
390: ) RETURN acnv_rec_type IS

Line 506: -- Validate_Attributes for:OKC_ACTIONS_V --

502: ---------------------------------------------------------------------------
503: -- PROCEDURE Validate_Attributes
504: ---------------------------------------------------------------------------
505: -------------------------------------------
506: -- Validate_Attributes for:OKC_ACTIONS_V --
507: -------------------------------------------
508: FUNCTION Validate_Attributes (
509: p_acnv_rec IN acnv_rec_type
510: ) RETURN VARCHAR2 IS

Line 582: SELECT id FROM OKC_ACTIONS_V

578: ,p_acnv_rec IN acnv_rec_type)
579: IS
580:
581: CURSOR l_unq_cur(p_correlation VARCHAR2) IS
582: SELECT id FROM OKC_ACTIONS_V
583: WHERE correlation = p_correlation;
584:
585: l_id NUMBER := OKC_API.G_MISS_NUM;
586: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 622: OKC_UTIL.CHECK_UNIQUE(p_view_name => 'OKC_ACTIONS_V'

618: p_msg_name => 'OKC_DUP_CORRELATION_NAME');
619: END IF;
620:
621: /*
622: OKC_UTIL.CHECK_UNIQUE(p_view_name => 'OKC_ACTIONS_V'
623: ,p_col_name => 'correlation'
624: ,p_col_value => p_acnv_rec.correlation
625: ,p_id => p_acnv_rec.id
626: ,x_return_status => l_return_status);

Line 1127: OKC_UTIL.CHECK_UNIQUE(p_view_name => 'OKC_ACTIONS_V'

1123: (p_acnv_rec.name <> OKC_API.G_MISS_CHAR) THEN
1124:
1125: -- check uniqueness
1126:
1127: OKC_UTIL.CHECK_UNIQUE(p_view_name => 'OKC_ACTIONS_V'
1128: ,p_col_name => 'name'
1129: ,p_col_value => p_acnv_rec.name
1130: ,p_id => p_acnv_rec.id
1131: ,x_return_status => l_return_status);

Line 1795: -- Validate_Record for:OKC_ACTIONS_V --

1791: ---------------------------------------------------------------------------
1792: -- PROCEDURE Validate_Record
1793: ---------------------------------------------------------------------------
1794: ---------------------------------------
1795: -- Validate_Record for:OKC_ACTIONS_V --
1796: ---------------------------------------
1797: FUNCTION Validate_Record (
1798: p_acnv_rec IN acnv_rec_type
1799: ) RETURN VARCHAR2 IS

Line 1922: -- validate_row for:OKC_ACTIONS_V --

1918: ---------------------------------------------------------------------------
1919: -- PROCEDURE validate_row
1920: ---------------------------------------------------------------------------
1921: ------------------------------------
1922: -- validate_row for:OKC_ACTIONS_V --
1923: ------------------------------------
1924: PROCEDURE validate_row(
1925: p_api_version IN NUMBER,
1926: p_init_msg_list IN VARCHAR2 ,

Line 2334: -- insert_row for:OKC_ACTIONS_V --

2330: '_PVT'
2331: );
2332: END insert_row;
2333: ----------------------------------
2334: -- insert_row for:OKC_ACTIONS_V --
2335: ----------------------------------
2336: PROCEDURE insert_row(
2337: p_api_version IN NUMBER,
2338: p_init_msg_list IN VARCHAR2 ,

Line 2371: -- Set_Attributes for:OKC_ACTIONS_V --

2367: l_acnv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2368: RETURN(l_acnv_rec);
2369: END fill_who_columns;
2370: --------------------------------------
2371: -- Set_Attributes for:OKC_ACTIONS_V --
2372: --------------------------------------
2373: FUNCTION Set_Attributes (
2374: p_acnv_rec IN acnv_rec_type,
2375: x_acnv_rec OUT NOCOPY acnv_rec_type

Line 2768: -- lock_row for:OKC_ACTIONS_V --

2764: '_PVT'
2765: );
2766: END lock_row;
2767: --------------------------------
2768: -- lock_row for:OKC_ACTIONS_V --
2769: --------------------------------
2770: PROCEDURE lock_row(
2771: p_api_version IN NUMBER,
2772: p_init_msg_list IN VARCHAR2 ,

Line 3377: -- update_row for:OKC_ACTIONS_V --

3373: '_PVT'
3374: );
3375: END update_row;
3376: ----------------------------------
3377: -- update_row for:OKC_ACTIONS_V --
3378: ----------------------------------
3379: PROCEDURE update_row(
3380: p_api_version IN NUMBER,
3381: p_init_msg_list IN VARCHAR2 ,

Line 3574: -- Set_Attributes for:OKC_ACTIONS_V --

3570: END IF;
3571: RETURN(l_return_status);
3572: END populate_new_record;
3573: --------------------------------------
3574: -- Set_Attributes for:OKC_ACTIONS_V --
3575: --------------------------------------
3576: FUNCTION Set_Attributes (
3577: p_acnv_rec IN acnv_rec_type,
3578: x_acnv_rec OUT NOCOPY acnv_rec_type

Line 3932: -- delete_row for:OKC_ACTIONS_V --

3928: '_PVT'
3929: );
3930: END delete_row;
3931: ----------------------------------
3932: -- delete_row for:OKC_ACTIONS_V --
3933: ----------------------------------
3934: PROCEDURE delete_row(
3935: p_api_version IN NUMBER,
3936: p_init_msg_list IN VARCHAR2 ,