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_RCT_PVT dependencies on OKL_TRX_CSH_RECEIPT_B

Line 102: -- FUNCTION get_rec for: OKL_TRX_CSH_RECEIPT_B

98:
99: END add_language;
100:
101: ---------------------------------------------------------------------------
102: -- FUNCTION get_rec for: OKL_TRX_CSH_RECEIPT_B
103: ---------------------------------------------------------------------------
104: ---------------------------------------------------------------------------
105: -- Start of comments
106: --

Line 108: -- Description : To get the record from the Okl_Trx_Csh_Receipt_B table.

104: ---------------------------------------------------------------------------
105: -- Start of comments
106: --
107: -- Function Name : get_rec
108: -- Description : To get the record from the Okl_Trx_Csh_Receipt_B table.
109: -- Business Rules :
110: -- Parameters : p_rct_rec, x_no_data_found
111: -- Version : 1.0
112: -- History : 25-AUG-04 abindal modified to include the new column

Line 169: FROM Okl_Trx_Csh_Receipt_B

165: RECEIPT_TYPE,
166: CASH_RECEIPT_ID,
167: FULLY_APPLIED_FLAG,
168: EXPIRED_FLAG
169: FROM Okl_Trx_Csh_Receipt_B
170: WHERE okl_trx_csh_receipt_b.id = p_id;
171: l_rct_pk rct_pk_csr%ROWTYPE;
172: l_rct_rec rct_rec_type;
173: BEGIN

Line 170: WHERE okl_trx_csh_receipt_b.id = p_id;

166: CASH_RECEIPT_ID,
167: FULLY_APPLIED_FLAG,
168: EXPIRED_FLAG
169: FROM Okl_Trx_Csh_Receipt_B
170: WHERE okl_trx_csh_receipt_b.id = p_id;
171: l_rct_pk rct_pk_csr%ROWTYPE;
172: l_rct_rec rct_rec_type;
173: BEGIN
174: x_no_data_found := TRUE;

Line 296: -- Description : To get the record from the Okl_Trx_Csh_Receipt_B table.

292: ---------------------------------------------------------------------------
293: -- Start of comments
294: --
295: -- Function Name : get_rec
296: -- Description : To get the record from the Okl_Trx_Csh_Receipt_B table.
297: -- Business Rules :
298: -- Parameters : p_rctv_rec, x_no_data_found
299: -- Version : 1.0
300: -- History : 25-AUG-04 abindal modified to include the new column

Line 1049: FROM okl_trx_csh_receipt_b

