DBA Data[Home] [Help]

APPS.OKL_SRS_PVT dependencies on OKL_SIF_RET_STRMS_V

Line 124: -- FUNCTION get_rec for: OKL_SIF_RET_STRMS_V

120: BEGIN
121: RETURN(get_rec(p_srs_rec, l_row_notfound));
122: END get_rec;
123: ---------------------------------------------------------------------------
124: -- FUNCTION get_rec for: OKL_SIF_RET_STRMS_V
125: ---------------------------------------------------------------------------
126: FUNCTION get_rec (
127: p_srsv_rec IN srsv_rec_type,
128: x_no_data_found OUT NOCOPY BOOLEAN

Line 161: FROM Okl_Sif_Ret_Strms_V

157: LAST_UPDATED_BY,
158: CREATION_DATE,
159: LAST_UPDATE_DATE,
160: LAST_UPDATE_LOGIN
161: FROM Okl_Sif_Ret_Strms_V
162: WHERE okl_sif_ret_strms_v.id = p_id;
163: l_srsv_pk srsv_pk_csr%ROWTYPE;
164: l_srsv_rec srsv_rec_type;
165: BEGIN

Line 162: WHERE okl_sif_ret_strms_v.id = p_id;

158: CREATION_DATE,
159: LAST_UPDATE_DATE,
160: LAST_UPDATE_LOGIN
161: FROM Okl_Sif_Ret_Strms_V
162: WHERE okl_sif_ret_strms_v.id = p_id;
163: l_srsv_pk srsv_pk_csr%ROWTYPE;
164: l_srsv_rec srsv_rec_type;
165: BEGIN
166: x_no_data_found := TRUE;

Line 213: -- FUNCTION null_out_defaults for: OKL_SIF_RET_STRMS_V --

209: RETURN(get_rec(p_srsv_rec, l_row_notfound));
210: END get_rec;
211:
212: ---------------------------------------------------------
213: -- FUNCTION null_out_defaults for: OKL_SIF_RET_STRMS_V --
214: ---------------------------------------------------------
215: FUNCTION null_out_defaults (
216: p_srsv_rec IN srsv_rec_type
217: ) RETURN srsv_rec_type IS

Line 313: -- Validate_Attributes for:OKL_SIF_RET_STRMS_V --

309: ---------------------------------------------------------------------------
310: -- PROCEDURE Validate_Attributes
311: ---------------------------------------------------------------------------
312: -------------------------------------------------
313: -- Validate_Attributes for:OKL_SIF_RET_STRMS_V --
314: -------------------------------------------------
315: FUNCTION Validate_Attributes (
316: p_srsv_rec IN srsv_rec_type
317: ) RETURN VARCHAR2 IS

Line 845: -- Validate_Record for:OKL_SIF_RET_STRMS_V --

841: ---------------------------------------------------------------------------
842: -- PROCEDURE Validate_Record
843: ---------------------------------------------------------------------------
844: ---------------------------------------------
845: -- Validate_Record for:OKL_SIF_RET_STRMS_V --
846: ---------------------------------------------
847: FUNCTION Validate_Record (
848: p_srsv_rec IN srsv_rec_type
849: ) RETURN VARCHAR2 IS

Line 940: -- validate_row for:OKL_SIF_RET_STRMS_V --

936: ---------------------------------------------------------------------------
937: -- PROCEDURE validate_row
938: ---------------------------------------------------------------------------
939: ------------------------------------------
940: -- validate_row for:OKL_SIF_RET_STRMS_V --
941: ------------------------------------------
942: PROCEDURE validate_row(
943: p_api_version IN NUMBER,
944: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1247: -- insert_row for:OKL_SIF_RET_STRMS_V --

1243:
1244:
1245:
1246: ----------------------------------------
1247: -- insert_row for:OKL_SIF_RET_STRMS_V --
1248: ----------------------------------------
1249:
1250: PROCEDURE insert_row(
1251: p_api_version IN NUMBER,

Line 1283: -- Set_Attributes for:OKL_SIF_RET_STRMS_V --

1279: l_srsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1280: RETURN(l_srsv_rec);
1281: END fill_who_columns;
1282: --------------------------------------------
1283: -- Set_Attributes for:OKL_SIF_RET_STRMS_V --
1284: --------------------------------------------
1285: FUNCTION Set_Attributes (
1286: p_srsv_rec IN srsv_rec_type,
1287: x_srsv_rec OUT NOCOPY srsv_rec_type

Line 1589: -- lock_row for:OKL_SIF_RET_STRMS_V --

1585: '_PVT'
1586: );
1587: END lock_row;
1588: --------------------------------------
1589: -- lock_row for:OKL_SIF_RET_STRMS_V --
1590: --------------------------------------
1591: PROCEDURE lock_row(
1592: p_api_version IN NUMBER,
1593: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2008: -- update_row for:OKL_SIF_RET_STRMS_V --

2004: '_PVT'
2005: );
2006: END update_row;
2007: ----------------------------------------
2008: -- update_row for:OKL_SIF_RET_STRMS_V --
2009: ----------------------------------------
2010: PROCEDURE update_row(
2011: p_api_version IN NUMBER,
2012: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2175: -- Set_Attributes for:OKL_SIF_RET_STRMS_V --

2171: END IF;
2172: RETURN(l_return_status);
2173: END populate_new_record;
2174: --------------------------------------------
2175: -- Set_Attributes for:OKL_SIF_RET_STRMS_V --
2176: --------------------------------------------
2177: FUNCTION Set_Attributes (
2178: p_srsv_rec IN srsv_rec_type,
2179: x_srsv_rec OUT NOCOPY srsv_rec_type

Line 2439: -- delete_row for:OKL_SIF_RET_STRMS_V --

2435: '_PVT'
2436: );
2437: END delete_row;
2438: ----------------------------------------
2439: -- delete_row for:OKL_SIF_RET_STRMS_V --
2440: ----------------------------------------
2441: PROCEDURE delete_row(
2442: p_api_version IN NUMBER,
2443: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2602: --- insert_row_per for:OKL_SIF_RET_STRMS_V --

2598: END delete_row;
2599:
2600: --BAKUCHIB Bug#2807737 start
2601: ---------------------------------------------
2602: --- insert_row_per for:OKL_SIF_RET_STRMS_V --
2603: ---------------------------------------------
2604: -- Start of comments
2605: -- Procedure Name : insert_row_per
2606: -- Description : Used extend insert_row without having the actuall insert

Line 2648: -- Set_Attributes for:OKL_SIF_RET_STRMS_V --

2644: l_srsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2645: RETURN(l_srsv_rec);
2646: END fill_who_columns;
2647: --------------------------------------------
2648: -- Set_Attributes for:OKL_SIF_RET_STRMS_V --
2649: --------------------------------------------
2650: FUNCTION Set_Attributes (
2651: p_srsv_rec IN srsv_rec_type,
2652: x_srsv_rec OUT NOCOPY srsv_rec_type

Line 2724: --- insert_row_upg for:OKL_SIF_RET_STRMS_V --

2720: );
2721:
2722: END insert_row_per;
2723: ---------------------------------------------
2724: --- insert_row_upg for:OKL_SIF_RET_STRMS_V --
2725: ---------------------------------------------
2726: -- Start of comments
2727: -- Procedure Name : insert_row_upg
2728: -- Description : Used for the Bulk insert into the OKL_SIF_RET_STRMS table