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

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

1615: exception
1616: when others then
1617: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1618: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1619: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
1620: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1621: x_return_status := FND_API.G_RET_STS_ERROR;
1622: END OKL_RCA_PARTY_MERGE;
1623:

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

2252: exception
2253: when others then
2254: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2255: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2256: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
2257: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2258: x_return_status := FND_API.G_RET_STS_ERROR;
2259: end;
2260: end if;

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

2362: exception
2363: when others then
2364: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2365: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2366: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
2367: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2368: x_return_status := FND_API.G_RET_STS_ERROR;
2369: end;
2370: end if;

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

2471: exception
2472: when others then
2473: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2474: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2475: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
2476: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2477: x_return_status := FND_API.G_RET_STS_ERROR;
2478: end;
2479: end if;

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

2571: exception
2572: when others then
2573: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2574: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2575: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
2576: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2577: x_return_status := FND_API.G_RET_STS_ERROR;
2578: end;
2579: end if;

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

2667: exception
2668: when others then
2669: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2670: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2671: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
2672: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2673: x_return_status := FND_API.G_RET_STS_ERROR;
2674: end;
2675: end if;

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

2763: exception
2764: when others then
2765: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2766: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2767: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
2768: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2769: x_return_status := FND_API.G_RET_STS_ERROR;
2770: end;
2771: end if;

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

2858: exception
2859: when others then
2860: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2861: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2862: 'OKL_TXL_RCPT_APPS_B for = '|| p_from_id));
2863: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2864: x_return_status := FND_API.G_RET_STS_ERROR;
2865: end;
2866: end if;

Line 5093: | Account merge procedure for the table, OKL_TXL_RCPT_APPS_B

5089: /*-------------------------------------------------------------
5090: | PROCEDURE
5091: | RCA_ACCOUNT_MERGE
5092: | DESCRIPTION :
5093: | Account merge procedure for the table, OKL_TXL_RCPT_APPS_B
5094: |
5095: | NOTES:
5096: |--------------------------------------------------------------*/
5097: PROCEDURE RCA_ACCOUNT_MERGE (

Line 5108: OKL_TXL_RCPT_APPS_B.ID%TYPE

5104: INDEX BY BINARY_INTEGER;
5105: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
5106:
5107: TYPE ID_LIST_TYPE IS TABLE OF
5108: OKL_TXL_RCPT_APPS_B.ID%TYPE
5109: INDEX BY BINARY_INTEGER;
5110: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
5111:
5112: TYPE ILE_ID_LIST_TYPE IS TABLE OF

Line 5113: OKL_TXL_RCPT_APPS_B.ILE_ID%TYPE

5109: INDEX BY BINARY_INTEGER;
5110: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
5111:
5112: TYPE ILE_ID_LIST_TYPE IS TABLE OF
5113: OKL_TXL_RCPT_APPS_B.ILE_ID%TYPE
5114: INDEX BY BINARY_INTEGER;
5115: NUM_COL1_ORIG_LIST ILE_ID_LIST_TYPE;
5116: NUM_COL1_NEW_LIST ILE_ID_LIST_TYPE;
5117:

Line 5123: FROM OKL_TXL_RCPT_APPS_B yt, ra_customer_merges m

5119: CURSOR merged_records IS
5120: SELECT distinct CUSTOMER_MERGE_HEADER_ID
5121: ,ID
5122: ,ILE_ID
5123: FROM OKL_TXL_RCPT_APPS_B yt, ra_customer_merges m
5124: WHERE (
5125: yt.ILE_ID = m.DUPLICATE_ID
5126: ) AND m.process_flag = 'N'
5127: AND m.request_id = req_id

Line 5137: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_TXL_RCPT_APPS_B',FALSE);

5133: IF process_mode='LOCK' THEN
5134: NULL;
5135: ELSE
5136: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
5137: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_TXL_RCPT_APPS_B',FALSE);
5138: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5139: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5140:
5141: open merged_records;

Line 5174: 'OKL_TXL_RCPT_APPS_B',

5170: LAST_UPDATE_LOGIN,
5171: LAST_UPDATE_DATE,
5172: LAST_UPDATED_BY
5173: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
5174: 'OKL_TXL_RCPT_APPS_B',
5175: MERGE_HEADER_ID_LIST(I),
5176: PRIMARY_KEY_ID_LIST(I),
5177: NUM_COL1_ORIG_LIST(I),
5178: NUM_COL1_NEW_LIST(I),

Line 5190: UPDATE OKL_TXL_RCPT_APPS_B yt SET

5186: );
5187:
5188: END IF;
5189: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5190: UPDATE OKL_TXL_RCPT_APPS_B yt SET
5191: ILE_ID=NUM_COL1_NEW_LIST(I)
5192: , LAST_UPDATE_DATE=SYSDATE
5193: , last_updated_by=arp_standard.profile.user_id
5194: , last_update_login=arp_standard.profile.last_update_login