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.OE_CUST_MERGE_DATA_FIX dependencies on OE_PC_VTMPLT_COLS

Line 2775: from oe_pc_vtmplt_cols

2771: Process_Mode IN VARCHAR2)
2772: IS
2773: CURSOR c1 is
2774: select VALIDATION_TMPLT_ID
2775: from oe_pc_vtmplt_cols
2776: where value_string in (select to_char(m.duplicate_site_id)
2777: from ra_customer_merges m
2778: where m.process_flag = 'Y'
2779: and m.request_id = req_id

Line 2786: from oe_pc_vtmplt_cols

2782: for update nowait;
2783:
2784: CURSOR c2 is
2785: select VALIDATION_TMPLT_ID
2786: from oe_pc_vtmplt_cols
2787: where value_string in (select to_char(m.duplicate_site_id)
2788: from ra_customer_merges m
2789: where m.process_flag = 'Y'
2790: and m.request_id = req_id

Line 2797: from oe_pc_vtmplt_cols

2793: for update nowait;
2794:
2795: CURSOR c4 is
2796: select VALIDATION_TMPLT_ID
2797: from oe_pc_vtmplt_cols
2798: where value_string in (select to_char(m.duplicate_site_id)
2799: from ra_customer_merges m
2800: where m.process_flag = 'Y'
2801: and m.request_id = req_id

Line 2808: from oe_pc_vtmplt_cols

2804: for update nowait;
2805:
2806: CURSOR c3 is
2807: select VALIDATION_TMPLT_ID
2808: from oe_pc_vtmplt_cols
2809: where value_string in (select to_char(m.duplicate_id)
2810: from ra_customer_merges m
2811: where m.process_flag = 'Y'
2812: and m.request_id = req_id

Line 2828: | oe_pc_vtmplt_cols|

2824: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_CONSTRAINTS_MERGE' ) ;
2825: END IF;
2826:
2827: /*-----------------------------+
2828: | oe_pc_vtmplt_cols|
2829: +-----------------------------*/
2830: /* both customer and site level */
2831:
2832: IF( process_mode = 'LOCK' ) THEN

Line 2835: -- arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );

2831:
2832: IF( process_mode = 'LOCK' ) THEN
2833:
2834: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
2835: -- arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
2836: IF l_debug_level > 0 THEN
2837: oe_debug_pub.add( 'LOCKING TABLE OE_PC_VTMPLT_COLS' ) ;
2838: END IF;
2839:

Line 2837: oe_debug_pub.add( 'LOCKING TABLE OE_PC_VTMPLT_COLS' ) ;

2833:
2834: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
2835: -- arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
2836: IF l_debug_level > 0 THEN
2837: oe_debug_pub.add( 'LOCKING TABLE OE_PC_VTMPLT_COLS' ) ;
2838: END IF;
2839:
2840: open c1;
2841: close c1;

Line 2861: -- arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );

2857: IF l_debug_level > 0 THEN
2858: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
2859: END IF;
2860: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2861: -- arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
2862: IF l_debug_level > 0 THEN
2863: oe_debug_pub.add( 'UPDATING OE_PC_VTMPLT_COLS.VALUE_STRING FOR COLUMN_NAME SHIP_TO_ORG_ID' ) ;
2864: END IF;
2865:

Line 2863: oe_debug_pub.add( 'UPDATING OE_PC_VTMPLT_COLS.VALUE_STRING FOR COLUMN_NAME SHIP_TO_ORG_ID' ) ;

2859: END IF;
2860: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2861: -- arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
2862: IF l_debug_level > 0 THEN
2863: oe_debug_pub.add( 'UPDATING OE_PC_VTMPLT_COLS.VALUE_STRING FOR COLUMN_NAME SHIP_TO_ORG_ID' ) ;
2864: END IF;
2865:
2866: UPDATE OE_PC_VTMPLT_COLS a
2867: set value_string = (select distinct to_char(m.customer_site_id)

Line 2866: UPDATE OE_PC_VTMPLT_COLS a

2862: IF l_debug_level > 0 THEN
2863: oe_debug_pub.add( 'UPDATING OE_PC_VTMPLT_COLS.VALUE_STRING FOR COLUMN_NAME SHIP_TO_ORG_ID' ) ;
2864: END IF;
2865:
2866: UPDATE OE_PC_VTMPLT_COLS a
2867: set value_string = (select distinct to_char(m.customer_site_id)
2868: from ra_customer_merges m
2869: where a.value_string =
2870: to_char(m.duplicate_site_id)

Line 2898: -- arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );

2894: IF l_debug_level > 0 THEN
2895: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
2896: END IF;
2897: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2898: -- arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
2899: IF l_debug_level > 0 THEN
2900: oe_debug_pub.add( 'UPDATING OE_PC_VTMPLT_COLS.VALUE_STRING FOR COLUMN_NAME INVOICE_TO_ORG_ID' ) ;
2901: END IF;
2902:

Line 2900: oe_debug_pub.add( 'UPDATING OE_PC_VTMPLT_COLS.VALUE_STRING FOR COLUMN_NAME INVOICE_TO_ORG_ID' ) ;

2896: END IF;
2897: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2898: -- arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
2899: IF l_debug_level > 0 THEN
2900: oe_debug_pub.add( 'UPDATING OE_PC_VTMPLT_COLS.VALUE_STRING FOR COLUMN_NAME INVOICE_TO_ORG_ID' ) ;
2901: END IF;
2902:
2903: UPDATE OE_PC_VTMPLT_COLS a
2904: set value_string = (select distinct to_char(m.customer_site_id)

Line 2903: UPDATE OE_PC_VTMPLT_COLS a

2899: IF l_debug_level > 0 THEN
2900: oe_debug_pub.add( 'UPDATING OE_PC_VTMPLT_COLS.VALUE_STRING FOR COLUMN_NAME INVOICE_TO_ORG_ID' ) ;
2901: END IF;
2902:
2903: UPDATE OE_PC_VTMPLT_COLS a
2904: set value_string = (select distinct to_char(m.customer_site_id)
2905: from ra_customer_merges m
2906: where a.value_string =
2907: to_char(m.duplicate_site_id)

Line 2935: -- arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );

2931: IF l_debug_level > 0 THEN
2932: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
2933: END IF;
2934: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2935: -- arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
2936: IF l_debug_level > 0 THEN
2937: oe_debug_pub.add( 'UPDATING OE_PC_VTMPLT_COLS.VALUE_STRING FOR COLUMN_NAME INTMED_TO_ORG_ID' ) ;
2938: END IF;
2939:

Line 2937: oe_debug_pub.add( 'UPDATING OE_PC_VTMPLT_COLS.VALUE_STRING FOR COLUMN_NAME INTMED_TO_ORG_ID' ) ;

2933: END IF;
2934: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2935: -- arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
2936: IF l_debug_level > 0 THEN
2937: oe_debug_pub.add( 'UPDATING OE_PC_VTMPLT_COLS.VALUE_STRING FOR COLUMN_NAME INTMED_TO_ORG_ID' ) ;
2938: END IF;
2939:
2940: UPDATE OE_PC_VTMPLT_COLS a
2941: set value_string = (select distinct to_char(m.customer_site_id)

Line 2940: UPDATE OE_PC_VTMPLT_COLS a

2936: IF l_debug_level > 0 THEN
2937: oe_debug_pub.add( 'UPDATING OE_PC_VTMPLT_COLS.VALUE_STRING FOR COLUMN_NAME INTMED_TO_ORG_ID' ) ;
2938: END IF;
2939:
2940: UPDATE OE_PC_VTMPLT_COLS a
2941: set value_string = (select distinct to_char(m.customer_site_id)
2942: from ra_customer_merges m
2943: where a.value_string =
2944: to_char(m.duplicate_site_id)

Line 2973: -- arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );

2969: IF l_debug_level > 0 THEN
2970: oe_debug_pub.add( 'CUSTOMER LEVEL UPDATE' ) ;
2971: END IF;
2972: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2973: -- arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
2974: IF l_debug_level > 0 THEN
2975: oe_debug_pub.add( 'UPDATING OE_PC_VTMPLT_COLS.VALUE_STRING FOR COLUMN_NAME SOLD_TO_ORG_ID' ) ;
2976: END IF;
2977:

Line 2975: oe_debug_pub.add( 'UPDATING OE_PC_VTMPLT_COLS.VALUE_STRING FOR COLUMN_NAME SOLD_TO_ORG_ID' ) ;

2971: END IF;
2972: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2973: -- arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
2974: IF l_debug_level > 0 THEN
2975: oe_debug_pub.add( 'UPDATING OE_PC_VTMPLT_COLS.VALUE_STRING FOR COLUMN_NAME SOLD_TO_ORG_ID' ) ;
2976: END IF;
2977:
2978: UPDATE OE_PC_VTMPLT_COLS a
2979: set value_string = (select distinct to_char(m.customer_id)

Line 2978: UPDATE OE_PC_VTMPLT_COLS a

2974: IF l_debug_level > 0 THEN
2975: oe_debug_pub.add( 'UPDATING OE_PC_VTMPLT_COLS.VALUE_STRING FOR COLUMN_NAME SOLD_TO_ORG_ID' ) ;
2976: END IF;
2977:
2978: UPDATE OE_PC_VTMPLT_COLS a
2979: set value_string = (select distinct to_char(m.customer_id)
2980: from ra_customer_merges m
2981: where a.value_string =
2982: to_char(m.duplicate_id)