DBA Data[Home] [Help]

APPS.WMS_TASK_LOAD dependencies on DBMS_SQL

Line 10420: l_CursorID := DBMS_SQL.OPEN_CURSOR;

10416: 'WHERE mmtt.transaction_temp_id = :x_temp_id ' ||
10417: ' AND mmtt.standard_operation_id = wutta.user_task_type_id '||
10418: ' AND mmtt.organization_id = wutta.organization_id '||
10419: ' AND wutta.honor_case_pick_flag = ''Y'' '; --Added for Bug#7584906
10420: l_CursorID := DBMS_SQL.OPEN_CURSOR;
10421: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
10422: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, honor_case_pick_count);
10423: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':x_temp_id', p_temp_id);
10424: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);

Line 10421: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);

10417: ' AND mmtt.standard_operation_id = wutta.user_task_type_id '||
10418: ' AND mmtt.organization_id = wutta.organization_id '||
10419: ' AND wutta.honor_case_pick_flag = ''Y'' '; --Added for Bug#7584906
10420: l_CursorID := DBMS_SQL.OPEN_CURSOR;
10421: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
10422: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, honor_case_pick_count);
10423: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':x_temp_id', p_temp_id);
10424: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
10425: l_Dummy := DBMS_SQL.FETCH_ROWS(l_CursorID);

Line 10422: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, honor_case_pick_count);

10418: ' AND mmtt.organization_id = wutta.organization_id '||
10419: ' AND wutta.honor_case_pick_flag = ''Y'' '; --Added for Bug#7584906
10420: l_CursorID := DBMS_SQL.OPEN_CURSOR;
10421: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
10422: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, honor_case_pick_count);
10423: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':x_temp_id', p_temp_id);
10424: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
10425: l_Dummy := DBMS_SQL.FETCH_ROWS(l_CursorID);
10426: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, honor_case_pick_count);

Line 10423: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':x_temp_id', p_temp_id);

10419: ' AND wutta.honor_case_pick_flag = ''Y'' '; --Added for Bug#7584906
10420: l_CursorID := DBMS_SQL.OPEN_CURSOR;
10421: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
10422: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, honor_case_pick_count);
10423: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':x_temp_id', p_temp_id);
10424: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
10425: l_Dummy := DBMS_SQL.FETCH_ROWS(l_CursorID);
10426: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, honor_case_pick_count);
10427: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

Line 10424: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);

10420: l_CursorID := DBMS_SQL.OPEN_CURSOR;
10421: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
10422: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, honor_case_pick_count);
10423: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':x_temp_id', p_temp_id);
10424: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
10425: l_Dummy := DBMS_SQL.FETCH_ROWS(l_CursorID);
10426: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, honor_case_pick_count);
10427: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
10428: END IF;

Line 10425: l_Dummy := DBMS_SQL.FETCH_ROWS(l_CursorID);

10421: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
10422: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, honor_case_pick_count);
10423: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':x_temp_id', p_temp_id);
10424: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
10425: l_Dummy := DBMS_SQL.FETCH_ROWS(l_CursorID);
10426: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, honor_case_pick_count);
10427: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
10428: END IF;
10429:

Line 10426: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, honor_case_pick_count);

10422: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, honor_case_pick_count);
10423: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':x_temp_id', p_temp_id);
10424: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
10425: l_Dummy := DBMS_SQL.FETCH_ROWS(l_CursorID);
10426: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, honor_case_pick_count);
10427: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
10428: END IF;
10429:
10430: IF (create_lpn = 'N') THEN

Line 10427: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

10423: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':x_temp_id', p_temp_id);
10424: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
10425: l_Dummy := DBMS_SQL.FETCH_ROWS(l_CursorID);
10426: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, honor_case_pick_count);
10427: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
10428: END IF;
10429:
10430: IF (create_lpn = 'N') THEN
10431: IF (wms_control.g_current_release_level >= 120001 AND honor_case_pick_count > 0) THEN

Line 10539: IF DBMS_SQL.IS_Open(l_cursorID) THEN

10535: EXCEPTION
10536: WHEN fnd_api.g_exc_error THEN
10537: x_return_status := fnd_api.g_ret_sts_error;
10538: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
10539: IF DBMS_SQL.IS_Open(l_cursorID) THEN
10540: DBMS_SQL.Close_Cursor(l_cursorID);
10541: END IF;
10542: WHEN OTHERS THEN
10543: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 10540: DBMS_SQL.Close_Cursor(l_cursorID);

10536: WHEN fnd_api.g_exc_error THEN
10537: x_return_status := fnd_api.g_ret_sts_error;
10538: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
10539: IF DBMS_SQL.IS_Open(l_cursorID) THEN
10540: DBMS_SQL.Close_Cursor(l_cursorID);
10541: END IF;
10542: WHEN OTHERS THEN
10543: x_return_status := fnd_api.g_ret_sts_unexp_error;
10544: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 10545: IF DBMS_SQL.IS_Open(l_cursorID) THEN

10541: END IF;
10542: WHEN OTHERS THEN
10543: x_return_status := fnd_api.g_ret_sts_unexp_error;
10544: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
10545: IF DBMS_SQL.IS_Open(l_cursorID) THEN
10546: DBMS_SQL.Close_Cursor(l_cursorID);
10547: END IF;
10548: END check_pack_lpn;
10549:

Line 10546: DBMS_SQL.Close_Cursor(l_cursorID);

10542: WHEN OTHERS THEN
10543: x_return_status := fnd_api.g_ret_sts_unexp_error;
10544: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
10545: IF DBMS_SQL.IS_Open(l_cursorID) THEN
10546: DBMS_SQL.Close_Cursor(l_cursorID);
10547: END IF;
10548: END check_pack_lpn;
10549:
10550: