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.OKI_DBI_LOAD_CLEB_PVT dependencies on OKI_DBI_REN_INC

Line 1145: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_REN_INC' ;

1141:
1142: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_CURR_CONV';
1143: EXECUTE IMMEDIATE l_sql_string;
1144: rlog( 'Truncated Table ' || l_oki_schema || '.OKI_DBI_CURR_CONV',1);
1145: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_REN_INC' ;
1146: EXECUTE IMMEDIATE l_sql_string ;
1147: rlog('Truncated Table OKI_DBI_REN_INC ',1);
1148: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_PREV_INC' ;
1149: EXECUTE IMMEDIATE l_sql_string ;

Line 1147: rlog('Truncated Table OKI_DBI_REN_INC ',1);

1143: EXECUTE IMMEDIATE l_sql_string;
1144: rlog( 'Truncated Table ' || l_oki_schema || '.OKI_DBI_CURR_CONV',1);
1145: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_REN_INC' ;
1146: EXECUTE IMMEDIATE l_sql_string ;
1147: rlog('Truncated Table OKI_DBI_REN_INC ',1);
1148: l_sql_string := 'TRUNCATE TABLE ' || l_oki_schema || '.OKI_DBI_PREV_INC' ;
1149: EXECUTE IMMEDIATE l_sql_string ;
1150: rlog('Truncated Table OKI_DBI_PREV_INC ',1);
1151:

