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.CSP_SHIP_TO_ADDRESS_PVT dependencies on DUAL

Line 269: select userenv('LANG') into l_language from dual;

265: SAVEPOINT do_create_ship_to_location_PUB;
266:
267: -- Initialize
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
269: select userenv('LANG') into l_language from dual;
270:
271: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
272: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
273: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.do_create_ship_to_location',

Line 278: select csp_location_id_s1.NEXTVAL into l_location_code from dual;

274: 'l_language = ' || l_language);
275: end if;
276:
277: -- Assign location code
278: select csp_location_id_s1.NEXTVAL into l_location_code from dual;
279: l_location_code := 'CSP' || l_location_code;
280:
281: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
282: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 929: select userenv('LANG') into l_language from dual;

925: SAVEPOINT do_update_ship_to_location_PUB;
926:
927: -- initialize
928: x_return_status := FND_API.G_RET_STS_SUCCESS;
929: select userenv('LANG') into l_language from dual;
930:
931: /* OPEN l_inv_location_csr;
932: FETCH l_inv_location_csr INTO
933: l_location_code,

Line 3051: select hz_parties_s.nextval from dual;

3047: -- select 'select '||select_id||' select_id, '||select_name||' select_name '|| 'from '||from_table sql_str, where_clause
3048: -- from jtf_objects_vl where object_code = l_resource_type;
3049:
3050: CURSOR l_party_number_csr IS
3051: select hz_parties_s.nextval from dual;
3052:
3053: CURSOR l_customer_number_csr IS
3054: select hz_cust_accounts_s.nextval from dual;
3055:

Line 3054: select hz_cust_accounts_s.nextval from dual;

3050: CURSOR l_party_number_csr IS
3051: select hz_parties_s.nextval from dual;
3052:
3053: CURSOR l_customer_number_csr IS
3054: select hz_cust_accounts_s.nextval from dual;
3055:
3056: CURSOR l_party_site_number_csr IS
3057: select hz_party_sites_s.nextval from dual;
3058:

Line 3057: select hz_party_sites_s.nextval from dual;

3053: CURSOR l_customer_number_csr IS
3054: select hz_cust_accounts_s.nextval from dual;
3055:
3056: CURSOR l_party_site_number_csr IS
3057: select hz_party_sites_s.nextval from dual;
3058:
3059: CURSOR l_po_loc_association_csr IS
3060: select p.customer_id,
3061: p.address_id,

Line 3158: select userenv('LANG') into s_language from dual;

3154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3155: END IF;
3156:
3157: x_return_status := FND_API.G_RET_STS_SUCCESS;
3158: select userenv('LANG') into s_language from dual;
3159: csp_ship_to_address_pvt.g_rs_cust_relation_id := null;
3160: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','B',x_return_status);
3161:
3162: -- If task assignment id and addresses are both null, return error.

Line 4149: FROM DUAL;

4145:
4146: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
4147: SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
4148: INTO l_org_id
4149: FROM DUAL;
4150:
4151: mo_global.set_policy_context('S', l_org_id);
4152:
4153: -- create sites

Line 4810: FROM dual;

4806: end if;
4807:
4808: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
4809: INTO l_org_id
4810: FROM dual;
4811:
4812: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4813: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4814: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',

Line 5010: FROM dual;

5006: end if;
5007:
5008: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
5009: INTO l_org_id
5010: FROM dual;
5011:
5012: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5013: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
5014: 'csp.plsql.CSP_SHIP_TO_ADDRESS_PVT.site_to_invloc_linkage',

Line 5329: FROM DUAL;*/

5325: /*
5326: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
5327: SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
5328: INTO l_org_id
5329: FROM DUAL;*/
5330: l_org_id := mo_global.get_current_org_id;
5331:
5332: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
5333: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,