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 CSP_REQUIREMENT_HEADERS

Line 2991: t_inv_location_id csp_requirement_headers.ship_to_location_id%TYPE;

2987: t_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE;
2988: t_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE;
2989: -- l_sql_str varchar2(1000);
2990: -- l_where_clause varchar2(500);
2991: t_inv_location_id csp_requirement_headers.ship_to_location_id%TYPE;
2992: l_timezone_id csp_requirement_headers.timezone_id%TYPE;
2993: l_rs_cust_relation_id number;
2994: l_process_type varchar2(30);
2995: l_column_NAME varchar2(30);

Line 2992: l_timezone_id csp_requirement_headers.timezone_id%TYPE;

2988: t_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE;
2989: -- l_sql_str varchar2(1000);
2990: -- l_where_clause varchar2(500);
2991: t_inv_location_id csp_requirement_headers.ship_to_location_id%TYPE;
2992: l_timezone_id csp_requirement_headers.timezone_id%TYPE;
2993: l_rs_cust_relation_id number;
2994: l_process_type varchar2(30);
2995: l_column_NAME varchar2(30);
2996: l_org_id number;

Line 3032: -- select ship_to_location_id from csp_requirement_headers where task_assignment_id = p_task_assignment_id;

3028: CURSOR l_party_id_csr IS
3029: select party_id from hz_cust_accounts where cust_account_id = l_customer_id;
3030:
3031: CURSOR l_requirement_hdr_csr IS
3032: -- select ship_to_location_id from csp_requirement_headers where task_assignment_id = p_task_assignment_id;
3033: select ship_to_location_id,
3034: timezone_id
3035: from csp_requirement_headers
3036: where task_assignment_id = p_task_assignment_id;

Line 3035: from csp_requirement_headers

3031: CURSOR l_requirement_hdr_csr IS
3032: -- select ship_to_location_id from csp_requirement_headers where task_assignment_id = p_task_assignment_id;
3033: select ship_to_location_id,
3034: timezone_id
3035: from csp_requirement_headers
3036: where task_assignment_id = p_task_assignment_id;
3037:
3038: CURSOR l_resource_name_csr IS
3039: select resource_name,

Line 3314: -- Use task_assignment_id to retrieve inventory_location_id from csp_requirement_headers

3310: END IF;
3311:
3312: IF p_task_assignment_id IS NOT NULL THEN
3313: -- IF l_inv_location_id IS NULL THEN
3314: -- Use task_assignment_id to retrieve inventory_location_id from csp_requirement_headers
3315: OPEN l_requirement_hdr_csr;
3316: -- FETCH l_requirement_hdr_csr INTO l_inv_location_id;
3317: FETCH l_requirement_hdr_csr INTO t_inv_location_id, l_timezone_id;
3318: IF l_requirement_hdr_csr%NOTFOUND THEN

Line 5261: --l_party_site_id NUMBER := to_number(Name_In('csp_requirement_headers.party_site_id'));

5257: l_site_use_id NUMBER;
5258: l_address_id NUMBER;
5259: l_api_version_number NUMBER := 1.0;
5260: l_api_name CONSTANT VARCHAR2(30) := 'cust_inv_loc_link';
5261: --l_party_site_id NUMBER := to_number(Name_In('csp_requirement_headers.party_site_id'));
5262: --l_account_id NUMBER := to_number(Name_In('csp_requirement_headers.account_id'));
5263: l_org_id NUMBER;
5264: l_inv_location_id NUMBER;
5265: l_inv_loc NUMBER;

Line 5262: --l_account_id NUMBER := to_number(Name_In('csp_requirement_headers.account_id'));

5258: l_address_id NUMBER;
5259: l_api_version_number NUMBER := 1.0;
5260: l_api_name CONSTANT VARCHAR2(30) := 'cust_inv_loc_link';
5261: --l_party_site_id NUMBER := to_number(Name_In('csp_requirement_headers.party_site_id'));
5262: --l_account_id NUMBER := to_number(Name_In('csp_requirement_headers.account_id'));
5263: l_org_id NUMBER;
5264: l_inv_location_id NUMBER;
5265: l_inv_loc NUMBER;
5266: l_Return_val BOOLEAN := FALSE;