DBA Data[Home] [Help]

APPS.OKL_TAA_PVT dependencies on OKL_TAA_REQUEST_DETAILS_V

Line 94: -- FUNCTION get_rec for: OKL_TAA_REQUEST_DETAILS_V

90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_TAA_REQUEST_DETAILS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_taav_rec IN taav_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 150: FROM Okl_Taa_Request_Details_V

146: CREATION_DATE,
147: LAST_UPDATED_BY,
148: LAST_UPDATE_DATE,
149: LAST_UPDATE_LOGIN
150: FROM Okl_Taa_Request_Details_V
151: WHERE okl_taa_request_details_v.id = p_id;
152: l_okl_taav_pk okl_taav_pk_csr%ROWTYPE;
153: l_taav_rec taav_rec_type;
154: BEGIN

Line 151: WHERE okl_taa_request_details_v.id = p_id;

147: LAST_UPDATED_BY,
148: LAST_UPDATE_DATE,
149: LAST_UPDATE_LOGIN
150: FROM Okl_Taa_Request_Details_V
151: WHERE okl_taa_request_details_v.id = p_id;
152: l_okl_taav_pk okl_taav_pk_csr%ROWTYPE;
153: l_taav_rec taav_rec_type;
154: BEGIN
155: x_no_data_found := TRUE;

Line 388: -- FUNCTION null_out_defaults for: OKL_TAA_REQUEST_DETAILS_V

384: BEGIN
385: RETURN(get_rec(p_taa_rec, l_row_not_found));
386: END get_rec;
387: ---------------------------------------------------------------------------
388: -- FUNCTION null_out_defaults for: OKL_TAA_REQUEST_DETAILS_V
389: ---------------------------------------------------------------------------
390: FUNCTION null_out_defaults (
391: p_taav_rec IN taav_rec_type
392: ) RETURN taav_rec_type IS

Line 599: -- Validate_Attributes for:OKL_TAA_REQUEST_DETAILS_V --

595: ---------------------------------------------------------------------------
596: -- FUNCTION Validate_Attributes
597: ---------------------------------------------------------------------------
598: -------------------------------------------------------
599: -- Validate_Attributes for:OKL_TAA_REQUEST_DETAILS_V --
600: -------------------------------------------------------
601: FUNCTION Validate_Attributes (
602: p_taav_rec IN taav_rec_type
603: ) RETURN VARCHAR2 IS

Line 646: -- Validate Record for:OKL_TAA_REQUEST_DETAILS_V --

