APPS.CSP_AUTO_ASLMSL_PVT dependencies on FND_INSTALLATION

Line 253: l_get_app_info := fnd_installation.get_app_info('CSP',l_status,l_industry, l_oracle_schema);

249: -- Alter session
250: if p_api_version_number <> 2.0 then
251: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
252: end if;
253: l_get_app_info := fnd_installation.get_app_info('CSP',l_status,l_industry, l_oracle_schema);
254: If p_Level_Id = '1' Then
255: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_USAGE_HEADERS';
256: Else
257: Delete from csp_usage_headers cuh

Line 960: l_get_app_info := fnd_installation.get_app_info('CSP',l_status,l_industry, l_oracle_schema);

956:
957: --
958: -- API body
959: --
960: l_get_app_info := fnd_installation.get_app_info('CSP',l_status,l_industry, l_oracle_schema);
961: -- Clean up the tables
962:
963: -- Delete from Csp_Usage_Headers
964: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_USAGE_HEADERS';

Line 1110: l_get_app_info := fnd_installation.get_app_info('CSP',l_status,l_industry, l_oracle_schema);

1106: End;
1107:
1108: G_LAST_RUN_DATE := NVL(G_LAST_RUN_DATE,FND_API.G_MISS_DATE);
1109: If G_LAST_RUN_DATE < trunc(sysdate) - 1 Then
1110: l_get_app_info := fnd_installation.get_app_info('CSP',l_status,l_industry, l_oracle_schema);
1111: -- Delete from CSP_SUPPLY_CHAIN
1112: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_SUPPLY_CHAIN';
1113: -- Standard Start of API savepoint
1114: SAVEPOINT CREATE_USAGE_PVT;

Line 2129: l_get_app_info := fnd_installation.get_app_info('CSP',l_status,l_industry, l_oracle_schema);

2125:
2126: --
2127: -- API body
2128: --
2129: l_get_app_info := fnd_installation.get_app_info('CSP',l_status,l_industry, l_oracle_schema);
2130: --- Delete from Supply Chain
2131: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_SUPPLY_CHAIN' ;
2132:
2133: open c_parameters(p_level_id);