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.HZ_IMP_LOAD_WRAPPER dependencies on HZ_IMP_CREDITRTNGS_INT

Line 1171: UPDATE HZ_IMP_CREDITRTNGS_INT

1167: AND party_orig_system_reference = l_posr(i);
1168:
1169: --Update Credit Ratings
1170: FORALL i in l_posr.FIRST..l_posr.LAST
1171: UPDATE HZ_IMP_CREDITRTNGS_INT
1172: SET interface_status = 'D'
1173: WHERE batch_id = p_batch_id AND Nvl(party_id,l_pid(i)) = l_pid(i)
1174: AND party_orig_system = l_pos(i)
1175: AND party_orig_system_reference = l_posr(i);

Line 1320: update HZ_IMP_CREDITRTNGS_INT

1316: where BATCH_ID = P_BATCH_ID
1317: and PARTY_ORIG_SYSTEM = P_ORIG_SYSTEM
1318: and INTERFACE_STATUS = 'C';
1319:
1320: update HZ_IMP_CREDITRTNGS_INT
1321: set error_id = null,
1322: interface_status = null
1323: where BATCH_ID = P_BATCH_ID
1324: and PARTY_ORIG_SYSTEM = P_ORIG_SYSTEM

Line 1424: update HZ_IMP_CREDITRTNGS_INT

1420: and batch_id = P_BATCH_ID
1421: and stage = 3
1422: and status = 'C');
1423:
1424: update HZ_IMP_CREDITRTNGS_INT
1425: set error_id = null, interface_status = null
1426: where batch_id = P_BATCH_ID
1427: and party_orig_system = P_ORIG_SYSTEM
1428: and interface_status = 'C'

