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_POX_PVT dependencies on OKL_POOL_TRANSACTIONS_V

Line 104: -- FUNCTION get_rec for: OKL_POOL_TRANSACTIONS_V

100: RETURN(l_newvalue);
101: END get_trans_num;
102:
103: ---------------------------------------------------------------------------
104: -- FUNCTION get_rec for: OKL_POOL_TRANSACTIONS_V
105: ---------------------------------------------------------------------------
106: FUNCTION get_rec (
107: p_poxv_rec IN poxv_rec_type,
108: x_no_data_found OUT NOCOPY BOOLEAN

Line 152: FROM OKL_POOL_TRANSACTIONS_V

148: LAST_UPDATE_DATE,
149: LAST_UPDATE_LOGIN,
150: LEGAL_ENTITY_ID,
151: TRANSACTION_STATUS
152: FROM OKL_POOL_TRANSACTIONS_V
153: WHERE OKL_POOL_TRANSACTIONS_V.id = p_id;
154: l_okl_poxv_pk okl_poxv_pk_csr%ROWTYPE;
155: l_poxv_rec poxv_rec_type;
156: BEGIN

Line 153: WHERE OKL_POOL_TRANSACTIONS_V.id = p_id;

149: LAST_UPDATE_LOGIN,
150: LEGAL_ENTITY_ID,
151: TRANSACTION_STATUS
152: FROM OKL_POOL_TRANSACTIONS_V
153: WHERE OKL_POOL_TRANSACTIONS_V.id = p_id;
154: l_okl_poxv_pk okl_poxv_pk_csr%ROWTYPE;
155: l_poxv_rec poxv_rec_type;
156: BEGIN
157: x_no_data_found := TRUE;

Line 367: -- FUNCTION null_out_defaults for: OKL_POOL_TRANSACTIONS_V

363: RETURN(get_rec(p_pox_rec, l_row_not_found));
364: END get_rec;
365:
366: ---------------------------------------------------------------------------
367: -- FUNCTION null_out_defaults for: OKL_POOL_TRANSACTIONS_V
368: -- mvasudev, hold this off for now
369: ---------------------------------------------------------------------------
370: FUNCTION null_out_defaults (
371: p_poxv_rec IN poxv_rec_type

Line 569: CURSOR okl_polv_pk_csr (p_id IN OKL_POOL_TRANSACTIONS_V.pol_id%TYPE) IS

565: l_dummy VARCHAR2(1) := '?';
566: l_row_not_found BOOLEAN := FALSE;
567:
568: -- Cursor For OKL_POL_POX_FK;
569: CURSOR okl_polv_pk_csr (p_id IN OKL_POOL_TRANSACTIONS_V.pol_id%TYPE) IS
570: SELECT '1'
571: FROM OKL_POOLS
572: WHERE OKL_POOLS.id = p_id;
573:

Line 868: FROM OKL_POOL_TRANSACTIONS_V

864:
865: -- Cursor for Pox Unique Key
866: CURSOR okl_pox_uk_csr(p_poxv_rec IN poxv_rec_type) IS
867: SELECT '1'
868: FROM OKL_POOL_TRANSACTIONS_V
869: WHERE transaction_number = p_poxv_rec.transaction_number
870: AND id <> NVL(p_poxv_rec.id,-9999);
871:
872: BEGIN

Line 912: -- Validate_Attributes for:OKL_POOL_TRANSACTIONS_V --

908: ---------------------------------------------------------------------------
909: -- FUNCTION Validate_Attributes
910: ---------------------------------------------------------------------------
911: ---------------------------------------------------
912: -- Validate_Attributes for:OKL_POOL_TRANSACTIONS_V --
913: ---------------------------------------------------
914: FUNCTION Validate_Attributes (
915: p_poxv_rec IN poxv_rec_type
916: ) RETURN VARCHAR2 IS

Line 1013: -- Validate Record for:OKL_POOL_TRANSACTIONS_V --

1009: ---------------------------------------------------------------------------
1010: -- PROCEDURE Validate_Record
1011: ---------------------------------------------------------------------------
1012: -----------------------------------------
1013: -- Validate Record for:OKL_POOL_TRANSACTIONS_V --
1014: -----------------------------------------
1015: FUNCTION Validate_Record (
1016: p_poxv_rec IN poxv_rec_type,
1017: p_db_poxv_rec IN poxv_rec_type

Line 1155: -- validate_row for:OKL_POOL_TRANSACTIONS_V --

1151: ---------------------------------------------------------------------------
1152: -- PROCEDURE validate_row
1153: ---------------------------------------------------------------------------
1154: --------------------------------------------
1155: -- validate_row for:OKL_POOL_TRANSACTIONS_V --
1156: --------------------------------------------
1157: PROCEDURE validate_row(
1158: p_api_version IN NUMBER,
1159: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1232: -- PL/SQL TBL validate_row for:OKL_POOL_TRANSACTIONS_V --

1228: '_PVT'
1229: );
1230: END validate_row;
1231: -------------------------------------------------------
1232: -- PL/SQL TBL validate_row for:OKL_POOL_TRANSACTIONS_V --
1233: -------------------------------------------------------
1234: PROCEDURE validate_row(
1235: p_api_version IN NUMBER,
1236: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1328: -- PL/SQL TBL validate_row for:OKL_POOL_TRANSACTIONS_V --

1324: );
1325: END validate_row;
1326:
1327: -------------------------------------------------------
1328: -- PL/SQL TBL validate_row for:OKL_POOL_TRANSACTIONS_V --
1329: -------------------------------------------------------
1330: PROCEDURE validate_row(
1331: p_api_version IN NUMBER,
1332: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1559: -- insert_row for :OKL_POOL_TRANSACTIONS_V --

1555: '_PVT'
1556: );
1557: END insert_row;
1558: -------------------------------------------
1559: -- insert_row for :OKL_POOL_TRANSACTIONS_V --
1560: -------------------------------------------
1561: PROCEDURE insert_row(
1562: p_api_version IN NUMBER,
1563: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1593: -- Set_Attributes for:OKL_POOL_TRANSACTIONS_V --

1589: l_poxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1590: RETURN(l_poxv_rec);
1591: END fill_who_columns;
1592: ----------------------------------------------
1593: -- Set_Attributes for:OKL_POOL_TRANSACTIONS_V --
1594: ----------------------------------------------
1595: FUNCTION Set_Attributes (
1596: p_poxv_rec IN poxv_rec_type,
1597: x_poxv_rec OUT NOCOPY poxv_rec_type

Line 1988: -- lock_row for: OKL_POOL_TRANSACTIONS_V --

1984: '_PVT'
1985: );
1986: END lock_row;
1987: -----------------------------------------
1988: -- lock_row for: OKL_POOL_TRANSACTIONS_V --
1989: -----------------------------------------
1990: PROCEDURE lock_row(
1991: p_api_version IN NUMBER,
1992: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2540: -- update_row for:OKL_POOL_TRANSACTIONS_V --

2536: '_PVT'
2537: );
2538: END update_row;
2539: ------------------------------------------
2540: -- update_row for:OKL_POOL_TRANSACTIONS_V --
2541: ------------------------------------------
2542: PROCEDURE update_row(
2543: p_api_version IN NUMBER,
2544: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2752: -- Set_Attributes for:OKL_POOL_TRANSACTIONS_V --

2748: END IF;
2749: RETURN(l_return_status);
2750: END populate_new_record;
2751: ----------------------------------------------
2752: -- Set_Attributes for:OKL_POOL_TRANSACTIONS_V --
2753: ----------------------------------------------
2754: FUNCTION Set_Attributes (
2755: p_poxv_rec IN poxv_rec_type,
2756: x_poxv_rec OUT NOCOPY poxv_rec_type

Line 3110: -- delete_row for:OKL_POOL_TRANSACTIONS_V --

3106: '_PVT'
3107: );
3108: END delete_row;
3109: ------------------------------------------
3110: -- delete_row for:OKL_POOL_TRANSACTIONS_V --
3111: ------------------------------------------
3112: PROCEDURE delete_row(
3113: p_api_version IN NUMBER,
3114: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3192: -- PL/SQL TBL delete_row for:OKL_POOL_TRANSACTIONS_V --

3188: '_PVT'
3189: );
3190: END delete_row;
3191: -----------------------------------------------------
3192: -- PL/SQL TBL delete_row for:OKL_POOL_TRANSACTIONS_V --
3193: -----------------------------------------------------
3194: PROCEDURE delete_row(
3195: p_api_version IN NUMBER,
3196: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3288: -- PL/SQL TBL delete_row for:OKL_POOL_TRANSACTIONS_V --

3284: );
3285: END delete_row;
3286:
3287: -----------------------------------------------------
3288: -- PL/SQL TBL delete_row for:OKL_POOL_TRANSACTIONS_V --
3289: -----------------------------------------------------
3290: PROCEDURE delete_row(
3291: p_api_version IN NUMBER,
3292: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,