DBA Data[Home] [Help]

APPS.ICX_QUESTIONS_ADMIN SQL Statements

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

Line: 290

    SELECT  FND.APPLICATION_SHORT_NAME,
            ICX.APPLICATION_ID,
            ICX.QUESTION_CODE,
            ICX.QUESTION
    FROM    ICX_QUESTIONS_VL ICX, FND_APPLICATION_VL FND
    WHERE   ICX.QUESTION_CODE LIKE UPPER(P_QUESTION_CODE) || '%'
    AND     ICX.QUESTION LIKE '%' ||P_QUESTION || '%'
    AND     ICX.TYPE = 'QUESTION'
    AND     (FND.APPLICATION_SHORT_NAME LIKE
                UPPER(P_APPLICATION_SHORT_NAME)||'%' OR
            P_APPLICATION_SHORT_NAME IS NULL)
    AND     FND.APPLICATION_ID = ICX.APPLICATION_ID
    ORDER   BY FND.APPLICATION_SHORT_NAME, ICX.QUESTION_CODE;
Line: 348

		  wf_core.translate('DELETE')||'',
		  calign=>'Center');
Line: 366

                      '&p_insert=FALSE'||
                      '&p_find_criteria='||l_find_criteria,
                  ctext=>questions.question_code, ctarget=>'_top'),
                  'Left');
Line: 381

                      '/icx_questions_admin.question_confirm_delete'||
                      '?p_application_id='||questions.application_id||
                      '&p_question_code='||wfa_html.conv_special_url_chars(questions.question_code)||
                      '&p_find_criteria='||l_find_criteria,
                      ctext=>''),
                      'center', cattributes=>'valign="MIDDLE"');
Line: 400

                      '?p_insert=TRUE'||
                      '&p_find_criteria='||l_find_criteria;
Line: 437

 P_INSERT                       IN  VARCHAR2     DEFAULT NULL
)
IS

L_APPLICATION_SHORT_NAME VARCHAR2(50)   := NULL;
Line: 459

  if (P_INSERT = 'FALSE' AND P_ERROR_MESSAGE IS NULL) THEN

     SELECT  FND.APPLICATION_SHORT_NAME,
             ICX.APPLICATION_ID,
             ICX.QUESTION_CODE,
             ICX.QUESTION
     INTO    L_APPLICATION_SHORT_NAME,
             L_APPLICATION_ID,
             L_QUESTION_CODE,
             L_QUESTION
     FROM    ICX_QUESTIONS_VL ICX, FND_APPLICATION_VL FND
     WHERE   ICX.QUESTION_CODE = P_QUESTION_CODE
     AND     ICX.TYPE = 'QUESTION'
     AND     ICX.APPLICATION_ID = P_APPLICATION_ID
     AND     FND.APPLICATION_ID = ICX.APPLICATION_ID;
Line: 508

  if (P_INSERT = 'FALSE') THEN

     htp.p('
');
Line: 514

     htp.p('');
Line: 552

  IF (P_INSERT = 'FALSE') THEN

     htp.formHidden(cname=>'p_question_code',  cvalue=>l_question_code);
Line: 640

procedure INSERT_QUESTION
(
 P_APPLICATION_ID               IN  VARCHAR2     DEFAULT NULL,
 P_QUESTION_CODE		IN  VARCHAR2     DEFAULT NULL,
 P_APPLICATION_SHORT_NAME       IN  VARCHAR2     DEFAULT NULL,
 P_QUESTION     	        IN  VARCHAR2     DEFAULT NULL,
 P_FIND_CRITERIA                IN  VARCHAR2     DEFAULT NULL
)
IS

L_ROWID            VARCHAR2(64);
Line: 657

   SELECT COUNT(*)
   INTO   l_count
   FROM   FND_APPLICATION_VL FND
   WHERE  FND.APPLICATION_SHORT_NAME = UPPER(P_APPLICATION_SHORT_NAME);
Line: 668

   SELECT count(*)
   INTO   l_count
   FROM   ICX_QUESTIONS ICX
   WHERE  ICX.QUESTION_CODE = UPPER(P_QUESTION_CODE);
Line: 693

            '&p_insert=TRUE'||
            '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria)||
            '&p_question='||wfa_html.conv_special_url_chars(p_question),
   		    bclose_header=>TRUE);
