DBA Data[Home] [Help]

APPS.QLTDACTB dependencies on DUAL

Line 398: -- FROM dual;

394:
395:
396: -- CURSOR MY_PO_GROUP_ID IS
397: -- SELECT rcv_interface_groups_s.nextval
398: -- FROM dual;
399:
400: -- used for action 18, 19 to
401: -- get status id for lot/serial statuses
402: CURSOR MY_STATUS_ID (X_PCA_ID NUMBER) IS

Line 1159: X_MESSAGE := 'SELECT ' || X_MESSAGE || ' FROM dual';

1155: ');
1156:
1157:
1158: IF X_ASSIGN_TYPE = 'F' THEN
1159: X_MESSAGE := 'SELECT ' || X_MESSAGE || ' FROM dual';
1160: END IF;
1161:
1162: BEGIN
1163: DO_ASSIGNMENT(pca_id_tab(i),X_MESSAGE,

Line 2068: from dual;

2064: */
2065:
2066: Cursor l_WorkFlowItemKey IS
2067: select qa_action_workflow_s.nextval
2068: from dual;
2069:
2070: TYPE wf_attributes_table IS TABLE OF WF_ITEM_ATTRIBUTES.NAME%TYPE
2071: INDEX BY BINARY_INTEGER;
2072:

Line 3018: FROM dual;

3014: 1,
3015: 0,
3016: 'i')
3017: INTO l_message_str
3018: FROM dual;
3019: END LOOP;
3020: RETURN l_message_str;
3021: END replace_tokens;
3022: