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_RCA_PVT dependencies on OKL_TXL_RCPT_APPS_B

Line 102: -- FUNCTION get_rec for: OKL_TXL_RCPT_APPS_B

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

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

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

Line 163: FROM Okl_Txl_Rcpt_Apps_B

159: -- sty_id is stream type id of selected stream.
160: STY_ID,
161: -- ar_invoice_id column added
162: AR_INVOICE_ID
163: FROM Okl_Txl_Rcpt_Apps_B
164: WHERE okl_txl_rcpt_apps_b.id = p_id;
165: l_rca_pk rca_pk_csr%ROWTYPE;
166: l_rca_rec rca_rec_type;
167: BEGIN

Line 164: WHERE okl_txl_rcpt_apps_b.id = p_id;

160: STY_ID,
161: -- ar_invoice_id column added
162: AR_INVOICE_ID
163: FROM Okl_Txl_Rcpt_Apps_B
164: WHERE okl_txl_rcpt_apps_b.id = p_id;
165: l_rca_pk rca_pk_csr%ROWTYPE;
166: l_rca_rec rca_rec_type;
167: BEGIN
168: x_no_data_found := TRUE;

Line 283: -- Description : To get the record from the Okl_Txl_Rcpt_Apps_B table.

279: ---------------------------------------------------------------------------
280: -- Start of comments
281: --
282: -- Function Name : get_rec
283: -- Description : To get the record from the Okl_Txl_Rcpt_Apps_B table.
284: -- Business Rules :
285: -- Parameters : p_rcav_rec, x_no_data_found
286: -- Version : 1.0
287: -- History : 25-AUG-04 abindal modified to include the new column

Line 1604: -- insert_row for:OKL_TXL_RCPT_APPS_B --

1600: ---------------------------------------------------------------------------
1601: -- PROCEDURE insert_row
1602: ---------------------------------------------------------------------------
1603: ----------------------------------------
1604: -- insert_row for:OKL_TXL_RCPT_APPS_B --
1605: ----------------------------------------
1606: ---------------------------------------------------------------------------
1607: -- Start of comments
1608: --

Line 1610: -- Description : Inserts the row in the table OKL_TXL_RCPT_APPS_B.

1606: ---------------------------------------------------------------------------
1607: -- Start of comments
1608: --
1609: -- Procedure Name : insert_row
1610: -- Description : Inserts the row in the table OKL_TXL_RCPT_APPS_B.
1611: -- Business Rules :
1612: -- Parameters : p_init_msg_list, x_return_status, x_msg_count, x_msg_data,
1613: -- p_rca_rec, x_rca_rec
1614: -- Version : 1.0

Line 1633: -- Set_Attributes for:OKL_TXL_RCPT_APPS_B --