Line: 700

      SELECT APPLICATION_ID
      INTO   L_APPLICATION_ID
      FROM   FND_APPLICATION_VL FND
      WHERE  FND.APPLICATION_SHORT_NAME = UPPER(P_APPLICATION_SHORT_NAME);
Line: 705

      ICX_QUESTIONS_PKG.INSERT_ROW (
          L_ROWID,
          UPPER(P_QUESTION_CODE),
          L_APPLICATION_ID,
          'QUESTION',
          P_QUESTION,
          sysdate,
          1,
          sysdate,
          1,
         1);
Line: 727

    wf_core.context('icx_questions_admin', 'insert_question');
Line: 730

END insert_question;
Line: 736

procedure UPDATE_QUESTION
(
 P_APPLICATION_ID               IN  VARCHAR2     DEFAULT NULL,
 P_QUESTION_CODE		IN  VARCHAR2     DEFAULT NULL,
 P_APPLICATION_SHORT_NAME       IN  VARCHAR2     DEFAULT NULL,
 P_QUESTION     	        IN  VARCHAR2     DEFAULT NULL,
 P_FIND_CRITERIA                IN  VARCHAR2     DEFAULT NULL
)
IS

L_COUNT            NUMBER;
Line: 751

   SELECT COUNT(*)
   INTO   l_count
   FROM   FND_APPLICATION_VL FND
   WHERE  FND.APPLICATION_SHORT_NAME = UPPER(P_APPLICATION_SHORT_NAME);
Line: 776

            '&p_insert=FALSE'||
            '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria)||
            '&p_question='||wfa_html.conv_special_url_chars(p_question),
   		    bclose_header=>TRUE);
Line: 783

      ICX_QUESTIONS_PKG.UPDATE_ROW (
          P_QUESTION_CODE,
          P_APPLICATION_ID,
          'QUESTION',
          P_QUESTION,
          sysdate,
         1,
         1);
Line: 800

    wf_core.context('icx_questions_admin', 'update_question');
Line: 803

END update_question;
Line: 807

Function	question_confirm_delete

Purpose		Provide a confirmation message to delete a message

============================================================================*/
procedure question_confirm_delete
(p_application_id  IN VARCHAR2   DEFAULT NULL,
p_question_code   IN VARCHAR2   DEFAULT NULL,
p_find_criteria   IN VARCHAR2   DEFAULT NULL
)
IS
  username             varchar2(240);
Line: 844

  htp.tabledata(wf_core.translate('ICX_CONFIRM_DELETE_MESSAGE') || ': ' ||
                ''||p_question_code||'');
Line: 852

  l_url         := wfa_html.base_url||'/icx_questions_admin.delete_question'||
                   '?p_application_id='||p_application_id||
                   '&p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
                   '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
Line: 882

    wf_core.context('icx_questions_admin', 'question_confirm_delete');
Line: 884

END Question_Confirm_Delete;
Line: 891

procedure DELETE_QUESTION
(
 P_APPLICATION_ID               IN  VARCHAR2     DEFAULT NULL,
 P_QUESTION_CODE		IN  VARCHAR2     DEFAULT NULL,
 P_FIND_CRITERIA                IN  VARCHAR2     DEFAULT NULL
)
IS

BEGIN

   delete from icx_question_functions where question_code = p_question_code;
Line: 902

   delete from icx_questions_tl where question_code = p_question_code;
Line: 903

   delete from icx_questions where question_code = p_question_code;
Line: 911

    wf_core.context('icx_questions_admin', 'delete_question');
Line: 914

END delete_question;
Line: 933