1045: /*FUNCTION IS_UNIQUE (p_rctv_rec rctv_rec_type) RETURN VARCHAR2
1046: IS
1047: CURSOR l_chr_csr IS
1048: SELECT 'x'
1049: FROM okl_trx_csh_receipt_b
1050: WHERE check_number = p_rctv_rec.check_number
1051: AND ile_id = p_rctv_rec.ile_id
1052: AND id <> NVL(p_rctv_rec.id,-99999);
1053:

Line 1562: -- insert_row for:OKL_TRX_CSH_RECEIPT_B --

1558: ---------------------------------------------------------------------------
1559: -- PROCEDURE insert_row
1560: ---------------------------------------------------------------------------
1561: ------------------------------------------
1562: -- insert_row for:OKL_TRX_CSH_RECEIPT_B --
1563: ------------------------------------------
1564: ---------------------------------------------------------------------------
1565: -- Start of comments
1566: --

Line 1568: -- Description : Inserts the row in the table OKL_TRX_CSH_RECEIPT_B

1564: ---------------------------------------------------------------------------
1565: -- Start of comments
1566: --
1567: -- Procedure Name : insert_row
1568: -- Description : Inserts the row in the table OKL_TRX_CSH_RECEIPT_B
1569: -- Business Rules :
1570: -- Parameters : p_init_msg_list, x_return_status, x_msg_count, x_msg_data,
1571: -- p_rct_rec, x_rct_rec
1572: -- Version : 1.0

Line 1592: -- Set_Attributes for:OKL_TRX_CSH_RECEIPT_B --

1588: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1589: l_rct_rec rct_rec_type := p_rct_rec;
1590: l_def_rct_rec rct_rec_type;
1591: ----------------------------------------------
1592: -- Set_Attributes for:OKL_TRX_CSH_RECEIPT_B --
1593: ----------------------------------------------
1594:
1595: FUNCTION Set_Attributes (
1596: p_rct_rec IN rct_rec_type,

Line 1624: INSERT INTO OKL_TRX_CSH_RECEIPT_B(

1620: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1621: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1622: RAISE Okl_Api.G_EXCEPTION_ERROR;
1623: END IF;
1624: INSERT INTO OKL_TRX_CSH_RECEIPT_B(
1625: id,
1626: currency_code,
1627: exchange_rate_type,
1628: exchange_rate_date,

Line 2127: -- lock_row for:OKL_TRX_CSH_RECEIPT_B --

2123: ---------------------------------------------------------------------------
2124: -- PROCEDURE lock_row
2125: ---------------------------------------------------------------------------
2126: ----------------------------------------
2127: -- lock_row for:OKL_TRX_CSH_RECEIPT_B --
2128: ----------------------------------------
2129: PROCEDURE lock_row(
2130: p_init_msg_list IN VARCHAR2,
2131: x_return_status OUT NOCOPY VARCHAR2,

Line 2140: FROM OKL_TRX_CSH_RECEIPT_B

2136: E_Resource_Busy EXCEPTION;
2137: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2138: CURSOR lock_csr (p_rct_rec IN rct_rec_type) IS
2139: SELECT OBJECT_VERSION_NUMBER
2140: FROM OKL_TRX_CSH_RECEIPT_B
2141: WHERE ID = p_rct_rec.id
2142: AND OBJECT_VERSION_NUMBER = p_rct_rec.object_version_number
2143: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2144:

Line 2147: FROM OKL_TRX_CSH_RECEIPT_B

2143: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2144:
2145: CURSOR lchk_csr (p_rct_rec IN rct_rec_type) IS
2146: SELECT OBJECT_VERSION_NUMBER
2147: FROM OKL_TRX_CSH_RECEIPT_B
2148: WHERE ID = p_rct_rec.id;
2149: l_api_version CONSTANT NUMBER := 1;
2150: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2151: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2152: l_object_version_number OKL_TRX_CSH_RECEIPT_B.OBJECT_VERSION_NUMBER%TYPE;

2148: WHERE ID = p_rct_rec.id;
2149: l_api_version CONSTANT NUMBER := 1;
2150: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2151: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2152: l_object_version_number OKL_TRX_CSH_RECEIPT_B.OBJECT_VERSION_NUMBER%TYPE;
2153: lc_object_version_number OKL_TRX_CSH_RECEIPT_B.OBJECT_VERSION_NUMBER%TYPE;
2154: l_row_notfound BOOLEAN := FALSE;
2155: lc_row_notfound BOOLEAN := FALSE;
2156: BEGIN

Line 2153: lc_object_version_number OKL_TRX_CSH_RECEIPT_B.OBJECT_VERSION_NUMBER%TYPE;

2149: l_api_version CONSTANT NUMBER := 1;
2150: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2151: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2152: l_object_version_number OKL_TRX_CSH_RECEIPT_B.OBJECT_VERSION_NUMBER%TYPE;
2153: lc_object_version_number OKL_TRX_CSH_RECEIPT_B.OBJECT_VERSION_NUMBER%TYPE;
2154: l_row_notfound BOOLEAN := FALSE;
2155: lc_row_notfound BOOLEAN := FALSE;
2156: BEGIN
2157: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 2500: -- update_row for:OKL_TRX_CSH_RECEIPT_B --

2496: ---------------------------------------------------------------------------
2497: -- PROCEDURE update_row
2498: ---------------------------------------------------------------------------
2499: ------------------------------------------
2500: -- update_row for:OKL_TRX_CSH_RECEIPT_B --
2501: ------------------------------------------
2502: ---------------------------------------------------------------------------
2503: -- Start of comments
2504: --

Line 2506: -- Description : Updates the row in the table OKL_TRX_CSH_RECEIPT_B

2502: ---------------------------------------------------------------------------
2503: -- Start of comments
2504: --
2505: -- Procedure Name : update_row
2506: -- Description : Updates the row in the table OKL_TRX_CSH_RECEIPT_B
2507: -- Business Rules :
2508: -- Parameters : p_init_msg_list, x_return_status, x_msg_count, x_msg_data,
2509: -- p_rct_rec, x_rct_rec
2510: -- Version : 1.0

Line 2733: -- Set_Attributes for:OKL_TRX_CSH_RECEIPT_B --

2729:
2730: RETURN(l_return_status);
2731: END populate_new_record;
2732: ----------------------------------------------
2733: -- Set_Attributes for:OKL_TRX_CSH_RECEIPT_B --
2734: ----------------------------------------------
2735:
2736: FUNCTION Set_Attributes (
2737: p_rct_rec IN rct_rec_type,

Line 2771: UPDATE OKL_TRX_CSH_RECEIPT_B

2767: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2768: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2769: RAISE Okl_Api.G_EXCEPTION_ERROR;
2770: END IF;
2771: UPDATE OKL_TRX_CSH_RECEIPT_B
2772: SET CURRENCY_CODE = l_def_rct_rec.currency_code,
2773: EXCHANGE_RATE_TYPE = l_def_rct_rec.exchange_rate_type,
2774: EXCHANGE_RATE_DATE = l_def_rct_rec.exchange_rate_date,
2775: EXCHANGE_RATE = l_def_rct_rec.exchange_rate,

Line 3026: -- Description : Updates the row in the table OKL_TRX_CSH_RECEIPT_B

3022: ---------------------------------------------------------------------------
3023: -- Start of comments
3024: --
3025: -- Procedure Name : update_row
3026: -- Description : Updates the row in the table OKL_TRX_CSH_RECEIPT_B
3027: -- Business Rules :
3028: -- Parameters : p_init_msg_list, x_return_status, x_msg_count, x_msg_data,
3029: -- p_rctv_rec, x_rctv_rec
3030: -- Version : 1.0

Line 3497: -- delete_row for:OKL_TRX_CSH_RECEIPT_B --

3493: ---------------------------------------------------------------------------
3494: -- PROCEDURE delete_row
3495: ---------------------------------------------------------------------------
3496: ------------------------------------------
3497: -- delete_row for:OKL_TRX_CSH_RECEIPT_B --
3498: ------------------------------------------
3499: PROCEDURE delete_row(
3500: p_init_msg_list IN VARCHAR2,
3501: x_return_status OUT NOCOPY VARCHAR2,

Line 3521: DELETE FROM OKL_TRX_CSH_RECEIPT_B

3517: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3518: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3519: RAISE Okl_Api.G_EXCEPTION_ERROR;
3520: END IF;
3521: DELETE FROM OKL_TRX_CSH_RECEIPT_B
3522: WHERE ID = l_rct_rec.id;
3523:
3524: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3525: EXCEPTION