DBA Data[Home] [Help]

APPS.OKL_ASR_PVT dependencies on OKL_ANSR_SET_CRTRIA_V

Line 95: p_token3_value => 'OKL_ANSR_SET_CRTRIA_V');

91: p_token1_value => 'ANT_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_CRTRIA_V');
96:
97: RAISE G_EXCEPTION_HALT_VALIDATION;
98: END IF;
99: END validate_ant_id;

Line 144: p_token3_value => 'OKL_ANSR_SET_CRTRIA_V');

140: p_token1_value => 'QCN_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_CRTRIA_V');
145:
146: RAISE G_EXCEPTION_HALT_VALIDATION;
147: END IF;
148: END validate_qcn_id;

Line 409: -- FUNCTION get_rec for: OKL_ANSR_SET_CRTRIA_V

405: BEGIN
406: RETURN(get_rec(p_okl_ansr_set_crtria_tl_rec, l_row_notfound));
407: END get_rec;
408: ---------------------------------------------------------------------------
409: -- FUNCTION get_rec for: OKL_ANSR_SET_CRTRIA_V
410: ---------------------------------------------------------------------------
411: FUNCTION get_rec (
412: p_asrv_rec IN asrv_rec_type,
413: x_no_data_found OUT NOCOPY BOOLEAN

Line 445: FROM Okl_Ansr_Set_Crtria_V

441: CREATION_DATE,
442: LAST_UPDATED_BY,
443: LAST_UPDATE_DATE,
444: LAST_UPDATE_LOGIN
445: FROM Okl_Ansr_Set_Crtria_V
446: WHERE okl_ansr_set_crtria_v.id = p_id;
447: l_okl_asrv_pk okl_asrv_pk_csr%ROWTYPE;
448: l_asrv_rec asrv_rec_type;
449: BEGIN

Line 446: WHERE okl_ansr_set_crtria_v.id = p_id;

442: LAST_UPDATED_BY,
443: LAST_UPDATE_DATE,
444: LAST_UPDATE_LOGIN
445: FROM Okl_Ansr_Set_Crtria_V
446: WHERE okl_ansr_set_crtria_v.id = p_id;
447: l_okl_asrv_pk okl_asrv_pk_csr%ROWTYPE;
448: l_asrv_rec asrv_rec_type;
449: BEGIN
450: x_no_data_found := TRUE;

Line 496: -- FUNCTION null_out_defaults for: OKL_ANSR_SET_CRTRIA_V --

492: RETURN(get_rec(p_asrv_rec, l_row_notfound));
493: END get_rec;
494:
495: -----------------------------------------------------------
496: -- FUNCTION null_out_defaults for: OKL_ANSR_SET_CRTRIA_V --
497: -----------------------------------------------------------
498: FUNCTION null_out_defaults (
499: p_asrv_rec IN asrv_rec_type
500: ) RETURN asrv_rec_type IS

Line 590: -- Validate_Attributes for:OKL_ANSR_SET_CRTRIA_V --

586: ---------------------------------------------------------------------------
587: -- PROCEDURE Validate_Attributes
588: ---------------------------------------------------------------------------
589: ---------------------------------------------------
590: -- Validate_Attributes for:OKL_ANSR_SET_CRTRIA_V --
591: ---------------------------------------------------
592: FUNCTION Validate_Attributes (
593: p_asrv_rec IN asrv_rec_type
594: ) RETURN VARCHAR2 IS

Line 659: -- Validate_Record for:OKL_ANSR_SET_CRTRIA_V --

655: ---------------------------------------------------------------------------
656: -- PROCEDURE Validate_Record
657: ---------------------------------------------------------------------------
658: -----------------------------------------------
659: -- Validate_Record for:OKL_ANSR_SET_CRTRIA_V --
660: -----------------------------------------------
661: FUNCTION Validate_Record (
662: p_asrv_rec IN asrv_rec_type
663: ) RETURN VARCHAR2 IS

Line 769: -- validate_row for:OKL_ANSR_SET_CRTRIA_V --

765: ---------------------------------------------------------------------------
766: -- PROCEDURE validate_row
767: ---------------------------------------------------------------------------
768: --------------------------------------------
769: -- validate_row for:OKL_ANSR_SET_CRTRIA_V --
770: --------------------------------------------
771: PROCEDURE validate_row(
772: p_api_version IN NUMBER,
773: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1165: -- insert_row for:OKL_ANSR_SET_CRTRIA_V --

1161: '_PVT'
1162: );
1163: END insert_row;
1164: ------------------------------------------
1165: -- insert_row for:OKL_ANSR_SET_CRTRIA_V --
1166: ------------------------------------------
1167: PROCEDURE insert_row(
1168: p_api_version IN NUMBER,
1169: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1201: -- Set_Attributes for:OKL_ANSR_SET_CRTRIA_V --

1197: l_asrv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1198: RETURN(l_asrv_rec);
1199: END fill_who_columns;
1200: ----------------------------------------------
1201: -- Set_Attributes for:OKL_ANSR_SET_CRTRIA_V --
1202: ----------------------------------------------
1203: FUNCTION Set_Attributes (
1204: p_asrv_rec IN asrv_rec_type,
1205: x_asrv_rec OUT NOCOPY asrv_rec_type

Line 1588: -- lock_row for:OKL_ANSR_SET_CRTRIA_V --

1584: '_PVT'
1585: );
1586: END lock_row;
1587: ----------------------------------------
1588: -- lock_row for:OKL_ANSR_SET_CRTRIA_V --
1589: ----------------------------------------
1590: PROCEDURE lock_row(
1591: p_api_version IN NUMBER,
1592: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 2156: -- update_row for:OKL_ANSR_SET_CRTRIA_V --

2152: '_PVT'
2153: );
2154: END update_row;
2155: ------------------------------------------
2156: -- update_row for:OKL_ANSR_SET_CRTRIA_V --
2157: ------------------------------------------
2158: PROCEDURE update_row(
2159: p_api_version IN NUMBER,
2160: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 2321: -- Set_Attributes for:OKL_ANSR_SET_CRTRIA_V --

2317: END IF;
2318: RETURN(l_return_status);
2319: END populate_new_record;
2320: ----------------------------------------------
2321: -- Set_Attributes for:OKL_ANSR_SET_CRTRIA_V --
2322: ----------------------------------------------
2323: FUNCTION Set_Attributes (
2324: p_asrv_rec IN asrv_rec_type,
2325: x_asrv_rec OUT NOCOPY asrv_rec_type

Line 2664: -- delete_row for:OKL_ANSR_SET_CRTRIA_V --

2660: '_PVT'
2661: );
2662: END delete_row;
2663: ------------------------------------------
2664: -- delete_row for:OKL_ANSR_SET_CRTRIA_V --
2665: ------------------------------------------
2666: PROCEDURE delete_row(
2667: p_api_version IN NUMBER,
2668: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,