DBA Data[Home] [Help]

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 957: l_get_app_info := fnd_installation.get_app_info('CSP',l_status,l_industry, l_oracle_schema);

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

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

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

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

2145:
2146: --
2147: -- API body
2148: --
2149: l_get_app_info := fnd_installation.get_app_info('CSP',l_status,l_industry, l_oracle_schema);
2150: --- Delete from Supply Chain
2151: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_SUPPLY_CHAIN' ;
2152:
2153: open c_parameters(p_level_id);

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

3034: BEGIN
3035: -- Standard Start of API savepoint
3036: SAVEPOINT CREATE_ROLLUP_PVT;
3037:
3038: l_get_app_info := fnd_installation.get_app_info('CSP',l_status,l_industry, l_oracle_schema);
3039:
3040: --
3041: -- API body
3042: --