DBA Data[Home] [Help]

APPS.OKL_QTY_PVT dependencies on OKL_QUESTION_TYPES_V

Line 109: p_token3_value => 'OKL_QUESTION_TYPES_V');

105: p_token1_value => 'LRG_LSE_ID_FOR',
106: p_token2 => G_CHILD_TABLE_TOKEN,
107: p_token2_value => G_VIEW,
108: p_token3 => G_PARENT_TABLE_TOKEN,
109: p_token3_value => 'OKL_QUESTION_TYPES_V');
110:
111: RAISE G_EXCEPTION_HALT_VALIDATION;
112: END IF;
113: END IF;

Line 149: p_token3_value => 'OKL_QUESTION_TYPES_V');

145: p_token1_value => 'LRG_SRD_ID_FOR',
146: p_token2 => G_CHILD_TABLE_TOKEN,
147: p_token2_value => G_VIEW,
148: p_token3 => G_PARENT_TABLE_TOKEN,
149: p_token3_value => 'OKL_QUESTION_TYPES_V');
150:
151: RAISE G_EXCEPTION_HALT_VALIDATION;
152: END IF;
153: END IF;

Line 190: p_token3_value => 'OKL_QUESTION_TYPES_V');

186: p_token1_value => 'SRD_ID_FOR',
187: p_token2 => G_CHILD_TABLE_TOKEN,
188: p_token2_value => G_VIEW,
189: p_token3 => G_PARENT_TABLE_TOKEN,
190: p_token3_value => 'OKL_QUESTION_TYPES_V');
191:
192: RAISE G_EXCEPTION_HALT_VALIDATION;
193: END IF;
194: END IF;

Line 231: p_token3_value => 'OKL_QUESTION_TYPES_V');

227: p_token1_value => 'RGR_RGD_CODE_FOR',
228: p_token2 => G_CHILD_TABLE_TOKEN,
229: p_token2_value => G_VIEW,
230: p_token3 => G_PARENT_TABLE_TOKEN,
231: p_token3_value => 'OKL_QUESTION_TYPES_V');
232:
233: RAISE G_EXCEPTION_HALT_VALIDATION;
234: END IF;
235: END IF;

Line 272: p_token3_value => 'OKL_QUESTION_TYPES_V');

268: p_token1_value => 'RDR_RDF_CODE_FOR',
269: p_token2 => G_CHILD_TABLE_TOKEN,
270: p_token2_value => G_VIEW,
271: p_token3 => G_PARENT_TABLE_TOKEN,
272: p_token3_value => 'OKL_QUESTION_TYPES_V');
273:
274: RAISE G_EXCEPTION_HALT_VALIDATION;
275: END IF;
276: END IF;

Line 290: FROM OKL_QUESTION_TYPES_V

286: ) RETURN VARCHAR2 IS
287:
288: CURSOR l_qtyv_csr IS
289: SELECT 'x'
290: FROM OKL_QUESTION_TYPES_V
291: WHERE name = p_qtyv_rec.name
292: AND id <> nvl (p_qtyv_rec.id, -99999);
293:
294: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 589: -- FUNCTION get_rec for: OKL_QUESTION_TYPES_V

