APPS.ICX_QUESTIONS_ADMIN dependencies on ICX_QUESTION_FUNCTIONS

Line 901: delete from icx_question_functions where question_code = p_question_code;

897: IS
898:
899: BEGIN
900:
901: delete from icx_question_functions where question_code = p_question_code;
902: delete from icx_questions_tl where question_code = p_question_code;
903: delete from icx_questions where question_code = p_question_code;
904:
905: -- use owa_util.redirect_url to redirect the URL to the home page

Line 1041: FROM ICX_QUESTION_FUNCTIONS ICX, FND_FORM_FUNCTIONS_VL FND

1037: cursor function_cursor is
1038: SELECT FND.FUNCTION_NAME,
1039: FND.FUNCTION_ID,
1040: FND.USER_FUNCTION_NAME
1041: FROM ICX_QUESTION_FUNCTIONS ICX, FND_FORM_FUNCTIONS_VL FND
1042: WHERE ICX.QUESTION_CODE = P_QUESTION_CODE
1043: AND ICX.FUNCTION_NAME = FND.FUNCTION_NAME
1044: ORDER BY FND.FUNCTION_NAME;
1045:

Line 1486: FROM ICX_QUESTION_FUNCTIONS ICX

1482: end if;
1483:
1484: SELECT COUNT(*)
1485: INTO l_count
1486: FROM ICX_QUESTION_FUNCTIONS ICX
1487: WHERE ICX.FUNCTION_NAME = P_FUNCTION_NAME
1488: AND ICX.QUESTION_CODE = P_QUESTION_CODE;
1489:
1490: if (l_count > 0) THEN

Line 1510: INSERT INTO ICX_QUESTION_FUNCTIONS

1506: bclose_header=>TRUE);
1507:
1508: else
1509:
1510: INSERT INTO ICX_QUESTION_FUNCTIONS
1511: (QUESTION_CODE,
1512: FUNCTION_NAME,
1513: LAST_UPDATE_DATE,
1514: LAST_UPDATED_BY,

Line 1576: FROM ICX_QUESTION_FUNCTIONS ICX

1572: end if;
1573:
1574: SELECT COUNT(*)
1575: INTO l_count
1576: FROM ICX_QUESTION_FUNCTIONS ICX
1577: WHERE ICX.FUNCTION_NAME = P_FUNCTION_NAME
1578: AND ICX.QUESTION_CODE = P_QUESTION_CODE;
1579:
1580: if (l_count > 0) THEN

Line 1599: UPDATE ICX_QUESTION_FUNCTIONS

1595: bclose_header=>TRUE);
1596:
1597: else
1598:
1599: UPDATE ICX_QUESTION_FUNCTIONS
1600: SET FUNCTION_NAME = P_FUNCTION_NAME,
1601: LAST_UPDATE_DATE = sysdate,
1602: LAST_UPDATED_BY = 1,
1603: LAST_UPDATE_LOGIN = 1

Line 1641: DELETE FROM ICX_QUESTION_FUNCTIONS

1637: L_ROWID VARCHAR2(64);
1638:
1639: BEGIN
1640:
1641: DELETE FROM ICX_QUESTION_FUNCTIONS
1642: WHERE QUESTION_CODE = P_QUESTION_CODE
1643: AND FUNCTION_NAME = P_FUNCTION_NAME;
1644:
1645: -- use owa_util.redirect_url to redirect the URL to the home page