SELECT
 application_id,
 application_short_name,
 application_name
FROM   fnd_application_vl
WHERE  application_short_name like UPPER(c_find_criteria)
ORDER  BY application_short_name;
Line: 942

SELECT
 application_short_name
FROM   fnd_application_vl
WHERE  application_id = c_id;
Line: 964

   select count(*)
   into   l_total_rows
   FROM   fnd_application_vl
   WHERE  application_short_name like UPPER(p_display_value||'%');
Line: 1038

    SELECT  FND.FUNCTION_NAME,
            FND.FUNCTION_ID,
            FND.USER_FUNCTION_NAME
    FROM    ICX_QUESTION_FUNCTIONS ICX, FND_FORM_FUNCTIONS_VL FND
    WHERE   ICX.QUESTION_CODE = P_QUESTION_CODE
    AND     ICX.FUNCTION_NAME = FND.FUNCTION_NAME
    ORDER   BY FND.FUNCTION_NAME;
Line: 1079

		  wf_core.translate('DELETE')||'',
		  calign=>'Center');
Line: 1098

                      '&p_insert=FALSE'||
                      '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
                  ctext=>functions.function_name, ctarget=>'_top'),
                  'Left');
Line: 1106

                      '/icx_questions_admin.delete_function'||
                      '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
                      '&p_function_name='||wfa_html.conv_special_url_chars(functions.function_name)||
                      '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
                      ctext=>''),
                      'center', cattributes=>'valign="MIDDLE"');
Line: 1126

                      '&p_insert=TRUE'||
                      '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
Line: 1172

 P_INSERT                       IN  VARCHAR2     DEFAULT NULL,
 P_ERROR_MESSAGE                IN  VARCHAR2     DEFAULT NULL,
 P_FIND_CRITERIA                IN  VARCHAR2     DEFAULT NULL
)
IS

L_FUNCTION_ID            NUMBER         := 0;
Line: 1195

  if (P_INSERT = 'FALSE' AND P_ERROR_MESSAGE IS NULL) THEN

     SELECT  FND.FUNCTION_ID,
             FND.FUNCTION_NAME,
             FND.USER_FUNCTION_NAME
     INTO    L_FUNCTION_ID,
             L_FUNCTION_NAME,
             L_USER_FUNCTION_NAME
     FROM    FND_FORM_FUNCTIONS_VL FND
     WHERE   FND.FUNCTION_ID = P_FUNCTION_ID;
Line: 1237

  if (P_INSERT = 'FALSE') THEN

     htp.p('');
Line: 1243

     htp.p('');
Line: 1369

SELECT FND.FUNCTION_ID,
       FND.FUNCTION_NAME,
       FND.USER_FUNCTION_NAME
FROM   FND_FORM_FUNCTIONS_VL FND
WHERE  FND.FUNCTION_NAME like upper(c_find_criteria)
ORDER  BY fnd.function_name;
Line: 1377

SELECT
 application_short_name
FROM   fnd_application_vl
WHERE  application_id = c_id;
Line: 1399

   select count(*)
   into   l_total_rows
   FROM   FND_FORM_FUNCTIONS_VL FND
   WHERE  FND.FUNCTION_NAME like upper(p_display_value||'%');
Line: 1456

procedure INSERT_FUNCTION
(
 P_FUNCTION_ID                  IN  VARCHAR2     DEFAULT NULL,
 P_OLD_FUNCTION_NAME		IN  VARCHAR2     DEFAULT NULL,
 P_FUNCTION_NAME		IN  VARCHAR2     DEFAULT NULL,
 P_USER_FUNCTION_NAME           IN  VARCHAR2     DEFAULT NULL,
 P_QUESTION_CODE     	        IN  VARCHAR2     DEFAULT NULL,
 P_FIND_CRITERIA                IN  VARCHAR2     DEFAULT NULL
)
IS

