DBA Data[Home] [Help]

APPS.OKL_INR_PVT dependencies on OKL_INS_RATES_V

Line 132: -- FUNCTION get_rec for: OKL_INS_RATES_V

128: BEGIN
129: RETURN(get_rec(p_inr_rec, l_row_notfound));
130: END get_rec;
131: ---------------------------------------------------------------------------
132: -- FUNCTION get_rec for: OKL_INS_RATES_V
133: ---------------------------------------------------------------------------
134: FUNCTION get_rec (
135: p_inrv_rec IN inrv_rec_type,
136: x_no_data_found OUT NOCOPY BOOLEAN

Line 174: FROM Okl_Ins_Rates_V

170: CREATION_DATE,
171: LAST_UPDATED_BY,
172: LAST_UPDATE_DATE,
173: LAST_UPDATE_LOGIN
174: FROM Okl_Ins_Rates_V
175: WHERE okl_ins_rates_v.id = p_id;
176: l_okl_inrv_pk okl_inrv_pk_csr%ROWTYPE;
177: l_inrv_rec inrv_rec_type;
178: BEGIN

Line 175: WHERE okl_ins_rates_v.id = p_id;

171: LAST_UPDATED_BY,
172: LAST_UPDATE_DATE,
173: LAST_UPDATE_LOGIN
174: FROM Okl_Ins_Rates_V
175: WHERE okl_ins_rates_v.id = p_id;
176: l_okl_inrv_pk okl_inrv_pk_csr%ROWTYPE;
177: l_inrv_rec inrv_rec_type;
178: BEGIN
179: x_no_data_found := TRUE;

Line 229: -- FUNCTION null_out_defaults for: OKL_INS_RATES_V --

225: BEGIN
226: RETURN(get_rec(p_inrv_rec, l_row_notfound));
227: END get_rec;
228: -----------------------------------------------------
229: -- FUNCTION null_out_defaults for: OKL_INS_RATES_V --
230: -----------------------------------------------------
231: FUNCTION null_out_defaults (
232: p_inrv_rec IN inrv_rec_type
233: ) RETURN inrv_rec_type IS

Line 1092: -- Validate_Attributes for:OKL_INS_RATES_V --

1088: -- Notify the caller of an unexpected error
1089: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1090: END validate_inr_last_update_date;
1091: ---------------------------------------------
1092: -- Validate_Attributes for:OKL_INS_RATES_V --
1093: ---------------------------------------------
1094: FUNCTION Validate_Attributes (
1095: p_inrv_rec IN inrv_rec_type
1096: ) RETURN VARCHAR2 IS

Line 1463: -- Validate_Record for:OKL_INS_RATES_V --

1459: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1460: RETURN(x_return_status);
1461: END compare_number;
1462: -----------------------------------------
1463: -- Validate_Record for:OKL_INS_RATES_V --
1464: -----------------------------------------
1465: FUNCTION Validate_Record (
1466: p_inrv_rec IN inrv_rec_type
1467: ) RETURN VARCHAR2 IS

Line 1676: -- validate_row for:OKL_INS_RATES_V --

1672: ---------------------------------------------------------------------------
1673: -- PROCEDURE validate_row
1674: ---------------------------------------------------------------------------
1675: --------------------------------------
1676: -- validate_row for:OKL_INS_RATES_V --
1677: --------------------------------------
1678: PROCEDURE validate_row(
1679: p_api_version IN NUMBER,
1680: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1969: -- insert_row for:OKL_INS_RATES_V --

1965: '_PVT'
1966: );
1967: END insert_row;
1968: ------------------------------------
1969: -- insert_row for:OKL_INS_RATES_V --
1970: ------------------------------------
1971: PROCEDURE insert_row(
1972: p_api_version IN NUMBER,
1973: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2002: -- Set_Attributes for:OKL_INS_RATES_V --

1998: l_inrv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1999: RETURN(l_inrv_rec);
2000: END fill_who_columns;
2001: ----------------------------------------
2002: -- Set_Attributes for:OKL_INS_RATES_V --
2003: ----------------------------------------
2004: FUNCTION Set_Attributes (
2005: p_inrv_rec IN inrv_rec_type,
2006: x_inrv_rec OUT NOCOPY inrv_rec_type

Line 2284: -- lock_row for:OKL_INS_RATES_V --

2280: '_PVT'
2281: );
2282: END lock_row;
2283: ----------------------------------
2284: -- lock_row for:OKL_INS_RATES_V --
2285: ----------------------------------
2286: PROCEDURE lock_row(
2287: p_api_version IN NUMBER,
2288: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2707: -- update_row for:OKL_INS_RATES_V --

2703: '_PVT'
2704: );
2705: END update_row;
2706: ------------------------------------
2707: -- update_row for:OKL_INS_RATES_V --
2708: ------------------------------------
2709: PROCEDURE update_row(
2710: p_api_version IN NUMBER,
2711: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2893: -- Set_Attributes for:OKL_INS_RATES_V --

2889: END IF;
2890: RETURN(l_return_status);
2891: END populate_new_record;
2892: ----------------------------------------
2893: -- Set_Attributes for:OKL_INS_RATES_V --
2894: ----------------------------------------
2895: FUNCTION Set_Attributes (
2896: p_inrv_rec IN inrv_rec_type,
2897: x_inrv_rec OUT NOCOPY inrv_rec_type

Line 3132: -- delete_row for:OKL_INS_RATES_V --

3128: '_PVT'
3129: );
3130: END delete_row;
3131: ------------------------------------
3132: -- delete_row for:OKL_INS_RATES_V --
3133: ------------------------------------
3134: PROCEDURE delete_row(
3135: p_api_version IN NUMBER,
3136: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,