DBA Data[Home] [Help]

APPS.OKL_ASV_PVT dependencies on OKL_ANSR_SET_CN_VLS_V

Line 95: p_token3_value => 'OKL_ANSR_SET_CN_VLS_V');

91: p_token1_value => 'ASR_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_ANSR_SET_CN_VLS_V');
96:
97: RAISE G_EXCEPTION_HALT_VALIDATION;
98: END IF;
99: END validate_asr_id;

Line 144: p_token3_value => 'OKL_ANSR_SET_CN_VLS_V');

140: p_token1_value => 'CRN_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_ANSR_SET_CN_VLS_V');
145:
146: RAISE G_EXCEPTION_HALT_VALIDATION;
147: END IF;
148: END validate_crn_id;

Line 342: -- FUNCTION get_rec for: OKL_ANSR_SET_CN_VLS_V

338: BEGIN
339: RETURN(get_rec(p_asv_rec, l_row_notfound));
340: END get_rec;
341: ---------------------------------------------------------------------------
342: -- FUNCTION get_rec for: OKL_ANSR_SET_CN_VLS_V
343: ---------------------------------------------------------------------------
344: FUNCTION get_rec (
345: p_asvv_rec IN asvv_rec_type,
346: x_no_data_found OUT NOCOPY BOOLEAN

Line 383: FROM Okl_Ansr_Set_Cn_Vls_V

379: CREATION_DATE,
380: LAST_UPDATED_BY,
381: LAST_UPDATE_DATE,
382: LAST_UPDATE_LOGIN
383: FROM Okl_Ansr_Set_Cn_Vls_V
384: WHERE okl_ansr_set_cn_vls_v.id = p_id;
385: l_okl_asvv_pk okl_asvv_pk_csr%ROWTYPE;
386: l_asvv_rec asvv_rec_type;
387: BEGIN

Line 384: WHERE okl_ansr_set_cn_vls_v.id = p_id;

380: LAST_UPDATED_BY,
381: LAST_UPDATE_DATE,
382: LAST_UPDATE_LOGIN
383: FROM Okl_Ansr_Set_Cn_Vls_V
384: WHERE okl_ansr_set_cn_vls_v.id = p_id;
385: l_okl_asvv_pk okl_asvv_pk_csr%ROWTYPE;
386: l_asvv_rec asvv_rec_type;
387: BEGIN
388: x_no_data_found := TRUE;

Line 439: -- FUNCTION null_out_defaults for: OKL_ANSR_SET_CN_VLS_V --

435: RETURN(get_rec(p_asvv_rec, l_row_notfound));
436: END get_rec;
437:
438: -----------------------------------------------------------
439: -- FUNCTION null_out_defaults for: OKL_ANSR_SET_CN_VLS_V --
440: -----------------------------------------------------------
441: FUNCTION null_out_defaults (
442: p_asvv_rec IN asvv_rec_type
443: ) RETURN asvv_rec_type IS

Line 548: -- Validate_Attributes for:OKL_ANSR_SET_CN_VLS_V --

544: ---------------------------------------------------------------------------
545: -- PROCEDURE Validate_Attributes
546: ---------------------------------------------------------------------------
547: ---------------------------------------------------
548: -- Validate_Attributes for:OKL_ANSR_SET_CN_VLS_V --
549: ---------------------------------------------------
550: FUNCTION Validate_Attributes (
551: p_asvv_rec IN asvv_rec_type
552: ) RETURN VARCHAR2 IS

Line 627: -- Validate_Record for:OKL_ANSR_SET_CN_VLS_V --

623: ---------------------------------------------------------------------------
624: -- PROCEDURE Validate_Record
625: ---------------------------------------------------------------------------
626: -----------------------------------------------
627: -- Validate_Record for:OKL_ANSR_SET_CN_VLS_V --
628: -----------------------------------------------
629: FUNCTION Validate_Record (
630: p_asvv_rec IN asvv_rec_type
631: ) RETURN VARCHAR2 IS

Line 723: -- validate_row for:OKL_ANSR_SET_CN_VLS_V --

719: ---------------------------------------------------------------------------
720: -- PROCEDURE validate_row
721: ---------------------------------------------------------------------------
722: --------------------------------------------
723: -- validate_row for:OKL_ANSR_SET_CN_VLS_V --
724: --------------------------------------------
725: PROCEDURE validate_row(
726: p_api_version IN NUMBER,
727: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1018: -- insert_row for:OKL_ANSR_SET_CN_VLS_V --

1014: '_PVT'
1015: );
1016: END insert_row;
1017: ------------------------------------------
1018: -- insert_row for:OKL_ANSR_SET_CN_VLS_V --
1019: ------------------------------------------
1020: PROCEDURE insert_row(
1021: p_api_version IN NUMBER,
1022: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1052: -- Set_Attributes for:OKL_ANSR_SET_CN_VLS_V --

1048: l_asvv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1049: RETURN(l_asvv_rec);
1050: END fill_who_columns;
1051: ----------------------------------------------
1052: -- Set_Attributes for:OKL_ANSR_SET_CN_VLS_V --
1053: ----------------------------------------------
1054: FUNCTION Set_Attributes (
1055: p_asvv_rec IN asvv_rec_type,
1056: x_asvv_rec OUT NOCOPY asvv_rec_type

Line 1338: -- lock_row for:OKL_ANSR_SET_CN_VLS_V --

1334: '_PVT'
1335: );
1336: END lock_row;
1337: ----------------------------------------
1338: -- lock_row for:OKL_ANSR_SET_CN_VLS_V --
1339: ----------------------------------------
1340: PROCEDURE lock_row(
1341: p_api_version IN NUMBER,
1342: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1761: -- update_row for:OKL_ANSR_SET_CN_VLS_V --

1757: '_PVT'
1758: );
1759: END update_row;
1760: ------------------------------------------
1761: -- update_row for:OKL_ANSR_SET_CN_VLS_V --
1762: ------------------------------------------
1763: PROCEDURE update_row(
1764: p_api_version IN NUMBER,
1765: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1944: -- Set_Attributes for:OKL_ANSR_SET_CN_VLS_V --

1940: END IF;
1941: RETURN(l_return_status);
1942: END populate_new_record;
1943: ----------------------------------------------
1944: -- Set_Attributes for:OKL_ANSR_SET_CN_VLS_V --
1945: ----------------------------------------------
1946: FUNCTION Set_Attributes (
1947: p_asvv_rec IN asvv_rec_type,
1948: x_asvv_rec OUT NOCOPY asvv_rec_type

Line 2188: -- delete_row for:OKL_ANSR_SET_CN_VLS_V --

2184: '_PVT'
2185: );
2186: END delete_row;
2187: ------------------------------------------
2188: -- delete_row for:OKL_ANSR_SET_CN_VLS_V --
2189: ------------------------------------------
2190: PROCEDURE delete_row(
2191: p_api_version IN NUMBER,
2192: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,