APPS.XLA_GL_TRANSFER_PKG dependencies on DBMS_SQL

Line 698: cid := dbms_sql.open_cursor;

694: END IF;
695:
696:
697:
698: cid := dbms_sql.open_cursor;
699: dbms_sql.parse(cid, statement, dbms_sql.native);
700:
701: -- Bind Variables
702: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);

Line 699: dbms_sql.parse(cid, statement, dbms_sql.native);

695:
696:
697:
698: cid := dbms_sql.open_cursor;
699: dbms_sql.parse(cid, statement, dbms_sql.native);
700:
701: -- Bind Variables
702: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
703: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);

Line 702: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);

698: cid := dbms_sql.open_cursor;
699: dbms_sql.parse(cid, statement, dbms_sql.native);
700:
701: -- Bind Variables
702: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
703: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
704: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
705:
706: IF Nvl(p_selection_type,1) = 1 THEN -- for batch transfer

Line 703: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);

699: dbms_sql.parse(cid, statement, dbms_sql.native);
700:
701: -- Bind Variables
702: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
703: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
704: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
705:
706: IF Nvl(p_selection_type,1) = 1 THEN -- for batch transfer
707: IF p_legal_entity_id IS NOT NULL THEN

Line 704: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);

700:
701: -- Bind Variables
702: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
703: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
704: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
705:
706: IF Nvl(p_selection_type,1) = 1 THEN -- for batch transfer
707: IF p_legal_entity_id IS NOT NULL THEN
708: -- Manufacturing Transfer

Line 709: dbms_sql.bind_variable(cid,':b_legal_entity_id', p_legal_entity_id);

705:
706: IF Nvl(p_selection_type,1) = 1 THEN -- for batch transfer
707: IF p_legal_entity_id IS NOT NULL THEN
708: -- Manufacturing Transfer
709: dbms_sql.bind_variable(cid,':b_legal_entity_id', p_legal_entity_id);
710: dbms_sql.bind_variable(cid,':b_cost_group_id', p_cost_group_id);
711: dbms_sql.bind_variable(cid,':b_cost_type_id', p_cost_type_id);
712: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
713: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

Line 710: dbms_sql.bind_variable(cid,':b_cost_group_id', p_cost_group_id);

706: IF Nvl(p_selection_type,1) = 1 THEN -- for batch transfer
707: IF p_legal_entity_id IS NOT NULL THEN
708: -- Manufacturing Transfer
709: dbms_sql.bind_variable(cid,':b_legal_entity_id', p_legal_entity_id);
710: dbms_sql.bind_variable(cid,':b_cost_group_id', p_cost_group_id);
711: dbms_sql.bind_variable(cid,':b_cost_type_id', p_cost_type_id);
712: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
713: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
714: ELSE

Line 711: dbms_sql.bind_variable(cid,':b_cost_type_id', p_cost_type_id);

707: IF p_legal_entity_id IS NOT NULL THEN
708: -- Manufacturing Transfer
709: dbms_sql.bind_variable(cid,':b_legal_entity_id', p_legal_entity_id);
710: dbms_sql.bind_variable(cid,':b_cost_group_id', p_cost_group_id);
711: dbms_sql.bind_variable(cid,':b_cost_type_id', p_cost_type_id);
712: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
713: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
714: ELSE
715: -- Allow user to transfer multiple journal categories. Following will

Line 712: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);

708: -- Manufacturing Transfer
709: dbms_sql.bind_variable(cid,':b_legal_entity_id', p_legal_entity_id);
710: dbms_sql.bind_variable(cid,':b_cost_group_id', p_cost_group_id);
711: dbms_sql.bind_variable(cid,':b_cost_type_id', p_cost_type_id);
712: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
713: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
714: ELSE
715: -- Allow user to transfer multiple journal categories. Following will
716: -- generate a string to transfer multiple categories.

Line 713: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

709: dbms_sql.bind_variable(cid,':b_legal_entity_id', p_legal_entity_id);
710: dbms_sql.bind_variable(cid,':b_cost_group_id', p_cost_group_id);
711: dbms_sql.bind_variable(cid,':b_cost_type_id', p_cost_type_id);
712: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
713: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
714: ELSE
715: -- Allow user to transfer multiple journal categories. Following will
716: -- generate a string to transfer multiple categories.
717: IF p_ae_category.COUNT > 1 THEN

Line 720: dbms_sql.bind_variable(cid,':b_journal_category', p_ae_category(1));

716: -- generate a string to transfer multiple categories.
717: IF p_ae_category.COUNT > 1 THEN
718: NULL;
719: ELSE
720: dbms_sql.bind_variable(cid,':b_journal_category', p_ae_category(1));
721: END IF;
722:
723: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
724: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

Line 723: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);

719: ELSE
720: dbms_sql.bind_variable(cid,':b_journal_category', p_ae_category(1));
721: END IF;
722:
723: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
724: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
725: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);
726: END IF;
727: ELSE --for Document Level Transfer

Line 724: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

720: dbms_sql.bind_variable(cid,':b_journal_category', p_ae_category(1));
721: END IF;
722:
723: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
724: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
725: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);
726: END IF;
727: ELSE --for Document Level Transfer
728: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);

Line 725: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);

721: END IF;
722:
723: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
724: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
725: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);
726: END IF;
727: ELSE --for Document Level Transfer
728: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);
729: dbms_sql.bind_variable(cid,':b_source_id', p_source_id);

Line 728: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);

724: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
725: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);
726: END IF;
727: ELSE --for Document Level Transfer
728: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);
729: dbms_sql.bind_variable(cid,':b_source_id', p_source_id);
730: dbms_sql.bind_variable(cid,':b_source_table', p_source_table);
731: END IF;
732:

Line 729: dbms_sql.bind_variable(cid,':b_source_id', p_source_id);

725: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);
726: END IF;
727: ELSE --for Document Level Transfer
728: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);
729: dbms_sql.bind_variable(cid,':b_source_id', p_source_id);
730: dbms_sql.bind_variable(cid,':b_source_table', p_source_table);
731: END IF;
732:
733:

Line 730: dbms_sql.bind_variable(cid,':b_source_table', p_source_table);

726: END IF;
727: ELSE --for Document Level Transfer
728: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);
729: dbms_sql.bind_variable(cid,':b_source_id', p_source_id);
730: dbms_sql.bind_variable(cid,':b_source_table', p_source_table);
731: END IF;
732:
733:
734: rows_processed := dbms_sql.execute(cid);

Line 734: rows_processed := dbms_sql.execute(cid);

730: dbms_sql.bind_variable(cid,':b_source_table', p_source_table);
731: END IF;
732:
733:
734: rows_processed := dbms_sql.execute(cid);
735:
736: dbms_sql.close_cursor(cid);
737: IF rows_processed > 0 THEN
738: g_headers_selected := rows_processed;

Line 736: dbms_sql.close_cursor(cid);

732:
733:
734: rows_processed := dbms_sql.execute(cid);
735:
736: dbms_sql.close_cursor(cid);
737: IF rows_processed > 0 THEN
738: g_headers_selected := rows_processed;
739: -- Populate records transferred only when account validation
740: -- is not done

Line 871: cid := dbms_sql.open_cursor;

867: ,p_level => C_LEVEL_STATEMENT
868: ,p_module => l_log_module);
869: END IF;
870:
871: cid := dbms_sql.open_cursor;
872: dbms_sql.parse(cid, statement, dbms_sql.native);
873:
874: -- Bind Variables
875: dbms_sql.bind_variable(cid,':b_coa_id', p_coa_id);

Line 872: dbms_sql.parse(cid, statement, dbms_sql.native);

868: ,p_module => l_log_module);
869: END IF;
870:
871: cid := dbms_sql.open_cursor;
872: dbms_sql.parse(cid, statement, dbms_sql.native);
873:
874: -- Bind Variables
875: dbms_sql.bind_variable(cid,':b_coa_id', p_coa_id);
876: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);

Line 875: dbms_sql.bind_variable(cid,':b_coa_id', p_coa_id);

871: cid := dbms_sql.open_cursor;
872: dbms_sql.parse(cid, statement, dbms_sql.native);
873:
874: -- Bind Variables
875: dbms_sql.bind_variable(cid,':b_coa_id', p_coa_id);
876: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
877: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
878: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
879:

Line 876: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);

872: dbms_sql.parse(cid, statement, dbms_sql.native);
873:
874: -- Bind Variables
875: dbms_sql.bind_variable(cid,':b_coa_id', p_coa_id);
876: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
877: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
878: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
879:
880: rows_processed := dbms_sql.execute(cid);

Line 877: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);

873:
874: -- Bind Variables
875: dbms_sql.bind_variable(cid,':b_coa_id', p_coa_id);
876: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
877: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
878: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
879:
880: rows_processed := dbms_sql.execute(cid);
881: dbms_sql.close_cursor(cid);

Line 878: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

874: -- Bind Variables
875: dbms_sql.bind_variable(cid,':b_coa_id', p_coa_id);
876: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
877: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
878: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
879:
880: rows_processed := dbms_sql.execute(cid);
881: dbms_sql.close_cursor(cid);
882:

Line 880: rows_processed := dbms_sql.execute(cid);

876: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
877: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
878: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
879:
880: rows_processed := dbms_sql.execute(cid);
881: dbms_sql.close_cursor(cid);
882:
883: IF rows_processed = 0 THEN
884: g_proceed := 'N';

Line 881: dbms_sql.close_cursor(cid);

877: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
878: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
879:
880: rows_processed := dbms_sql.execute(cid);
881: dbms_sql.close_cursor(cid);
882:
883: IF rows_processed = 0 THEN
884: g_proceed := 'N';
885: END IF;

Line 951: cid := dbms_sql.open_cursor;

947: ,p_level => C_LEVEL_STATEMENT
948: ,p_module => l_log_module);
949: END IF;
950:
951: cid := dbms_sql.open_cursor;
952: dbms_sql.parse(cid, statement, dbms_sql.native);
953: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
954: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
955: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

Line 952: dbms_sql.parse(cid, statement, dbms_sql.native);

948: ,p_module => l_log_module);
949: END IF;
950:
951: cid := dbms_sql.open_cursor;
952: dbms_sql.parse(cid, statement, dbms_sql.native);
953: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
954: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
955: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
956:

Line 953: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);

949: END IF;
950:
951: cid := dbms_sql.open_cursor;
952: dbms_sql.parse(cid, statement, dbms_sql.native);
953: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
954: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
955: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
956:
957: l_invalid_headers := dbms_sql.execute(cid);

Line 954: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);

950:
951: cid := dbms_sql.open_cursor;
952: dbms_sql.parse(cid, statement, dbms_sql.native);
953: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
954: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
955: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
956:
957: l_invalid_headers := dbms_sql.execute(cid);
958:

Line 955: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

951: cid := dbms_sql.open_cursor;
952: dbms_sql.parse(cid, statement, dbms_sql.native);
953: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
954: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
955: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
956:
957: l_invalid_headers := dbms_sql.execute(cid);
958:
959: dbms_sql.close_cursor(cid);

Line 957: l_invalid_headers := dbms_sql.execute(cid);

953: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
954: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
955: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
956:
957: l_invalid_headers := dbms_sql.execute(cid);
958:
959: dbms_sql.close_cursor(cid);
960:
961: g_control_info(g_periods_cnt).cnt_transfer_errors :=

Line 959: dbms_sql.close_cursor(cid);

955: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
956:
957: l_invalid_headers := dbms_sql.execute(cid);
958:
959: dbms_sql.close_cursor(cid);
960:
961: g_control_info(g_periods_cnt).cnt_transfer_errors :=
962: g_control_info(g_periods_cnt).cnt_transfer_errors + l_invalid_headers;
963:

Line 1053: cid := dbms_sql.open_cursor;

1049: ,p_module => l_log_module);
1050: END IF;
1051:
1052:
1053: cid := dbms_sql.open_cursor;
1054: dbms_sql.parse(cid, statement, dbms_sql.native);
1055: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1056: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1057: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);

Line 1054: dbms_sql.parse(cid, statement, dbms_sql.native);

1050: END IF;
1051:
1052:
1053: cid := dbms_sql.open_cursor;
1054: dbms_sql.parse(cid, statement, dbms_sql.native);
1055: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1056: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1057: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1058: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);

Line 1055: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);

1051:
1052:
1053: cid := dbms_sql.open_cursor;
1054: dbms_sql.parse(cid, statement, dbms_sql.native);
1055: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1056: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1057: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1058: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1059: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

Line 1056: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);

1052:
1053: cid := dbms_sql.open_cursor;
1054: dbms_sql.parse(cid, statement, dbms_sql.native);
1055: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1056: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1057: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1058: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1059: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1060:

Line 1057: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);

1053: cid := dbms_sql.open_cursor;
1054: dbms_sql.parse(cid, statement, dbms_sql.native);
1055: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1056: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1057: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1058: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1059: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1060:
1061: rows_processed := dbms_sql.execute(cid);

Line 1058: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);

1054: dbms_sql.parse(cid, statement, dbms_sql.native);
1055: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1056: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1057: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1058: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1059: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1060:
1061: rows_processed := dbms_sql.execute(cid);
1062: dbms_sql.close_cursor(cid);

Line 1059: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

1055: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1056: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1057: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1058: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1059: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1060:
1061: rows_processed := dbms_sql.execute(cid);
1062: dbms_sql.close_cursor(cid);
1063:

Line 1061: rows_processed := dbms_sql.execute(cid);

1057: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1058: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1059: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1060:
1061: rows_processed := dbms_sql.execute(cid);
1062: dbms_sql.close_cursor(cid);
1063:
1064: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1065: xla_message('XLA_GLT_UPDATE_ENC_LINES','COUNT',rows_processed,'','','','',

Line 1062: dbms_sql.close_cursor(cid);

1058: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1059: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1060:
1061: rows_processed := dbms_sql.execute(cid);
1062: dbms_sql.close_cursor(cid);
1063:
1064: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1065: xla_message('XLA_GLT_UPDATE_ENC_LINES','COUNT',rows_processed,'','','','',
1066: l_log_module,

Line 1135: cid := dbms_sql.open_cursor;

1131: AND aeh.gl_transfer_run_id = :b_transfer_run_id
1132: AND aeh.accounting_date BETWEEN :b_start_date AND :b_end_date
1133: AND jc.je_category_name = aeh.ae_category';
1134:
1135: cid := dbms_sql.open_cursor;
1136: dbms_sql.parse(cid, statement, dbms_sql.native);
1137:
1138: -- Bind variables
1139: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);

Line 1136: dbms_sql.parse(cid, statement, dbms_sql.native);

1132: AND aeh.accounting_date BETWEEN :b_start_date AND :b_end_date
1133: AND jc.je_category_name = aeh.ae_category';
1134:
1135: cid := dbms_sql.open_cursor;
1136: dbms_sql.parse(cid, statement, dbms_sql.native);
1137:
1138: -- Bind variables
1139: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);
1140: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);

Line 1139: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);

1135: cid := dbms_sql.open_cursor;
1136: dbms_sql.parse(cid, statement, dbms_sql.native);
1137:
1138: -- Bind variables
1139: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);
1140: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1141: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1142: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1143: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);

Line 1140: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);

1136: dbms_sql.parse(cid, statement, dbms_sql.native);
1137:
1138: -- Bind variables
1139: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);
1140: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1141: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1142: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1143: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1144: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);

Line 1141: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);

1137:
1138: -- Bind variables
1139: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);
1140: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1141: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1142: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1143: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1144: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1145: dbms_sql.bind_variable(cid,':b_base_currency_code', g_base_currency_code);

Line 1142: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);

1138: -- Bind variables
1139: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);
1140: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1141: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1142: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1143: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1144: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1145: dbms_sql.bind_variable(cid,':b_base_currency_code', g_base_currency_code);
1146: dbms_sql.bind_variable(cid,':b_link_table', g_enc_table_alias);

Line 1143: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);

1139: dbms_sql.bind_variable(cid,':b_set_of_books_id', p_set_of_books_id);
1140: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1141: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1142: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1143: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1144: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1145: dbms_sql.bind_variable(cid,':b_base_currency_code', g_base_currency_code);
1146: dbms_sql.bind_variable(cid,':b_link_table', g_enc_table_alias);
1147: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);

Line 1144: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);

1140: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1141: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1142: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1143: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1144: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1145: dbms_sql.bind_variable(cid,':b_base_currency_code', g_base_currency_code);
1146: dbms_sql.bind_variable(cid,':b_link_table', g_enc_table_alias);
1147: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1148: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

Line 1145: dbms_sql.bind_variable(cid,':b_base_currency_code', g_base_currency_code);

1141: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1142: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1143: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1144: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1145: dbms_sql.bind_variable(cid,':b_base_currency_code', g_base_currency_code);
1146: dbms_sql.bind_variable(cid,':b_link_table', g_enc_table_alias);
1147: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1148: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1149: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);

Line 1146: dbms_sql.bind_variable(cid,':b_link_table', g_enc_table_alias);

1142: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1143: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1144: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1145: dbms_sql.bind_variable(cid,':b_base_currency_code', g_base_currency_code);
1146: dbms_sql.bind_variable(cid,':b_link_table', g_enc_table_alias);
1147: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1148: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1149: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1150: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);

Line 1147: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);

1143: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1144: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1145: dbms_sql.bind_variable(cid,':b_base_currency_code', g_base_currency_code);
1146: dbms_sql.bind_variable(cid,':b_link_table', g_enc_table_alias);
1147: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1148: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1149: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1150: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1151: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);

Line 1148: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

1144: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1145: dbms_sql.bind_variable(cid,':b_base_currency_code', g_base_currency_code);
1146: dbms_sql.bind_variable(cid,':b_link_table', g_enc_table_alias);
1147: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1148: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1149: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1150: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1151: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1152: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);

Line 1149: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);

1145: dbms_sql.bind_variable(cid,':b_base_currency_code', g_base_currency_code);
1146: dbms_sql.bind_variable(cid,':b_link_table', g_enc_table_alias);
1147: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1148: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1149: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1150: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1151: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1152: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1153:

Line 1150: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);

1146: dbms_sql.bind_variable(cid,':b_link_table', g_enc_table_alias);
1147: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1148: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1149: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1150: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1151: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1152: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1153:
1154: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);

Line 1151: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);

1147: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1148: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1149: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1150: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1151: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1152: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1153:
1154: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1155: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);

Line 1152: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);

1148: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1149: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1150: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1151: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1152: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1153:
1154: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1155: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);
1156:

Line 1154: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);

1150: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1151: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1152: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1153:
1154: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1155: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);
1156:
1157: rows_processed := dbms_sql.execute(cid);
1158: dbms_sql.close_cursor(cid);

Line 1155: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);

1151: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1152: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1153:
1154: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1155: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);
1156:
1157: rows_processed := dbms_sql.execute(cid);
1158: dbms_sql.close_cursor(cid);
1159: g_sob_rows_created := g_sob_rows_created + rows_processed;

Line 1157: rows_processed := dbms_sql.execute(cid);

1153:
1154: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1155: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);
1156:
1157: rows_processed := dbms_sql.execute(cid);
1158: dbms_sql.close_cursor(cid);
1159: g_sob_rows_created := g_sob_rows_created + rows_processed;
1160:
1161: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1158: dbms_sql.close_cursor(cid);

1154: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1155: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);
1156:
1157: rows_processed := dbms_sql.execute(cid);
1158: dbms_sql.close_cursor(cid);
1159: g_sob_rows_created := g_sob_rows_created + rows_processed;
1160:
1161: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1162: xla_message('XLA_GLT_INSERTED_ENC_LINES','COUNT',rows_processed,'','','','',

Line 1449: cid := dbms_sql.open_cursor;

1445: 0,Decode(Sign(ael.entered_cr), 1,''cr'', -1, ''cr'',''dr''),''cr'')
1446: '|| l_group_by_actual_flag;
1447: END IF;
1448:
1449: cid := dbms_sql.open_cursor;
1450: dbms_sql.parse(cid, statement_summary, dbms_sql.native);
1451:
1452: --Bind Variables
1453: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);

Line 1450: dbms_sql.parse(cid, statement_summary, dbms_sql.native);

1446: '|| l_group_by_actual_flag;
1447: END IF;
1448:
1449: cid := dbms_sql.open_cursor;
1450: dbms_sql.parse(cid, statement_summary, dbms_sql.native);
1451:
1452: --Bind Variables
1453: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1454: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);

Line 1453: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);

1449: cid := dbms_sql.open_cursor;
1450: dbms_sql.parse(cid, statement_summary, dbms_sql.native);
1451:
1452: --Bind Variables
1453: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1454: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1455: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1456: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1457: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);

Line 1454: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);

1450: dbms_sql.parse(cid, statement_summary, dbms_sql.native);
1451:
1452: --Bind Variables
1453: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1454: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1455: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1456: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1457: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1458: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);

Line 1455: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);

1451:
1452: --Bind Variables
1453: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1454: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1455: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1456: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1457: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1458: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1459: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);

Line 1456: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);

1452: --Bind Variables
1453: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1454: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1455: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1456: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1457: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1458: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1459: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);
1460: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);

Line 1457: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);

1453: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1454: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1455: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1456: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1457: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1458: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1459: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);
1460: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1461: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

Line 1458: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);

1454: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1455: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1456: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1457: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1458: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1459: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);
1460: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1461: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1462: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);

Line 1459: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);

1455: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1456: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1457: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1458: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1459: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);
1460: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1461: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1462: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1463: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);

Line 1460: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);

1456: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1457: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1458: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1459: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);
1460: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1461: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1462: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1463: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1464: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);

Line 1461: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

1457: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1458: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1459: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);
1460: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1461: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1462: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1463: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1464: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1465: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);

Line 1462: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);

1458: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1459: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);
1460: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1461: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1462: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1463: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1464: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1465: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1466: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);

Line 1463: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);

1459: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);
1460: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1461: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1462: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1463: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1464: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1465: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1466: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1467: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);

Line 1464: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);

1460: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1461: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1462: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1463: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1464: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1465: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1466: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1467: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);
1468: dbms_sql.bind_variable(cid,':b_program_name', g_program_name);

Line 1465: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);

1461: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1462: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1463: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1464: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1465: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1466: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1467: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);
1468: dbms_sql.bind_variable(cid,':b_program_name', g_program_name);
1469:

Line 1466: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);

1462: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1463: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1464: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1465: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1466: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1467: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);
1468: dbms_sql.bind_variable(cid,':b_program_name', g_program_name);
1469:
1470: IF p_gl_transfer_mode = 'P' THEN

Line 1467: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);

1463: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1464: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1465: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1466: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1467: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);
1468: dbms_sql.bind_variable(cid,':b_program_name', g_program_name);
1469:
1470: IF p_gl_transfer_mode = 'P' THEN
1471: dbms_sql.bind_variable(cid,':b_period_name', p_period_name);

Line 1468: dbms_sql.bind_variable(cid,':b_program_name', g_program_name);

1464: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1465: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1466: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1467: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);
1468: dbms_sql.bind_variable(cid,':b_program_name', g_program_name);
1469:
1470: IF p_gl_transfer_mode = 'P' THEN
1471: dbms_sql.bind_variable(cid,':b_period_name', p_period_name);
1472: END IF;

Line 1471: dbms_sql.bind_variable(cid,':b_period_name', p_period_name);

1467: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);
1468: dbms_sql.bind_variable(cid,':b_program_name', g_program_name);
1469:
1470: IF p_gl_transfer_mode = 'P' THEN
1471: dbms_sql.bind_variable(cid,':b_period_name', p_period_name);
1472: END IF;
1473:
1474: rows_processed := dbms_sql.execute(cid);
1475:

Line 1474: rows_processed := dbms_sql.execute(cid);

1470: IF p_gl_transfer_mode = 'P' THEN
1471: dbms_sql.bind_variable(cid,':b_period_name', p_period_name);
1472: END IF;
1473:
1474: rows_processed := dbms_sql.execute(cid);
1475:
1476: IF rows_processed = 0 THEN
1477: g_proceed := 'N';
1478: ELSE

Line 1482: dbms_sql.close_cursor(cid);

1478: ELSE
1479: g_sob_rows_created := g_sob_rows_created + rows_processed;
1480: g_rec_transfer_flag := 'Y'; --set the globle flag to 'Y' whenever there are records transferred.
1481: END IF;
1482: dbms_sql.close_cursor(cid);
1483:
1484: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1485: xla_message('XLA_GLT_GL_INSERT','COUNT','(summary) ' || rows_processed,'','','','',
1486: l_log_module,

Line 1665: cid := dbms_sql.open_cursor;

1661: || l_where;
1662: END IF;
1663:
1664:
1665: cid := dbms_sql.open_cursor;
1666: dbms_sql.parse(cid, statement_detail, dbms_sql.native);
1667:
1668: --Bind Variables
1669: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);

Line 1666: dbms_sql.parse(cid, statement_detail, dbms_sql.native);

1662: END IF;
1663:
1664:
1665: cid := dbms_sql.open_cursor;
1666: dbms_sql.parse(cid, statement_detail, dbms_sql.native);
1667:
1668: --Bind Variables
1669: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1670: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);

Line 1669: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);

1665: cid := dbms_sql.open_cursor;
1666: dbms_sql.parse(cid, statement_detail, dbms_sql.native);
1667:
1668: --Bind Variables
1669: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1670: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1671: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1672: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1673: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);

Line 1670: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);

1666: dbms_sql.parse(cid, statement_detail, dbms_sql.native);
1667:
1668: --Bind Variables
1669: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1670: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1671: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1672: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1673: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1674: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);

Line 1671: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);

1667:
1668: --Bind Variables
1669: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1670: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1671: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1672: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1673: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1674: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1675: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);

Line 1672: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);

1668: --Bind Variables
1669: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1670: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1671: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1672: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1673: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1674: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1675: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1676: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);

