APPS.OKL_ANT_PVT dependencies on OKL_ANSWER_SETS_V

Line 95: p_token3_value => 'OKL_ANSWER_SETS_V');

91: p_token1_value => 'QTY_ID_FOR',
92: p_token2 => G_CHILD_TABLE_TOKEN,
93: p_token2_value => G_VIEW,
94: p_token3 => G_PARENT_TABLE_TOKEN,
95: p_token3_value => 'OKL_ANSWER_SETS_V');
96:
97: RAISE G_EXCEPTION_HALT_VALIDATION;
98: END IF;
99: END validate_qty_id;

Line 136: FROM okl_answer_sets_v

132: ) RETURN VARCHAR2 IS
133:
134: CURSOR l_antv_csr IS
135: SELECT 'x'
136: FROM okl_answer_sets_v
137: WHERE name = p_antv_rec.name
138: AND id <> nvl (p_antv_rec.id, -99999);
139:
140: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 439: -- FUNCTION get_rec for: OKL_ANSWER_SETS_V

435: BEGIN
436: RETURN(get_rec(p_okl_answer_sets_tl_rec, l_row_notfound));
437: END get_rec;
438: ---------------------------------------------------------------------------
439: -- FUNCTION get_rec for: OKL_ANSWER_SETS_V
440: ---------------------------------------------------------------------------
441: FUNCTION get_rec (
442: p_antv_rec IN antv_rec_type,
443: x_no_data_found OUT NOCOPY BOOLEAN

Line 480: FROM Okl_Answer_Sets_V

476: CREATION_DATE,
477: LAST_UPDATED_BY,
478: LAST_UPDATE_DATE,
479: LAST_UPDATE_LOGIN
480: FROM Okl_Answer_Sets_V
481: WHERE okl_answer_sets_v.id = p_id;
482: l_okl_antv_pk okl_antv_pk_csr%ROWTYPE;
483: l_antv_rec antv_rec_type;
484: BEGIN

Line 481: WHERE okl_answer_sets_v.id = p_id;

477: LAST_UPDATED_BY,
478: LAST_UPDATE_DATE,
479: LAST_UPDATE_LOGIN
480: FROM Okl_Answer_Sets_V
481: WHERE okl_answer_sets_v.id = p_id;
482: l_okl_antv_pk okl_antv_pk_csr%ROWTYPE;
483: l_antv_rec antv_rec_type;
484: BEGIN
485: x_no_data_found := TRUE;

Line 536: -- FUNCTION null_out_defaults for: OKL_ANSWER_SETS_V --

532: RETURN(get_rec(p_antv_rec, l_row_notfound));
533: END get_rec;
534:
535: -------------------------------------------------------
536: -- FUNCTION null_out_defaults for: OKL_ANSWER_SETS_V --
537: -------------------------------------------------------
538: FUNCTION null_out_defaults (
539: p_antv_rec IN antv_rec_type
540: ) RETURN antv_rec_type IS

Line 645: -- Validate_Attributes for:OKL_ANSWER_SETS_V --

641: ---------------------------------------------------------------------------
642: -- PROCEDURE Validate_Attributes
643: ---------------------------------------------------------------------------
644: -----------------------------------------------
645: -- Validate_Attributes for:OKL_ANSWER_SETS_V --
646: -----------------------------------------------
647: FUNCTION Validate_Attributes (
648: p_antv_rec IN antv_rec_type
649: ) RETURN VARCHAR2 IS

Line 704: -- Validate_Record for:OKL_ANSWER_SETS_V --

700: ---------------------------------------------------------------------------
701: -- PROCEDURE Validate_Record
702: ---------------------------------------------------------------------------
703: -------------------------------------------
704: -- Validate_Record for:OKL_ANSWER_SETS_V --
705: -------------------------------------------
706: FUNCTION Validate_Record (
707: p_antv_rec IN antv_rec_type
708: ) RETURN VARCHAR2 IS

Line 851: -- validate_row for:OKL_ANSWER_SETS_V --

847: ---------------------------------------------------------------------------
848: -- PROCEDURE validate_row
849: ---------------------------------------------------------------------------
850: ----------------------------------------
851: -- validate_row for:OKL_ANSWER_SETS_V --
852: ----------------------------------------
853: PROCEDURE validate_row(
854: p_api_version IN NUMBER,
855: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1257: -- insert_row for:OKL_ANSWER_SETS_V --

1253: '_PVT'
1254: );
1255: END insert_row;
1256: --------------------------------------
1257: -- insert_row for:OKL_ANSWER_SETS_V --
1258: --------------------------------------
1259: PROCEDURE insert_row(
1260: p_api_version IN NUMBER,
1261: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1293: -- Set_Attributes for:OKL_ANSWER_SETS_V --

1289: l_antv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1290: RETURN(l_antv_rec);
1291: END fill_who_columns;
1292: ------------------------------------------
1293: -- Set_Attributes for:OKL_ANSWER_SETS_V --
1294: ------------------------------------------
1295: FUNCTION Set_Attributes (
1296: p_antv_rec IN antv_rec_type,
1297: x_antv_rec OUT NOCOPY antv_rec_type

Line 1680: -- lock_row for:OKL_ANSWER_SETS_V --

1676: '_PVT'
1677: );
1678: END lock_row;
1679: ------------------------------------
1680: -- lock_row for:OKL_ANSWER_SETS_V --
1681: ------------------------------------
1682: PROCEDURE lock_row(
1683: p_api_version IN NUMBER,
1684: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 2273: -- update_row for:OKL_ANSWER_SETS_V --

2269: '_PVT'
2270: );
2271: END update_row;
2272: --------------------------------------
2273: -- update_row for:OKL_ANSWER_SETS_V --
2274: --------------------------------------
2275: PROCEDURE update_row(
2276: p_api_version IN NUMBER,
2277: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 2458: -- Set_Attributes for:OKL_ANSWER_SETS_V --

2454: END IF;
2455: RETURN(l_return_status);
2456: END populate_new_record;
2457: ------------------------------------------
2458: -- Set_Attributes for:OKL_ANSWER_SETS_V --
2459: ------------------------------------------
2460: FUNCTION Set_Attributes (
2461: p_antv_rec IN antv_rec_type,
2462: x_antv_rec OUT NOCOPY antv_rec_type

Line 2801: -- delete_row for:OKL_ANSWER_SETS_V --

2797: '_PVT'
2798: );
2799: END delete_row;
2800: --------------------------------------
2801: -- delete_row for:OKL_ANSWER_SETS_V --
2802: --------------------------------------
2803: PROCEDURE delete_row(
2804: p_api_version IN NUMBER,
2805: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,