DBA Data[Home] [Help]

APPS.OKL_QCN_PVT dependencies on OKL_QUESTION_CRTRNS_V

Line 95: p_token3_value => 'OKL_QUESTION_CRTRNS_V');

91: p_token1_value => 'CRN_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_QUESTION_CRTRNS_V');
96:
97: RAISE G_EXCEPTION_HALT_VALIDATION;
98: END IF;
99: END validate_crn_id;

Line 144: p_token3_value => 'OKL_QUESTION_CRTRNS_V');

140: p_token1_value => 'QTY_ID_FOR',
141: p_token2 => G_CHILD_TABLE_TOKEN,
142: p_token2_value => G_VIEW,
143: p_token3 => G_PARENT_TABLE_TOKEN,
144: p_token3_value => 'OKL_QUESTION_CRTRNS_V');
145:
146: RAISE G_EXCEPTION_HALT_VALIDATION;
147: END IF;
148: END validate_qty_id;

Line 263: -- FUNCTION get_rec for: OKL_QUESTION_CRTRNS_V

259: BEGIN
260: RETURN(get_rec(p_qcn_rec, l_row_notfound));
261: END get_rec;
262: ---------------------------------------------------------------------------
263: -- FUNCTION get_rec for: OKL_QUESTION_CRTRNS_V
264: ---------------------------------------------------------------------------
265: FUNCTION get_rec (
266: p_qcnv_rec IN qcnv_rec_type,
267: x_no_data_found OUT NOCOPY BOOLEAN

Line 296: FROM Okl_Question_Crtrns_V

292: CREATION_DATE,
293: LAST_UPDATED_BY,
294: LAST_UPDATE_DATE,
295: LAST_UPDATE_LOGIN
296: FROM Okl_Question_Crtrns_V
297: WHERE okl_question_crtrns_v.id = p_id;
298: l_okl_qcnv_pk okl_qcnv_pk_csr%ROWTYPE;
299: l_qcnv_rec qcnv_rec_type;
300: BEGIN

Line 297: WHERE okl_question_crtrns_v.id = p_id;

293: LAST_UPDATED_BY,
294: LAST_UPDATE_DATE,
295: LAST_UPDATE_LOGIN
296: FROM Okl_Question_Crtrns_V
297: WHERE okl_question_crtrns_v.id = p_id;
298: l_okl_qcnv_pk okl_qcnv_pk_csr%ROWTYPE;
299: l_qcnv_rec qcnv_rec_type;
300: BEGIN
301: x_no_data_found := TRUE;

Line 344: -- FUNCTION null_out_defaults for: OKL_QUESTION_CRTRNS_V --

340: RETURN(get_rec(p_qcnv_rec, l_row_notfound));
341: END get_rec;
342:
343: -----------------------------------------------------------
344: -- FUNCTION null_out_defaults for: OKL_QUESTION_CRTRNS_V --
345: -----------------------------------------------------------
346: FUNCTION null_out_defaults (
347: p_qcnv_rec IN qcnv_rec_type
348: ) RETURN qcnv_rec_type IS

Line 429: -- Validate_Attributes for:OKL_QUESTION_CRTRNS_V --

425: ---------------------------------------------------------------------------
426: -- PROCEDURE Validate_Attributes
427: ---------------------------------------------------------------------------
428: ---------------------------------------------------
429: -- Validate_Attributes for:OKL_QUESTION_CRTRNS_V --
430: ---------------------------------------------------
431: FUNCTION Validate_Attributes (
432: p_qcnv_rec IN qcnv_rec_type
433: ) RETURN VARCHAR2 IS

Line 510: -- Validate_Record for:OKL_QUESTION_CRTRNS_V --

506: ---------------------------------------------------------------------------
507: -- PROCEDURE Validate_Record
508: ---------------------------------------------------------------------------
509: -----------------------------------------------
510: -- Validate_Record for:OKL_QUESTION_CRTRNS_V --
511: -----------------------------------------------
512: FUNCTION Validate_Record (
513: p_qcnv_rec IN qcnv_rec_type
514: ) RETURN VARCHAR2 IS

Line 590: -- validate_row for:OKL_QUESTION_CRTRNS_V --

586: ---------------------------------------------------------------------------
587: -- PROCEDURE validate_row
588: ---------------------------------------------------------------------------
589: --------------------------------------------
590: -- validate_row for:OKL_QUESTION_CRTRNS_V --
591: --------------------------------------------
592: PROCEDURE validate_row(
593: p_api_version IN NUMBER,
594: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 869: -- insert_row for:OKL_QUESTION_CRTRNS_V --

865: '_PVT'
866: );
867: END insert_row;
868: ------------------------------------------
869: -- insert_row for:OKL_QUESTION_CRTRNS_V --
870: ------------------------------------------
871: PROCEDURE insert_row(
872: p_api_version IN NUMBER,
873: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 903: -- Set_Attributes for:OKL_QUESTION_CRTRNS_V --

899: l_qcnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
900: RETURN(l_qcnv_rec);
901: END fill_who_columns;
902: ----------------------------------------------
903: -- Set_Attributes for:OKL_QUESTION_CRTRNS_V --
904: ----------------------------------------------
905: FUNCTION Set_Attributes (
906: p_qcnv_rec IN qcnv_rec_type,
907: x_qcnv_rec OUT NOCOPY qcnv_rec_type

Line 1189: -- lock_row for:OKL_QUESTION_CRTRNS_V --

1185: '_PVT'
1186: );
1187: END lock_row;
1188: ----------------------------------------
1189: -- lock_row for:OKL_QUESTION_CRTRNS_V --
1190: ----------------------------------------
1191: PROCEDURE lock_row(
1192: p_api_version IN NUMBER,
1193: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1572: -- update_row for:OKL_QUESTION_CRTRNS_V --

1568: '_PVT'
1569: );
1570: END update_row;
1571: ------------------------------------------
1572: -- update_row for:OKL_QUESTION_CRTRNS_V --
1573: ------------------------------------------
1574: PROCEDURE update_row(
1575: p_api_version IN NUMBER,
1576: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1723: -- Set_Attributes for:OKL_QUESTION_CRTRNS_V --

1719: END IF;
1720: RETURN(l_return_status);
1721: END populate_new_record;
1722: ----------------------------------------------
1723: -- Set_Attributes for:OKL_QUESTION_CRTRNS_V --
1724: ----------------------------------------------
1725: FUNCTION Set_Attributes (
1726: p_qcnv_rec IN qcnv_rec_type,
1727: x_qcnv_rec OUT NOCOPY qcnv_rec_type

Line 1967: -- delete_row for:OKL_QUESTION_CRTRNS_V --

1963: '_PVT'
1964: );
1965: END delete_row;
1966: ------------------------------------------
1967: -- delete_row for:OKL_QUESTION_CRTRNS_V --
1968: ------------------------------------------
1969: PROCEDURE delete_row(
1970: p_api_version IN NUMBER,
1971: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,