Line 1673: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);

1669: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1670: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1671: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1672: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1673: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1674: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1675: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1676: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);
1677: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);

Line 1674: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);

1670: dbms_sql.bind_variable(cid,':b_user_id', g_user_id);
1671: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1672: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1673: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1674: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1675: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1676: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);
1677: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1678: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

Line 1675: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);

1671: dbms_sql.bind_variable(cid,':b_group_id', p_group_id);
1672: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1673: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1674: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1675: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1676: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);
1677: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1678: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1679: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);

Line 1676: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);

1672: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1673: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1674: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1675: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1676: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);
1677: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1678: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1679: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1680: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);

Line 1677: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);

1673: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1674: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1675: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1676: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);
1677: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1678: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1679: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1680: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1681: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);

Line 1678: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

1674: dbms_sql.bind_variable(cid,':b_source_name', p_source_name);
1675: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1676: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);
1677: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1678: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1679: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1680: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1681: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1682: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);

Line 1679: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);

1675: dbms_sql.bind_variable(cid,':b_batch_name', g_batch_name);
1676: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);
1677: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1678: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1679: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1680: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1681: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1682: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1683: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);

Line 1680: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);

1676: dbms_sql.bind_variable(cid,':b_link_table', g_actual_table_alias);
1677: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1678: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1679: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1680: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1681: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1682: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1683: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1684: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);

Line 1681: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);

1677: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1678: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1679: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1680: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1681: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1682: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1683: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1684: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);
1685:

Line 1682: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);

1678: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1679: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1680: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1681: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1682: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1683: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1684: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);
1685:
1686: rows_processed := dbms_sql.execute(cid);

Line 1683: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);

1679: dbms_sql.bind_variable(cid,':b_batch_desc', p_batch_desc);
1680: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1681: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1682: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1683: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1684: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);
1685:
1686: rows_processed := dbms_sql.execute(cid);
1687:

Line 1684: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);

1680: dbms_sql.bind_variable(cid,':b_je_desc', p_je_desc);
1681: dbms_sql.bind_variable(cid,':b_je_line_desc', p_je_line_desc);
1682: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1683: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1684: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);
1685:
1686: rows_processed := dbms_sql.execute(cid);
1687:
1688: IF rows_processed = 0 THEN

Line 1686: rows_processed := dbms_sql.execute(cid);

1682: dbms_sql.bind_variable(cid,':b_next_period', p_next_period);
1683: dbms_sql.bind_variable(cid,':b_reversal_date', p_reversal_date);
1684: dbms_sql.bind_variable(cid,':b_average_balances_flag', p_average_balances_flag);
1685:
1686: rows_processed := dbms_sql.execute(cid);
1687:
1688: IF rows_processed = 0 THEN
1689: g_proceed := 'N';
1690: ELSE

Line 1694: dbms_sql.close_cursor(cid);

1690: ELSE
1691: g_sob_rows_created := g_sob_rows_created + rows_processed;
1692: g_rec_transfer_flag := 'Y'; --set the globle flag to 'Y' whenever there are records transferred.
1693: END IF;
1694: dbms_sql.close_cursor(cid);
1695:
1696: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1697: xla_message('XLA_GLT_GL_INSERT','COUNT','(Detail) ' || rows_processed,'','','','',
1698: l_log_module,

Line 1816: cid := dbms_sql.open_cursor;

1812: ,p_module => l_log_module);
1813: END IF;
1814:
1815:
1816: cid := dbms_sql.open_cursor;
1817: dbms_sql.parse(cid, statement, dbms_sql.native);
1818:
1819: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1820: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);

Line 1817: dbms_sql.parse(cid, statement, dbms_sql.native);

1813: END IF;
1814:
1815:
1816: cid := dbms_sql.open_cursor;
1817: dbms_sql.parse(cid, statement, dbms_sql.native);
1818:
1819: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1820: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1821: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);

Line 1819: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);

1815:
1816: cid := dbms_sql.open_cursor;
1817: dbms_sql.parse(cid, statement, dbms_sql.native);
1818:
1819: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1820: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1821: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1822: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1823: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

Line 1820: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);

1816: cid := dbms_sql.open_cursor;
1817: dbms_sql.parse(cid, statement, dbms_sql.native);
1818:
1819: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1820: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1821: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1822: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1823: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1824: dbms_sql.bind_variable(cid,':b_actual_table_alias', g_actual_table_alias);

Line 1821: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);