Line 3019: rlog('Populating table OKI_DBI_REN_INC due to ''Operation Lines Changes'': '

3015: l_start_date := OKI_DBI_LOAD_CLEB_PVT.g_start_date ;
3016: l_end_date := OKI_DBI_LOAD_CLEB_PVT.g_end_date ;
3017: l_run_date := OKI_DBI_LOAD_CLEB_PVT.g_run_date ;
3018:
3019: rlog('Populating table OKI_DBI_REN_INC due to ''Operation Lines Changes'': '
3020: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3021: /* Changes to operation_lines */
3022: /* Changed for appsperf bug 4913262 */
3023: MERGE /*+ INDEX(B OKI_DBI_REN_INC_U1) */ INTO OKI_DBI_REN_INC b

Line 3023: MERGE /+ INDEX(B OKI_DBI_REN_INC_U1) / INTO OKI_DBI_REN_INC b

3019: rlog('Populating table OKI_DBI_REN_INC due to ''Operation Lines Changes'': '
3020: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3021: /* Changes to operation_lines */
3022: /* Changed for appsperf bug 4913262 */
3023: MERGE /*+ INDEX(B OKI_DBI_REN_INC_U1) */ INTO OKI_DBI_REN_INC b
3024: USING
3025: (SELECT s1.cle_id
3026: , s1.r_cle_id
3027: , case when g_true_incr = 1 then mod(rownum-1,p_no_of_workers)+1 else -99 end worker_number

Line 3074: rlog( 'Number of lines inserted into OKI_DBI_REN_INC : '

3070: );
3071:
3072: l_count := SQL%ROWCOUNT;
3073:
3074: rlog( 'Number of lines inserted into OKI_DBI_REN_INC : '
3075: ||TO_CHAR(l_count),2);
3076: rlog('Load of table OKI_DBI_REN_INC due to ''Operation Lines Changes'' completed: '
3077: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3078: COMMIT;

Line 3076: rlog('Load of table OKI_DBI_REN_INC due to ''Operation Lines Changes'' completed: '

3072: l_count := SQL%ROWCOUNT;
3073:
3074: rlog( 'Number of lines inserted into OKI_DBI_REN_INC : '
3075: ||TO_CHAR(l_count),2);
3076: rlog('Load of table OKI_DBI_REN_INC due to ''Operation Lines Changes'' completed: '
3077: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3078: COMMIT;
3079:
3080: IF g_true_incr = 0 THEN

Line 3082: -- GATHER_TABLE_STATS(TABNAME=>'OKI_DBI_REN_INC');

3078: COMMIT;
3079:
3080: IF g_true_incr = 0 THEN
3081:
3082: -- GATHER_TABLE_STATS(TABNAME=>'OKI_DBI_REN_INC');
3083:
3084: rlog('Updating table OKI_DBI_REN_INC due to ''Operation Lines Changes'': '
3085: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3086:

Line 3084: rlog('Updating table OKI_DBI_REN_INC due to ''Operation Lines Changes'': '

3080: IF g_true_incr = 0 THEN
3081:
3082: -- GATHER_TABLE_STATS(TABNAME=>'OKI_DBI_REN_INC');
3083:
3084: rlog('Updating table OKI_DBI_REN_INC due to ''Operation Lines Changes'': '
3085: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3086:
3087: /* Changes to operation_lines */
3088: MERGE /*+ INDEX(B OKI_DBI_REN_INC_U1) */ INTO OKI_DBI_REN_INC b

Line 3088: MERGE /+ INDEX(B OKI_DBI_REN_INC_U1) / INTO OKI_DBI_REN_INC b

3084: rlog('Updating table OKI_DBI_REN_INC due to ''Operation Lines Changes'': '
3085: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3086:
3087: /* Changes to operation_lines */
3088: MERGE /*+ INDEX(B OKI_DBI_REN_INC_U1) */ INTO OKI_DBI_REN_INC b
3089: USING
3090: (SELECT s1.cle_id
3091: , s1.r_cle_id
3092: , mod(rownum-1,p_no_of_workers)+1 worker_number

Line 3096: FROM oki_dbi_ren_inc b,

3092: , mod(rownum-1,p_no_of_workers)+1 worker_number
3093: FROM (SELECT /*+ ordered index(b) use_nl(rel,opins) */
3094: rel.object_cle_id cle_id
3095: , MAX (rel.subject_cle_id)KEEP (DENSE_RANK LAST ORDER BY rel.last_update_date) r_cle_id
3096: FROM oki_dbi_ren_inc b,
3097: okc_operation_lines rel
3098: ,okc_operation_instances opins,
3099: okc_class_operations clsop
3100: WHERE 1 = 1

Line 3129: rlog('Number of lines updated into OKI_DBI_REN_INC : '

3125: , s.worker_number
3126: );
3127: l_count := SQL%ROWCOUNT;
3128:
3129: rlog('Number of lines updated into OKI_DBI_REN_INC : '
3130: ||TO_CHAR(l_count),2);
3131: rlog('Updation of table OKI_DBI_REN_INC due to ''Operation Lines Changes'' completed: '
3132: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3133: COMMIT;

Line 3131: rlog('Updation of table OKI_DBI_REN_INC due to ''Operation Lines Changes'' completed: '

3127: l_count := SQL%ROWCOUNT;
3128:
3129: rlog('Number of lines updated into OKI_DBI_REN_INC : '
3130: ||TO_CHAR(l_count),2);
3131: rlog('Updation of table OKI_DBI_REN_INC due to ''Operation Lines Changes'' completed: '
3132: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3133: COMMIT;
3134: END IF;
3135:

Line 3139: rlog('Populating table OKI_DBI_REN_INC due to ''Deletes'': '

3135:
3136: /* Lines affected due to deletes */
3137: IF (g_del_count > 0 ) then
3138:
3139: rlog('Populating table OKI_DBI_REN_INC due to ''Deletes'': '
3140: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3141:
3142: MERGE INTO OKI_DBI_REN_INC b
3143: USING

Line 3142: MERGE INTO OKI_DBI_REN_INC b

3138:
3139: rlog('Populating table OKI_DBI_REN_INC due to ''Deletes'': '
3140: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3141:
3142: MERGE INTO OKI_DBI_REN_INC b
3143: USING
3144: (SELECT cle_id
3145: , r_cle_id
3146: , mod(rownum-1,p_no_of_workers)+1 worker_number

Line 3188: rlog( 'Number of lines inserted into OKI_DBI_REN_INC : '

3184: , s.worker_number
3185: );
3186:
3187: l_count := SQL%ROWCOUNT;
3188: rlog( 'Number of lines inserted into OKI_DBI_REN_INC : '
3189: ||TO_CHAR(l_count),2);
3190: rlog('Load of table OKI_DBI_REN_INC due to ''Deletes'' completed: '
3191: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3192: COMMIT;

Line 3190: rlog('Load of table OKI_DBI_REN_INC due to ''Deletes'' completed: '

3186:
3187: l_count := SQL%ROWCOUNT;
3188: rlog( 'Number of lines inserted into OKI_DBI_REN_INC : '
3189: ||TO_CHAR(l_count),2);
3190: rlog('Load of table OKI_DBI_REN_INC due to ''Deletes'' completed: '
3191: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3192: COMMIT;
3193: END IF;
3194: GATHER_TABLE_STATS( TABNAME=>'OKI_DBI_REN_INC' );

Line 3194: GATHER_TABLE_STATS( TABNAME=>'OKI_DBI_REN_INC' );

3190: rlog('Load of table OKI_DBI_REN_INC due to ''Deletes'' completed: '
3191: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3192: COMMIT;
3193: END IF;
3194: GATHER_TABLE_STATS( TABNAME=>'OKI_DBI_REN_INC' );
3195:
3196:
3197: EXCEPTION
3198: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3201: rlog('Error in populate_ren_rel: Insert into OKI_DBI_REN_INC FAILED', 0);

3197: EXCEPTION
3198: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3199: RAISE;
3200: WHEN OTHERS THEN
3201: rlog('Error in populate_ren_rel: Insert into OKI_DBI_REN_INC FAILED', 0);
3202: rlog(sqlerrm ||' '||sqlcode, 0);
3203: rlog(l_location , 0);
3204: fnd_message.set_name( application => 'FND'
3205: , name => 'CRM-DEBUG ERROR' ) ;

Line 3256: FROM oki_dbi_ren_inc ren_inc,

3252: chr_id
3253: , old.cle_id
3254: , date_signed
3255: , date_cancelled
3256: FROM oki_dbi_ren_inc ren_inc,
3257: oki_dbi_cle_b_old old
3258: WHERE ren_inc.r_cle_id = old.cle_id (+)
3259: AND ren_inc.worker_number = p_worker
3260: AND ren_inc.cle_id = b.cle_id)

Line 3263: oki_dbi_ren_inc ren_inc

3259: AND ren_inc.worker_number = p_worker
3260: AND ren_inc.cle_id = b.cle_id)
3261: WHERE EXISTS (SELECT/*+ ordered index(ren_inc) use_nl(old) */ 1
3262: FROM oki_dbi_cle_b_old old,
3263: oki_dbi_ren_inc ren_inc
3264: WHERE ren_inc.r_cle_id = old.cle_id (+)
3265: AND ren_inc.worker_number = p_worker
3266: AND ren_inc.cle_id = b.cle_id);
3267:

Line 3558: rlog('Populating table OKI_DBI_REN_INC from OKI_DBI_PREV_INC: '

3554: IF ( l_phase = 2 ) THEN
3555:
3556: GATHER_TABLE_STATS(TABNAME=>'OKI_DBI_PREV_INC');
3557:
3558: rlog('Populating table OKI_DBI_REN_INC from OKI_DBI_PREV_INC: '
3559: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3560:
3561: MERGE INTO OKI_DBI_REN_INC b
3562: USING

Line 3561: MERGE INTO OKI_DBI_REN_INC b

3557:
3558: rlog('Populating table OKI_DBI_REN_INC from OKI_DBI_PREV_INC: '
3559: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3560:
3561: MERGE INTO OKI_DBI_REN_INC b
3562: USING
3563: (SELECT rel.p_cle_id cle_id
3564: , rel.cle_id r_cle_id
3565: , MOD(ROWNUM-1,l_no_of_workers)+1 worker_number

Line 3584: rlog( 'Number of lines inserted into OKI_DBI_REN_INC : '

3580: , s.worker_number
3581: );
3582:
3583: l_count := SQL%ROWCOUNT;
3584: rlog( 'Number of lines inserted into OKI_DBI_REN_INC : '
3585: ||TO_CHAR(l_count),2);
3586: rlog('Load of table OKI_DBI_REN_INC from OKI_DBI_PREV_INC completed: '
3587: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3588: COMMIT;

Line 3586: rlog('Load of table OKI_DBI_REN_INC from OKI_DBI_PREV_INC completed: '

3582:
3583: l_count := SQL%ROWCOUNT;
3584: rlog( 'Number of lines inserted into OKI_DBI_REN_INC : '
3585: ||TO_CHAR(l_count),2);
3586: rlog('Load of table OKI_DBI_REN_INC from OKI_DBI_PREV_INC completed: '
3587: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3588: COMMIT;
3589: OKI_DBI_LOAD_CLEB_PVT.populate_ren_rel(l_no_of_workers);
3590:

Line 3603: rlog('Populating table OKI_DBI_CLE_DEL from OKI_DBI_REN_INC,OKI_DBI_PREV_INC: '

3599: l_sql_string := 'TRUNCATE TABLE '||l_oki_schema||'.oki_dbi_Cle_del';
3600: EXECUTE IMMEDIATE l_sql_string;
3601: rlog('Truncated table OKI_DBI_CLE_DEL ',2);
3602:
3603: rlog('Populating table OKI_DBI_CLE_DEL from OKI_DBI_REN_INC,OKI_DBI_PREV_INC: '
3604: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3605: INSERT INTO OKI_DBI_CLE_DEL
3606: ( cle_id
3607: ,worker_number)

Line 3615: SELECT /+ index_ffs(OKI_DBI_REN_INC OKI_DBI_REN_INC_U1) /

3611: FROM (
3612: SELECT cle_id
3613: , MOD(ROWNUM-1,l_no_of_workers)+1 worker_number
3614: FROM (
3615: SELECT /*+ index_ffs(OKI_DBI_REN_INC OKI_DBI_REN_INC_U1) */
3616: cle_id FROM oki_dbi_ren_inc
3617: UNION
3618: SELECT r_cle_id FROM oki_dbi_ren_inc
3619: where r_cle_id is not null

Line 3616: cle_id FROM oki_dbi_ren_inc

3612: SELECT cle_id
3613: , MOD(ROWNUM-1,l_no_of_workers)+1 worker_number
3614: FROM (
3615: SELECT /*+ index_ffs(OKI_DBI_REN_INC OKI_DBI_REN_INC_U1) */
3616: cle_id FROM oki_dbi_ren_inc
3617: UNION
3618: SELECT r_cle_id FROM oki_dbi_ren_inc
3619: where r_cle_id is not null
3620: UNION

Line 3618: SELECT r_cle_id FROM oki_dbi_ren_inc

3614: FROM (
3615: SELECT /*+ index_ffs(OKI_DBI_REN_INC OKI_DBI_REN_INC_U1) */
3616: cle_id FROM oki_dbi_ren_inc
3617: UNION
3618: SELECT r_cle_id FROM oki_dbi_ren_inc
3619: where r_cle_id is not null
3620: UNION
3621: SELECT /*+ index_ffs(OKI_DBI_PREV_INC OKI_DBI_PREV_INC_U1) */
3622: cle_id FROM oki_dbi_prev_inc

Line 3630: rlog('Load of table OKI_DBI_CLE_DEL from OKI_DBI_REN_INC,OKI_DBI_PREV_INC completed: '

3626: );
3627:
3628: COMMIT;
3629:
3630: rlog('Load of table OKI_DBI_CLE_DEL from OKI_DBI_REN_INC,OKI_DBI_PREV_INC completed: '
3631: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3632:
3633: GATHER_TABLE_STATS(TABNAME=>'OKI_DBI_CLE_DEL');
3634:

Line 5889: rlog('Populating renewal incremental table OKI_DBI_REN_INC due to ''Delta Changes'': '

5885: l_count NUMBER;
5886:
5887: BEGIN
5888: l_location := ' populating renewal increments table ' ;
5889: rlog('Populating renewal incremental table OKI_DBI_REN_INC due to ''Delta Changes'': '
5890: ||fnd_date.date_to_displayDT(sysdate), 1) ;
5891:
5892: /* Delta Changes */
5893: INSERT INTO OKI_DBI_REN_INC

Line 5893: INSERT INTO OKI_DBI_REN_INC

5889: rlog('Populating renewal incremental table OKI_DBI_REN_INC due to ''Delta Changes'': '
5890: ||fnd_date.date_to_displayDT(sysdate), 1) ;
5891:
5892: /* Delta Changes */
5893: INSERT INTO OKI_DBI_REN_INC
5894: (
5895: cle_id
5896: , r_cle_id
5897: , worker_number

Line 5909: rlog( 'Number of lines inserted into OKI_DBI_REN_INC due to ''Delta Changes'' is '

5905: WHERE ch.worker_number = p_worker
5906: AND ch.cle_id = al.r_cle_id);
5907:
5908: l_count := SQL%ROWCOUNT;
5909: rlog( 'Number of lines inserted into OKI_DBI_REN_INC due to ''Delta Changes'' is '
5910: ||TO_CHAR(l_count),2);
5911: rlog('Load of renewal incremental table OKI_DBI_REN_INC due to ''Delta Changes'' completed: '
5912: ||fnd_date.date_to_displayDT(sysdate), 1) ;
5913: COMMIT;

Line 5911: rlog('Load of renewal incremental table OKI_DBI_REN_INC due to ''Delta Changes'' completed: '

5907:
5908: l_count := SQL%ROWCOUNT;
5909: rlog( 'Number of lines inserted into OKI_DBI_REN_INC due to ''Delta Changes'' is '
5910: ||TO_CHAR(l_count),2);
5911: rlog('Load of renewal incremental table OKI_DBI_REN_INC due to ''Delta Changes'' completed: '
5912: ||fnd_date.date_to_displayDT(sysdate), 1) ;
5913: COMMIT;
5914:
5915: l_location := ' populating original increments table ' ;

Line 6392: rlog('Populating original incremental table OKI_DBI_PREV_INC from OKI_DBI_REN_INC: '

6388: Hence there is no need of processing deletes here*/
6389:
6390: IF( p_stage = 1 ) THEN
6391:
6392: rlog('Populating original incremental table OKI_DBI_PREV_INC from OKI_DBI_REN_INC: '
6393: ||fnd_date.date_to_displayDT(sysdate), 1) ;
6394:
6395: /* Changes to Operation Lines...Use the information Already found in
6396: the previous merge to get p_cle_id*/

Line 6402: FROM oki_dbi_ren_inc rel

6398: USING
6399: (SELECT rel.r_cle_id cle_id
6400: , rel.cle_id p_cle_id
6401: , MOD(ROWNUM-1,p_no_of_workers)+1 worker_number
6402: FROM oki_dbi_ren_inc rel
6403: WHERE rel.worker_number = p_worker
6404: )s
6405: ON (b.cle_id = s.cle_id)
6406: WHEN MATCHED THEN

Line 6422: rlog( 'Number of lines inserted into OKI_DBI_PREV_INC from OKI_DBI_REN_INC: '

6418: );
6419:
6420: l_count := SQL%ROWCOUNT;
6421:
6422: rlog( 'Number of lines inserted into OKI_DBI_PREV_INC from OKI_DBI_REN_INC: '
6423: ||TO_CHAR(l_count),2);
6424:
6425: rlog('Load of original incremental table OKI_DBI_PREV_INC from OKI_DBI_REN_INC: '
6426: ||fnd_date.date_to_displayDT(sysdate), 1) ;

Line 6425: rlog('Load of original incremental table OKI_DBI_PREV_INC from OKI_DBI_REN_INC: '

6421:
6422: rlog( 'Number of lines inserted into OKI_DBI_PREV_INC from OKI_DBI_REN_INC: '
6423: ||TO_CHAR(l_count),2);
6424:
6425: rlog('Load of original incremental table OKI_DBI_PREV_INC from OKI_DBI_REN_INC: '
6426: ||fnd_date.date_to_displayDT(sysdate), 1) ;
6427:
6428: COMMIT;
6429:

Line 6469: rlog( 'Number of lines inserted into OKI_DBI_REN_INC due to ''Intermediate Cancellations'' is '

6465: , s.worker_number
6466: );
6467:
6468: l_count := SQL%ROWCOUNT;
6469: rlog( 'Number of lines inserted into OKI_DBI_REN_INC due to ''Intermediate Cancellations'' is '
6470: ||TO_CHAR(l_count),2);
6471:
6472: rlog('Load of original incremental table OKI_DBI_PREV_INC for ''Intermediate Cancellations'' completed : '
6473: ||fnd_date.date_to_displayDT(sysdate), 1) ;