33: )
34: IS
35:
36: BEGIN
37: fv_sla_utl_processing_pkg.trace
38: (
39: p_level => p_level,
40: p_procedure_name => p_procedure_name,
41: p_debug_info => p_debug_info
69: p_accounting_mode IN VARCHAR2
70: )
71: IS
72: l_procedure_name VARCHAR2(100):='.FV_EXTRACT';
73: l_fv_extract_detail fv_sla_utl_processing_pkg.fv_ref_detail;
74: l_error_code NUMBER;
75: l_gt_error_code NUMBER;
76: l_error_desc VARCHAR2(1024);
77: BEGIN
104: trace(C_STATE_LEVEL, l_procedure_name, 'No of rows inserted into FV_EXTRACT_DETAIL_GT: '|| SQL%ROWCOUNT );
105: END IF;
106:
107: IF (l_error_code = C_SUCCESS) THEN
108: trace(C_STATE_LEVEL, l_procedure_name, 'Calling fv_sla_utl_processing_pkg.pya_processor');
109: fv_sla_utl_processing_pkg.pya_processor
110: (
111: p_application_id => p_application_id,
112: p_error_code => l_error_code,
105: END IF;
106:
107: IF (l_error_code = C_SUCCESS) THEN
108: trace(C_STATE_LEVEL, l_procedure_name, 'Calling fv_sla_utl_processing_pkg.pya_processor');
109: fv_sla_utl_processing_pkg.pya_processor
110: (
111: p_application_id => p_application_id,
112: p_error_code => l_error_code,
113: p_error_desc => l_error_desc
114: );
115: END IF;
116:
117: trace(C_STATE_LEVEL, l_procedure_name, 'Calling dump_gt_table');
118: fv_sla_utl_processing_pkg.dump_gt_table
119: (
120: p_fv_extract_detail => l_fv_extract_detail,
121: p_error_code => l_gt_error_code,
122: p_error_desc => l_error_desc