DBA Data[Home] [Help]

APPS.OKL_VIR_PVT dependencies on OKL_VAR_INT_PARAMS_V

Line 94: -- FUNCTION get_rec for: OKL_VAR_INT_PARAMS_V

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

Line 141: FROM Okl_Var_Int_Params_V

137: LAST_UPDATE_DATE,
138: LAST_UPDATE_LOGIN,
139: INTEREST_AMT,
140: INTEREST_CALC_DAYS
141: FROM Okl_Var_Int_Params_V
142: WHERE okl_var_int_params_v.id = p_id;
143: l_okl_virv_pk okl_virv_pk_csr%ROWTYPE;
144: l_virv_rec virv_rec_type;
145: BEGIN

Line 142: WHERE okl_var_int_params_v.id = p_id;

138: LAST_UPDATE_LOGIN,
139: INTEREST_AMT,
140: INTEREST_CALC_DAYS
141: FROM Okl_Var_Int_Params_V
142: WHERE okl_var_int_params_v.id = p_id;
143: l_okl_virv_pk okl_virv_pk_csr%ROWTYPE;
144: l_virv_rec virv_rec_type;
145: BEGIN
146: x_no_data_found := TRUE;

Line 352: -- FUNCTION null_out_defaults for: OKL_VAR_INT_PARAMS_V

348: BEGIN
349: RETURN(get_rec(p_vir_rec, l_row_not_found));
350: END get_rec;
351: ---------------------------------------------------------------------------
352: -- FUNCTION null_out_defaults for: OKL_VAR_INT_PARAMS_V
353: ---------------------------------------------------------------------------
354: FUNCTION null_out_defaults (
355: p_virv_rec IN virv_rec_type
356: ) RETURN virv_rec_type IS

Line 838: -- Validate_Attributes for:OKL_VAR_INT_PARAMS_V --

834: ---------------------------------------------------------------------------
835: -- FUNCTION Validate_Attributes
836: ---------------------------------------------------------------------------
837: --------------------------------------------------
838: -- Validate_Attributes for:OKL_VAR_INT_PARAMS_V --
839: --------------------------------------------------
840: FUNCTION Validate_Attributes (
841: p_virv_rec IN virv_rec_type
842: ) RETURN VARCHAR2 IS

Line 966: -- Validate Record for:OKL_VAR_INT_PARAMS_V --

962: ---------------------------------------------------------------------------
963: -- PROCEDURE Validate_Record
964: ---------------------------------------------------------------------------
965: ----------------------------------------------
966: -- Validate Record for:OKL_VAR_INT_PARAMS_V --
967: ----------------------------------------------
968: FUNCTION Validate_Record (
969: p_virv_rec IN virv_rec_type,
970: p_db_virv_rec IN virv_rec_type

Line 1084: -- validate_row for:OKL_VAR_INT_PARAMS_V --

1080: ---------------------------------------------------------------------------
1081: -- PROCEDURE validate_row
1082: ---------------------------------------------------------------------------
1083: -------------------------------------------
1084: -- validate_row for:OKL_VAR_INT_PARAMS_V --
1085: -------------------------------------------
1086: PROCEDURE validate_row(
1087: p_api_version IN NUMBER,
1088: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1161: -- PL/SQL TBL validate_row for:OKL_VAR_INT_PARAMS_V --

1157: '_PVT'
1158: );
1159: END validate_row;
1160: ------------------------------------------------------
1161: -- PL/SQL TBL validate_row for:OKL_VAR_INT_PARAMS_V --
1162: ------------------------------------------------------
1163: PROCEDURE validate_row(
1164: p_api_version IN NUMBER,
1165: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1257: -- PL/SQL TBL validate_row for:OKL_VAR_INT_PARAMS_V --

1253: );
1254: END validate_row;
1255:
1256: ------------------------------------------------------
1257: -- PL/SQL TBL validate_row for:OKL_VAR_INT_PARAMS_V --
1258: ------------------------------------------------------
1259: PROCEDURE validate_row(
1260: p_api_version IN NUMBER,
1261: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1486: -- insert_row for :OKL_VAR_INT_PARAMS_V --

1482: '_PVT'
1483: );
1484: END insert_row;
1485: ------------------------------------------
1486: -- insert_row for :OKL_VAR_INT_PARAMS_V --
1487: ------------------------------------------
1488: PROCEDURE insert_row(
1489: p_api_version IN NUMBER,
1490: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1520: -- Set_Attributes for:OKL_VAR_INT_PARAMS_V --

1516: l_virv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1517: RETURN(l_virv_rec);
1518: END fill_who_columns;
1519: ---------------------------------------------
1520: -- Set_Attributes for:OKL_VAR_INT_PARAMS_V --
1521: ---------------------------------------------
1522: FUNCTION Set_Attributes (
1523: p_virv_rec IN virv_rec_type,
1524: x_virv_rec OUT NOCOPY virv_rec_type

Line 1921: -- lock_row for: OKL_VAR_INT_PARAMS_V --

1917: '_PVT'
1918: );
1919: END lock_row;
1920: ----------------------------------------
1921: -- lock_row for: OKL_VAR_INT_PARAMS_V --
1922: ----------------------------------------
1923: PROCEDURE lock_row(
1924: p_api_version IN NUMBER,
1925: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2468: -- update_row for:OKL_VAR_INT_PARAMS_V --

2464: '_PVT'
2465: );
2466: END update_row;
2467: -----------------------------------------
2468: -- update_row for:OKL_VAR_INT_PARAMS_V --
2469: -----------------------------------------
2470: PROCEDURE update_row(
2471: p_api_version IN NUMBER,
2472: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2679: -- Set_Attributes for:OKL_VAR_INT_PARAMS_V --

2675: END IF;
2676: RETURN(l_return_status);
2677: END populate_new_record;
2678: ---------------------------------------------
2679: -- Set_Attributes for:OKL_VAR_INT_PARAMS_V --
2680: ---------------------------------------------
2681: FUNCTION Set_Attributes (
2682: p_virv_rec IN virv_rec_type,
2683: x_virv_rec OUT NOCOPY virv_rec_type

Line 3058: -- delete_row for:OKL_VAR_INT_PARAMS_V --

3054: '_PVT'
3055: );
3056: END delete_row;
3057: -----------------------------------------
3058: -- delete_row for:OKL_VAR_INT_PARAMS_V --
3059: -----------------------------------------
3060: PROCEDURE delete_row(
3061: p_api_version IN NUMBER,
3062: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3140: -- PL/SQL TBL delete_row for:OKL_VAR_INT_PARAMS_V --

3136: '_PVT'
3137: );
3138: END delete_row;
3139: ----------------------------------------------------
3140: -- PL/SQL TBL delete_row for:OKL_VAR_INT_PARAMS_V --
3141: ----------------------------------------------------
3142: PROCEDURE delete_row(
3143: p_api_version IN NUMBER,
3144: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3236: -- PL/SQL TBL delete_row for:OKL_VAR_INT_PARAMS_V --

3232: );
3233: END delete_row;
3234:
3235: ----------------------------------------------------
3236: -- PL/SQL TBL delete_row for:OKL_VAR_INT_PARAMS_V --
3237: ----------------------------------------------------
3238: PROCEDURE delete_row(
3239: p_api_version IN NUMBER,
3240: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,