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 1198: X_MESSAGE := 'SELECT ' || X_MESSAGE || ' FROM dual';

1194: ');
1195:
1196:
1197: IF X_ASSIGN_TYPE = 'F' THEN
1198: X_MESSAGE := 'SELECT ' || X_MESSAGE || ' FROM dual';
1199: END IF;
1200:
1201: BEGIN
1202: DO_ASSIGNMENT(pca_id_tab(i),X_MESSAGE,

Line 2148: from dual;

2144: */
2145:
2146: Cursor l_WorkFlowItemKey IS
2147: select qa_action_workflow_s.nextval
2148: from dual;
2149:
2150: TYPE wf_attributes_table IS TABLE OF WF_ITEM_ATTRIBUTES.NAME%TYPE
2151: INDEX BY BINARY_INTEGER;
2152:

Line 3149: FROM dual;

3145: 1,
3146: 0,
3147: 'i')
3148: INTO l_message_str
3149: FROM dual;
3150: END LOOP;
3151:
3152: --
3153: -- Bug 9843457

Line 3175: FROM dual;

3171: 1,
3172: 0,
3173: 'i')
3174: INTO l_message_str
3175: FROM dual;
3176:
3177: RETURN l_message_str;
3178: END replace_tokens;
3179: