DBA Data[Home] [Help]

APPS.JTF_TASKS_PUB dependencies on JTF_NUMBER_TABLE

Line 8121: ,P_TASK_ID_LIST IN JTF_NUMBER_TABLE

8117: PROCEDURE MASS_TASK_UPDATE (
8118: P_API_VERSION IN NUMBER
8119: ,P_INIT_MSG_LIST IN VARCHAR2
8120: ,P_COMMIT IN VARCHAR2
8121: ,P_TASK_ID_LIST IN JTF_NUMBER_TABLE
8122: ,P_NEW_TASK_STATUS_ID IN NUMBER
8123: ,P_NEW_SOURCE_TYPE_CODE IN VARCHAR2
8124: ,P_NEW_SOURCE_VALUE IN VARCHAR2
8125: ,P_NEW_SOURCE_ID IN VARCHAR2

Line 8143: ,X_SUCC_TASK_ID_LIST OUT NOCOPY JTF_NUMBER_TABLE

8139: ,P_REMOVE_ASSIGNMENT_FLAG IN VARCHAR2
8140: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
8141: ,X_MSG_COUNT OUT NOCOPY NUMBER
8142: ,X_MSG_DATA OUT NOCOPY VARCHAR2
8143: ,X_SUCC_TASK_ID_LIST OUT NOCOPY JTF_NUMBER_TABLE
8144: ,X_FAILED_TASK_ID_LIST OUT NOCOPY JTF_NUMBER_TABLE
8145: ,X_FAILED_REASON_LIST OUT NOCOPY JTF_VARCHAR2_TABLE_2000
8146: ) IS
8147: l_task_att_modified_flag number :=1;

Line 8144: ,X_FAILED_TASK_ID_LIST OUT NOCOPY JTF_NUMBER_TABLE

8140: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
8141: ,X_MSG_COUNT OUT NOCOPY NUMBER
8142: ,X_MSG_DATA OUT NOCOPY VARCHAR2
8143: ,X_SUCC_TASK_ID_LIST OUT NOCOPY JTF_NUMBER_TABLE
8144: ,X_FAILED_TASK_ID_LIST OUT NOCOPY JTF_NUMBER_TABLE
8145: ,X_FAILED_REASON_LIST OUT NOCOPY JTF_VARCHAR2_TABLE_2000
8146: ) IS
8147: l_task_att_modified_flag number :=1;
8148: l_task_updated number;

Line 8152: L_TASK_UPDATE_COMPLTED JTF_NUMBER_TABLE;

8148: l_task_updated number;
8149: l_failed_index number :=1;
8150: l_completed_index number :=1;
8151: l_last_task number:=0;
8152: L_TASK_UPDATE_COMPLTED JTF_NUMBER_TABLE;
8153: l_succ_task_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
8154: l_failed_task_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
8155: l_failed_reason_list JTF_VARCHAR2_TABLE_2000 := JTF_VARCHAR2_TABLE_2000();
8156: l_return_status VARCHAR2(100);

Line 8153: l_succ_task_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

8149: l_failed_index number :=1;
8150: l_completed_index number :=1;
8151: l_last_task number:=0;
8152: L_TASK_UPDATE_COMPLTED JTF_NUMBER_TABLE;
8153: l_succ_task_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
8154: l_failed_task_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
8155: l_failed_reason_list JTF_VARCHAR2_TABLE_2000 := JTF_VARCHAR2_TABLE_2000();
8156: l_return_status VARCHAR2(100);
8157: l_msg_count NUMBER;

Line 8154: l_failed_task_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

8150: l_completed_index number :=1;
8151: l_last_task number:=0;
8152: L_TASK_UPDATE_COMPLTED JTF_NUMBER_TABLE;
8153: l_succ_task_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
8154: l_failed_task_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
8155: l_failed_reason_list JTF_VARCHAR2_TABLE_2000 := JTF_VARCHAR2_TABLE_2000();
8156: l_return_status VARCHAR2(100);
8157: l_msg_count NUMBER;
8158: l_msg_data VARCHAR2(2000);