1629: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1630: l_rca_rec rca_rec_type := p_rca_rec;
1631: l_def_rca_rec rca_rec_type;
1632: --------------------------------------------
1633: -- Set_Attributes for:OKL_TXL_RCPT_APPS_B --
1634: --------------------------------------------
1635:
1636: FUNCTION Set_Attributes (
1637: p_rca_rec IN rca_rec_type,

Line 1668: INSERT INTO OKL_TXL_RCPT_APPS_B(

1664: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1665: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1666: RAISE Okl_Api.G_EXCEPTION_ERROR;
1667: END IF;
1668: INSERT INTO OKL_TXL_RCPT_APPS_B(
1669: id,
1670: rct_id_details,
1671: cnr_id,
1672: khr_id,

Line 2154: -- lock_row for:OKL_TXL_RCPT_APPS_B --

2150: ---------------------------------------------------------------------------
2151: -- PROCEDURE lock_row
2152: ---------------------------------------------------------------------------
2153: --------------------------------------
2154: -- lock_row for:OKL_TXL_RCPT_APPS_B --
2155: --------------------------------------
2156: PROCEDURE lock_row(
2157: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
2158: x_return_status OUT NOCOPY VARCHAR2,

Line 2167: FROM OKL_TXL_RCPT_APPS_B

2163: E_Resource_Busy EXCEPTION;
2164: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2165: CURSOR lock_csr (p_rca_rec IN rca_rec_type) IS
2166: SELECT OBJECT_VERSION_NUMBER
2167: FROM OKL_TXL_RCPT_APPS_B
2168: WHERE ID = p_rca_rec.id
2169: AND OBJECT_VERSION_NUMBER = p_rca_rec.object_version_number
2170: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2171:

Line 2174: FROM OKL_TXL_RCPT_APPS_B

2170: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2171:
2172: CURSOR lchk_csr (p_rca_rec IN rca_rec_type) IS
2173: SELECT OBJECT_VERSION_NUMBER
2174: FROM OKL_TXL_RCPT_APPS_B
2175: WHERE ID = p_rca_rec.id;
2176: l_api_version CONSTANT NUMBER := 1;
2177: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2178: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 2179: l_object_version_number OKL_TXL_RCPT_APPS_B.OBJECT_VERSION_NUMBER%TYPE;

2175: WHERE ID = p_rca_rec.id;
2176: l_api_version CONSTANT NUMBER := 1;
2177: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2178: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2179: l_object_version_number OKL_TXL_RCPT_APPS_B.OBJECT_VERSION_NUMBER%TYPE;
2180: lc_object_version_number OKL_TXL_RCPT_APPS_B.OBJECT_VERSION_NUMBER%TYPE;
2181: l_row_notfound BOOLEAN := FALSE;
2182: lc_row_notfound BOOLEAN := FALSE;
2183: BEGIN

Line 2180: lc_object_version_number OKL_TXL_RCPT_APPS_B.OBJECT_VERSION_NUMBER%TYPE;

2176: l_api_version CONSTANT NUMBER := 1;
2177: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2178: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2179: l_object_version_number OKL_TXL_RCPT_APPS_B.OBJECT_VERSION_NUMBER%TYPE;
2180: lc_object_version_number OKL_TXL_RCPT_APPS_B.OBJECT_VERSION_NUMBER%TYPE;
2181: l_row_notfound BOOLEAN := FALSE;
2182: lc_row_notfound BOOLEAN := FALSE;
2183: BEGIN
2184: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 2528: -- update_row for:OKL_TXL_RCPT_APPS_B --

2524: ---------------------------------------------------------------------------
2525: -- PROCEDURE update_row
2526: ---------------------------------------------------------------------------
2527: ----------------------------------------
2528: -- update_row for:OKL_TXL_RCPT_APPS_B --
2529: ----------------------------------------
2530: ---------------------------------------------------------------------------
2531: -- Start of comments
2532: --

Line 2534: -- Description : Updates the row in the table OKL_TXL_RCPT_APPS_B.

2530: ---------------------------------------------------------------------------
2531: -- Start of comments
2532: --
2533: -- Procedure Name : update_row
2534: -- Description : Updates the row in the table OKL_TXL_RCPT_APPS_B.
2535: -- Business Rules :
2536: -- Parameters : p_init_msg_list, x_return_status, x_msg_count, x_msg_data,
2537: -- p_rca_rec, x_rca_rec
2538: -- Version : 1.0

Line 2732: -- Set_Attributes for:OKL_TXL_RCPT_APPS_B --

2728:
2729: RETURN(l_return_status);
2730: END populate_new_record;
2731: --------------------------------------------
2732: -- Set_Attributes for:OKL_TXL_RCPT_APPS_B --
2733: --------------------------------------------
2734:
2735: FUNCTION Set_Attributes (
2736: p_rca_rec IN rca_rec_type,

Line 2770: UPDATE OKL_TXL_RCPT_APPS_B

2766: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2767: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2768: RAISE Okl_Api.G_EXCEPTION_ERROR;
2769: END IF;
2770: UPDATE OKL_TXL_RCPT_APPS_B
2771: SET RCT_ID_DETAILS = l_def_rca_rec.rct_id_details,
2772: CNR_ID = l_def_rca_rec.cnr_id,
2773: KHR_ID = l_def_rca_rec.khr_id,
2774: LLN_ID = l_def_rca_rec.lln_id,

Line 3018: -- Description : Updates the row in the table OKL_TXL_RCPT_APPS_B.

3014: ---------------------------------------------------------------------------
3015: -- Start of comments
3016: --
3017: -- Procedure Name : update_row
3018: -- Description : Updates the row in the table OKL_TXL_RCPT_APPS_B.
3019: -- Business Rules :
3020: -- Parameters : p_init_msg_list, x_return_status, x_msg_count, x_msg_data,
3021: -- p_rcav_rec, x_rcav_rec
3022: -- Version : 1.0

Line 3473: -- delete_row for:OKL_TXL_RCPT_APPS_B --

3469: ---------------------------------------------------------------------------
3470: -- PROCEDURE delete_row
3471: ---------------------------------------------------------------------------
3472: ----------------------------------------
3473: -- delete_row for:OKL_TXL_RCPT_APPS_B --
3474: ----------------------------------------
3475: PROCEDURE delete_row(
3476: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
3477: x_return_status OUT NOCOPY VARCHAR2,

Line 3497: DELETE FROM OKL_TXL_RCPT_APPS_B

3493: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3494: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3495: RAISE Okl_Api.G_EXCEPTION_ERROR;
3496: END IF;
3497: DELETE FROM OKL_TXL_RCPT_APPS_B
3498: WHERE ID = l_rca_rec.id;
3499:
3500: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3501: EXCEPTION

Line 3858: arp_message.set_token('TABLE_NAME','OKL_TXL_RCPT_APPS_B',FALSE);

3854:
3855: if p_from_fk_id <> p_to_fk_id then
3856: begin
3857: arp_message.set_name('AR','AR_UPDATING_TABLE');
3858: arp_message.set_token('TABLE_NAME','OKL_TXL_RCPT_APPS_B',FALSE);
3859: --
3860: --
3861: UPDATE OKL_TXL_RCPT_APPS_B RCAB
3862: SET RCAB.ILE_ID = p_to_fk_id

Line 3861: UPDATE OKL_TXL_RCPT_APPS_B RCAB

3857: arp_message.set_name('AR','AR_UPDATING_TABLE');
3858: arp_message.set_token('TABLE_NAME','OKL_TXL_RCPT_APPS_B',FALSE);
3859: --
3860: --
3861: UPDATE OKL_TXL_RCPT_APPS_B RCAB
3862: SET RCAB.ILE_ID = p_to_fk_id
3863: ,RCAB.object_version_number = RCAB.object_version_number + 1
3864: ,RCAB.last_update_date = SYSDATE
3865: ,RCAB.last_updated_by = arp_standard.profile.user_id

Line 3878: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));

3874: when others then
3875: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
3876: --
3877: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
3878: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
3879: --
3880: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
3881: x_return_status := FND_API.G_RET_STS_ERROR;
3882: end;