DBA Data[Home] [Help]

APPS.IEX_IEH_PVT dependencies on IEX_EXCLUSION_HIST_V

Line 164: -- FUNCTION get_rec for: IEX_EXCLUSION_HIST_V

160: );
161: END add_language;
162:
163: ---------------------------------------------------------------------------
164: -- FUNCTION get_rec for: IEX_EXCLUSION_HIST_V
165: ---------------------------------------------------------------------------
166: FUNCTION get_rec (
167: p_iehv_rec IN iehv_rec_type,
168: x_no_data_found OUT NOCOPY BOOLEAN

Line 170: CURSOR iex_exclusion_hist_v_pk_csr (p_exclusion_history_id IN NUMBER) IS

166: FUNCTION get_rec (
167: p_iehv_rec IN iehv_rec_type,
168: x_no_data_found OUT NOCOPY BOOLEAN
169: ) RETURN iehv_rec_type AS
170: CURSOR iex_exclusion_hist_v_pk_csr (p_exclusion_history_id IN NUMBER) IS
171: SELECT
172: EXCLUSION_HISTORY_ID,
173: OBJECT1_ID1,
174: OBJECT1_ID2,

Line 209: FROM Iex_Exclusion_Hist_V

205: CREATION_DATE,
206: LAST_UPDATED_BY,
207: LAST_UPDATE_DATE,
208: LAST_UPDATE_LOGIN
209: FROM Iex_Exclusion_Hist_V
210: WHERE iex_exclusion_hist_v.exclusion_history_id = p_exclusion_history_id;
211: l_iex_exclusion_hist_v_pk iex_exclusion_hist_v_pk_csr%ROWTYPE;
212: l_iehv_rec iehv_rec_type;
213: BEGIN

Line 210: WHERE iex_exclusion_hist_v.exclusion_history_id = p_exclusion_history_id;

206: LAST_UPDATED_BY,
207: LAST_UPDATE_DATE,
208: LAST_UPDATE_LOGIN
209: FROM Iex_Exclusion_Hist_V
210: WHERE iex_exclusion_hist_v.exclusion_history_id = p_exclusion_history_id;
211: l_iex_exclusion_hist_v_pk iex_exclusion_hist_v_pk_csr%ROWTYPE;
212: l_iehv_rec iehv_rec_type;
213: BEGIN
214: x_no_data_found := TRUE;

Line 211: l_iex_exclusion_hist_v_pk iex_exclusion_hist_v_pk_csr%ROWTYPE;

207: LAST_UPDATE_DATE,
208: LAST_UPDATE_LOGIN
209: FROM Iex_Exclusion_Hist_V
210: WHERE iex_exclusion_hist_v.exclusion_history_id = p_exclusion_history_id;
211: l_iex_exclusion_hist_v_pk iex_exclusion_hist_v_pk_csr%ROWTYPE;
212: l_iehv_rec iehv_rec_type;
213: BEGIN
214: x_no_data_found := TRUE;
215: -- Get current database values

Line 216: OPEN iex_exclusion_hist_v_pk_csr (p_iehv_rec.exclusion_history_id);

212: l_iehv_rec iehv_rec_type;
213: BEGIN
214: x_no_data_found := TRUE;
215: -- Get current database values
216: OPEN iex_exclusion_hist_v_pk_csr (p_iehv_rec.exclusion_history_id);
217: FETCH iex_exclusion_hist_v_pk_csr INTO
218: l_iehv_rec.exclusion_history_id,
219: l_iehv_rec.object1_id1,
220: l_iehv_rec.object1_id2,

Line 217: FETCH iex_exclusion_hist_v_pk_csr INTO

213: BEGIN
214: x_no_data_found := TRUE;
215: -- Get current database values
216: OPEN iex_exclusion_hist_v_pk_csr (p_iehv_rec.exclusion_history_id);
217: FETCH iex_exclusion_hist_v_pk_csr INTO
218: l_iehv_rec.exclusion_history_id,
219: l_iehv_rec.object1_id1,
220: l_iehv_rec.object1_id2,
221: l_iehv_rec.jtot_object1_code,

Line 255: x_no_data_found := iex_exclusion_hist_v_pk_csr%NOTFOUND;

251: l_iehv_rec.creation_date,
252: l_iehv_rec.last_updated_by,
253: l_iehv_rec.last_update_date,
254: l_iehv_rec.last_update_login;
255: x_no_data_found := iex_exclusion_hist_v_pk_csr%NOTFOUND;
256: CLOSE iex_exclusion_hist_v_pk_csr;
257: RETURN(l_iehv_rec);
258: END get_rec;
259:

Line 256: CLOSE iex_exclusion_hist_v_pk_csr;

252: l_iehv_rec.last_updated_by,
253: l_iehv_rec.last_update_date,
254: l_iehv_rec.last_update_login;
255: x_no_data_found := iex_exclusion_hist_v_pk_csr%NOTFOUND;
256: CLOSE iex_exclusion_hist_v_pk_csr;
257: RETURN(l_iehv_rec);
258: END get_rec;
259:
260: ------------------------------------------------------------------

Line 477: -- FUNCTION null_out_defaults for: IEX_EXCLUSION_HIST_V

473: BEGIN
474: RETURN(get_rec(p_ieh_rec, l_row_not_found));
475: END get_rec;
476: ---------------------------------------------------------------------------
477: -- FUNCTION null_out_defaults for: IEX_EXCLUSION_HIST_V
478: ---------------------------------------------------------------------------
479: FUNCTION null_out_defaults (
480: p_iehv_rec IN iehv_rec_type
481: ) RETURN iehv_rec_type AS

Line 839: -- Validate_Attributes for:IEX_EXCLUSION_HIST_V --

835: ---------------------------------------------------------------------------
836: -- FUNCTION Validate_Attributes
837: ---------------------------------------------------------------------------
838: --------------------------------------------------
839: -- Validate_Attributes for:IEX_EXCLUSION_HIST_V --
840: --------------------------------------------------
841: FUNCTION Validate_Attributes (
842: p_iehv_rec IN iehv_rec_type
843: ) RETURN VARCHAR2 AS

Line 985: -- Validate Record for:IEX_EXCLUSION_HIST_V --

981: ---------------------------------------------------------------------------
982: -- PROCEDURE Validate_Record
983: ---------------------------------------------------------------------------
984: ----------------------------------------------
985: -- Validate Record for:IEX_EXCLUSION_HIST_V --
986: ----------------------------------------------
987: FUNCTION Validate_Record (
988: p_iehv_rec IN iehv_rec_type,
989: p_db_iehv_rec IN iehv_rec_type

Line 1123: -- validate_row for:IEX_EXCLUSION_HIST_V --

1119: ---------------------------------------------------------------------------
1120: -- PROCEDURE validate_row
1121: ---------------------------------------------------------------------------
1122: -------------------------------------------
1123: -- validate_row for:IEX_EXCLUSION_HIST_V --
1124: -------------------------------------------
1125: PROCEDURE validate_row(
1126: p_api_version IN NUMBER,
1127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1200: -- PL/SQL TBL validate_row for:IEX_EXCLUSION_HIST_V --

1196: '_PVT'
1197: );
1198: END validate_row;
1199: ------------------------------------------------------
1200: -- PL/SQL TBL validate_row for:IEX_EXCLUSION_HIST_V --
1201: ------------------------------------------------------
1202: PROCEDURE validate_row(
1203: p_api_version IN NUMBER,
1204: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1296: -- PL/SQL TBL validate_row for:IEX_EXCLUSION_HIST_V --

1292: );
1293: END validate_row;
1294:
1295: ------------------------------------------------------
1296: -- PL/SQL TBL validate_row for:IEX_EXCLUSION_HIST_V --
1297: ------------------------------------------------------
1298: PROCEDURE validate_row(
1299: p_api_version IN NUMBER,
1300: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1628: -- insert_row for :IEX_EXCLUSION_HIST_V --

1624: '_PVT'
1625: );
1626: END insert_row;
1627: ------------------------------------------
1628: -- insert_row for :IEX_EXCLUSION_HIST_V --
1629: ------------------------------------------
1630: PROCEDURE insert_row(
1631: p_api_version IN NUMBER,
1632: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1664: -- Set_Attributes for:IEX_EXCLUSION_HIST_V --

1660: l_iehv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1661: RETURN(l_iehv_rec);
1662: END fill_who_columns;
1663: ---------------------------------------------
1664: -- Set_Attributes for:IEX_EXCLUSION_HIST_V --
1665: ---------------------------------------------
1666: FUNCTION Set_Attributes (
1667: p_iehv_rec IN iehv_rec_type,
1668: x_iehv_rec OUT NOCOPY iehv_rec_type

Line 2149: -- lock_row for: IEX_EXCLUSION_HIST_V --

2145: '_PVT'
2146: );
2147: END lock_row;
2148: ----------------------------------------
2149: -- lock_row for: IEX_EXCLUSION_HIST_V --
2150: ----------------------------------------
2151: PROCEDURE lock_row(
2152: p_api_version IN NUMBER,
2153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2844: -- update_row for:IEX_EXCLUSION_HIST_V --

2840: '_PVT'
2841: );
2842: END update_row;
2843: -----------------------------------------
2844: -- update_row for:IEX_EXCLUSION_HIST_V --
2845: -----------------------------------------
2846: PROCEDURE update_row(
2847: p_api_version IN NUMBER,
2848: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3042: -- Set_Attributes for:IEX_EXCLUSION_HIST_V --

3038: END IF;
3039: RETURN(l_return_status);
3040: END populate_new_record;
3041: ---------------------------------------------
3042: -- Set_Attributes for:IEX_EXCLUSION_HIST_V --
3043: ---------------------------------------------
3044: FUNCTION Set_Attributes (
3045: p_iehv_rec IN iehv_rec_type,
3046: x_iehv_rec OUT NOCOPY iehv_rec_type

Line 3475: -- delete_row for:IEX_EXCLUSION_HIST_V --

3471: '_PVT'
3472: );
3473: END delete_row;
3474: -----------------------------------------
3475: -- delete_row for:IEX_EXCLUSION_HIST_V --
3476: -----------------------------------------
3477: PROCEDURE delete_row(
3478: p_api_version IN NUMBER,
3479: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3571: -- PL/SQL TBL delete_row for:IEX_EXCLUSION_HIST_V --

3567: '_PVT'
3568: );
3569: END delete_row;
3570: ----------------------------------------------------
3571: -- PL/SQL TBL delete_row for:IEX_EXCLUSION_HIST_V --
3572: ----------------------------------------------------
3573: PROCEDURE delete_row(
3574: p_api_version IN NUMBER,
3575: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3667: -- PL/SQL TBL delete_row for:IEX_EXCLUSION_HIST_V --

3663: );
3664: END delete_row;
3665:
3666: ----------------------------------------------------
3667: -- PL/SQL TBL delete_row for:IEX_EXCLUSION_HIST_V --
3668: ----------------------------------------------------
3669: PROCEDURE delete_row(
3670: p_api_version IN NUMBER,
3671: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,