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.JTF_TTY_CAL_METRICS_PVT dependencies on JTF_TTY_ACCT_METRICS

Line 63: INSERT into jtf_tty_acct_metrics

59:
60: BEGIN
61:
62: FORALL i in partyList.FIRST ..partyList.LAST
63: INSERT into jtf_tty_acct_metrics
64: ( NAMED_ACCT_METRIC_ID
65: ,OBJECT_VERSION_NUMBER
66: ,NAMED_ACCOUNT_ID
67: ,METRIC_LOOKUP_TYPE

Line 80: ( select jtf_tty_acct_metrics_s.nextval,

76: ,PROGRAM_LOGIN_ID
77: ,PROGRAM_APPLICATION_ID
78: ,REQUEST_ID
79: )
80: ( select jtf_tty_acct_metrics_s.nextval,
81: 1,
82: na.named_account_id,
83: G_METRIC_TYPE,
84: l_align_metric_code,

Line 103: print_log(' Inserted ' || SQL%ROWCOUNT || ' rows IN JTF_TTY_ACCT_METRICS ');

99: and na.party_id = partyList(i)
100: );
101:
102:
103: print_log(' Inserted ' || SQL%ROWCOUNT || ' rows IN JTF_TTY_ACCT_METRICS ');
104: COMMIT;
105:
106: END;
107:

Line 116: INSERT into jtf_tty_acct_metrics

112: l_sysdate DATE := SYSDATE;
113: BEGIN
114:
115: FORALL i in partyList.FIRST ..partyList.LAST
116: INSERT into jtf_tty_acct_metrics
117: ( NAMED_ACCT_METRIC_ID
118: ,OBJECT_VERSION_NUMBER
119: ,NAMED_ACCOUNT_ID
120: ,METRIC_LOOKUP_TYPE

Line 133: ( select jtf_tty_acct_metrics_s.nextval,

129: ,PROGRAM_LOGIN_ID
130: ,PROGRAM_APPLICATION_ID
131: ,REQUEST_ID
132: )
133: ( select jtf_tty_acct_metrics_s.nextval,
134: 1,
135: na.named_account_id,
136: G_METRIC_TYPE,
137: l_align_metric_code,

Line 167: print_log(' Inserted ' || SQL%ROWCOUNT || ' rows IN JTF_TTY_ACCT_METRICS ');

163: and na.party_id = partyList(i)
164: );
165:
166:
167: print_log(' Inserted ' || SQL%ROWCOUNT || ' rows IN JTF_TTY_ACCT_METRICS ');
168: COMMIT;
169:
170: END;
171:

Line 206: INSERT into jtf_tty_acct_metrics

202: END IF;
203:
204:
205: FORALL i in partyList.FIRST ..partyList.LAST
206: INSERT into jtf_tty_acct_metrics
207: (NAMED_ACCT_METRIC_ID
208: ,OBJECT_VERSION_NUMBER
209: ,NAMED_ACCOUNT_ID
210: ,METRIC_LOOKUP_TYPE

Line 223: ( select jtf_tty_acct_metrics_s.nextval,

219: ,PROGRAM_LOGIN_ID
220: ,PROGRAM_APPLICATION_ID
221: ,REQUEST_ID
222: )
223: ( select jtf_tty_acct_metrics_s.nextval,
224: 1,
225: na_list.named_account_id,
226: G_METRIC_TYPE,
227: l_align_metric_code,

Line 253: print_log(' Inserted ' || SQL%ROWCOUNT || ' rows IN JTF_TTY_ACCT_METRICS ');

249: ) na_list
250:
251: );
252:
253: print_log(' Inserted ' || SQL%ROWCOUNT || ' rows IN JTF_TTY_ACCT_METRICS ');
254: COMMIT;
255:
256: END;
257:

Line 307: l_trunc_statement := 'Truncate table ' || l_jtf_schema || '.JTF_TTY_ACCT_METRICS';

303:
304:
305: IF p_metric_code = 'ALL'
306: THEN
307: l_trunc_statement := 'Truncate table ' || l_jtf_schema || '.JTF_TTY_ACCT_METRICS';
308: print_log(' Truncating table JTF_TTY_ACCT_METRICS ');
309: EXECUTE IMMEDIATE l_trunc_statement;
310: print_log(' Completed Truncating table JTF_TTY_ACCT_METRICS ');
311: ELSE

Line 308: print_log(' Truncating table JTF_TTY_ACCT_METRICS ');

304:
305: IF p_metric_code = 'ALL'
306: THEN
307: l_trunc_statement := 'Truncate table ' || l_jtf_schema || '.JTF_TTY_ACCT_METRICS';
308: print_log(' Truncating table JTF_TTY_ACCT_METRICS ');
309: EXECUTE IMMEDIATE l_trunc_statement;
310: print_log(' Completed Truncating table JTF_TTY_ACCT_METRICS ');
311: ELSE
312: print_log(' Deleting from JTF_TTY_ACCT_METRICS ');

Line 310: print_log(' Completed Truncating table JTF_TTY_ACCT_METRICS ');

306: THEN
307: l_trunc_statement := 'Truncate table ' || l_jtf_schema || '.JTF_TTY_ACCT_METRICS';
308: print_log(' Truncating table JTF_TTY_ACCT_METRICS ');
309: EXECUTE IMMEDIATE l_trunc_statement;
310: print_log(' Completed Truncating table JTF_TTY_ACCT_METRICS ');
311: ELSE
312: print_log(' Deleting from JTF_TTY_ACCT_METRICS ');
313: delete from JTF_TTY_ACCT_METRICS where metric_lookup_code = p_metric_code;
314: print_log(' Completed deleting ' || SQL%ROWCOUNT || ' rows from JTF_TTY_ACCT_METRICS ');

Line 312: print_log(' Deleting from JTF_TTY_ACCT_METRICS ');

308: print_log(' Truncating table JTF_TTY_ACCT_METRICS ');
309: EXECUTE IMMEDIATE l_trunc_statement;
310: print_log(' Completed Truncating table JTF_TTY_ACCT_METRICS ');
311: ELSE
312: print_log(' Deleting from JTF_TTY_ACCT_METRICS ');
313: delete from JTF_TTY_ACCT_METRICS where metric_lookup_code = p_metric_code;
314: print_log(' Completed deleting ' || SQL%ROWCOUNT || ' rows from JTF_TTY_ACCT_METRICS ');
315: END IF;
316:

Line 313: delete from JTF_TTY_ACCT_METRICS where metric_lookup_code = p_metric_code;

309: EXECUTE IMMEDIATE l_trunc_statement;
310: print_log(' Completed Truncating table JTF_TTY_ACCT_METRICS ');
311: ELSE
312: print_log(' Deleting from JTF_TTY_ACCT_METRICS ');
313: delete from JTF_TTY_ACCT_METRICS where metric_lookup_code = p_metric_code;
314: print_log(' Completed deleting ' || SQL%ROWCOUNT || ' rows from JTF_TTY_ACCT_METRICS ');
315: END IF;
316:
317: print_log(' Starting Processing of Named Accounts Loop');

Line 314: print_log(' Completed deleting ' || SQL%ROWCOUNT || ' rows from JTF_TTY_ACCT_METRICS ');

310: print_log(' Completed Truncating table JTF_TTY_ACCT_METRICS ');
311: ELSE
312: print_log(' Deleting from JTF_TTY_ACCT_METRICS ');
313: delete from JTF_TTY_ACCT_METRICS where metric_lookup_code = p_metric_code;
314: print_log(' Completed deleting ' || SQL%ROWCOUNT || ' rows from JTF_TTY_ACCT_METRICS ');
315: END IF;
316:
317: print_log(' Starting Processing of Named Accounts Loop');
318: OPEN c_get_parties;