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.AS_SC_DENORM dependencies on AS_PERIOD_DAYS

Line 9: -- to refresh as_period_days table

5: -- HISTORY
6: -- 04/07/2000 NACHARYA Created
7: -- 12/21/2000 SOLIN Bug 1498351
8: -- Change to add a new concurrent program
9: -- to refresh as_period_days table
10: -- 12/22/2000 SOLIN Bug 1549115
11: -- Add a new column BUSINESS_GROUP_NAME in
12: -- AS_SALES_CREDITS_DENORM
13: -- 12/26/2000 SOLIN Change to have debug message for concurrent

Line 64: PROCEDURE Populate_as_period_days(

60: EXCEPTION WHEN OTHERS THEN
61: NULL;
62: END trace;
63:
64: PROCEDURE Populate_as_period_days(
65: ERRBUF OUT NOCOPY VARCHAR2,
66: RETCODE OUT NOCOPY VARCHAR2,
67: p_debug_mode IN VARCHAR2,
68: p_trace_mode IN VARCHAR2) IS

Line 79: FROM as_period_days;

75: l_oracle_schema VARCHAR2(32);
76: l_schema_return BOOLEAN;
77: CURSOR c1 IS
78: SELECT period_set_name, period_name, start_date, end_date, period_type
79: FROM as_period_days;
80:
81: l_module CONSTANT VARCHAR2(255) := 'as.plsql.scden.Populate_as_period_days';
82:
83: BEGIN

Line 81: l_module CONSTANT VARCHAR2(255) := 'as.plsql.scden.Populate_as_period_days';

77: CURSOR c1 IS
78: SELECT period_set_name, period_name, start_date, end_date, period_type
79: FROM as_period_days;
80:
81: l_module CONSTANT VARCHAR2(255) := 'as.plsql.scden.Populate_as_period_days';
82:
83: BEGIN
84: l_schema_return := FND_INSTALLATION.get_app_info('AS', l_fnd_status, l_industry, l_oracle_schema);
85:

Line 99: dbms_sql.parse(ddl_curs,'TRUNCATE TABLE ' || l_oracle_schema || '.AS_PERIOD_DAYS drop storage',

95: trace(FALSE);
96: END IF;
97:
98: ddl_curs := dbms_sql.open_cursor;
99: dbms_sql.parse(ddl_curs,'TRUNCATE TABLE ' || l_oracle_schema || '.AS_PERIOD_DAYS drop storage',
100: dbms_sql.native);
101: dbms_sql.close_cursor(ddl_curs);
102:
103: INSERT INTO as_period_days (period_set_name, period_name, period_day,

Line 103: INSERT INTO as_period_days (period_set_name, period_name, period_day,

99: dbms_sql.parse(ddl_curs,'TRUNCATE TABLE ' || l_oracle_schema || '.AS_PERIOD_DAYS drop storage',
100: dbms_sql.native);
101: dbms_sql.close_cursor(ddl_curs);
102:
103: INSERT INTO as_period_days (period_set_name, period_name, period_day,
104: start_date,end_date, period_type)
105: SELECT period_set_name, period_name, trunc(start_date),
106: trunc(start_date), trunc(end_date), period_type
107: FROM gl_periods

Line 117: INSERT INTO as_period_days (

113: LOOP
114: curr_day := chg_tbl.start_date + 1;
115: WHILE (curr_Day <= chg_tbl.end_date)
116: LOOP
117: INSERT INTO as_period_days (
118: period_set_name, period_name, period_Day, start_date,
119: end_date, period_type)
120: VALUES (
121: chg_tbl.period_set_name, chg_tbl.period_name, curr_day,

Line 130: ERRBUF := ERRBUF||'Error in Populate_as_period_days:'

126: COMMIT;
127:
128: EXCEPTION
129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
130: ERRBUF := ERRBUF||'Error in Populate_as_period_days:'
131: || to_char(sqlcode) || sqlerrm;
132: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
133: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Error in Populate_as_period_days');
134: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, sqlerrm);

Line 133: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Error in Populate_as_period_days');

129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
130: ERRBUF := ERRBUF||'Error in Populate_as_period_days:'
131: || to_char(sqlcode) || sqlerrm;
132: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
133: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Error in Populate_as_period_days');
134: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, sqlerrm);
135: Rollback;
136: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
137: IF l_status = TRUE THEN

Line 142: ERRBUF := ERRBUF||'Error Populate_as_period_days:'

138: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,
139: 'Error, can not complete Concurrent Program') ;
140: END IF;
141: WHEN OTHERS THEN
142: ERRBUF := ERRBUF||'Error Populate_as_period_days:'
143: || to_char(sqlcode) || sqlerrm;
144: RETCODE := '2';
145: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Error in Populate_as_period_days');
146: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, sqlerrm);

Line 145: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Error in Populate_as_period_days');

141: WHEN OTHERS THEN
142: ERRBUF := ERRBUF||'Error Populate_as_period_days:'
143: || to_char(sqlcode) || sqlerrm;
144: RETCODE := '2';
145: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Error in Populate_as_period_days');
146: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, sqlerrm);
147: Rollback;
148: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
149: IF l_status = TRUE THEN

Line 153: END Populate_as_period_days;

149: IF l_status = TRUE THEN
150: Write_Log(l_module, G_DEBUG_CONCURRENT, 1,
151: 'Error, can not complete Concurrent Program') ;
152: END IF ;
153: END Populate_as_period_days;
154:
155: PROCEDURE clear_snapshots IS
156: l_fnd_status VARCHAR2(2);
157: l_industry VARCHAR2(2);

Line 165: WHERE (log_owner = l_oracle_schema and master in ('AS_PERIOD_DAYS','AS_SALES_CREDITS_DENORM','AS_MC_SALES_CREDITS_DEN'))

161:
162: cursor dr_obj is
163: SELECT 'drop materialized view log on '||log_owner||'.'||master sqlstmt
164: FROM all_snapshot_logs
165: WHERE (log_owner = l_oracle_schema and master in ('AS_PERIOD_DAYS','AS_SALES_CREDITS_DENORM','AS_MC_SALES_CREDITS_DEN'))
166: --or (log_owner = 'JTF' and master in ('JTF_RS_REP_MANAGERS','JTF_RS_GROUP_USAGES'))
167: or (log_owner = l_apps_schema and master in ('ASF_SC_BIN_MV','ASF_SCBINLD_MV'))
168: UNION ALL
169: SELECT 'drop materialized view '||owner||'.'||name

Line 462: as_period_rates pr, as_period_days pd

458: --as_interest_codes_tl pic, as_interest_codes_tl sic, as_interest_types_tl it,
459: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,
460: jtf_rs_resource_extns jrs2,
461: hr_all_organization_units_tl org,
462: as_period_rates pr, as_period_days pd
463: Where
464: ll.lead_id = lead.lead_id
465: and ll.lead_line_id = sc.lead_line_id
466: and lead.sales_stage_id = sales.sales_stage_id(+)

Line 634: as_period_rates pr, as_period_days pd

630: --as_interest_codes_tl pic, as_interest_codes_tl sic, as_interest_types_tl it,
631: jtf_rs_resource_extns jrs0, jtf_rs_resource_extns jrs1,
632: jtf_rs_resource_extns jrs2,
633: hr_all_organization_units_tl org,
634: as_period_rates pr, as_period_days pd
635: Where
636: ll.lead_id = lead.lead_id
637: and ll.lead_line_id = sc.lead_line_id
638: and lead.sales_stage_id = sales.sales_stage_id(+)