DBA Data[Home] [Help]

APPS.OKL_CLM_PVT dependencies on OKL_INS_CLAIMS_V

Line 177: -- FUNCTION get_rec for: OKL_INS_CLAIMS_V

173: AND T.LANGUAGE = L.LANGUAGE_CODE
174: );
175: END add_language;
176: ---------------------------------------------------------------------------
177: -- FUNCTION get_rec for: OKL_INS_CLAIMS_V
178: ---------------------------------------------------------------------------
179: FUNCTION get_rec (
180: p_clmv_rec IN clmv_rec_type,
181: x_no_data_found OUT NOCOPY BOOLEAN

Line 225: FROM Okl_Ins_Claims_V

221: CREATION_DATE,
222: LAST_UPDATED_BY,
223: LAST_UPDATE_DATE,
224: LAST_UPDATE_LOGIN
225: FROM Okl_Ins_Claims_V
226: WHERE okl_ins_claims_v.id = p_id;
227: l_okl_clmv_pk okl_clmv_pk_csr%ROWTYPE;
228: l_clmv_rec clmv_rec_type;
229: BEGIN

Line 226: WHERE okl_ins_claims_v.id = p_id;

222: LAST_UPDATED_BY,
223: LAST_UPDATE_DATE,
224: LAST_UPDATE_LOGIN
225: FROM Okl_Ins_Claims_V
226: WHERE okl_ins_claims_v.id = p_id;
227: l_okl_clmv_pk okl_clmv_pk_csr%ROWTYPE;
228: l_clmv_rec clmv_rec_type;
229: BEGIN
230: x_no_data_found := TRUE;

Line 509: -- FUNCTION null_out_defaults for: OKL_INS_CLAIMS_V

505: BEGIN
506: RETURN(get_rec(p_okl_ins_claims_tl_rec, l_row_not_found));
507: END get_rec;
508: ---------------------------------------------------------------------------
509: -- FUNCTION null_out_defaults for: OKL_INS_CLAIMS_V
510: ---------------------------------------------------------------------------
511: FUNCTION null_out_defaults (
512: p_clmv_rec IN clmv_rec_type
513: ) RETURN clmv_rec_type IS

Line 1052: -- Validate_Attributes for:OKL_INS_CLAIMS_V --

1048: ---------------------------------------------------------------------------
1049: -- FUNCTION Validate_Attributes
1050: ---------------------------------------------------------------------------
1051: ----------------------------------------------
1052: -- Validate_Attributes for:OKL_INS_CLAIMS_V --
1053: ----------------------------------------------
1054: FUNCTION Validate_Attributes (
1055: p_clmv_rec IN clmv_rec_type
1056: ) RETURN VARCHAR2 IS

Line 1252: FROM okl_ins_claims_v

1248: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1249: l_dummy_var VARCHAR2(1) := '?';
1250: CURSOR l_clmv_csr IS
1251: SELECT 'x'
1252: FROM okl_ins_claims_v
1253: WHERE ipy_id = p_clmv_rec.ipy_id
1254: AND claim_number = p_clmv_rec.claim_number
1255: AND ID <> p_clmv_rec.id;
1256: BEGIN

Line 1277: -- Validate Record for:OKL_INS_CLAIMS_V --

1273: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1274: END validate_duplicates;
1275:
1276: ------------------------------------------
1277: -- Validate Record for:OKL_INS_CLAIMS_V --
1278: ------------------------------------------
1279: FUNCTION Validate_Record (
1280: p_clmv_rec IN clmv_rec_type,
1281: p_db_clmv_rec IN clmv_rec_type

Line 1443: -- validate_row for:OKL_INS_CLAIMS_V --

1439: ---------------------------------------------------------------------------
1440: -- PROCEDURE validate_row
1441: ---------------------------------------------------------------------------
1442: ---------------------------------------
1443: -- validate_row for:OKL_INS_CLAIMS_V --
1444: ---------------------------------------
1445: PROCEDURE validate_row(
1446: p_api_version IN NUMBER,
1447: p_init_msg_list IN VARCHAR2 ,

Line 1519: -- PL/SQL TBL validate_row for:OKL_INS_CLAIMS_V --

1515: '_PVT'
1516: );
1517: END validate_row;
1518: --------------------------------------------------
1519: -- PL/SQL TBL validate_row for:OKL_INS_CLAIMS_V --
1520: --------------------------------------------------
1521: PROCEDURE validate_row(
1522: p_api_version IN NUMBER,
1523: p_init_msg_list IN VARCHAR2 ,

Line 1613: -- PL/SQL TBL validate_row for:OKL_INS_CLAIMS_V --

1609: '_PVT'
1610: );
1611: END validate_row;
1612: --------------------------------------------------
1613: -- PL/SQL TBL validate_row for:OKL_INS_CLAIMS_V --
1614: --------------------------------------------------
1615: PROCEDURE validate_row(
1616: p_api_version IN NUMBER,
1617: p_init_msg_list IN VARCHAR2 ,

Line 1955: -- insert_row for :OKL_INS_CLAIMS_V --

1951: '_PVT'
1952: );
1953: END insert_row;
1954: --------------------------------------
1955: -- insert_row for :OKL_INS_CLAIMS_V --
1956: --------------------------------------
1957: PROCEDURE insert_row(
1958: p_api_version IN NUMBER,
1959: p_init_msg_list IN VARCHAR2 ,

Line 2115: -- Set_Attributes for:OKL_INS_CLAIMS_V --

2111: l_clmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2112: RETURN(l_clmv_rec);
2113: END fill_who_columns;
2114: -----------------------------------------
2115: -- Set_Attributes for:OKL_INS_CLAIMS_V --
2116: -----------------------------------------
2117: FUNCTION Set_Attributes (
2118: p_clmv_rec IN clmv_rec_type,
2119: x_clmv_rec OUT NOCOPY clmv_rec_type

Line 2622: -- lock_row for: OKL_INS_CLAIMS_V --

2618: '_PVT'
2619: );
2620: END lock_row;
2621: ------------------------------------
2622: -- lock_row for: OKL_INS_CLAIMS_V --
2623: ------------------------------------
2624: PROCEDURE lock_row(
2625: p_api_version IN NUMBER,
2626: p_init_msg_list IN VARCHAR2 ,

Line 3343: -- update_row for:OKL_INS_CLAIMS_V --

3339: '_PVT'
3340: );
3341: END update_row;
3342: -------------------------------------
3343: -- update_row for:OKL_INS_CLAIMS_V --
3344: -------------------------------------
3345: PROCEDURE update_row(
3346: p_api_version IN NUMBER,
3347: p_init_msg_list IN VARCHAR2 ,

Line 3552: -- Set_Attributes for:OKL_INS_CLAIMS_V --

3548: END IF;
3549: RETURN(l_return_status);
3550: END populate_new_record;
3551: -----------------------------------------
3552: -- Set_Attributes for:OKL_INS_CLAIMS_V --
3553: -----------------------------------------
3554: FUNCTION Set_Attributes (
3555: p_clmv_rec IN clmv_rec_type,
3556: x_clmv_rec OUT NOCOPY clmv_rec_type

Line 3975: -- delete_row for:OKL_INS_CLAIMS_V --

3971: '_PVT'
3972: );
3973: END delete_row;
3974: -------------------------------------
3975: -- delete_row for:OKL_INS_CLAIMS_V --
3976: -------------------------------------
3977: PROCEDURE delete_row(
3978: p_api_version IN NUMBER,
3979: p_init_msg_list IN VARCHAR2 ,

Line 4070: -- PL/SQL TBL delete_row for:OKL_INS_CLAIMS_V --

4066: '_PVT'
4067: );
4068: END delete_row;
4069: ------------------------------------------------
4070: -- PL/SQL TBL delete_row for:OKL_INS_CLAIMS_V --
4071: ------------------------------------------------
4072: PROCEDURE delete_row(
4073: p_api_version IN NUMBER,
4074: p_init_msg_list IN VARCHAR2 ,

Line 4164: -- PL/SQL TBL delete_row for:OKL_INS_CLAIMS_V --

4160: '_PVT'
4161: );
4162: END delete_row;
4163: ------------------------------------------------
4164: -- PL/SQL TBL delete_row for:OKL_INS_CLAIMS_V --
4165: ------------------------------------------------
4166: PROCEDURE delete_row(
4167: p_api_version IN NUMBER,
4168: p_init_msg_list IN VARCHAR2 ,