585: BEGIN
586: RETURN(get_rec(p_okl_question_types_tl_rec, l_row_notfound));
587: END get_rec;
588: ---------------------------------------------------------------------------
589: -- FUNCTION get_rec for: OKL_QUESTION_TYPES_V
590: ---------------------------------------------------------------------------
591: FUNCTION get_rec (
592: p_qtyv_rec IN qtyv_rec_type,
593: x_no_data_found OUT NOCOPY BOOLEAN

Line 628: FROM Okl_Question_Types_V

624: CREATION_DATE,
625: LAST_UPDATED_BY,
626: LAST_UPDATE_DATE,
627: LAST_UPDATE_LOGIN
628: FROM Okl_Question_Types_V
629: WHERE okl_question_types_v.id = p_id;
630: l_okl_qtyv_pk okl_qtyv_pk_csr%ROWTYPE;
631: l_qtyv_rec qtyv_rec_type;
632: BEGIN

Line 629: WHERE okl_question_types_v.id = p_id;

625: LAST_UPDATED_BY,
626: LAST_UPDATE_DATE,
627: LAST_UPDATE_LOGIN
628: FROM Okl_Question_Types_V
629: WHERE okl_question_types_v.id = p_id;
630: l_okl_qtyv_pk okl_qtyv_pk_csr%ROWTYPE;
631: l_qtyv_rec qtyv_rec_type;
632: BEGIN
633: x_no_data_found := TRUE;

Line 682: -- FUNCTION null_out_defaults for: OKL_QUESTION_TYPES_V --

678: RETURN(get_rec(p_qtyv_rec, l_row_notfound));
679: END get_rec;
680:
681: ----------------------------------------------------------
682: -- FUNCTION null_out_defaults for: OKL_QUESTION_TYPES_V --
683: ----------------------------------------------------------
684: FUNCTION null_out_defaults (
685: p_qtyv_rec IN qtyv_rec_type
686: ) RETURN qtyv_rec_type IS

Line 785: -- Validate_Attributes for:OKL_QUESTION_TYPES_V --

781: ---------------------------------------------------------------------------
782: -- PROCEDURE Validate_Attributes
783: ---------------------------------------------------------------------------
784: --------------------------------------------------
785: -- Validate_Attributes for:OKL_QUESTION_TYPES_V --
786: --------------------------------------------------
787: FUNCTION Validate_Attributes (
788: p_qtyv_rec IN qtyv_rec_type
789: ) RETURN VARCHAR2 IS

Line 885: -- Validate_Record for:OKL_QUESTION_TYPES_V --

881: ---------------------------------------------------------------------------
882: -- PROCEDURE Validate_Record
883: ---------------------------------------------------------------------------
884: ----------------------------------------------
885: -- Validate_Record for:OKL_QUESTION_TYPES_V --
886: ----------------------------------------------
887: FUNCTION Validate_Record (
888: p_qtyv_rec IN qtyv_rec_type
889: ) RETURN VARCHAR2 IS

Line 1031: -- validate_row for:OKL_QUESTION_TYPES_V --

1027: ---------------------------------------------------------------------------
1028: -- PROCEDURE validate_row
1029: ---------------------------------------------------------------------------
1030: -------------------------------------------
1031: -- validate_row for:OKL_QUESTION_TYPES_V --
1032: -------------------------------------------
1033: PROCEDURE validate_row(
1034: p_api_version IN NUMBER,
1035: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1433: -- insert_row for:OKL_QUESTION_TYPES_V --

1429: '_PVT'
1430: );
1431: END insert_row;
1432: -----------------------------------------
1433: -- insert_row for:OKL_QUESTION_TYPES_V --
1434: -----------------------------------------
1435: PROCEDURE insert_row(
1436: p_api_version IN NUMBER,
1437: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1469: -- Set_Attributes for:OKL_QUESTION_TYPES_V --

1465: l_qtyv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1466: RETURN(l_qtyv_rec);
1467: END fill_who_columns;
1468: ---------------------------------------------
1469: -- Set_Attributes for:OKL_QUESTION_TYPES_V --
1470: ---------------------------------------------
1471: FUNCTION Set_Attributes (
1472: p_qtyv_rec IN qtyv_rec_type,
1473: x_qtyv_rec OUT NOCOPY qtyv_rec_type

Line 1856: -- lock_row for:OKL_QUESTION_TYPES_V --

1852: '_PVT'
1853: );
1854: END lock_row;
1855: ---------------------------------------
1856: -- lock_row for:OKL_QUESTION_TYPES_V --
1857: ---------------------------------------
1858: PROCEDURE lock_row(
1859: p_api_version IN NUMBER,
1860: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 2439: -- update_row for:OKL_QUESTION_TYPES_V --

2435: '_PVT'
2436: );
2437: END update_row;
2438: -----------------------------------------
2439: -- update_row for:OKL_QUESTION_TYPES_V --
2440: -----------------------------------------
2441: PROCEDURE update_row(
2442: p_api_version IN NUMBER,
2443: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 2616: -- Set_Attributes for:OKL_QUESTION_TYPES_V --

2612: END IF;
2613: RETURN(l_return_status);
2614: END populate_new_record;
2615: ---------------------------------------------
2616: -- Set_Attributes for:OKL_QUESTION_TYPES_V --
2617: ---------------------------------------------
2618: FUNCTION Set_Attributes (
2619: p_qtyv_rec IN qtyv_rec_type,
2620: x_qtyv_rec OUT NOCOPY qtyv_rec_type

Line 2959: -- delete_row for:OKL_QUESTION_TYPES_V --

2955: '_PVT'
2956: );
2957: END delete_row;
2958: -----------------------------------------
2959: -- delete_row for:OKL_QUESTION_TYPES_V --
2960: -----------------------------------------
2961: PROCEDURE delete_row(
2962: p_api_version IN NUMBER,
2963: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,