Line 2619: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2615: into hz_imp_errors (
2616: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2617: token1_name, token1_value, token2_name, token2_value)
2618: values (
2619: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2620: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'BANKRUPTCY_IND', 'LOOKUP_TYPE',
2621: 'YES/NO')
2622: when (E2_FLAG is null) then
2623: into hz_imp_errors (

Line 2627: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2623: into hz_imp_errors (
2624: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2625: token1_name, token1_value, token2_name, token2_value)
2626: values (
2627: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2628: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'SUIT_IND', 'LOOKUP_TYPE', 'YES/NO')
2629: when (E4_FLAG is null) then
2630: into hz_imp_errors (
2631: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 2634: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2630: into hz_imp_errors (
2631: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2632: token1_name, token1_value, token2_name, token2_value)
2633: values (
2634: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2635: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'DEBARMENT_IND', 'LOOKUP_TYPE',
2636: 'YES/NO')
2637: when (E5_FLAG is null) then
2638: into hz_imp_errors (

Line 2643: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2639: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2640: token1_name, token1_value, token2_name,
2641: token2_value)
2642: values (
2643: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2644: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FINCL_EMBT_IND', 'LOOKUP_TYPE',
2645: 'YES/NO')
2646: when (E6_FLAG is null) then
2647: into hz_imp_errors (

Line 2651: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2647: into hz_imp_errors (
2648: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2649: token1_name, token1_value, token2_name, token2_value)
2650: values (
2651: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2652: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'NO_TRADE_IND', 'LOOKUP_TYPE',
2653: 'YES/NO')
2654: when (E7_FLAG is null) then
2655: into hz_imp_errors (

Line 2659: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2655: into hz_imp_errors (
2656: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2657: token1_name, token1_value, token2_name, token2_value)
2658: values (
2659: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2660: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'JUDGEMENT_IND', 'LOOKUP_TYPE',
2661: 'YES/NO')
2662: when (E8_FLAG is null) then
2663: into hz_imp_errors (

Line 2667: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2663: into hz_imp_errors (
2664: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2665: token1_name, token1_value, token2_name, token2_value)
2666: values (
2667: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2668: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'LIEN_IND', 'LOOKUP_TYPE', 'YES/NO')
2669: when (E9_FLAG is null) then
2670: into hz_imp_errors (
2671: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,

Line 2674: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2670: into hz_imp_errors (
2671: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2672: token1_name, token1_value, token2_name, token2_value)
2673: values (
2674: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2675: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_OVERRIDE_CODE',
2676: 'LOOKUP_TYPE', 'FAILURE_SCORE_OVERRIDE_CODE')
2677: when (E10_FLAG is null) then
2678: into hz_imp_errors (

Line 2682: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2678: into hz_imp_errors (
2679: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2680: token1_name, token1_value, token2_name, token2_value)
2681: values (
2682: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2683: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY',
2684: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2685: when (E11_FLAG is null) then
2686: into hz_imp_errors (

Line 2690: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2686: into hz_imp_errors (
2687: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2688: token1_name, token1_value, token2_name, token2_value)
2689: values (
2690: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2691: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY2',
2692: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2693: when (E12_FLAG is null) then
2694: into hz_imp_errors (

Line 2698: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2694: into hz_imp_errors (
2695: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2696: token1_name, token1_value, token2_name, token2_value)
2697: values (
2698: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2699: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY3',
2700: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2701: when (E13_FLAG is null) then
2702: into hz_imp_errors (

Line 2706: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2702: into hz_imp_errors (
2703: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2704: token1_name, token1_value, token2_name, token2_value)
2705: values (
2706: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2707: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY4',
2708: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2709: when (E14_FLAG is null) then
2710: into hz_imp_errors (

Line 2714: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2710: into hz_imp_errors (
2711: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2712: token1_name, token1_value, token2_name, token2_value)
2713: values (
2714: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2715: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY5',
2716: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2717: when (E15_FLAG is null) then
2718: into hz_imp_errors (

Line 2722: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2718: into hz_imp_errors (
2719: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2720: token1_name, token1_value, token2_name, token2_value)
2721: values (
2722: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2723: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY6',
2724: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2725: when (E16_FLAG is null) then
2726: into hz_imp_errors (

Line 2730: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2726: into hz_imp_errors (
2727: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2728: token1_name, token1_value, token2_name, token2_value)
2729: values (
2730: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2731: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY7',
2732: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2733: when (E17_FLAG is null) then
2734: into hz_imp_errors (

Line 2738: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2734: into hz_imp_errors (
2735: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2736: token1_name, token1_value, token2_name, token2_value)
2737: values (
2738: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2739: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY8',
2740: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2741: when (E18_FLAG is null) then
2742: into hz_imp_errors (

Line 2746: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2742: into hz_imp_errors (
2743: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2744: token1_name, token1_value, token2_name, token2_value)
2745: values (
2746: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2747: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY9',
2748: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2749: when (E19_FLAG is null) then
2750: into hz_imp_errors (

Line 2754: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2750: into hz_imp_errors (
2751: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2752: token1_name, token1_value, token2_name, token2_value)
2753: values (
2754: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2755: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_COMMENTARY10',
2756: 'LOOKUP_TYPE', 'FAILURE_SCORE_COMMENTARY')
2757: when (E20_FLAG is null) then
2758: into hz_imp_errors (

Line 2762: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2758: into hz_imp_errors (
2759: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2760: token1_name, token1_value, token2_name, token2_value)
2761: values (
2762: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2763: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'FAILURE_SCORE_OVERRIDE_CODE',
2764: 'LOOKUP_TYPE', 'FAILURE_SCORE_OVERRIDE_CODE')
2765: when (E21_FLAG is null) then
2766: into hz_imp_errors (

Line 2770: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2766: into hz_imp_errors (
2767: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2768: token1_name, token1_value, token2_name, token2_value)
2769: values (
2770: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2771: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY',
2772: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2773: when (E22_FLAG is null) then
2774: into hz_imp_errors (

Line 2778: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2774: into hz_imp_errors (
2775: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2776: token1_name, token1_value, token2_name, token2_value)
2777: values (
2778: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2779: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY2',
2780: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2781: when (E23_FLAG is null) then
2782: into hz_imp_errors (

Line 2786: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2782: into hz_imp_errors (
2783: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2784: token1_name, token1_value, token2_name, token2_value)
2785: values (
2786: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2787: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY3',
2788: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2789: when (E24_FLAG is null) then
2790: into hz_imp_errors (

Line 2794: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2790: into hz_imp_errors (
2791: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2792: token1_name, token1_value, token2_name, token2_value)
2793: values (
2794: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2795: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY4',
2796: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2797: when (E25_FLAG is null) then
2798: into hz_imp_errors (

Line 2802: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2798: into hz_imp_errors (
2799: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2800: token1_name, token1_value, token2_name, token2_value)
2801: values (
2802: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2803: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY5',
2804: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2805: when (E26_FLAG is null) then
2806: into hz_imp_errors (

Line 2810: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2806: into hz_imp_errors (
2807: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2808: token1_name, token1_value, token2_name, token2_value)
2809: values (
2810: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2811: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY6',
2812: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2813: when (E27_FLAG is null) then
2814: into hz_imp_errors (

Line 2818: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2814: into hz_imp_errors (
2815: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2816: token1_name, token1_value, token2_name, token2_value)
2817: values (
2818: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2819: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY7',
2820: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2821: when (E28_FLAG is null) then
2822: into hz_imp_errors (

Line 2826: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2822: into hz_imp_errors (
2823: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2824: token1_name, token1_value, token2_name, token2_value)
2825: values (
2826: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2827: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY8',
2828: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2829: when (E29_FLAG is null) then
2830: into hz_imp_errors (

Line 2834: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2830: into hz_imp_errors (
2831: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2832: token1_name, token1_value, token2_name, token2_value)
2833: values (
2834: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2835: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY9',
2836: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2837: when (E30_FLAG is null) then
2838: into hz_imp_errors (

Line 2842: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2838: into hz_imp_errors (
2839: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2840: token1_name, token1_value, token2_name, token2_value)
2841: values (
2842: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2843: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREDIT_SCORE_COMMENTARY10',
2844: 'LOOKUP_TYPE', 'CREDIT_SCORE_COMMENTARY')
2845: when (E31_FLAG is null) then
2846: into hz_imp_errors (

Line 2850: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2846: into hz_imp_errors (
2847: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2848: token1_name, token1_value, token2_name, token2_value)
2849: values (
2850: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2851: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'PRNT_HQ_BKCY_IND',
2852: 'LOOKUP_TYPE', 'PRNT_HQ_IND')
2853: when (E32_FLAG is null) then
2854: into hz_imp_errors (

Line 2859: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2855: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2856: token1_name, token1_value, token2_name, token2_value, token3_name,
2857: token3_value)
2858: values (
2859: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2860: 'HZ_API_INVALID_FK', 'FK', 'CURRENCY_CODE', 'COLUMN',
2861: 'MAXIMUM_CREDIT_CURRENCY_CODE', 'TABLE', 'FND_CURRENCIES')
2862: when (E33_FLAG is null) then
2863: into hz_imp_errors (

Line 2867: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2863: into hz_imp_errors (
2864: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2865: token1_name, token1_value, token2_name, token2_value)
2866: values (
2867: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2868: 'HZ_API_INVALID_LOOKUP', 'COLUMN', 'CREATED_BY_MODULE', 'LOOKUP_TYPE',
2869: 'HZ_CREATED_BY_MODULES')
2870: when (DUP_VAL_IDX_EXCEP_FLAG = 'A') then
2871: into hz_imp_errors (

Line 2875: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2871: into hz_imp_errors (
2872: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2873: token1_name, token1_value, token2_name, token2_value)
2874: values (
2875: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2876: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_CREDIT_RATINGS_U1', 'ENTITY',
2877: 'HZ_CREDIT_RATINGS')
2878: when (DUP_VAL_IDX_EXCEP_FLAG = 'B') then
2879: into hz_imp_errors (

Line 2883: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2879: into hz_imp_errors (
2880: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name,
2881: token1_name, token1_value, token2_name, token2_value)
2882: values (
2883: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2884: 'HZ_IMP_DUP_VAL', 'INDEX', 'HZ_CREDIT_RATINGS_U2', 'ENTITY',
2885: 'HZ_CREDIT_RATINGS')
2886: when (ACTION_MISMATCH_FLAG is null) then
2887: into hz_imp_errors (

Line 2890: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2886: when (ACTION_MISMATCH_FLAG is null) then
2887: into hz_imp_errors (
2888: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2889: values (
2890: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2891: 'HZ_IMP_ACTION_MISMATCH')
2892: when (MISSING_PARENT_FLAG is null) then
2893: into hz_imp_errors (
2894: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)

Line 2896: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',

2892: when (MISSING_PARENT_FLAG is null) then
2893: into hz_imp_errors (
2894: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, message_name)
2895: values (
2896: creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, 'HZ_IMP_CREDITRTNGS_INT',
2897: 'HZ_IMP_PARENT_PARTY_NOT_FOUND')
2898: select creation_date, created_by, last_update_date, last_updated_by, last_update_login, program_application_id, program_id, program_update_date, error_id, batch_id, request_id, interface_table_name, E1_FLAG, E2_FLAG,
2899:
2900: E4_FLAG, E5_FLAG, E6_FLAG, E7_FLAG, E8_FLAG, E9_FLAG, E10_FLAG,

Line 2910: and e.interface_table_name = 'HZ_IMP_CREDITRTNGS_INT';

2906: ACTION_MISMATCH_FLAG, MISSING_PARENT_FLAG
2907: from hz_imp_tmp_errors e
2908: where e.batch_id = P_BATCH_ID
2909: and e.request_id = P_REQUEST_ID
2910: and e.interface_table_name = 'HZ_IMP_CREDITRTNGS_INT';
2911:
2912:
2913: insert all
2914: when (E1_FLAG is null) then

Line 3284: update hz_imp_creditrtngs_int

3280: where rowid = l_row_id(i)
3281: and l_table_name(i) = 'HZ_IMP_FINNUMBERS_INT';
3282:
3283: ForAll i in 1..l_row_id.count
3284: update hz_imp_creditrtngs_int
3285: set interface_status = 'E',
3286: error_id = l_error_id(i)
3287: where rowid = l_row_id(i)
3288: and l_table_name(i) = 'HZ_IMP_CREDITRTNGS_INT';

Line 3288: and l_table_name(i) = 'HZ_IMP_CREDITRTNGS_INT';

3284: update hz_imp_creditrtngs_int
3285: set interface_status = 'E',
3286: error_id = l_error_id(i)
3287: where rowid = l_row_id(i)
3288: and l_table_name(i) = 'HZ_IMP_CREDITRTNGS_INT';
3289:
3290: ForAll i in 1..l_row_id.count
3291: update hz_imp_classifics_int
3292: set interface_status = 'E',

Line 3951: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_INT');

3947: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CLASSIFICS_INT');
3948: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTPTS_INT');
3949: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTROLES_INT');
3950: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CONTACTS_INT');
3951: fnd_stats.gather_table_stats('AR', 'HZ_IMP_CREDITRTNGS_INT');
3952: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINNUMBERS_INT');
3953: fnd_stats.gather_table_stats('AR', 'HZ_IMP_FINREPORTS_INT');
3954: fnd_stats.gather_table_stats('AR', 'HZ_IMP_RELSHIPS_INT');
3955: END IF;

Line 4451: select /+ index_ffs(a,hz_imp_creditrtngs_int_n1) parallel_index(a)/

4447: from hz_imp_contactpts_int a
4448: where party_orig_system = :2
4449: and batch_id=:1
4450: union all -- Credit Ratings
4451: select /*+ index_ffs(a,hz_imp_creditrtngs_int_n1) parallel_index(a)*/
4452: party_orig_system_reference
4453: from hz_imp_creditrtngs_int a
4454: where party_orig_system = :2
4455: and batch_id=:1

Line 4453: from hz_imp_creditrtngs_int a

4449: and batch_id=:1
4450: union all -- Credit Ratings
4451: select /*+ index_ffs(a,hz_imp_creditrtngs_int_n1) parallel_index(a)*/
4452: party_orig_system_reference
4453: from hz_imp_creditrtngs_int a
4454: where party_orig_system = :2
4455: and batch_id=:1
4456: union all -- Financial Reports
4457: select /*+ index_ffs(a,hz_imp_finreports_int_n1) parallel_index(a)*/

Line 4548: select /+ index(a,hz_imp_creditrtngs_int_n1) /

4544: from hz_imp_contactpts_int a
4545: where party_orig_system = :2
4546: and batch_id=:1
4547: union all -- Credit Ratings
4548: select /*+ index(a,hz_imp_creditrtngs_int_n1) */
4549: party_orig_system_reference
4550: from hz_imp_creditrtngs_int a
4551: where party_orig_system = :2
4552: and batch_id=:1

Line 4550: from hz_imp_creditrtngs_int a

4546: and batch_id=:1
4547: union all -- Credit Ratings
4548: select /*+ index(a,hz_imp_creditrtngs_int_n1) */
4549: party_orig_system_reference
4550: from hz_imp_creditrtngs_int a
4551: where party_orig_system = :2
4552: and batch_id=:1
4553: union all -- Financial Reports
4554: select /*+ index(a,hz_imp_finreports_int_n1) */