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 2485: t_inv_location_id csp_requirement_headers.ship_to_location_id%TYPE;

2481: t_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE;
2482: t_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE;
2483: -- l_sql_str varchar2(1000);
2484: -- l_where_clause varchar2(500);
2485: t_inv_location_id csp_requirement_headers.ship_to_location_id%TYPE;
2486: l_timezone_id csp_requirement_headers.timezone_id%TYPE;
2487: l_rs_cust_relation_id number;
2488: l_process_type varchar2(30);
2489: l_column_NAME varchar2(30);

Line 2486: l_timezone_id csp_requirement_headers.timezone_id%TYPE;

2482: t_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE;
2483: -- l_sql_str varchar2(1000);
2484: -- l_where_clause varchar2(500);
2485: t_inv_location_id csp_requirement_headers.ship_to_location_id%TYPE;
2486: l_timezone_id csp_requirement_headers.timezone_id%TYPE;
2487: l_rs_cust_relation_id number;
2488: l_process_type varchar2(30);
2489: l_column_NAME varchar2(30);
2490:

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

2520: CURSOR l_party_id_csr IS
2521: select party_id from hz_cust_accounts where cust_account_id = l_customer_id;
2522:
2523: CURSOR l_requirement_hdr_csr IS
2524: -- select ship_to_location_id from csp_requirement_headers where task_assignment_id = p_task_assignment_id;
2525: select ship_to_location_id,
2526: timezone_id
2527: from csp_requirement_headers
2528: where task_assignment_id = p_task_assignment_id;

Line 2527: from csp_requirement_headers

2523: CURSOR l_requirement_hdr_csr IS
2524: -- select ship_to_location_id from csp_requirement_headers where task_assignment_id = p_task_assignment_id;
2525: select ship_to_location_id,
2526: timezone_id
2527: from csp_requirement_headers
2528: where task_assignment_id = p_task_assignment_id;
2529:
2530: CURSOR l_resource_name_csr IS
2531: select resource_name,

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

2765: END IF;
2766:
2767: IF p_task_assignment_id IS NOT NULL THEN
2768: -- IF l_inv_location_id IS NULL THEN
2769: -- Use task_assignment_id to retrieve inventory_location_id from csp_requirement_headers
2770: OPEN l_requirement_hdr_csr;
2771: -- FETCH l_requirement_hdr_csr INTO l_inv_location_id;
2772: FETCH l_requirement_hdr_csr INTO t_inv_location_id, l_timezone_id;
2773: IF l_requirement_hdr_csr%NOTFOUND THEN

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

4396: l_site_use_id NUMBER;
4397: l_address_id NUMBER;
4398: l_api_version_number NUMBER := 1.0;
4399: l_api_name CONSTANT VARCHAR2(30) := 'cust_inv_loc_link';
4400: --l_party_site_id NUMBER := to_number(Name_In('csp_requirement_headers.party_site_id'));
4401: --l_account_id NUMBER := to_number(Name_In('csp_requirement_headers.account_id'));
4402: l_org_id NUMBER;
4403: l_inv_location_id NUMBER;
4404: l_inv_loc NUMBER;

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

4397: l_address_id NUMBER;
4398: l_api_version_number NUMBER := 1.0;
4399: l_api_name CONSTANT VARCHAR2(30) := 'cust_inv_loc_link';
4400: --l_party_site_id NUMBER := to_number(Name_In('csp_requirement_headers.party_site_id'));
4401: --l_account_id NUMBER := to_number(Name_In('csp_requirement_headers.account_id'));
4402: l_org_id NUMBER;
4403: l_inv_location_id NUMBER;
4404: l_inv_loc NUMBER;
4405: l_Return_val BOOLEAN := FALSE;