APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on DUAL

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

255: SAVEPOINT do_create_ship_to_location_PUB;
256:
257: -- Initialize
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259: select userenv('LANG') into l_language from dual;
260:
261: -- Assign location code
262: select csp_location_id_s1.NEXTVAL into l_location_code from dual;
263: l_location_code := 'CSP' || l_location_code;

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

258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259: select userenv('LANG') into l_language from dual;
260:
261: -- Assign location code
262: select csp_location_id_s1.NEXTVAL into l_location_code from dual;
263: l_location_code := 'CSP' || l_location_code;
264:
265: -- Default location description to address 1.
266: --l_description := p_address_line_1;

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

445: SAVEPOINT do_update_ship_to_location_PUB;
446:
447: -- initialize
448: x_return_status := FND_API.G_RET_STS_SUCCESS;
449: select userenv('LANG') into l_language from dual;
450:
451: /* OPEN l_inv_location_csr;
452: FETCH l_inv_location_csr INTO
453: l_location_code,

Line 2543: select hz_parties_s.nextval from dual;

2539: -- select 'select '||select_id||' select_id, '||select_name||' select_name '|| 'from '||from_table sql_str, where_clause
2540: -- from jtf_objects_vl where object_code = l_resource_type;
2541:
2542: CURSOR l_party_number_csr IS
2543: select hz_parties_s.nextval from dual;
2544:
2545: CURSOR l_customer_number_csr IS
2546: select hz_cust_accounts_s.nextval from dual;
2547:

Line 2546: select hz_cust_accounts_s.nextval from dual;

2542: CURSOR l_party_number_csr IS
2543: select hz_parties_s.nextval from dual;
2544:
2545: CURSOR l_customer_number_csr IS
2546: select hz_cust_accounts_s.nextval from dual;
2547:
2548: CURSOR l_party_site_number_csr IS
2549: select hz_party_sites_s.nextval from dual;
2550:

Line 2549: select hz_party_sites_s.nextval from dual;

2545: CURSOR l_customer_number_csr IS
2546: select hz_cust_accounts_s.nextval from dual;
2547:
2548: CURSOR l_party_site_number_csr IS
2549: select hz_party_sites_s.nextval from dual;
2550:
2551: CURSOR l_po_loc_association_csr IS
2552: select p.customer_id,
2553: p.address_id,

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

2609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2610: END IF;
2611:
2612: x_return_status := FND_API.G_RET_STS_SUCCESS;
2613: select userenv('LANG') into s_language from dual;
2614: csp_ship_to_address_pvt.g_rs_cust_relation_id := null;
2615: csp_ship_to_address_pvt.call_internal_hook('CSP_SHIP_TO_ADDRESS_PVT','SHIP_TO_ADDRESS_HANDLER','B',x_return_status);
2616:
2617: -- If task assignment id and addresses are both null, return error.

Line 4464: FROM DUAL;

4460: BEGIN
4461: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
4462: SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
4463: INTO l_org_id
4464: FROM DUAL;
4465: END;
4466:
4467: OPEN site_use_cur;
4468: FETCH site_use_cur INTO l_site_use_id, l_address_id;