L_ROWID            VARCHAR2(64);
Line: 1473

   SELECT COUNT(*)
   INTO   l_count
   FROM   FND_FORM_FUNCTIONS_VL FND
   WHERE  FND.FUNCTION_NAME = P_FUNCTION_NAME;
Line: 1484

   SELECT COUNT(*)
   INTO   l_count
   FROM   ICX_QUESTION_FUNCTIONS ICX
   WHERE  ICX.FUNCTION_NAME = P_FUNCTION_NAME
   AND    ICX.QUESTION_CODE = P_QUESTION_CODE;
Line: 1503

            '&p_insert=TRUE'||
            '&p_error_message='||l_error_msg||
            '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
   		    bclose_header=>TRUE);
Line: 1510

      INSERT INTO ICX_QUESTION_FUNCTIONS
      (QUESTION_CODE,
       FUNCTION_NAME,
       LAST_UPDATE_DATE,
       LAST_UPDATED_BY,
       CREATION_DATE,
       CREATED_BY
     )
     VALUES
       (P_QUESTION_CODE,
       P_FUNCTION_NAME,
       sysdate,
       1,
       sysdate,
       1
      );
Line: 1537

    wf_core.context('icx_questions_admin', 'insert_function');
Line: 1540

END insert_function;
Line: 1546

procedure UPDATE_FUNCTION
(
 P_FUNCTION_ID                  IN  VARCHAR2     DEFAULT NULL,
 P_OLD_FUNCTION_NAME		IN  VARCHAR2     DEFAULT NULL,
 P_FUNCTION_NAME		IN  VARCHAR2     DEFAULT NULL,
 p_USER_FUNCTION_NAME           IN  VARCHAR2     DEFAULT NULL,
 P_QUESTION_CODE     	        IN  VARCHAR2     DEFAULT NULL,
 P_FIND_CRITERIA                IN  VARCHAR2     DEFAULT NULL
)
IS

L_ROWID        VARCHAR2(64);
Line: 1563

   SELECT COUNT(*)
   INTO   l_count
   FROM   FND_FORM_FUNCTIONS_VL FND
   WHERE  FND.FUNCTION_NAME = P_FUNCTION_NAME;
Line: 1574

   SELECT COUNT(*)
   INTO   l_count
   FROM   ICX_QUESTION_FUNCTIONS ICX
   WHERE  ICX.FUNCTION_NAME = P_FUNCTION_NAME
   AND    ICX.QUESTION_CODE = P_QUESTION_CODE;
Line: 1592

            '&p_insert=TRUE'||
            '&p_error_message='||l_error_msg||
            '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
   		    bclose_header=>TRUE);
Line: 1599

      UPDATE ICX_QUESTION_FUNCTIONS
      SET    FUNCTION_NAME = P_FUNCTION_NAME,
             LAST_UPDATE_DATE = sysdate,
             LAST_UPDATED_BY  = 1,
             LAST_UPDATE_LOGIN  = 1
      WHERE  QUESTION_CODE = P_QUESTION_CODE
      AND    FUNCTION_NAME   = P_OLD_FUNCTION_NAME;
Line: 1618

    wf_core.context('icx_questions_admin', 'update_function');
Line: 1621

END update_function;
Line: 1628

procedure DELETE_FUNCTION
(
 P_FUNCTION_ID                  IN  VARCHAR2     DEFAULT NULL,
 P_FUNCTION_NAME		IN  VARCHAR2     DEFAULT NULL,
 P_QUESTION_CODE     	        IN  VARCHAR2     DEFAULT NULL,
 P_FIND_CRITERIA                IN  VARCHAR2     DEFAULT NULL
)
IS

L_ROWID        VARCHAR2(64);
Line: 1641

   DELETE FROM ICX_QUESTION_FUNCTIONS
   WHERE  QUESTION_CODE = P_QUESTION_CODE
   AND    FUNCTION_NAME = P_FUNCTION_NAME;
Line: 1653

    wf_core.context('icx_questions_admin', 'delete_function');
Line: 1656

END delete_function;