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 144: FROM Okl_Var_Int_Params_V

140: INTEREST_CALC_DAYS,
141: KLE_ID,
142: CATCHUP_AMT,
143: CATCHUP_SETTLEMENT_CODE
144: FROM Okl_Var_Int_Params_V
145: WHERE okl_var_int_params_v.id = p_id;
146: l_okl_virv_pk okl_virv_pk_csr%ROWTYPE;
147: l_virv_rec virv_rec_type;
148: BEGIN

Line 145: WHERE okl_var_int_params_v.id = p_id;

141: KLE_ID,
142: CATCHUP_AMT,
143: CATCHUP_SETTLEMENT_CODE
144: FROM Okl_Var_Int_Params_V
145: WHERE okl_var_int_params_v.id = p_id;
146: l_okl_virv_pk okl_virv_pk_csr%ROWTYPE;
147: l_virv_rec virv_rec_type;
148: BEGIN
149: x_no_data_found := TRUE;

Line 364: -- FUNCTION null_out_defaults for: OKL_VAR_INT_PARAMS_V

360: BEGIN
361: RETURN(get_rec(p_vir_rec, l_row_not_found));
362: END get_rec;
363: ---------------------------------------------------------------------------
364: -- FUNCTION null_out_defaults for: OKL_VAR_INT_PARAMS_V
365: ---------------------------------------------------------------------------
366: FUNCTION null_out_defaults (
367: p_virv_rec IN virv_rec_type
368: ) RETURN virv_rec_type IS

Line 859: -- Validate_Attributes for:OKL_VAR_INT_PARAMS_V --

855: ---------------------------------------------------------------------------
856: -- FUNCTION Validate_Attributes
857: ---------------------------------------------------------------------------
858: --------------------------------------------------
859: -- Validate_Attributes for:OKL_VAR_INT_PARAMS_V --
860: --------------------------------------------------
861: FUNCTION Validate_Attributes (
862: p_virv_rec IN virv_rec_type
863: ) RETURN VARCHAR2 IS

Line 987: -- Validate Record for:OKL_VAR_INT_PARAMS_V --

983: ---------------------------------------------------------------------------
984: -- PROCEDURE Validate_Record
985: ---------------------------------------------------------------------------
986: ----------------------------------------------
987: -- Validate Record for:OKL_VAR_INT_PARAMS_V --
988: ----------------------------------------------
989: FUNCTION Validate_Record (
990: p_virv_rec IN virv_rec_type,
991: p_db_virv_rec IN virv_rec_type

Line 1112: -- validate_row for:OKL_VAR_INT_PARAMS_V --

1108: ---------------------------------------------------------------------------
1109: -- PROCEDURE validate_row
1110: ---------------------------------------------------------------------------
1111: -------------------------------------------
1112: -- validate_row for:OKL_VAR_INT_PARAMS_V --
1113: -------------------------------------------
1114: PROCEDURE validate_row(
1115: p_api_version IN NUMBER,
1116: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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

1185: '_PVT'
1186: );
1187: END validate_row;
1188: ------------------------------------------------------
1189: -- PL/SQL TBL validate_row for:OKL_VAR_INT_PARAMS_V --
1190: ------------------------------------------------------
1191: PROCEDURE validate_row(
1192: p_api_version IN NUMBER,
1193: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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

1281: );
1282: END validate_row;
1283:
1284: ------------------------------------------------------
1285: -- PL/SQL TBL validate_row for:OKL_VAR_INT_PARAMS_V --
1286: ------------------------------------------------------
1287: PROCEDURE validate_row(
1288: p_api_version IN NUMBER,
1289: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1520: -- insert_row for :OKL_VAR_INT_PARAMS_V --

1516: '_PVT'
1517: );
1518: END insert_row;
1519: ------------------------------------------
1520: -- insert_row for :OKL_VAR_INT_PARAMS_V --
1521: ------------------------------------------
1522: PROCEDURE insert_row(
1523: p_api_version IN NUMBER,
1524: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1554: -- Set_Attributes for:OKL_VAR_INT_PARAMS_V --

1550: l_virv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1551: RETURN(l_virv_rec);
1552: END fill_who_columns;
1553: ---------------------------------------------
1554: -- Set_Attributes for:OKL_VAR_INT_PARAMS_V --
1555: ---------------------------------------------
1556: FUNCTION Set_Attributes (
1557: p_virv_rec IN virv_rec_type,
1558: x_virv_rec OUT NOCOPY virv_rec_type

Line 1955: -- lock_row for: OKL_VAR_INT_PARAMS_V --

1951: '_PVT'
1952: );
1953: END lock_row;
1954: ----------------------------------------
1955: -- lock_row for: OKL_VAR_INT_PARAMS_V --
1956: ----------------------------------------
1957: PROCEDURE lock_row(
1958: p_api_version IN NUMBER,
1959: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2516: -- update_row for:OKL_VAR_INT_PARAMS_V --

2512: '_PVT'
2513: );
2514: END update_row;
2515: -----------------------------------------
2516: -- update_row for:OKL_VAR_INT_PARAMS_V --
2517: -----------------------------------------
2518: PROCEDURE update_row(
2519: p_api_version IN NUMBER,
2520: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2739: -- Set_Attributes for:OKL_VAR_INT_PARAMS_V --

2735: END IF;
2736: RETURN(l_return_status);
2737: END populate_new_record;
2738: ---------------------------------------------
2739: -- Set_Attributes for:OKL_VAR_INT_PARAMS_V --
2740: ---------------------------------------------
2741: FUNCTION Set_Attributes (
2742: p_virv_rec IN virv_rec_type,
2743: x_virv_rec OUT NOCOPY virv_rec_type

Line 3118: -- delete_row for:OKL_VAR_INT_PARAMS_V --

3114: '_PVT'
3115: );
3116: END delete_row;
3117: -----------------------------------------
3118: -- delete_row for:OKL_VAR_INT_PARAMS_V --
3119: -----------------------------------------
3120: PROCEDURE delete_row(
3121: p_api_version IN NUMBER,
3122: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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

3196: '_PVT'
3197: );
3198: END delete_row;
3199: ----------------------------------------------------
3200: -- PL/SQL TBL delete_row for:OKL_VAR_INT_PARAMS_V --
3201: ----------------------------------------------------
3202: PROCEDURE delete_row(
3203: p_api_version IN NUMBER,
3204: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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

3292: );
3293: END delete_row;
3294:
3295: ----------------------------------------------------
3296: -- PL/SQL TBL delete_row for:OKL_VAR_INT_PARAMS_V --
3297: ----------------------------------------------------
3298: PROCEDURE delete_row(
3299: p_api_version IN NUMBER,
3300: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,