DBA Data[Home] [Help]

APPS.WMS_TASK_LOAD dependencies on DBMS_SQL

Line 12712: l_CursorID := DBMS_SQL.OPEN_CURSOR;

12708: 'WHERE mmtt.transaction_temp_id = :x_temp_id ' ||
12709: ' AND mmtt.standard_operation_id = wutta.user_task_type_id '||
12710: ' AND mmtt.organization_id = wutta.organization_id '||
12711: ' AND wutta.honor_case_pick_flag = ''Y'' '; --Added for Bug#7584906
12712: l_CursorID := DBMS_SQL.OPEN_CURSOR;
12713: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
12714: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, honor_case_pick_count);
12715: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':x_temp_id', p_temp_id);
12716: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);

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

12709: ' AND mmtt.standard_operation_id = wutta.user_task_type_id '||
12710: ' AND mmtt.organization_id = wutta.organization_id '||
12711: ' AND wutta.honor_case_pick_flag = ''Y'' '; --Added for Bug#7584906
12712: l_CursorID := DBMS_SQL.OPEN_CURSOR;
12713: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
12714: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, honor_case_pick_count);
12715: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':x_temp_id', p_temp_id);
12716: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
12717: l_Dummy := DBMS_SQL.FETCH_ROWS(l_CursorID);

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

12710: ' AND mmtt.organization_id = wutta.organization_id '||
12711: ' AND wutta.honor_case_pick_flag = ''Y'' '; --Added for Bug#7584906
12712: l_CursorID := DBMS_SQL.OPEN_CURSOR;
12713: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
12714: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, honor_case_pick_count);
12715: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':x_temp_id', p_temp_id);
12716: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
12717: l_Dummy := DBMS_SQL.FETCH_ROWS(l_CursorID);
12718: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, honor_case_pick_count);

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

12711: ' AND wutta.honor_case_pick_flag = ''Y'' '; --Added for Bug#7584906
12712: l_CursorID := DBMS_SQL.OPEN_CURSOR;
12713: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
12714: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, honor_case_pick_count);
12715: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':x_temp_id', p_temp_id);
12716: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
12717: l_Dummy := DBMS_SQL.FETCH_ROWS(l_CursorID);
12718: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, honor_case_pick_count);
12719: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

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

12712: l_CursorID := DBMS_SQL.OPEN_CURSOR;
12713: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
12714: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, honor_case_pick_count);
12715: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':x_temp_id', p_temp_id);
12716: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
12717: l_Dummy := DBMS_SQL.FETCH_ROWS(l_CursorID);
12718: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, honor_case_pick_count);
12719: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
12720: END IF;

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

12713: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
12714: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, honor_case_pick_count);
12715: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':x_temp_id', p_temp_id);
12716: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
12717: l_Dummy := DBMS_SQL.FETCH_ROWS(l_CursorID);
12718: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, honor_case_pick_count);
12719: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
12720: END IF;
12721:

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

12714: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, honor_case_pick_count);
12715: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':x_temp_id', p_temp_id);
12716: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
12717: l_Dummy := DBMS_SQL.FETCH_ROWS(l_CursorID);
12718: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, honor_case_pick_count);
12719: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
12720: END IF;
12721:
12722: IF (create_lpn = 'N') THEN

Line 12719: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

12715: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':x_temp_id', p_temp_id);
12716: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
12717: l_Dummy := DBMS_SQL.FETCH_ROWS(l_CursorID);
12718: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, honor_case_pick_count);
12719: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
12720: END IF;
12721:
12722: IF (create_lpn = 'N') THEN
12723: IF (wms_control.g_current_release_level >= 120001 AND honor_case_pick_count > 0) THEN

Line 12833: IF DBMS_SQL.IS_Open(l_cursorID) THEN

12829: EXCEPTION
12830: WHEN fnd_api.g_exc_error THEN
12831: x_return_status := fnd_api.g_ret_sts_error;
12832: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12833: IF DBMS_SQL.IS_Open(l_cursorID) THEN
12834: DBMS_SQL.Close_Cursor(l_cursorID);
12835: END IF;
12836: WHEN OTHERS THEN
12837: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 12834: DBMS_SQL.Close_Cursor(l_cursorID);

12830: WHEN fnd_api.g_exc_error THEN
12831: x_return_status := fnd_api.g_ret_sts_error;
12832: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12833: IF DBMS_SQL.IS_Open(l_cursorID) THEN
12834: DBMS_SQL.Close_Cursor(l_cursorID);
12835: END IF;
12836: WHEN OTHERS THEN
12837: x_return_status := fnd_api.g_ret_sts_unexp_error;
12838: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 12839: IF DBMS_SQL.IS_Open(l_cursorID) THEN

12835: END IF;
12836: WHEN OTHERS THEN
12837: x_return_status := fnd_api.g_ret_sts_unexp_error;
12838: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12839: IF DBMS_SQL.IS_Open(l_cursorID) THEN
12840: DBMS_SQL.Close_Cursor(l_cursorID);
12841: END IF;
12842: END check_pack_lpn;
12843:

Line 12840: DBMS_SQL.Close_Cursor(l_cursorID);

12836: WHEN OTHERS THEN
12837: x_return_status := fnd_api.g_ret_sts_unexp_error;
12838: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12839: IF DBMS_SQL.IS_Open(l_cursorID) THEN
12840: DBMS_SQL.Close_Cursor(l_cursorID);
12841: END IF;
12842: END check_pack_lpn;
12843:
12844: