DBA Data[Home] [Help]

APPS.OKL_POC_PVT dependencies on OKL_POOL_CONTENTS

Line 94: -- FUNCTION get_rec for: OKL_POOL_CONTENTS_V

90: NULL;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_POOL_CONTENTS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_pocv_rec IN pocv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 142: FROM OKL_POOL_CONTENTS_V

138: CREATION_DATE,
139: LAST_UPDATED_BY,
140: LAST_UPDATE_DATE,
141: LAST_UPDATE_LOGIN
142: FROM OKL_POOL_CONTENTS_V
143: WHERE OKL_POOL_CONTENTS_V.id = p_id;
144: l_okl_pocv_pk okl_pocv_pk_csr%ROWTYPE;
145: l_pocv_rec pocv_rec_type;
146: BEGIN

Line 143: WHERE OKL_POOL_CONTENTS_V.id = p_id;

139: LAST_UPDATED_BY,
140: LAST_UPDATE_DATE,
141: LAST_UPDATE_LOGIN
142: FROM OKL_POOL_CONTENTS_V
143: WHERE OKL_POOL_CONTENTS_V.id = p_id;
144: l_okl_pocv_pk okl_pocv_pk_csr%ROWTYPE;
145: l_pocv_rec pocv_rec_type;
146: BEGIN
147: x_no_data_found := TRUE;

Line 225: -- FUNCTION get_rec for: okl_pool_contents

221: BEGIN
222: RETURN(get_rec(p_pocv_rec, l_row_not_found));
223: END get_rec;
224: ---------------------------------------------------------------------------
225: -- FUNCTION get_rec for: okl_pool_contents
226: ---------------------------------------------------------------------------
227: FUNCTION get_rec (
228: p_poc_rec IN poc_rec_type,
229: x_no_data_found OUT NOCOPY BOOLEAN

Line 231: CURSOR okl_pool_contents_pk_csr (p_id IN NUMBER) IS

227: FUNCTION get_rec (
228: p_poc_rec IN poc_rec_type,
229: x_no_data_found OUT NOCOPY BOOLEAN
230: ) RETURN poc_rec_type IS
231: CURSOR okl_pool_contents_pk_csr (p_id IN NUMBER) IS
232: SELECT
233: ID,
234: OBJECT_VERSION_NUMBER,
235: POL_ID,

Line 273: FROM okl_pool_contents

269: CREATION_DATE,
270: LAST_UPDATED_BY,
271: LAST_UPDATE_DATE,
272: LAST_UPDATE_LOGIN
273: FROM okl_pool_contents
274: WHERE okl_pool_contents.id = p_id;
275: l_okl_pool_contents_pk okl_pool_contents_pk_csr%ROWTYPE;
276: l_poc_rec poc_rec_type;
277: BEGIN

Line 274: WHERE okl_pool_contents.id = p_id;

270: LAST_UPDATED_BY,
271: LAST_UPDATE_DATE,
272: LAST_UPDATE_LOGIN
273: FROM okl_pool_contents
274: WHERE okl_pool_contents.id = p_id;
275: l_okl_pool_contents_pk okl_pool_contents_pk_csr%ROWTYPE;
276: l_poc_rec poc_rec_type;
277: BEGIN
278: x_no_data_found := TRUE;

Line 275: l_okl_pool_contents_pk okl_pool_contents_pk_csr%ROWTYPE;

271: LAST_UPDATE_DATE,
272: LAST_UPDATE_LOGIN
273: FROM okl_pool_contents
274: WHERE okl_pool_contents.id = p_id;
275: l_okl_pool_contents_pk okl_pool_contents_pk_csr%ROWTYPE;
276: l_poc_rec poc_rec_type;
277: BEGIN
278: x_no_data_found := TRUE;
279: -- Get current database values

Line 280: OPEN okl_pool_contents_pk_csr (p_poc_rec.id);

276: l_poc_rec poc_rec_type;
277: BEGIN
278: x_no_data_found := TRUE;
279: -- Get current database values
280: OPEN okl_pool_contents_pk_csr (p_poc_rec.id);
281: FETCH okl_pool_contents_pk_csr INTO
282: l_poc_rec.id,
283: l_poc_rec.object_version_number,
284: l_poc_rec.pol_id,

Line 281: FETCH okl_pool_contents_pk_csr INTO

277: BEGIN
278: x_no_data_found := TRUE;
279: -- Get current database values
280: OPEN okl_pool_contents_pk_csr (p_poc_rec.id);
281: FETCH okl_pool_contents_pk_csr INTO
282: l_poc_rec.id,
283: l_poc_rec.object_version_number,
284: l_poc_rec.pol_id,
285: l_poc_rec.khr_id,

Line 322: x_no_data_found := okl_pool_contents_pk_csr%NOTFOUND;

318: l_poc_rec.creation_date,
319: l_poc_rec.last_updated_by,
320: l_poc_rec.last_update_date,
321: l_poc_rec.last_update_login;
322: x_no_data_found := okl_pool_contents_pk_csr%NOTFOUND;
323: CLOSE okl_pool_contents_pk_csr;
324: RETURN(l_poc_rec);
325: END get_rec;
326:

Line 323: CLOSE okl_pool_contents_pk_csr;

319: l_poc_rec.last_updated_by,
320: l_poc_rec.last_update_date,
321: l_poc_rec.last_update_login;
322: x_no_data_found := okl_pool_contents_pk_csr%NOTFOUND;
323: CLOSE okl_pool_contents_pk_csr;
324: RETURN(l_poc_rec);
325: END get_rec;
326:
327: ------------------------------------------------------------------

Line 357: -- FUNCTION null_out_defaults for: OKL_POOL_CONTENTS_V

353: RETURN(get_rec(p_poc_rec, l_row_not_found));
354: END get_rec;
355:
356: ---------------------------------------------------------------------------
357: -- FUNCTION null_out_defaults for: OKL_POOL_CONTENTS_V
358: -- mvasudev, hold this off for now
359: ---------------------------------------------------------------------------
360: FUNCTION null_out_defaults (
361: p_pocv_rec IN pocv_rec_type

Line 559: CURSOR okl_polv_pk_csr (p_id IN OKL_POOL_CONTENTS_V.pol_id%TYPE) IS

555: l_dummy VARCHAR2(1) := '?';
556: l_row_not_found BOOLEAN := FALSE;
557:
558: -- Cursor For OKL_POL_POT_FK;
559: CURSOR okl_polv_pk_csr (p_id IN OKL_POOL_CONTENTS_V.pol_id%TYPE) IS
560: SELECT '1'
561: FROM OKL_POOLS
562: WHERE OKL_POOLS.id = p_id;
563:

Line 611: CURSOR okl_khrv_pk_csr (p_id IN OKL_POOL_CONTENTS_V.khr_id%TYPE) IS

607: l_dummy VARCHAR2(1) := '?';
608: l_row_not_found BOOLEAN := FALSE;
609:
610: -- Cursor For OKL_POL_KHR_FK;
611: CURSOR okl_khrv_pk_csr (p_id IN OKL_POOL_CONTENTS_V.khr_id%TYPE) IS
612: SELECT '1'
613: FROM OKL_K_HEADERS_V
614: WHERE OKL_K_HEADERS_V.id = p_id;
615:

Line 664: CURSOR okl_klev_pk_csr (p_id IN OKL_POOL_CONTENTS_V.kle_id%TYPE) IS

660: l_dummy VARCHAR2(1) := '?';
661: l_row_not_found BOOLEAN := FALSE;
662:
663: -- Cursor For OKL_POL_KHR_FK;
664: CURSOR okl_klev_pk_csr (p_id IN OKL_POOL_CONTENTS_V.kle_id%TYPE) IS
665: SELECT '1'
666: FROM OKL_K_LINES_V
667: WHERE OKL_K_LINES_V.id = p_id;
668:

Line 717: CURSOR okl_styv_pk_csr (p_id IN OKL_POOL_CONTENTS_V.sty_id%TYPE) IS

713: l_dummy VARCHAR2(1) := '?';
714: l_row_not_found BOOLEAN := FALSE;
715:
716: -- Cursor For OKL_POL_KHR_FK;
717: CURSOR okl_styv_pk_csr (p_id IN OKL_POOL_CONTENTS_V.sty_id%TYPE) IS
718: SELECT '1'
719: FROM OKL_STRM_TYPE_V
720: WHERE OKL_STRM_TYPE_V.id = p_id;
721:

Line 770: CURSOR okl_stm_pk_csr (p_id IN OKL_POOL_CONTENTS_V.stm_id%TYPE) IS

766: l_dummy VARCHAR2(1) := '?';
767: l_row_not_found BOOLEAN := FALSE;
768:
769: -- Cursor For OKL_POL_KHR_FK;
770: CURSOR okl_stm_pk_csr (p_id IN OKL_POOL_CONTENTS_V.stm_id%TYPE) IS
771: SELECT '1'
772: FROM OKL_STREAMS
773: WHERE OKL_STREAMS.id = p_id;
774:

Line 823: CURSOR okl_poxv_pk_csr (p_id IN OKL_POOL_CONTENTS_V.pox_id%TYPE) IS

819: l_dummy VARCHAR2(1) := '?';
820: l_row_not_found BOOLEAN := FALSE;
821:
822: -- Cursor For OKL_POL_KHR_FK;
823: CURSOR okl_poxv_pk_csr (p_id IN OKL_POOL_CONTENTS_V.pox_id%TYPE) IS
824: SELECT '1'
825: FROM OKL_POOL_TRANSACTIONS_V
826: WHERE OKL_POOL_TRANSACTIONS_V.id = p_id;
827:

Line 899: CURSOR okl_poxv_trans_csr (p_trans_num IN OKL_POOL_CONTENTS_V.transaction_number_in%TYPE) IS

895: l_dummy VARCHAR2(1) := '?';
896: l_row_not_found BOOLEAN := FALSE;
897:
898: -- Cursor For OKL_CURRENCIES;
899: CURSOR okl_poxv_trans_csr (p_trans_num IN OKL_POOL_CONTENTS_V.transaction_number_in%TYPE) IS
900: SELECT '1'
901: FROM OKL_POOL_TRANSACTIONS_V
902: WHERE OKL_POOL_TRANSACTIONS_V.transaction_number = p_trans_num;
903:

Line 947: CURSOR okl_poxv_trans_csr (p_trans_num IN OKL_POOL_CONTENTS_V.transaction_number_out%TYPE) IS

943: l_dummy VARCHAR2(1) := '?';
944: l_row_not_found BOOLEAN := FALSE;
945:
946: -- Cursor For OKL_CURRENCIES;
947: CURSOR okl_poxv_trans_csr (p_trans_num IN OKL_POOL_CONTENTS_V.transaction_number_out%TYPE) IS
948: SELECT '1'
949: FROM OKL_POOL_TRANSACTIONS_V
950: WHERE OKL_POOL_TRANSACTIONS_V.transaction_number = p_trans_num;
951:

Line 987: -- Validate_Attributes for:OKL_POOL_CONTENTS_V --

983: ---------------------------------------------------------------------------
984: -- FUNCTION Validate_Attributes
985: ---------------------------------------------------------------------------
986: ---------------------------------------------------
987: -- Validate_Attributes for:OKL_POOL_CONTENTS_V --
988: ---------------------------------------------------
989: FUNCTION Validate_Attributes (
990: p_pocv_rec IN pocv_rec_type
991: ) RETURN VARCHAR2 IS

Line 1115: -- Validate Record for:OKL_POOL_CONTENTS_V --

1111: ---------------------------------------------------------------------------
1112: -- PROCEDURE Validate_Record
1113: ---------------------------------------------------------------------------
1114: -----------------------------------------
1115: -- Validate Record for:OKL_POOL_CONTENTS_V --
1116: -----------------------------------------
1117: FUNCTION Validate_Record (
1118: p_pocv_rec IN pocv_rec_type,
1119: p_db_pocv_rec IN pocv_rec_type

Line 1255: -- validate_row for:OKL_POOL_CONTENTS_V --

1251: ---------------------------------------------------------------------------
1252: -- PROCEDURE validate_row
1253: ---------------------------------------------------------------------------
1254: --------------------------------------------
1255: -- validate_row for:OKL_POOL_CONTENTS_V --
1256: --------------------------------------------
1257: PROCEDURE validate_row(
1258: p_api_version IN NUMBER,
1259: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1332: -- PL/SQL TBL validate_row for:OKL_POOL_CONTENTS_V --

1328: '_PVT'
1329: );
1330: END validate_row;
1331: -------------------------------------------------------
1332: -- PL/SQL TBL validate_row for:OKL_POOL_CONTENTS_V --
1333: -------------------------------------------------------
1334: PROCEDURE validate_row(
1335: p_api_version IN NUMBER,
1336: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1428: -- PL/SQL TBL validate_row for:OKL_POOL_CONTENTS_V --

1424: );
1425: END validate_row;
1426:
1427: -------------------------------------------------------
1428: -- PL/SQL TBL validate_row for:OKL_POOL_CONTENTS_V --
1429: -------------------------------------------------------
1430: PROCEDURE validate_row(
1431: p_api_version IN NUMBER,
1432: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1493: -- insert_row for:okl_pool_contents --

1489: ---------------------------------------------------------------------------
1490: -- PROCEDURE insert_row
1491: ---------------------------------------------------------------------------
1492: ----------------------------------------
1493: -- insert_row for:okl_pool_contents --
1494: ----------------------------------------
1495: PROCEDURE insert_row(
1496: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1497: x_return_status OUT NOCOPY VARCHAR2,

Line 1509: -- Set_Attributes for:okl_pool_contents --

1505: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1506: l_poc_rec poc_rec_type := p_poc_rec;
1507: l_def_poc_rec poc_rec_type;
1508: --------------------------------------------
1509: -- Set_Attributes for:okl_pool_contents --
1510: --------------------------------------------
1511: FUNCTION Set_Attributes (
1512: p_poc_rec IN poc_rec_type,
1513: x_poc_rec OUT NOCOPY poc_rec_type

Line 1540: INSERT INTO okl_pool_contents(

1536: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1537: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1538: RAISE OKL_API.G_EXCEPTION_ERROR;
1539: END IF;
1540: INSERT INTO okl_pool_contents(
1541: ID,
1542: OBJECT_VERSION_NUMBER,
1543: POL_ID,
1544: KHR_ID,

Line 1659: -- insert_row for :OKL_POOL_CONTENTS_V --

1655: '_PVT'
1656: );
1657: END insert_row;
1658: -------------------------------------------
1659: -- insert_row for :OKL_POOL_CONTENTS_V --
1660: -------------------------------------------
1661: PROCEDURE insert_row(
1662: p_api_version IN NUMBER,
1663: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1693: -- Set_Attributes for:OKL_POOL_CONTENTS_V --

1689: l_pocv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1690: RETURN(l_pocv_rec);
1691: END fill_who_columns;
1692: ----------------------------------------------
1693: -- Set_Attributes for:OKL_POOL_CONTENTS_V --
1694: ----------------------------------------------
1695: FUNCTION Set_Attributes (
1696: p_pocv_rec IN pocv_rec_type,
1697: x_pocv_rec OUT NOCOPY pocv_rec_type

Line 1980: -- lock_row for:okl_pool_contents --

1976: ---------------------------------------------------------------------------
1977: -- PROCEDURE lock_row
1978: ---------------------------------------------------------------------------
1979: --------------------------------------
1980: -- lock_row for:okl_pool_contents --
1981: --------------------------------------
1982: PROCEDURE lock_row(
1983: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1984: x_return_status OUT NOCOPY VARCHAR2,

Line 1993: FROM okl_pool_contents

1989: E_Resource_Busy EXCEPTION;
1990: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1991: CURSOR lock_csr (p_poc_rec IN poc_rec_type) IS
1992: SELECT OBJECT_VERSION_NUMBER
1993: FROM okl_pool_contents
1994: WHERE ID = p_poc_rec.id
1995: AND OBJECT_VERSION_NUMBER = p_poc_rec.object_version_number
1996: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1997:

Line 2000: FROM okl_pool_contents

1996: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1997:
1998: CURSOR lchk_csr (p_poc_rec IN poc_rec_type) IS
1999: SELECT OBJECT_VERSION_NUMBER
2000: FROM okl_pool_contents
2001: WHERE ID = p_poc_rec.id;
2002: l_api_version CONSTANT NUMBER := 1;
2003: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2004: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2005: l_object_version_number okl_pool_contents.OBJECT_VERSION_NUMBER%TYPE;

2001: WHERE ID = p_poc_rec.id;
2002: l_api_version CONSTANT NUMBER := 1;
2003: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2004: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2005: l_object_version_number okl_pool_contents.OBJECT_VERSION_NUMBER%TYPE;
2006: lc_object_version_number okl_pool_contents.OBJECT_VERSION_NUMBER%TYPE;
2007: l_row_notfound BOOLEAN := FALSE;
2008: lc_row_notfound BOOLEAN := FALSE;
2009: BEGIN

Line 2006: lc_object_version_number okl_pool_contents.OBJECT_VERSION_NUMBER%TYPE;

2002: l_api_version CONSTANT NUMBER := 1;
2003: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2004: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2005: l_object_version_number okl_pool_contents.OBJECT_VERSION_NUMBER%TYPE;
2006: lc_object_version_number okl_pool_contents.OBJECT_VERSION_NUMBER%TYPE;
2007: l_row_notfound BOOLEAN := FALSE;
2008: lc_row_notfound BOOLEAN := FALSE;
2009: BEGIN
2010: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2087: -- lock_row for: OKL_POOL_CONTENTS_V --

2083: '_PVT'
2084: );
2085: END lock_row;
2086: -----------------------------------------
2087: -- lock_row for: OKL_POOL_CONTENTS_V --
2088: -----------------------------------------
2089: PROCEDURE lock_row(
2090: p_api_version IN NUMBER,
2091: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2327: -- update_row for:okl_pool_contents --

2323: ---------------------------------------------------------------------------
2324: -- PROCEDURE update_row
2325: ---------------------------------------------------------------------------
2326: ----------------------------------------
2327: -- update_row for:okl_pool_contents --
2328: ----------------------------------------
2329: PROCEDURE update_row(
2330: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2331: x_return_status OUT NOCOPY VARCHAR2,

Line 2523: -- Set_Attributes for:okl_pool_contents --

2519: END IF;
2520: RETURN(l_return_status);
2521: END populate_new_record;
2522: --------------------------------------------
2523: -- Set_Attributes for:okl_pool_contents --
2524: --------------------------------------------
2525: FUNCTION Set_Attributes (
2526: p_poc_rec IN poc_rec_type,
2527: x_poc_rec OUT NOCOPY poc_rec_type

Line 2561: UPDATE okl_pool_contents

2557: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2558: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2559: RAISE OKL_API.G_EXCEPTION_ERROR;
2560: END IF;
2561: UPDATE okl_pool_contents
2562: SET OBJECT_VERSION_NUMBER = l_def_poc_rec.object_version_number,
2563: POL_ID = l_def_poc_rec.pol_id,
2564: KHR_ID = l_def_poc_rec.khr_id,
2565: KLE_ID = l_def_poc_rec.kle_id,

Line 2639: -- update_row for:OKL_POOL_CONTENTS_V --

2635: '_PVT'
2636: );
2637: END update_row;
2638: ------------------------------------------
2639: -- update_row for:OKL_POOL_CONTENTS_V --
2640: ------------------------------------------
2641: PROCEDURE update_row(
2642: p_api_version IN NUMBER,
2643: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2851: -- Set_Attributes for:OKL_POOL_CONTENTS_V --

2847: END IF;
2848: RETURN(l_return_status);
2849: END populate_new_record;
2850: ----------------------------------------------
2851: -- Set_Attributes for:OKL_POOL_CONTENTS_V --
2852: ----------------------------------------------
2853: FUNCTION Set_Attributes (
2854: p_pocv_rec IN pocv_rec_type,
2855: x_pocv_rec OUT NOCOPY pocv_rec_type

Line 3146: -- delete_row for:okl_pool_contents --

3142: ---------------------------------------------------------------------------
3143: -- PROCEDURE delete_row
3144: ---------------------------------------------------------------------------
3145: ----------------------------------------
3146: -- delete_row for:okl_pool_contents --
3147: ----------------------------------------
3148: PROCEDURE delete_row(
3149: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3150: x_return_status OUT NOCOPY VARCHAR2,

Line 3171: DELETE FROM okl_pool_contents

3167: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3168: RAISE OKL_API.G_EXCEPTION_ERROR;
3169: END IF;
3170:
3171: DELETE FROM okl_pool_contents
3172: WHERE ID = p_poc_rec.id;
3173:
3174: x_return_status := l_return_status;
3175: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3209: -- delete_row for:OKL_POOL_CONTENTS_V --

3205: '_PVT'
3206: );
3207: END delete_row;
3208: ------------------------------------------
3209: -- delete_row for:OKL_POOL_CONTENTS_V --
3210: ------------------------------------------
3211: PROCEDURE delete_row(
3212: p_api_version IN NUMBER,
3213: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3291: -- PL/SQL TBL delete_row for:OKL_POOL_CONTENTS_V --

3287: '_PVT'
3288: );
3289: END delete_row;
3290: -----------------------------------------------------
3291: -- PL/SQL TBL delete_row for:OKL_POOL_CONTENTS_V --
3292: -----------------------------------------------------
3293: PROCEDURE delete_row(
3294: p_api_version IN NUMBER,
3295: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3387: -- PL/SQL TBL delete_row for:OKL_POOL_CONTENTS_V --

3383: );
3384: END delete_row;
3385:
3386: -----------------------------------------------------
3387: -- PL/SQL TBL delete_row for:OKL_POOL_CONTENTS_V --
3388: -----------------------------------------------------
3389: PROCEDURE delete_row(
3390: p_api_version IN NUMBER,
3391: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,