DBA Data[Home] [Help]

APPS.GR_PROCESS_DOCUMENTS_INSERTS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 33

PROCEDURE Worksheet_Insert_Row
                (p_line_number IN OUT NOCOPY NUMBER,
                 p_output_type IN VARCHAR2,
                 p_user_id IN NUMBER,
                 p_current_date IN DATE,
                 p_language_code IN VARCHAR2,
                 p_session_id IN NUMBER,
                 p_item_code IN VARCHAR2,
                 p_print_font IN VARCHAR2,
                 p_print_size IN NUMBER,
                 p_text_line IN VARCHAR2,
                 p_line_type IN VARCHAR2,
                 x_return_status OUT NOCOPY VARCHAR2)
IS

/*  ------------- LOCAL VARIABLES ------------------- */
L_TEXT_LINE          GR_WORK_WORKSHEETS.text_line%TYPE;
Line: 62

   SELECT   om.orgn_name,
            oa.addr1,
            oa.addr2,
            oa.addr3,
            oa.addr4,
            oa.postal_code,
            oa.state_code,
            oa.country_code,
            oc.daytime_contact_name,
            oc.daytime_telephone,
            oc.daytime_extension,
            oc.daytime_area_code,
            oc.evening_contact_name,
            oc.evening_telephone,
            oc.evening_extension,
            oc.evening_area_code,
            oc.daytime_fax_no,
            oc.daytime_email,
            oc.evening_fax_no,
            oc.evening_email
   FROM     gr_organization_contacts oc,
            sy_addr_mst oa,
            sy_orgn_mst om
   WHERE    om.orgn_code = l_default_orgn
   AND      om.addr_id = oa.addr_id
   AND      oc.orgn_code = om.orgn_code;
Line: 92

   SELECT   lab.data_position_indicator,
            lat.label_description
   FROM     gr_labels_tl lat,
            gr_labels_b lab
   WHERE    lab.label_code = l_label_code
   AND      lat.label_code = lab.label_code
   AND      lat.language = l_language_code;
Line: 106

   SELECT   geog_desc
   FROM     sy_geog_mst
   WHERE    geog_type = 1
   AND      geog_code = V_country_code;
Line: 130

   /* M. Grosser 27-Feb-2003 BUG 2718956 - Put an IF statment around the selection of
                        organization data and the error message associated with it.
                        It is only applicable to organization data.
   */
   IF l_text_line in ('01100','01101','01102','01103','01104','01105','01106','01107','01008') THEN
      OPEN c_get_orgn_info;
Line: 168

         Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
                p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Line: 176

            Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
                   p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Line: 187

            Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
                   p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Line: 198

            Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
                   p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Line: 208

            Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
                   p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Line: 233

            Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
                   p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Line: 251

            Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
                   p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Line: 290

               Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
                      p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Line: 336

               Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
                      p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Line: 374

               Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
                      p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Line: 420

               Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
                      p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Line: 456

               Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
                      p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Line: 493

               Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
                      p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Line: 529

               Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
                      p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Line: 565

               Insert_Gr_Work_Worksheets (p_output_type,p_line_number,p_session_id,
                      p_item_code, p_print_font, p_print_size,l_text_line, p_line_type, x_return_status);
Line: 591

      INSERT INTO gr_work_worksheets
                (session_id,
                 text_line_number,
                 item_code,
                 print_font,
                 print_size,
                 text_line,
                 line_type)
          VALUES
                (p_session_id,
                 p_line_number,
                 p_item_code,
                 p_print_font,
                 p_print_size,
                 l_text_line,
                 p_line_type);
Line: 611

      FND_FILE.PUT(FND_FILE.LOG,'   WORKSHEET INSERT: '||sqlerrm);
Line: 615

END Worksheet_Insert_Row;
Line: 649

PROCEDURE Document_Insert_Row
                (p_line_number IN OUT NOCOPY NUMBER,
                 p_output_type IN VARCHAR2,
                 p_document_text_id IN NUMBER,
                 p_user_id IN NUMBER,
                 p_current_date IN DATE,
                 p_session_id IN NUMBER,
                 p_item_code IN VARCHAR2,
                 p_print_font IN VARCHAR2,
                 p_print_size IN NUMBER,
                 p_text_line IN VARCHAR2,
                 p_line_type IN VARCHAR2,
                 x_return_status OUT NOCOPY VARCHAR2,
                 x_msg_data OUT NOCOPY VARCHAR2)


 IS

/*  ------------- LOCAL VARIABLES ------------------- */
/*	Alpha Variables */
L_COMMIT            VARCHAR2(1) := 'F';
Line: 700

   GR_DOCUMENT_DETAILS_PKG.Insert_Row
                 (l_commit,
                  l_called_by_form,
                  p_line_number,
                  p_document_text_id,
                  p_print_font,
                  p_print_size,
                  p_text_line,
                  p_line_type,
                  p_user_id,
                  p_current_date,
                  p_user_id,
                  p_current_date,
                  p_user_id,
                  l_rowid,
                  l_return_status,
                  l_oracle_error,
                  l_msg_data);
Line: 725

END Document_Insert_Row;
Line: 765

PROCEDURE Insert_Work_Row
                (p_session_id IN NUMBER,
                 p_document_code IN VARCHAR2,
                 p_main_heading_code IN VARCHAR2,
                 p_main_display_order IN NUMBER,
                 p_sub_heading_code IN VARCHAR2,
                 p_sub_display_order IN NUMBER,
                 p_record_type IN VARCHAR2,
                 p_label_or_phrase_code IN VARCHAR2,
                 p_concentration_percent IN NUMBER,
                 p_label_class IN VARCHAR2,
                 p_phrase_hierarchy IN NUMBER,
                 p_phrase_type IN VARCHAR2,
                 p_print_flag IN VARCHAR2,
                 p_source_itemcode IN VARCHAR2,
                 p_structure_display_order IN NUMBER,
                 x_return_status OUT NOCOPY VARCHAR2,
                 x_msg_data OUT NOCOPY VARCHAR2)
 IS


/*  ------------- LOCAL VARIABLES ------------------- */
/*	Alpha Variables */
L_CODE_BLOCK      VARCHAR2(2000);
Line: 789

L_UPDATE_OK       VARCHAR2(2);
Line: 800

   SELECT   wbd.print_flag
   FROM     gr_work_build_docs wbd
   WHERE    wbd.document_code = p_document_code
   AND      wbd.main_heading_code = p_main_heading_code
   AND      wbd.sub_heading_code = p_sub_heading_code
   AND      wbd.record_type = p_label_or_phrase_code
   AND		wbd.label_or_phrase_code = p_label_or_phrase_code;
Line: 811

   SAVEPOINT Insert_Work_Row;
Line: 816

      l_update_ok := 'YS';
Line: 821

	     l_update_ok := 'YS';
Line: 823

	     l_update_ok := 'NO';
Line: 828

   IF l_update_ok = 'YS' THEN
      INSERT INTO gr_work_build_docs
            (session_id,
             sequence_number,
             document_code,
             main_heading_code,
             main_display_order,
             sub_heading_code,
             sub_display_order,
             record_type,
             label_or_phrase_code,
             concentration_percent,
             label_class,
             phrase_hierarchy,
             phrase_type,
             print_flag,
             source_itemcode,
             structure_display_order)
          VALUES
            (p_session_id,
             gr_work_build_docs_s.nextval,
             p_document_code,
             p_main_heading_code,
             p_main_display_order,
             p_sub_heading_code,
             p_sub_display_order,
             p_record_type,
             p_label_or_phrase_code,
             p_concentration_percent,
             p_label_class,
             p_phrase_hierarchy,
             p_phrase_type,
             p_print_flag,
             p_source_itemcode,
             p_structure_display_order);
Line: 867

      ROLLBACK TO SAVEPOINT Insert_Work_Row;
Line: 875

END Insert_Work_Row;
Line: 905

PROCEDURE Insert_Data_Record
            (p_line_number IN OUT NOCOPY NUMBER,
             p_line_type IN VARCHAR2,
             p_output_type IN VARCHAR2,
             p_user_id IN NUMBER,
             p_current_date IN DATE,
             p_language_code IN VARCHAR2,
             p_document_text_id IN NUMBER,
             p_session_id IN NUMBER,
             p_document_item IN VARCHAR2,
             p_print_font IN VARCHAR2,
             p_print_size IN NUMBER,
             p_text_line_1 IN VARCHAR2,
             p_text_line_2 IN VARCHAR2,
             p_source_action IN VARCHAR2,
             x_return_status OUT NOCOPY VARCHAR2)
 IS

/*  ------------- LOCAL VARIABLES ------------------- */
L_RETURN_STATUS          VARCHAR2(1);
Line: 929

WORKSHEET_INSERT_ERROR   EXCEPTION;
Line: 930

DOCUMENT_INSERT_ERROR    EXCEPTION;
Line: 945

      Worksheet_Insert_Row
          (p_line_number,
           p_output_type,
           p_user_id,
           p_current_date,
           p_language_code,
           p_session_id,
           p_document_item,
           p_print_font,
           p_print_size,
           p_text_line_1,
           l_line_type,
           l_return_status);
Line: 960

         RAISE Worksheet_Insert_Error;
Line: 964

         Worksheet_Insert_Row
             (p_line_number,
              p_output_type,
              p_user_id,
              p_current_date,
              p_language_code,
              p_session_id,
              p_document_item,
              p_print_font,
              p_print_size,
              p_text_line_2,
              l_line_type,
              l_return_status);
Line: 979

            RAISE Worksheet_Insert_Error;
Line: 984

     Document_Insert_Row
            (p_line_number,
             p_output_type,
             p_document_text_id,
             p_user_id,
             p_current_date,
             p_session_id,
             p_document_item,
             p_print_font,
             p_print_size,
             p_text_line_1,
             l_line_type,
             l_return_status,
             l_msg_data);
Line: 1000

        RAISE Worksheet_Insert_Error;
Line: 1004

        Document_Insert_Row
            (p_line_number,
             p_output_type,
             p_document_text_id,
             p_user_id,
             p_current_date,
             p_session_id,
             p_document_item,
             p_print_font,
             p_print_size,
             p_text_line_2,
             l_line_type,
             l_return_status,
             l_msg_data);
Line: 1021

           RAISE Worksheet_Insert_Error;
Line: 1029

   WHEN Document_Insert_Error THEN
      x_return_status := FND_API.G_RET_STS_ERROR;
Line: 1032

   WHEN Worksheet_Insert_Error THEN
      x_return_status := FND_API.G_RET_STS_ERROR;
Line: 1038

END Insert_Data_Record;
Line: 1069

PROCEDURE Insert_Gr_Work_Worksheets
           (p_output_type IN VARCHAR2,
            p_line_number IN OUT NOCOPY NUMBER,
            p_session_id IN NUMBER,
            p_item_code IN VARCHAR2,
            p_print_font IN VARCHAR2,
            p_print_size IN NUMBER,
            p_text_line IN VARCHAR2,
            p_line_type IN VARCHAR2,
            x_return_status OUT NOCOPY VARCHAR2)
  IS

BEGIN
   x_return_status := 'S';
Line: 1091

   INSERT INTO gr_work_worksheets
       (session_id,
        text_line_number,
        item_code,
        print_font,
        print_size,
        text_line,
        line_type)
   VALUES
       (p_session_id,
        p_line_number,
        p_item_code,
        p_print_font,
        p_print_size,
        p_text_line,
        p_line_type);
Line: 1110

      FND_FILE.PUT(FND_FILE.LOG,' PROCEDURE WORKSHEET INSERT: '||sqlerrm);
Line: 1114

END Insert_Gr_Work_Worksheets;
Line: 1144

PROCEDURE Insert_XML_Data
          (p_line_number IN OUT NOCOPY NUMBER,
           p_output_type IN VARCHAR2,
           p_user_id IN NUMBER,
           p_current_date IN DATE,
           p_language_code IN VARCHAR2,
           p_document_text_id IN NUMBER,
           p_session_id IN NUMBER,
           p_document_item IN VARCHAR2,
           p_print_font  IN VARCHAR2,
           p_print_size  IN NUMBER,
           p_value IN  VARCHAR2,
           p_line_type IN  VARCHAR2,
           p_source IN VARCHAR2,
           x_return_status OUT NOCOPY VARCHAR2)
  IS

/*  ------------- LOCAL VARIABLES ------------------- */
L_RETURN_STATUS   VARCHAR2(4);
Line: 1167

WORKSHEET_INSERT_ERROR	        EXCEPTION;
Line: 1176

      Insert_Data_Record
            (p_line_number,
             p_line_type,
             p_output_type,
             p_user_id,
             p_current_date,
             p_language_code,
             p_document_text_id,
             p_session_id,
             p_document_item,
             p_print_font,
             p_print_size,
             p_value,
             NULL,
             p_source,
             l_return_status);
Line: 1194

           RAISE Worksheet_Insert_Error;
Line: 1200

   WHEN Worksheet_Insert_Error THEN
      x_return_status := FND_API.G_RET_STS_ERROR;
Line: 1205

END Insert_XML_Data;
Line: 1208

END GR_PROCESS_DOCUMENTS_INSERTS;