eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_POC_PVT dependencies on OKL_POOL_CONTENTS_V

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 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 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 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 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 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,