1817: dbms_sql.parse(cid, statement, dbms_sql.native);
1818:
1819: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1820: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1821: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1822: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1823: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1824: dbms_sql.bind_variable(cid,':b_actual_table_alias', g_actual_table_alias);
1825:

Line 1822: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);

1818:
1819: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1820: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1821: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1822: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1823: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1824: dbms_sql.bind_variable(cid,':b_actual_table_alias', g_actual_table_alias);
1825:
1826: rows_processed := dbms_sql.execute(cid);

Line 1823: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

1819: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1820: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1821: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1822: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1823: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1824: dbms_sql.bind_variable(cid,':b_actual_table_alias', g_actual_table_alias);
1825:
1826: rows_processed := dbms_sql.execute(cid);
1827:

Line 1824: dbms_sql.bind_variable(cid,':b_actual_table_alias', g_actual_table_alias);

1820: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1821: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1822: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1823: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1824: dbms_sql.bind_variable(cid,':b_actual_table_alias', g_actual_table_alias);
1825:
1826: rows_processed := dbms_sql.execute(cid);
1827:
1828: dbms_sql.close_cursor(cid);

Line 1826: rows_processed := dbms_sql.execute(cid);

1822: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1823: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1824: dbms_sql.bind_variable(cid,':b_actual_table_alias', g_actual_table_alias);
1825:
1826: rows_processed := dbms_sql.execute(cid);
1827:
1828: dbms_sql.close_cursor(cid);
1829:
1830: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 1828: dbms_sql.close_cursor(cid);

1824: dbms_sql.bind_variable(cid,':b_actual_table_alias', g_actual_table_alias);
1825:
1826: rows_processed := dbms_sql.execute(cid);
1827:
1828: dbms_sql.close_cursor(cid);
1829:
1830: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1831: trace
1832: (p_msg => 'END of procedure update_linkid_summary'

Line 1892: cid := dbms_sql.open_cursor;

1888: ,p_module => l_log_module);
1889: END IF;
1890:
1891:
1892: cid := dbms_sql.open_cursor;
1893: dbms_sql.parse(cid, statement, dbms_sql.native);
1894:
1895: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1896: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);

Line 1893: dbms_sql.parse(cid, statement, dbms_sql.native);

1889: END IF;
1890:
1891:
1892: cid := dbms_sql.open_cursor;
1893: dbms_sql.parse(cid, statement, dbms_sql.native);
1894:
1895: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1896: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1897: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);

Line 1895: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);

1891:
1892: cid := dbms_sql.open_cursor;
1893: dbms_sql.parse(cid, statement, dbms_sql.native);
1894:
1895: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1896: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1897: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1898: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1899: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

Line 1896: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);

1892: cid := dbms_sql.open_cursor;
1893: dbms_sql.parse(cid, statement, dbms_sql.native);
1894:
1895: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1896: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1897: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1898: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1899: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1900:

Line 1897: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);

1893: dbms_sql.parse(cid, statement, dbms_sql.native);
1894:
1895: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1896: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1897: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1898: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1899: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1900:
1901: rows_processed := dbms_sql.execute(cid);

Line 1898: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);

1894:
1895: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1896: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1897: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1898: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1899: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1900:
1901: rows_processed := dbms_sql.execute(cid);
1902:

Line 1899: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);

1895: dbms_sql.bind_variable(cid,':b_transfer_run_id', p_transfer_run_id);
1896: dbms_sql.bind_variable(cid,':b_request_id', p_request_id);
1897: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1898: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1899: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1900:
1901: rows_processed := dbms_sql.execute(cid);
1902:
1903: IF rows_processed = 0 THEN

Line 1901: rows_processed := dbms_sql.execute(cid);

1897: dbms_sql.bind_variable(cid,':b_program_id', g_program_id);
1898: dbms_sql.bind_variable(cid,':b_start_date', p_start_date);
1899: dbms_sql.bind_variable(cid,':b_end_date', p_end_date);
1900:
1901: rows_processed := dbms_sql.execute(cid);
1902:
1903: IF rows_processed = 0 THEN
1904: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1905: xla_message('XLA_GLT_NO_ACCT_LINES','','','','','','',

Line 1912: dbms_sql.close_cursor(cid);

1908: END IF;
1909:
1910: g_proceed := 'N';
1911: END IF;
1912: dbms_sql.close_cursor(cid);
1913:
1914: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1915: trace
1916: (p_msg => 'END of procedure UPDATE_LINKID_DETAIL'