The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
wf_core.translate('DELETE')||'',
calign=>'Center');
'&p_insert=FALSE'||
'&p_find_criteria='||l_find_criteria,
ctext=>questions.question_code, ctarget=>'_top'),
'Left');
'/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"');
'?p_insert=TRUE'||
'&p_find_criteria='||l_find_criteria;
P_INSERT IN VARCHAR2 DEFAULT NULL
)
IS
L_APPLICATION_SHORT_NAME VARCHAR2(50) := NULL;
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;
if (P_INSERT = 'FALSE') THEN
htp.p('
htp.p('
IF (P_INSERT = 'FALSE') THEN
htp.formHidden(cname=>'p_question_code', cvalue=>l_question_code);
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);
SELECT COUNT(*)
INTO l_count
FROM FND_APPLICATION_VL FND
WHERE FND.APPLICATION_SHORT_NAME = UPPER(P_APPLICATION_SHORT_NAME);
SELECT count(*)
INTO l_count
FROM ICX_QUESTIONS ICX
WHERE ICX.QUESTION_CODE = UPPER(P_QUESTION_CODE);
'&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);
SELECT APPLICATION_ID
INTO L_APPLICATION_ID
FROM FND_APPLICATION_VL FND
WHERE FND.APPLICATION_SHORT_NAME = UPPER(P_APPLICATION_SHORT_NAME);
ICX_QUESTIONS_PKG.INSERT_ROW (
L_ROWID,
UPPER(P_QUESTION_CODE),
L_APPLICATION_ID,
'QUESTION',
P_QUESTION,
sysdate,
1,
sysdate,
1,
1);
wf_core.context('icx_questions_admin', 'insert_question');
END insert_question;
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;
SELECT COUNT(*)
INTO l_count
FROM FND_APPLICATION_VL FND
WHERE FND.APPLICATION_SHORT_NAME = UPPER(P_APPLICATION_SHORT_NAME);
'&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);
ICX_QUESTIONS_PKG.UPDATE_ROW (
P_QUESTION_CODE,
P_APPLICATION_ID,
'QUESTION',
P_QUESTION,
sysdate,
1,
1);
wf_core.context('icx_questions_admin', 'update_question');
END update_question;
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);
htp.tabledata(wf_core.translate('ICX_CONFIRM_DELETE_MESSAGE') || ': ' ||
''||p_question_code||'');
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);
wf_core.context('icx_questions_admin', 'question_confirm_delete');
END Question_Confirm_Delete;
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;
delete from icx_questions_tl where question_code = p_question_code;
delete from icx_questions where question_code = p_question_code;
wf_core.context('icx_questions_admin', 'delete_question');
END delete_question;
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;
SELECT
application_short_name
FROM fnd_application_vl
WHERE application_id = c_id;
select count(*)
into l_total_rows
FROM fnd_application_vl
WHERE application_short_name like UPPER(p_display_value||'%');
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;
wf_core.translate('DELETE')||'',
calign=>'Center');
'&p_insert=FALSE'||
'&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
ctext=>functions.function_name, ctarget=>'_top'),
'Left');
'/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"');
'&p_insert=TRUE'||
'&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
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;
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;
if (P_INSERT = 'FALSE') THEN
htp.p('
htp.p('
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;
SELECT
application_short_name
FROM fnd_application_vl
WHERE application_id = c_id;
select count(*)
into l_total_rows
FROM FND_FORM_FUNCTIONS_VL FND
WHERE FND.FUNCTION_NAME like upper(p_display_value||'%');
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);
SELECT COUNT(*)
INTO l_count
FROM FND_FORM_FUNCTIONS_VL FND
WHERE FND.FUNCTION_NAME = P_FUNCTION_NAME;
SELECT COUNT(*)
INTO l_count
FROM ICX_QUESTION_FUNCTIONS ICX
WHERE ICX.FUNCTION_NAME = P_FUNCTION_NAME
AND ICX.QUESTION_CODE = P_QUESTION_CODE;
'&p_insert=TRUE'||
'&p_error_message='||l_error_msg||
'&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
bclose_header=>TRUE);
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
);
wf_core.context('icx_questions_admin', 'insert_function');
END insert_function;
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);
SELECT COUNT(*)
INTO l_count
FROM FND_FORM_FUNCTIONS_VL FND
WHERE FND.FUNCTION_NAME = P_FUNCTION_NAME;
SELECT COUNT(*)
INTO l_count
FROM ICX_QUESTION_FUNCTIONS ICX
WHERE ICX.FUNCTION_NAME = P_FUNCTION_NAME
AND ICX.QUESTION_CODE = P_QUESTION_CODE;
'&p_insert=TRUE'||
'&p_error_message='||l_error_msg||
'&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
bclose_header=>TRUE);
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;
wf_core.context('icx_questions_admin', 'update_function');
END update_function;
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);
DELETE FROM ICX_QUESTION_FUNCTIONS
WHERE QUESTION_CODE = P_QUESTION_CODE
AND FUNCTION_NAME = P_FUNCTION_NAME;
wf_core.context('icx_questions_admin', 'delete_function');
END delete_function;