642: ---------------------------------------------------------------------------
643: -- PROCEDURE Validate_Record
644: ---------------------------------------------------------------------------
645: ---------------------------------------------------
646: -- Validate Record for:OKL_TAA_REQUEST_DETAILS_V --
647: ---------------------------------------------------
648: FUNCTION Validate_Record (
649: p_taav_rec IN taav_rec_type,
650: p_db_taav_rec IN taav_rec_type

Line 782: -- validate_row for:OKL_TAA_REQUEST_DETAILS_V --

778: ---------------------------------------------------------------------------
779: -- PROCEDURE validate_row
780: ---------------------------------------------------------------------------
781: ------------------------------------------------
782: -- validate_row for:OKL_TAA_REQUEST_DETAILS_V --
783: ------------------------------------------------
784: PROCEDURE validate_row(
785: p_api_version IN NUMBER,
786: p_init_msg_list IN VARCHAR2,

Line 859: -- PL/SQL TBL validate_row for:OKL_TAA_REQUEST_DETAILS_V --

855: '_PVT'
856: );
857: END validate_row;
858: -----------------------------------------------------------
859: -- PL/SQL TBL validate_row for:OKL_TAA_REQUEST_DETAILS_V --
860: -----------------------------------------------------------
861: PROCEDURE validate_row(
862: p_api_version IN NUMBER,
863: p_init_msg_list IN VARCHAR2,

Line 955: -- PL/SQL TBL validate_row for:OKL_TAA_REQUEST_DETAILS_V --

951: );
952: END validate_row;
953:
954: -----------------------------------------------------------
955: -- PL/SQL TBL validate_row for:OKL_TAA_REQUEST_DETAILS_V --
956: -----------------------------------------------------------
957: PROCEDURE validate_row(
958: p_api_version IN NUMBER,
959: p_init_msg_list IN VARCHAR2,

Line 1202: -- insert_row for :OKL_TAA_REQUEST_DETAILS_V --

1198: '_PVT'
1199: );
1200: END insert_row;
1201: -----------------------------------------------
1202: -- insert_row for :OKL_TAA_REQUEST_DETAILS_V --
1203: -----------------------------------------------
1204: PROCEDURE insert_row(
1205: p_api_version IN NUMBER,
1206: p_init_msg_list IN VARCHAR2,

Line 1236: -- Set_Attributes for:OKL_TAA_REQUEST_DETAILS_V --

1232: l_taav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1233: RETURN(l_taav_rec);
1234: END fill_who_columns;
1235: --------------------------------------------------
1236: -- Set_Attributes for:OKL_TAA_REQUEST_DETAILS_V --
1237: --------------------------------------------------
1238: FUNCTION Set_Attributes (
1239: p_taav_rec IN taav_rec_type,
1240: x_taav_rec OUT NOCOPY taav_rec_type

Line 1609: -- lock_row for: OKL_TAA_REQUEST_DETAILS_V --

1605: '_PVT'
1606: );
1607: END lock_row;
1608: ---------------------------------------------
1609: -- lock_row for: OKL_TAA_REQUEST_DETAILS_V --
1610: ---------------------------------------------
1611: PROCEDURE lock_row(
1612: p_api_version IN NUMBER,
1613: p_init_msg_list IN VARCHAR2,

Line 2199: -- update_row for:OKL_TAA_REQUEST_DETAILS_V --

2195: '_PVT'
2196: );
2197: END update_row;
2198: ----------------------------------------------
2199: -- update_row for:OKL_TAA_REQUEST_DETAILS_V --
2200: ----------------------------------------------
2201: PROCEDURE update_row(
2202: p_api_version IN NUMBER,
2203: p_init_msg_list IN VARCHAR2,

Line 2443: -- Set_Attributes for:OKL_TAA_REQUEST_DETAILS_V --

2439: END IF;
2440: RETURN(l_return_status);
2441: END populate_new_record;
2442: --------------------------------------------------
2443: -- Set_Attributes for:OKL_TAA_REQUEST_DETAILS_V --
2444: --------------------------------------------------
2445: FUNCTION Set_Attributes (
2446: p_taav_rec IN taav_rec_type,
2447: x_taav_rec OUT NOCOPY taav_rec_type

Line 2800: -- delete_row for:OKL_TAA_REQUEST_DETAILS_V --

2796: '_PVT'
2797: );
2798: END delete_row;
2799: ----------------------------------------------
2800: -- delete_row for:OKL_TAA_REQUEST_DETAILS_V --
2801: ----------------------------------------------
2802: PROCEDURE delete_row(
2803: p_api_version IN NUMBER,
2804: p_init_msg_list IN VARCHAR2,

Line 2882: -- PL/SQL TBL delete_row for:OKL_TAA_REQUEST_DETAILS_V --

2878: '_PVT'
2879: );
2880: END delete_row;
2881: ---------------------------------------------------------
2882: -- PL/SQL TBL delete_row for:OKL_TAA_REQUEST_DETAILS_V --
2883: ---------------------------------------------------------
2884: PROCEDURE delete_row(
2885: p_api_version IN NUMBER,
2886: p_init_msg_list IN VARCHAR2,

Line 2978: -- PL/SQL TBL delete_row for:OKL_TAA_REQUEST_DETAILS_V --

2974: );
2975: END delete_row;
2976:
2977: ---------------------------------------------------------
2978: -- PL/SQL TBL delete_row for:OKL_TAA_REQUEST_DETAILS_V --
2979: ---------------------------------------------------------
2980: PROCEDURE delete_row(
2981: p_api_version IN NUMBER,
2982: p_init_msg_list IN VARCHAR2,